sybase宕机求助

enigmazero

sybase在处理数据时自己宕机了，下面是日志，请帮忙找一下为什么好么？


04:00000:00240:2007/07/09 23:00:46.14 kernel Cannot read, host process disconnected: 688336 spid: 240
07:00000:00378:2007/07/09 23:51:01.86 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 378 is set to default values.
04:00000:01178:2007/07/09 23:51:01.86 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1178 is set to default values.
02:00000:00013:2007/07/09 23:51:01.85 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 13 is set to default values.
04:00000:00745:2007/07/09 23:51:01.95 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 745 is set to default values.
07:00000:01130:2007/07/09 23:51:02.03 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1130 is set to default values.
03:00000:00378:2007/07/09 23:51:10.37 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 378 is set to default values.
07:00000:00400:2007/07/09 23:51:14.88 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 400 is set to default values.
03:00000:01130:2007/07/09 23:52:22.83 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1130 is set to default values.
03:00000:00158:2007/07/09 23:52:51.89 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 158 is set to default values.
03:00000:00158:2007/07/09 23:52:51.92 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 158 is set to default values.
02:00000:00010:2007/07/09 23:52:52.08 server Error: 1204, Severity: 17, State: 2
02:00000:00010:2007/07/09 23:52:52.10 server SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
07:00000:00516:2007/07/09 23:53:04.47 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 516 is set to default values.
07:00000:00153:2007/07/09 23:53:04.47 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 153 is set to default values.
06:00000:00153:2007/07/09 23:53:04.56 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 153 is set to default values.
07:00000:00989:2007/07/09 23:53:11.52 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 989 is set to default values.
07:00000:00750:2007/07/09 23:53:14.22 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 750 is set to default values.
02:00000:00750:2007/07/09 23:53:14.76 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 750 is set to default values.
02:00000:00750:2007/07/09 23:53:14.77 server Error: 216, Severity: 20, State: 3
02:00000:00750:2007/07/09 23:53:14.77 server Attempt to automatically drop temporary table failed.
02:00000:00750:2007/07/09 23:53:14.77 server Error: 216, Severity: 20, State: 3
02:00000:00750:2007/07/09 23:53:14.77 server Attempt to automatically drop temporary table failed.
02:00000:00750:2007/07/09 23:53:14.85 kernel ************************************
02:00000:00750:2007/07/09 23:53:14.86 kernel SQL causing error : execute p_interface_writetask 5,'m','200706',null

02:00000:00750:2007/07/09 23:53:14.86 kernel ************************************
02:00000:00750:2007/07/09 23:53:14.87 server SQL Text: execute p_interface_writetask 5,'m','200706',null
02:00000:00750:2007/07/09 23:53:14.87 kernel curdb = 4 pstat = 0x10000 lasterror = 216
02:00000:00750:2007/07/09 23:53:14.87 kernel preverror = 0 transtate = 3
02:00000:00750:2007/07/09 23:53:14.87 kernel curcmd = 196 program = isql
02:00000:00750:2007/07/09 23:53:14.91 kernel pc: 0x000000010034c374 .pcstkwalk+0x88()
02:00000:00750:2007/07/09 23:53:14.91 kernel pc: 0x000000010034ca2c .ucstkgentrace+0x238()
02:00000:00750:2007/07/09 23:53:14.91 kernel pc: 0x000000010034b7c0 .ucbacktrace+0x78()
02:00000:00750:2007/07/09 23:53:14.92 kernel pc: 0x000000010021d41c .terminate_process[3]+0x7d4()
02:00000:00750:2007/07/09 23:53:14.93 kernel pc: 0x000000010021032c .close_network+0x18()
02:00000:00750:2007/07/09 23:53:14.93 kernel pc: 0x000000010020ffb0 .hdl_default+0x50()
02:00000:00750:2007/07/09 23:53:14.93 kernel pc: 0x00000001005fae18 .s_handle+0x1288()
02:00000:00750:2007/07/09 23:53:14.93 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
02:00000:00750:2007/07/09 23:53:14.93 kernel pc: 0x00000001005fbda8 .s_free[10]+0x6c()
02:00000:00750:2007/07/09 23:53:14.95 kernel pc: 0x0000000100038948 .s_pop+0x34()
02:00000:00750:2007/07/09 23:53:14.96 kernel pc: 0x0000000100129790 .s_cleanframe+0x108()
02:00000:00750:2007/07/09 23:53:14.96 kernel pc: 0x00000001005faa44 .s_handle+0xeb4()
02:00000:00750:2007/07/09 23:53:14.96 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
02:00000:00750:2007/07/09 23:53:14.96 kernel pc: 0x0000000100354f88 .lock__fillcache[1]+0x1d0()
02:00000:00750:2007/07/09 23:53:14.96 kernel pc: 0x00000001000c2970 .lock_logical[32]+0xc()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x0000000100003bb4 .fglock[1]+0x34()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x000000010007edb0 .dol__get_lock[1]+0x20()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x0000000100452fcc .dol_qualrow[13]+0x73c()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x00000001001619d8 .dol_oamscan_getnext[1]+0x104()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x000000010000c360 .getnext[1]+0x5c()
02:00000:00750:2007/07/09 23:53:14.97 kernel pc: 0x000000010000b5d0 .ind__ides_get[1]+0xb0()
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x000000010001f7f0 .exec_eop[10]+0x40()
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x00000001004de158 .jcsExHandler installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x00000001001fe690 .sortmerr installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x00000001004d89cc .aritherr installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x0000000100007d60 .execute[1]+0x1c()
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x0000000100011c30 .s_execute[7]+0xc8()
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x000000010003b108 .execproc+0x2ac()
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x0000000100091534 .s_execute[41]+0xb0()
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x00000001000776dc .tdsrecv_language[1]+0x58()
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
02:00000:00750:2007/07/09 23:53:14.98 kernel pc: 0x000000010007732c .addstep[3]+0xb8()
02:00000:00750:2007/07/09 23:53:14.98 kernel end of stack trace, spid 750, kpid 482280197, suid 8
07:00000:00750:2007/07/09 23:53:15.36 server Error: 1204, Severity: 17, State: 2
07:00000:00750:2007/07/09 23:53:15.36 server SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
07:00000:01288:2007/07/09 23:59:01.08 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1288 is set to default values.
07:00000:00249:2007/07/09 23:59:01.30 server login: Process with spid 249 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00920:2007/07/09 23:59:01.57 server login: Process with spid 920 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00699:2007/07/09 23:59:03.50 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 699 is set to default values.
07:00000:00754:2007/07/09 23:59:06.05 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 754 is set to default values.
07:00000:01042:2007/07/09 23:59:07.32 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1042 is set to default values.
07:00000:00381:2007/07/09 23:59:07.65 server login: Process with spid 381 could not connect to the SQL Server which has temporarily run out of locks.
02:00000:00352:2007/07/09 23:59:11.76 kernel Cannot read, host process disconnected: p650 721126 spid: 352
05:00000:00779:2007/07/09 23:59:11.80 kernel Cannot read, host process disconnected: p650 721122 spid: 779
07:00000:01001:2007/07/09 23:59:14.25 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1001 is set to default values.
07:00000:00009:2007/07/09 23:59:28.92 server Error: 1204, Severity: 17, State: 1
07:00000:00009:2007/07/09 23:59:28.92 server SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
07:00000:01296:2007/07/09 23:59:36.00 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1296 is set to default values.
07:00000:01300:2007/07/09 23:59:56.92 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1300 is set to default values.
07:00000:00051:2007/07/10 00:00:19.76 server login: Process with spid 51 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00817:2007/07/10 00:00:21.08 server login: Process with spid 817 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00685:2007/07/10 00:00:22.08 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 685 is set to default values.
01:00000:01178:2007/07/10 00:01:33.79 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1178 is set to default values.
06:00000:00496:2007/07/10 00:02:51.15 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 496 is set to default values.
07:00000:00490:2007/07/10 00:02:51.15 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 490 is set to default values.
07:00000:00852:2007/07/10 00:02:51.15 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 852 is set to default values.
06:00000:00490:2007/07/10 00:02:51.81 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 490 is set to default values.
07:00000:00490:2007/07/10 00:02:51.90 server Error: 216, Severity: 20, State: 3
07:00000:00490:2007/07/10 00:02:51.90 server Attempt to automatically drop temporary table failed.
07:00000:00490:2007/07/10 00:02:51.90 server Error: 216, Severity: 20, State: 3
07:00000:00490:2007/07/10 00:02:51.90 server Attempt to automatically drop temporary table failed.
07:00000:00490:2007/07/10 00:02:51.90 kernel ************************************
07:00000:00490:2007/07/10 00:02:51.90 kernel SQL causing error : execute p_interface_writetask 13,'m','200706',null

07:00000:00490:2007/07/10 00:02:51.90 kernel ************************************
07:00000:00490:2007/07/10 00:02:51.90 server SQL Text: execute p_interface_writetask 13,'m','200706',null
07:00000:00490:2007/07/10 00:02:51.90 kernel curdb = 4 pstat = 0x10000 lasterror = 216
07:00000:00490:2007/07/10 00:02:51.90 kernel preverror = 0 transtate = 3
07:00000:00490:2007/07/10 00:02:51.90 kernel curcmd = 196 program = isql
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010034c374 .pcstkwalk+0x88()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010034ca2c .ucstkgentrace+0x238()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010034b7c0 .ucbacktrace+0x78()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010021d41c .terminate_process[3]+0x7d4()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010021032c .close_network+0x18()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010020ffb0 .hdl_default+0x50()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001005fae18 .s_handle+0x1288()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001005fbda8 .s_free[10]+0x6c()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100038948 .s_pop+0x34()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100129790 .s_cleanframe+0x108()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001005faa44 .s_handle+0xeb4()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100354f88 .lock__fillcache[1]+0x1d0()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001000c2970 .lock_logical[32]+0xc()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100003bb4 .fglock[1]+0x34()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010007edb0 .dol__get_lock[1]+0x20()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100452fcc .dol_qualrow[13]+0x73c()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001001619d8 .dol_oamscan_getnext[1]+0x104()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010000c360 .getnext[1]+0x5c()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010000b5d0 .ind__ides_get[1]+0xb0()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010001f7f0 .exec_eop[10]+0x40()
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x00000001004de158 .jcsExHandler installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x00000001001fe690 .sortmerr installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x00000001004d89cc .aritherr installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100007d60 .execute[1]+0x1c()
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100011c30 .s_execute[7]+0xc8()
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010003b108 .execproc+0x2ac()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100091534 .s_execute[41]+0xb0()
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x00000001000776dc .tdsrecv_language[1]+0x58()
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:00490:2007/07/10 00:02:51.90 kernel pc: 0x000000010007732c .addstep[3]+0xb8()
07:00000:00490:2007/07/10 00:02:51.90 kernel end of stack trace, spid 490, kpid 483983655, suid 8
07:00000:00221:2007/07/10 00:02:52.76 server login: Process with spid 221 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00490:2007/07/10 00:02:52.76 server Error: 1204, Severity: 17, State: 2

chenfeng825

原帖由 enigmazero 于 2007-7-10 10:42 发表
sybase在处理数据时自己宕机了，下面是日志，请帮忙找一下为什么好么？


04:00000:00240:2007/07/09 23:00:46.14 kernel Cannot read, host process disconnected: 688336 spid: 240
07:00000:00378:2007/ ...

看起来是number of locks不够导致的自动删除临时表出错！
sp_configure 'number of locks'后再看！

enigmazero

日志没有贴完，还有部分在下面
07:00000:00490:2007/07/10 00:02:52.76 server SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
07:00000:00302:2007/07/10 00:02:54.59 server login: Process with spid 302 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01160:2007/07/10 00:02:56.25 server login: Process with spid 1160 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00562:2007/07/10 00:02:58.17 server login: Process with spid 562 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00911:2007/07/10 00:03:00.03 server login: Process with spid 911 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00663:2007/07/10 00:03:01.99 server login: Process with spid 663 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00495:2007/07/10 00:03:03.64 server login: Process with spid 495 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00959:2007/07/10 00:03:05.43 server login: Process with spid 959 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01095:2007/07/10 00:03:06.45 server login: Process with spid 1095 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00465:2007/07/10 00:03:07.13 server login: Process with spid 465 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00782:2007/07/10 00:03:07.15 server login: Process with spid 782 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00616:2007/07/10 00:03:07.73 server login: Process with spid 616 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01049:2007/07/10 00:03:08.41 server login: Process with spid 1049 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00938:2007/07/10 00:03:08.79 server login: Process with spid 938 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00628:2007/07/10 00:03:09.14 server login: Process with spid 628 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01125:2007/07/10 00:03:09.73 server login: Process with spid 1125 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00537:2007/07/10 00:03:10.35 server login: Process with spid 537 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01321:2007/07/10 00:03:10.43 server login: Process with spid 1321 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01136:2007/07/10 00:03:11.08 server login: Process with spid 1136 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00601:2007/07/10 00:03:11.95 server login: Process with spid 601 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01075:2007/07/10 00:03:12.80 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1075 is set to default values.
07:00000:00895:2007/07/10 00:03:13.51 server login: Process with spid 895 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00206:2007/07/10 00:03:14.63 server login: Process with spid 206 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00343:2007/07/10 00:03:14.67 server login: Process with spid 343 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00205:2007/07/10 00:03:15.31 server login: Process with spid 205 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01034:2007/07/10 00:03:16.46 server login: Process with spid 1034 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01343:2007/07/10 00:03:16.66 server login: Process with spid 1343 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00552:2007/07/10 00:03:16.74 server login: Process with spid 552 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01072:2007/07/10 00:03:17.54 server login: Process with spid 1072 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00666:2007/07/10 00:03:18.20 server login: Process with spid 666 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00768:2007/07/10 00:03:18.32 server login: Process with spid 768 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00244:2007/07/10 00:03:18.90 server login: Process with spid 244 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00034:2007/07/10 00:03:19.50 server login: Process with spid 34 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00187:2007/07/10 00:03:20.05 server login: Process with spid 187 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01236:2007/07/10 00:03:21.27 server login: Process with spid 1236 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01272:2007/07/10 00:03:22.85 server login: Process with spid 1272 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01338:2007/07/10 00:03:24.33 server login: Process with spid 1338 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:00145:2007/07/10 00:03:25.83 server login: Process with spid 145 could not connect to the SQL Server which has temporarily run out of locks.
07:00000:01168:2007/07/10 00:03:27.22 server login: Process with spid 1168 could not connect to the SQL Server which has temporarily run out of locks.
00:00000:00496:2007/07/10 00:03:28.96 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 496 is set to default values.
07:00000:01390:2007/07/10 00:06:03.57 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1390 is set to default values.
07:00000:01372:2007/07/10 00:06:03.57 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1372 is set to default values.
07:00000:01390:2007/07/10 00:06:04.03 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1390 is set to default values.
07:00000:01390:2007/07/10 00:06:04.03 server Error: 216, Severity: 20, State: 3
07:00000:01390:2007/07/10 00:06:04.03 server Attempt to automatically drop temporary table failed.
07:00000:01390:2007/07/10 00:06:04.03 server Error: 216, Severity: 20, State: 3
07:00000:01390:2007/07/10 00:06:04.03 server Attempt to automatically drop temporary table failed.
07:00000:01390:2007/07/10 00:06:04.03 kernel ************************************
07:00000:01390:2007/07/10 00:06:04.03 kernel SQL causing error : ?
07:00000:01390:2007/07/10 00:06:04.03 kernel ************************************
07:00000:01390:2007/07/10 00:06:04.03 server SQL Text: ?
07:00000:01390:2007/07/10 00:06:04.03 kernel curdb = 4 pstat = 0x10000 lasterror = 216
07:00000:01390:2007/07/10 00:06:04.03 kernel preverror = 0 transtate = 3
07:00000:01390:2007/07/10 00:06:04.03 kernel curcmd = 195 program = CT-lib 0.1 sbaa
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010034c374 .pcstkwalk+0x88()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010034ca2c .ucstkgentrace+0x238()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010034b7c0 .ucbacktrace+0x78()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010021d41c .terminate_process[3]+0x7d4()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010021032c .close_network+0x18()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010020ffb0 .hdl_default+0x50()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001005fae18 .s_handle+0x1288()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001005fbda8 .s_free[10]+0x6c()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100038948 .s_pop+0x34()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100129790 .s_cleanframe+0x108()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001005faa44 .s_handle+0xeb4()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100354f88 .lock__fillcache[1]+0x1d0()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x00000001000c2970 .lock_logical[32]+0xc()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100003bb4 .fglock[1]+0x34()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010002d4d8 .apl_getnext[2]+0x88()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010000b9c0 .getnext+0x78()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010000b8d0 .ind__ides_get[1]+0x3b0()
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010001f7f0 .exec_eop[10]+0x40()
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x00000001004de158 .jcsExHandler installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x00000001001fe690 .sortmerr installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x000000010042d6b8 .execerr installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x00000001004d89cc .aritherr installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100007d60 .execute[1]+0x1c()
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100011c30 .s_execute[7]+0xc8()
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
07:00000:01390:2007/07/10 00:06:04.03 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.03 kernel pc: 0x000000010003b108 .execproc+0x2ac()
07:00000:01390:2007/07/10 00:06:04.06 kernel [Handler pc: 0x00000001008cd4e8 .execrpc_handle installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x000000010003c0f4 .execrpc[2]+0x6c()
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x000000010003b858 .tdsrecv_rpc+0x20()
07:00000:01390:2007/07/10 00:06:04.06 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.06 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.06 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x0000000100037f0c .conn_hdlr[1]+0x16c()
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x0000000100015270 +0x1c()
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x000000010001524c .kpinitproc[1]+0x1c()
07:00000:01390:2007/07/10 00:06:04.06 kernel pc: 0x0000000000000000 ()
07:00000:01390:2007/07/10 00:06:04.06 kernel end of stack trace, spid 1390, kpid 487391374, suid 8
07:00000:01390:2007/07/10 00:06:04.87 server Error: 1204, Severity: 17, State: 2
07:00000:01390:2007/07/10 00:06:04.87 server SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
07:00000:01310:2007/07/10 00:06:07.03 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1310 is set to default values.
07:00000:01027:2007/07/10 00:06:09.14 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1027 is set to default values.
07:00000:01027:2007/07/10 00:06:09.15 server Error: 707, Severity: 20, State: 1
07:00000:01027:2007/07/10 00:06:09.15 server System error detected during attempt to free memory at address 0x190306000. Please consult the SQL Server error log for more details.
07:00000:01027:2007/07/10 00:06:09.15 kernel ************************************
07:00000:01027:2007/07/10 00:06:09.15 kernel SQL causing error : execute p_interface_writetask 13,'m','200706',null

07:00000:01027:2007/07/10 00:06:09.15 kernel ************************************
07:00000:01027:2007/07/10 00:06:09.15 server SQL Text: execute p_interface_writetask 13,'m','200706',null
07:00000:01027:2007/07/10 00:06:09.15 kernel curdb = 4 pstat = 0x10000 lasterror = 707
07:00000:01027:2007/07/10 00:06:09.15 kernel preverror = 0 transtate = 1
07:00000:01027:2007/07/10 00:06:09.15 kernel curcmd = 224 program = isql
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010034c374 .pcstkwalk+0x88()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010034ca2c .ucstkgentrace+0x238()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010034b7c0 .ucbacktrace+0x78()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010021d41c .terminate_process[3]+0x7d4()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010021032c .close_network+0x18()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x000000010020ffb0 .hdl_default+0x50()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x00000001005fa584 .s_handle+0x9f4()
07:00000:01027:2007/07/10 00:06:09.15 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x0000000100383788 .mem__free_this_phdr[12]+0x98()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x0000000100032be8 .memfree[1]+0x10()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x000000010038591c .proc_read__backout+0x60()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x00000001003857d8 +0xb4()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x00000001001736a4 .ex_raise[1]+0x48()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x0000000100354f88 .lock__fillcache[1]+0x1d0()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x00000001000c2970 .lock_logical[32]+0xc()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x0000000100003bb4 .fglock[1]+0x34()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x000000010002d4d8 .apl_getnext[2]+0x88()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x000000010000c360 .getnext[1]+0x5c()
07:00000:01027:2007/07/10 00:06:09.16 kernel pc: 0x00000001000343e0 .proc__fetchphdr[1]+0x7c()
07:00000:01027:2007/07/10 00:06:09.16 kernel [Handler pc: 0x0000000100385724 installed by the following function:-]
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x00000001000dac68 .proc_read+0x3ac()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x00000001000db3bc .proc_get[2]+0xac()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x0000000100039df0 .s_getTreeOrPlan+0xd4()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x000000010003af94 .execproc+0x138()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x0000000100091534 .s_execute[41]+0xb0()
07:00000:01027:2007/07/10 00:06:09.18 kernel [Handler pc: 0x00000001005f9b90 .s_handle installed by the following function:-]
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x0000000100036528 .sequencer[1]+0x174()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x00000001000776dc .tdsrecv_language[1]+0x58()
07:00000:01027:2007/07/10 00:06:09.18 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
07:00000:01027:2007/07/10 00:06:09.18 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:01027:2007/07/10 00:06:09.18 kernel [Handler pc: 0x000000010044b044 .ut_handle installed by the following function:-]
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x000000010007732c .addstep[3]+0xb8()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x0000000100015270 +0x1c()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x000000010001524c .kpinitproc[1]+0x1c()
07:00000:01027:2007/07/10 00:06:09.18 kernel pc: 0x0000000000000000 ()
07:00000:01027:2007/07/10 00:06:09.18 kernel end of stack trace, spid 1027, kpid 487653653, suid 8
04:00000:01310:2007/07/10 00:07:41.58 server Logical Process Manager Warning: Due to internal error, the execution attribute values of spid 1310 is set to default values.
00:00000:00010:2007/07/10 00:16:14.48 kernel current process (0x390039) infected with 11
00:00000:00010:2007/07/10 00:16:14.51 kernel Error at address 0x0000000100099a1c (.pss_get_active_or_sick+0x8c)
00:00000:00010:2007/07/10 00:16:14.51 kernel Spinlocks held by kpid 3735609

00:00000:00010:2007/07/10 00:16:14.51 kernel Spinlock Resource->rpssmgr_spin at address 000000016023af00 owned by 3735609
00:00000:00010:2007/07/10 00:16:14.51 kernel End of spinlock display.
00:00000:00010:2007/07/10 00:16:14.52 kernel pc: 0x000000010034c374 .pcstkwalk+0x88()
00:00000:00010:2007/07/10 00:16:14.52 kernel pc: 0x000000010034ca2c .ucstkgentrace+0x238()
00:00000:00010:2007/07/10 00:16:14.52 kernel pc: 0x000000010034b7c0 .ucbacktrace+0x78()
00:00000:00010:2007/07/10 00:16:14.52 kernel pc: 0x000000010021cc70 .terminate_process[3]+0x28()
00:00000:00010:2007/07/10 00:16:14.55 kernel pc: 0x00000001007df6e0 .kisignal+0xf4()
00:00000:00010:2007/07/10 00:16:14.55 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.56 kernel pc: 0x0000000100651600 .check_license_usage[2]+0xfc()
00:00000:00010:2007/07/10 00:16:14.56 kernel [Handler pc: 0x0000000100210014 .hdl_backout installed by the following function:-]
00:00000:00010:2007/07/10 00:16:14.58 kernel pc: 0x00000001000cb39c .hk__run_other_chores[1]+0x38()
00:00000:00010:2007/07/10 00:16:14.58 kernel pc: 0x00000001000c4ddc .hk__cycle_chores+0x90()
00:00000:00010:2007/07/10 00:16:14.58 kernel [Handler pc: 0x000000010020ffc8 .hdl_backout_msg installed by the following function:-]
00:00000:00010:2007/07/10 00:16:14.58 kernel pc: 0x00000001000c4cc0 .bt_validateplace+0x88()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x00000001001d380c .housekeeper+0x280()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000100015270 +0x1c()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x000000010001524c .kpinitproc[1]+0x1c()

enigmazero

00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel pc: 0x0000000000000000 ()
00:00000:00010:2007/07/10 00:16:14.59 kernel end of stack trace, spid 10, kpid 3735609, suid 0
00:00000:00010:2007/07/10 00:16:14.59 kernel ueshutdown: exiting
03:00000:00000:2007/07/10 00:16:15.08 kernel Unix interval timer enabled for sysclk interrupts.
02:00000:00000:2007/07/10 00:16:15.08 kernel Unix interval timer enabled for sysclk interrupts.
06:00000:00000:2007/07/10 00:16:15.08 kernel Unix interval timer enabled for sysclk interrupts.
05:00000:00000:2007/07/10 00:16:15.11 kernel Unix interval timer enabled for sysclk interrupts.
07:00000:00000:2007/07/10 00:16:15.11 kernel Unix interval timer enabled for sysclk interrupts.
00:00000:00010:2007/07/10 00:16:15.11 kernel Unix interval timer enabled for sysclk interrupts.
01:00000:00000:2007/07/10 00:16:15.13 kernel Unix interval timer enabled for sysclk interrupts.
04:00000:00000:2007/07/10 00:16:15.16 kernel Unix interval timer enabled for sysclk interrupts.

Sybase技术专家

如果您所购买的ASE产品仍然在服务器内（请联系相关行业和地区的销售人员确认）请到www.sybase.com下载相应平台和版本的ASE补丁进行安装。