免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 43876 | 回复: 2
打印 上一主题 下一主题

sybase 数据库报错,重启就好了 [复制链接]

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2015-12-30 06:20:00
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2015-12-27 13:32 |只看该作者 |倒序浏览
各位大神帮忙看一下什么问题
晚上还正常,今天早上就报这个错了。

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。

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2015-12-30 06:20:00
2 [报告]
发表于 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。
这两行在重复

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
3 [报告]
发表于 2015-12-27 17:43 |只看该作者
你的库有两个问题,一个是锁不够用了,一个是日志满了。

锁数量不够。适当增大number of locks试试解决此错误。

  1. 1> sp_monitorconfig "number of locks"
  2. 2> go
复制代码
看一下你的最大是多少。然后根据那个加吧,最省事的办法,只接加到300000

  1. 1>sp_configure "number of locks",400000
  2. 2>go
复制代码
做日志截断

  1. >sp_dboption database_name,"trunc log on chkpt",true
  2. >go
  3. >checkpoint
  4. >go
复制代码
也可以做日志清除(这个不建议做,如果采用dump/loan做数据恢复有些麻烦)

  1. >dump transaction databasename with no_log  
  2. >go
复制代码
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP