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 '%開庭%'
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 時間: 2015-12-27 13:33
到了11點之后就一直是
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 時間: 2015-12-27 17:43
你的庫有兩個問題，一個是鎖不夠用了，一個是日志滿了。
鎖數(shù)量不夠。適當(dāng)增大number of locks試試解決此錯誤。
1> sp_monitorconfig "number of locks"
2> go
復(fù)制代碼
看一下你的最大是多少。然后根據(jù)那個加吧，最省事的辦法，只接加到300000
1>sp_configure "number of locks",400000
2>go
復(fù)制代碼
做日志截斷
>sp_dboption database_name,"trunc log on chkpt",true