2,596
社区成员
发帖
与我相关
我的任务
分享win 2003下 ase 12.5 大量1204错误，最后重复no more alarms available
各位大神帮忙看一下什么问题，数据库昨天晚上还正常，今天早上就挂了，有很多1204的错误。
昨晚8点的
00:00000:00202:2015/12/26 20:34:00.73 server Attempt by user 1 to dump xact on db escourt5_web with NO_LOG
00:00000:00202:2015/12/26 20:34:00.75 server Attempt by user 1 to dump xact on db escourt5_web with NO_LOG was successful
00:00000:00202:2015/12/26 20:34:00.75 server WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.76 server WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.76 server Attempt by user 1 to dump xact on db esoa with NO_LOG
00:00000:00202:2015/12/26 20:34:00.78 server Attempt by user 1 to dump xact on db esoa with NO_LOG was successful
00:00000:00202:2015/12/26 20:34:00.78 server WARNING: ***************************
今天一早9点的
00:00000:00341:2015/12/27 09:13:05.59 kernel Cannot send, host process disconnected: 3980 suid: 6
00:00000:00341:2015/12/27 09:13:05.64 server Error: 1608, Severity: 18, State: 4
00:00000:00341:2015/12/27 09:13:05.64 server A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00341:2015/12/27 09:13:05.67 kernel extended error information: hostname: login: escourt4
00:00000:00017:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00017:2015/12/27 09:22:58.00 server SQL Text: update FLOWREC set DQR ='8-18-2042 9:21:15.766' WHERE YWPK ='187700000150371' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00338:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00338:2015/12/27 09:22:58.00 server SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='TSBB'
00:00000:00482:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00482:2015/12/27 09:22:58.00 server SQL Text: d exists(select 1 from SJJH_DATATIME where CASES_SN=CASES.SN and (UPDTIME>JHDATE or JHDATE is null or JHDATE='' or JHDATE<'1900-01-02'))
11点之后的
00:00000:00113:2015/12/27 11:06:34.45 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00339:2015/12/27 11:06:34.45 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00104:2015/12/27 11:06:34.45 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.155'.
00:00000:00104:2015/12/27 11:06:34.45 server SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='WSSW_HZ'
-----
00:00000:00425:2015/12/27 11:06:44.21 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00306:2015/12/27 11:06:46.01 server Error 1204, Severity 17, State 1 occurred for User 'table_dba'. Client IP address is '10.28.163.8'.
00:00000:00306:2015/12/27 11:06:46.01 server SQL Text:
00:00000:00306:2015/12/27 11:06:46.01 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00317:2015/12/27 11:06:47.35 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
最后就是这两行大量重复
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available。
昨晚8点的
00:00000:00202:2015/12/26 20:34:00.73 server Attempt by user 1 to dump xact on db escourt5_web with NO_LOG
00:00000:00202:2015/12/26 20:34:00.75 server Attempt by user 1 to dump xact on db escourt5_web with NO_LOG was successful
00:00000:00202:2015/12/26 20:34:00.75 server WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.76 server WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.76 server Attempt by user 1 to dump xact on db esoa with NO_LOG
00:00000:00202:2015/12/26 20:34:00.78 server Attempt by user 1 to dump xact on db esoa with NO_LOG was successful
00:00000:00202:2015/12/26 20:34:00.78 server WARNING: ***************************
今天一早9点的
00:00000:00341:2015/12/27 09:13:05.59 kernel Cannot send, host process disconnected: 3980 suid: 6
00:00000:00341:2015/12/27 09:13:05.64 server Error: 1608, Severity: 18, State: 4
00:00000:00341:2015/12/27 09:13:05.64 server A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00341:2015/12/27 09:13:05.67 kernel extended error information: hostname: login: escourt4
00:00000:00017:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00017:2015/12/27 09:22:58.00 server SQL Text: update FLOWREC set DQR ='8-18-2042 9:21:15.766' WHERE YWPK ='187700000150371' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00338:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00338:2015/12/27 09:22:58.00 server SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='TSBB'
00:00000:00482:2015/12/27 09:22:58.00 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.100.207'.
00:00000:00482:2015/12/27 09:22:58.00 server SQL Text: d exists(select 1 from SJJH_DATATIME where CASES_SN=CASES.SN and (UPDTIME>JHDATE or JHDATE is null or JHDATE='' or JHDATE<'1900-01-02'))
11点之后的
00:00000:00113:2015/12/27 11:06:34.45 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00339:2015/12/27 11:06:34.45 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00104:2015/12/27 11:06:34.45 server Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.155'.
00:00000:00104:2015/12/27 11:06:34.45 server SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='WSSW_HZ'
-----
00:00000:00425:2015/12/27 11:06:44.21 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00306:2015/12/27 11:06:46.01 server Error 1204, Severity 17, State 1 occurred for User 'table_dba'. Client IP address is '10.28.163.8'.
00:00000:00306:2015/12/27 11:06:46.01 server SQL Text:
00:00000:00306:2015/12/27 11:06:46.01 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00317:2015/12/27 11:06:47.35 server Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
最后就是这两行大量重复
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available
00:00000:00317:2015/12/27 11:06:47.37 kernel uppause: No free alarms available.
00:00000:00317:2015/12/27 11:06:47.37 kernel uasetalarm: no more alarms available。
...全文
请发表友善的回复…
发表回复
文修 2015-12-28
- 打赏
- 举报
Possible workarounds:
(1) Increase number of alarms configured for ASE.
(2) Reboot sql server to clear up alarm structures.
