sybase 數(shù)據(jù)庫(kù)報(bào)錯(cuò)，重啟就好了

qinglaninfo

各位大神幫忙看一下什么問(wèn)題
晚上還正常，今天早上就報(bào)這個(gè)錯(cuò)了。

00:00000:00202:2015/12/26 20:34:00.70 server  WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.70 server  WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.70 server  Attempt by user 1 to dump xact on db sjzx with NO_LOG
00:00000:00202:2015/12/26 20:34:00.73 server  Attempt by user 1 to dump xact on db sjzx with NO_LOG was successful
00:00000:00202:2015/12/26 20:34:00.73 server  WARNING: ***************************
00:00000:00202:2015/12/26 20:34:00.73 server  WARNING: ***************************
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: ***************************
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'))
00:00000:00407:2015/12/27 09:31:34.07 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.124'.
00:00000:00407:2015/12/27 09:31:34.09 server  SQL Text: select JARQ , AJSJ from CASES where SN =187700000150898
00:00000:00379:2015/12/27 09:31:34.09 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.112'.
00:00000:00379:2015/12/27 09:31:34.09 server  SQL Text: select count ( *) from CASES_PQ where CASE_SN =187700000157774 and YT like '%開(kāi)庭%'
00:00000:00041:2015/12/27 09:31:34.09 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.112'.
00:00000:00041:2015/12/27 09:31:34.09 server  SQL Text: update FLOWREC set DQR ='12-16-2042 9:31:39.546' WHERE YWPK ='187700000155736' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00030:2015/12/27 09:31:34.09 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.112'.
00:00000:00030:2015/12/27 09:31:34.09 server  SQL Text:
00:00000:00160:2015/12/27 09:31:34.09 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.112'.
00:00000:00160:2015/12/27 09:31:34.09 server  SQL Text: SELECT S_AJLBJDDY.COURT_NO,              S_AJLBJDDY.XH,              S_AJLBJDDY.PXH,              S_AJLBJDDY.AJLB,              S_AJLBJDDY.NODENO,              S_AJLBJDDY.DXDM,              S_AJLBJDDY.DXMC,              S_AJLBJDDY.DXMS,              S_AJLBJDDY.OPENX,              S_AJLBJDDY.OPENY,              S_AJLBJDDY.CCBH,              S_AJLBJDDY.ZT        FROM S_AJLBJDDY     WHERE COURT_NO = '0F32' and AJLB = '81' and NODENO = '01' and ZT <> '
00:00000:00242:2015/12/27 09:32:56.71 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.50'.
00:00000:00242:2015/12/27 09:32:56.71 server  SQL Text: J,              SPACE(100) AS ANHAO,              SPACE(10) AS JARQ,                          SPACE(255) AS SXSM,                          0 AS BZ,                          0 AS DB,                          0 AS SDB,                          SPACE(20) AS CBR,                          SPACE(20) AS CBBM      FROM FLOWREC       WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') ORDER BY FLOWREC.NODENO ASC,              FLOWREC.BDATETIME ASC      
00:00000:00001:2015/12/27 09:32:56.71 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.113'.
00:00000:00001:2015/12/27 09:32:56.71 server  SQL Text: J,              SPACE(100) AS ANHAO,              SPACE(10) AS JARQ,                          SPACE(255) AS SXSM,                          0 AS BZ,                          0 AS DB,                          0 AS SDB,                          SPACE(20) AS CBR,                          SPACE(20) AS CBBM      FROM FLOWREC       WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') ORDER BY FLOWREC.NODENO ASC,              FLOWREC.BDATETIME ASC      
00:00000:00232:2015/12/27 09:32:56.73 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.233'.
00:00000:00232:2015/12/27 09:32:56.73 server  SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='TSBB'
00:00000:00395:2015/12/27 09:32:57.01 server  Error 1204, Severity 17, State 2 occurred for User 'table_dba'. Client IP address is '10.28.163.8'.
00:00000:00395:2015/12/27 09:32:57.01 server  SQL Text:   and  DZJZ_AJXX.ZT!=''  and DZJZ_AJXX.AJ_SN=DZJZ_AJZZJL.AJ_SN   and DZJZ_AJZZJL.CZRID='0F320027'  and DZJZ_AJZZJL.STATE='1' and DZJZ_AJZZJL.CSFS!='3' and   DZJZ_AJZZJL.CSFS!='4' and   DZJZ_AJZZJL.CSFS!=''  
00:00000:00041:2015/12/27 09:32:57.01 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.8'.
00:00000:00041:2015/12/27 09:32:57.01 server  SQL Text: update FLOWREC set DQR ='1-6-2043 9:33:1.656' WHERE YWPK ='187700000156392' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00034:2015/12/27 09:32:57.01 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.8'.
00:00000:00034:2015/12/27 09:32:57.01 server  SQL Text:  = '0F320083') OR (CASES.HYTCY like '%齊艷%') OR (CASES.HYTCY_ID like '%0F320083%') OR (CASES.BH > 0)) ORDER BY CASES.ND ASC,              CASES.CASEWORD ASC,              CASES.BH ASC     
00:00000:00447:2015/12/27 09:32:57.01 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.8'.
00:00000:00447:2015/12/27 09:32:57.01 server  SQL Text: select count ( *) from FLOWREC WHERE YWPK ='187700000148458' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00398:2015/12/27 09:32:57.01 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.8'.
00:00000:00398:2015/12/27 09:32:57.01 server  SQL Text: SELECT FLOWREC.NODENO,              NODES.NODENAME,              COUNT(*) AS JS        FROM FLOWREC,              NODES    WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') and ( FLOWREC.NODENO = NODES.NODENO ) and(FLOWREC.FLOWNO <>'540') and(FLOWREC.FLOWNO <>'728') GROUP BY FLOWREC.NODENO,              NODES.NODENAME    ORDER BY FLOWREC.NODENO A
00:00000:00398:2015/12/27 09:33:51.29 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.49'.
00:00000:00398:2015/12/27 09:33:51.31 server  SQL Text: SELECT FLOWREC.NODENO,              NODES.NODENAME,              COUNT(*) AS JS        FROM FLOWREC,              NODES    WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') and ( FLOWREC.NODENO = NODES.NODENO ) and(FLOWREC.FLOWNO <>'540') and(FLOWREC.FLOWNO <>'728') GROUP BY FLOWREC.NODENO,              NODES.NODENAME    ORDER BY FLOWREC.NODENO A
00:00000:00145:2015/12/27 09:33:51.31 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.49'.
00:00000:00145:2015/12/27 09:33:51.31 server  SQL Text: select PARMVALUE FROM S_SYSPARM WHERE PARMCODE ='DBAJXSCBR'
00:00000:00254:2015/12/27 09:33:51.31 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.49'.
00:00000:00254:2015/12/27 09:33:51.31 server  SQL Text: update FLOWREC set DQR ='1-2-2043 9:32:9.313' WHERE YWPK ='187700000156276' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00110:2015/12/27 09:33:51.31 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.49'.
00:00000:00110:2015/12/27 09:33:51.31 server  SQL Text: select o.name, o.id, o.type, o.uid, user_name(o.uid) from sysusers u, sysobjects o  where o.name like 'DATACODE' and user_name(o.uid) like 'escourt4'
00:00000:00447:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00447:2015/12/27 09:34:09.65 server  SQL Text: update FLOWREC set DQR ='6-29-2042 9:44:34.500' WHERE YWPK ='187700000149242' and STATE ='1' and ( NODENO ='49' or NODENO ='63' or NODENO ='66' )
00:00000:00360:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00360:2015/12/27 09:34:09.65 server  SQL Text: J,              SPACE(100) AS ANHAO,              SPACE(10) AS JARQ,                          SPACE(255) AS SXSM,                          0 AS BZ,                          0 AS DB,                          0 AS SDB,                          SPACE(20) AS CBR,                          SPACE(20) AS CBBM      FROM FLOWREC       WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F320178' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0018') ORDER BY FLOWREC.NODENO ASC,              FLOWREC.BDATETIME ASC      
00:00000:00346:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00346:2015/12/27 09:34:09.65 server  SQL Text: J,              SPACE(100) AS ANHAO,              SPACE(10) AS JARQ,                          SPACE(255) AS SXSM,                          0 AS BZ,                          0 AS DB,                          0 AS SDB,                          SPACE(20) AS CBR,                          SPACE(20) AS CBBM      FROM FLOWREC       WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F320029' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0018') ORDER BY FLOWREC.NODENO ASC,              FLOWREC.BDATETIME ASC      
00:00000:00407:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00407:2015/12/27 09:34:09.65 server  SQL Text: SELECT FLOWREC.NODENO,              NODES.NODENAME,              COUNT(*) AS JS        FROM FLOWREC,              NODES    WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') and ( FLOWREC.NODENO = NODES.NODENO ) and(FLOWREC.FLOWNO <>'540') and(FLOWREC.FLOWNO <>'728') GROUP BY FLOWREC.NODENO,              NODES.NODENAME    ORDER BY FLOWREC.NODENO A
00:00000:00326:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00326:2015/12/27 09:34:09.65 server  SQL Text: SELECT FLOWREC.NODENO,              NODES.NODENAME,              COUNT(*) AS JS        FROM FLOWREC,              NODES    WHERE ( FLOWREC.STATE = '1' ) AND ( FLOWREC.NODEUSER = '0F32019A' or FLOWREC.NODEROLE = '0002' or FLOWREC.NODEROLE = '0003' or FLOWREC.NODEROLE = '0018') and ( FLOWREC.NODENO = NODES.NODENO ) and(FLOWREC.FLOWNO <>'540') and(FLOWREC.FLOWNO <>'728') GROUP BY FLOWREC.NODENO,              NODES.NODENAME    ORDER BY FLOWREC.NODENO A
00:00000:00110:2015/12/27 09:34:09.65 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.111'.
00:00000:00110:2015/12/27 09:34:09.65 server  SQL Text: select USERID,USERNAME,OFFICEID,SORTID FROM S_USER WHERE STATE = '0' order by SORTID
00:00000:00376:2015/12/27 09:35:19.90 server  Error 1204, Severity 17, State 1 occurred for User 'table_dba'. Client IP address is '10.28.163.8'.
---------
0:00000:00114:2015/12/27 10:53:28.54 server  Error 1204, Severity 17, State 2 occurred for User 'escourt4'. Client IP address is '10.28.163.193'.
00:00000:00114:2015/12/27 10:53:28.54 server  SQL Text: ,'0018'))))
00:00000:00190:2015/12/27 10:54:24.00 kernel  Cannot send, host process disconnected:  3416 suid: 6
00:00000:00190:2015/12/27 10:54:24.03 server  Error: 1608, Severity: 18, State: 4
00:00000:00190:2015/12/27 10:54:24.03 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00190:2015/12/27 10:54:24.03 kernel  extended error information: hostname:  login: escourt4
00:00000:00057: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:00162: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:00447: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:00271: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:00050: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: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:00021:2015/12/27 11:06:34.46 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.46 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:00254:2015/12/27 11:06:34.46 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:00224:2015/12/27 11:06:34.54 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:00471:2015/12/27 11:06:34.54 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:00477:2015/12/27 11:06:34.71 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:00088:2015/12/27 11:06:34.75 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:00006:2015/12/27 11:06:34.96 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:00349:2015/12/27 11:06:35.18 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:00047:2015/12/27 11:06:35.26 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:00237:2015/12/27 11:06:35.40 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:00365:2015/12/27 11:06:35.60 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:00093:2015/12/27 11:06:35.75 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:00309:2015/12/27 11:06:36.12 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:00368:2015/12/27 11:06:36.51 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:00101:2015/12/27 11:06:36.60 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:00219:2015/12/27 11:06:36.67 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:00085:2015/12/27 11:06:36.73 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:00029:2015/12/27 11:06:37.09 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:00153:2015/12/27 11:06:42.96 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:00357:2015/12/27 11:06:43.26 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: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。

qinglaninfo

到了11點(diǎn)之后就一直是
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。
這兩行在重復(fù)

wfcjz

你的庫(kù)有兩個(gè)問(wèn)題，一個(gè)是鎖不夠用了，一個(gè)是日志滿(mǎn)了。

鎖數(shù)量不夠。適當(dāng)增大number of locks試試解決此錯(cuò)誤。

1. 
   
2. 1> sp_monitorconfig "number of locks"
   
3. 2> go
   

復(fù)制代碼

看一下你的最大是多少。然后根據(jù)那個(gè)加吧，最省事的辦法，只接加到300000

1. 
   
2. 1>sp_configure "number of locks",400000
   
3. 2>go
   

復(fù)制代碼

做日志截?cái)?div id="a9ur7n9vt" class="blockcode">

1. 
   
2. >sp_dboption database_name,"trunc log on chkpt",true
   
3. >go
   
4. >checkpoint
   
5. >go
   

復(fù)制代碼也可以做日志清除(這個(gè)不建議做，如果采用dump/loan做數(shù)據(jù)恢復(fù)有些麻煩）

1. 
   
2. >dump transaction databasename with no_log  
   
3. >go
   

復(fù)制代碼