求助:sybase 无故宕机,麻烦高手分析,非常感谢!
偶有一个sybase数据在运行过程中突然异常宕机,以下为sybase 宕机数据库的日志,偶十分想知道造成宕机的原因,请高手帮助分析一下,万分感谢!!
01:00000:03042:2019/02/20 16:00:00.74 server DBCC TRACEON 3604, SPID 3042
01:00000:03042:2019/02/20 16:00:00.80 server DBCC TRACEOFF 3604, SPID 3042
05:00000:02503:2019/02/20 16:01:01.44 server DBCC TRACEON 3604, SPID 2503
05:00000:02503:2019/02/20 16:01:02.47 server DBCC TRACEOFF 3604, SPID 2503
07:00000:01425:2019/02/20 16:03:18.54 kernel Cannot read, host process disconnected: spid: 1425
06:00000:00781:2019/02/20 16:06:01.18 server DBCC TRACEON 3604, SPID 781
18:00000:00781:2019/02/20 16:06:02.22 server DBCC TRACEOFF 3604, SPID 781
18:00000:02597:2019/02/20 16:11:01.09 server DBCC TRACEON 3604, SPID 2597
11:00000:02597:2019/02/20 16:11:12.97 server DBCC TRACEOFF 3604, SPID 2597
02:00000:01247:2019/02/20 16:16:00.74 server DBCC TRACEON 3604, SPID 1247
02:00000:01247:2019/02/20 16:16:01.87 server DBCC TRACEOFF 3604, SPID 1247
11:00000:02010:2019/02/20 16:21:01.12 server DBCC TRACEON 3604, SPID 2010
11:00000:02010:2019/02/20 16:21:01.95 server DBCC TRACEOFF 3604, SPID 2010
13:00000:01541:2019/02/20 16:26:38.94 kernel timeslice -1501, current process infected
13:00000:01541:2019/02/20 16:26:38.94 kernel timeslice error: spid 1541 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1500 ticks (150000 milliseconds). It has been marked for termination.
13:00000:01541:2019/02/20 16:26:38.94 kernel ************************************
13:00000:01541:2019/02/20 16:26:38.94 kernel SQL causing error : select a1,a2,a3 from a where
13:00000:01541:2019/02/20 16:26:38.94 kernel Current statement number: 2 Current line number: 1
13:00000:01541:2019/02/20 16:26:38.94 kernel ************************************
13:00000:01541:2019/02/20 16:26:38.94 server SQL Text: select a1,a2,a3 from a
13:00000:01541:2019/02/20 16:26:38.94 server SQL Text: select a1,a2,a3 from a
13:00000:01541:2019/02/20 16:26:38.94 kernel curdb = 4 tempdb = 2 pstat = 0x10000
13:00000:01541:2019/02/20 16:26:38.94 kernel lasterror = 0 preverror = 0 transtate = 1
13:00000:01541:2019/02/20 16:26:38.94 kernel curcmd = 193 program =
13:00000:01541:2019/02/20 16:26:38.94 kernel extended error information: hostname: login: user
13:00000:01541:2019/02/20 16:26:38.94 kernel pc: 0x0000000100024b80 pcstkwalk+0x88()
13:00000:01541:2019/02/20 16:26:38.94 kernel pc: 0x000000010002460c ucstkgentrace+0x1ac()
13:00000:01541:2019/02/20 16:26:38.94 kernel pc: 0x0000000100023d30 ucbacktrace+0x90()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x00000001001d41e4 terminate_process__fdpr_1+0x734()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101a06f1c kitermproc@AF12_9__fdpr_1+0x94()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d167f8 aix_get_lock+0x50()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d0f560 fg_lock+0x260()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d0fd40 bt__lock+0x1d0()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d10134 bt_getnext+0x120()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d0c024 dol_bt_getnext+0x198()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d1c244 getnext+0x124()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d1cec8 LeScanOp::_LeOpNext(ExeCtxt&)+0x168()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101cfa744 LeEmitSndOp::_LeOpNext(ExeCtxt&)+0x234()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101ce8194 LePlanNext+0x128()
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101fc553c le_execerr+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101fc4ed0 aritherr+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101ce7de4 exec_lava__fdpr_16+0xe0()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101cd2520 s_execute__fdpr_84+0x3c()
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101ebe4b0 hdl_stack+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101ecc58c s_handle+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101ccd448 sequencer+0x230()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101cb1664 execproc+0x3a4()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101cb216c s_execute__fdpr_73+0xb4()
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101ebe4b0 hdl_stack+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101ecc58c s_handle+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101ccd448 sequencer+0x230()
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101d927d0 tdsrecv_language+0xb8()
13:00000:01541:2019/02/20 16:26:38.96 kernel [Handler pc: 0x0000000101e99394 ut_handle+0x0 installed by the following function:-]
13:00000:01541:2019/02/20 16:26:38.96 kernel pc: 0x0000000101cb34cc conn_hdlr__fdpr_14+0x3c()
13:00000:01541:2019/02/20 16:26:38.96 kernel end of stack trace, spid 1541, kpid 1872037201, suid 3
13:00000:01534:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 7012622 spid: 1534
13:00000:01477:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 2097598 spid: 1477
13:00000:01481:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 13108370 spid: 1481
13:00000:01527:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 11534442 spid: 1527
13:00000:02234:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 18875282 spid: 2234
13:00000:02677:2019/02/20 16:26:39.01 kernel Cannot read, host process disconnected: 5702186 spid: 2677
06:00000:01012:2019/02/20 16:26:39.04 kernel timeslice -1501, current process infected
06:00000:01012:2019/02/20 16:26:39.04 kernel timeslice error: spid 1012 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1500 ticks (150000 milliseconds). It has been marked for termination.
06:00000:01012:2019/02/20 16:26:39.04 kernel Spinlocks held by kpid 902629870
06:00000:01012:2019/02/20 16:26:39.04 kernel Spinlock fglockspins at address 0000000165578120 owned by 902629870
06:00000:01012:2019/02/20 16:26:39.04 kernel End of spinlock display.
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000100024b80 pcstkwalk+0x88()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x000000010002460c ucstkgentrace+0x1ac()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000100023d30 ucbacktrace+0x90()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x00000001001d3b4c terminate_process__fdpr_1+0x9c()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101a06f1c kitermproc@AF12_9__fdpr_1+0x94()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x000000010009edbc IPRA.$lock__set_sleepingowner_list__fdpr_1+0x44()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101e531cc IPRA.$lock__check_deadlock+0x158()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101e534e8 lock__perform_deadlock_search+0x120()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d308f4 lock__semawait__fdpr_5+0x1c0()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101e84ae8 lock_waitfor_range+0x448()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d2fd10 bt__lock_nextkey__fdpr_2+0x130()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d2f424 bt__insert_into_leaf+0x18()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d2f260 bt__traverseandinsert+0x68()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d721dc bt_insert+0x174()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101d71fbc dol__ncinsert+0x3e8()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101cd7788 dol_insert__fdpr_10+0x1c4()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101cd8290 ins_insert__fdpr_6+0x10()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101cd7e6c insert_all+0xac()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101cedfa0 LeInsertOp::_LeOpNext(ExeCtxt&)+0x360()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101ced6e8 LeEmitNoSndOp::_LeOpNext(ExeCtxt&)+0x264()
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101ce8194 LePlanNext+0x128()
06:00000:01012:2019/02/20 16:26:39.04 kernel [Handler pc: 0x0000000101fc553c le_execerr+0x0 installed by the following function:-]
06:00000:01012:2019/02/20 16:26:39.04 kernel [Handler pc: 0x0000000101fc4ed0 aritherr+0x0 installed by the following function:-]
06:00000:01012:2019/02/20 16:26:39.04 kernel pc: 0x0000000101ce7de4 exec_lava__fdpr_16+0xe0()