本文记录了一次数据库进程出现SQL错误的情况，详细展示了内核层面的时间切片、错误处理过程及堆栈跟踪信息。通过对日志的分析，可以了解在特定条件下数据库进程如何响应SQL错误并触发终止。
00:00000:01604:2014/07/02 22:01:18.74 kernel timeslice -501, current process infected
00:00000:01604:2014/07/02 22:02:29.24 kernel ************************************
00:00000:01604:2014/07/02 22:02:29.24 kernel SQL causing error :
00:00000:01604:2014/07/02 22:02:29.24 kernel ************************************
00:00000:01604:2014/07/02 22:02:29.24 server SQL Text:
00:00000:01604:2014/07/02 22:02:29.24 kernel curdb = 4 tempdb = 2 pstat = 0x10000
00:00000:01604:2014/07/02 22:02:29.24 kernel lasterror = 4016 preverror = 0 transtate = 1
00:00000:01604:2014/07/02 22:02:29.24 kernel curcmd = 0 program =
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x00000000808f6818 pcstkwalk+0x28(0x000001001bdd83e8, 0x000001001bdd7b60, 0x000000000000270f, 0x0000000000000002, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x00000000808f65f0 ucstkgentrace+0xbc(0x000000004a700b75, 0x0000000000000000, 0x000001008ae0ba80, 0x0000000000000000, 0x000001009df82030)
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x000000008089f8c8 ucbacktrace+0x84(0x0000000000000000, 0x0000000000000001, 0x000000000000001e, 0x000001008ae1fbf4, 0x0000010000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x000000008025131c terminate_process+0x860(0x000001008ae0ba80, 0x000000000000a400, 0x000001001bdd8b00, 0xffffffff7e04cb10, 0x2020202020202020)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7ded61c8 __sighndlr+0xc(0x0000000000000010, 0x000001001bdd8de0, 0x000001001bdd8b00, 0x00000000808bf4ec, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec9d2c call_user_handler+0x3e0(0xffffffff7e000200, 0xffffffff7e000200, 0x000001001bdd8b00, 0x0000000000000008, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec9f24 sigacthandler+0x54(0x0000000000000000, 0x000001001bdd8de0, 0x000001001bdd8b00, 0xffffffff7e000200, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec78d4 write+0x60(0x0000000000000001, 0x000001001bdd9100, 0x000000000000006b, 0x0000000000000000, 0x000000000000ff00)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b1ccc b_cerrlog_uio+0x94(0x000001001bdd9100, 0x000001001bdd9100, 0x0000000081133400, 0xffffffffffffffd3, 0x00000000801fbd84)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b0a88 uciverrlog+0x34(0x000000000000000a, 0x000000000002e6bd, 0x000001001bdd9440, 0x000000000a57327b, 0x0000000000009800)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b096c ucierrlog+0x20(0x000000000000000a, 0x000000000002e6bd, 0x0000000000000002, 0x000001008ae1fb87, 0xffffffff7ecbc8a0)
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000802aca98 hdl_backout installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x0000000080273024 login+0x1784(0x000000000000a400, 0x000001008ae160b0, 0x0000000000400000, 0x0000000000007800, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000802aca98 hdl_backout installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x0000000080201030 conn_hdlr+0x7c0(0x00000000000076b8, 0x0000000000001400, 0x000001008ae15804, 0x0000000000007400, 0xffffffffffffffff)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x000000008090cc48 _coldstart(0x000000000000061f, 0x0000000080200870, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel end of stack trace, spid 1604, kpid 1248856949, suid 14
08:00000:01980:2014/07/02 22:02:29.27 server DBCC TRACEON 3604, SPID 1980
00:00000:01604:2014/07/02 22:02:29.24 kernel ************************************
00:00000:01604:2014/07/02 22:02:29.24 kernel SQL causing error :
00:00000:01604:2014/07/02 22:02:29.24 kernel ************************************
00:00000:01604:2014/07/02 22:02:29.24 server SQL Text:
00:00000:01604:2014/07/02 22:02:29.24 kernel curdb = 4 tempdb = 2 pstat = 0x10000
00:00000:01604:2014/07/02 22:02:29.24 kernel lasterror = 4016 preverror = 0 transtate = 1
00:00000:01604:2014/07/02 22:02:29.24 kernel curcmd = 0 program =
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x00000000808f6818 pcstkwalk+0x28(0x000001001bdd83e8, 0x000001001bdd7b60, 0x000000000000270f, 0x0000000000000002, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x00000000808f65f0 ucstkgentrace+0xbc(0x000000004a700b75, 0x0000000000000000, 0x000001008ae0ba80, 0x0000000000000000, 0x000001009df82030)
00:00000:01604:2014/07/02 22:02:29.24 kernel pc: 0x000000008089f8c8 ucbacktrace+0x84(0x0000000000000000, 0x0000000000000001, 0x000000000000001e, 0x000001008ae1fbf4, 0x0000010000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x000000008025131c terminate_process+0x860(0x000001008ae0ba80, 0x000000000000a400, 0x000001001bdd8b00, 0xffffffff7e04cb10, 0x2020202020202020)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7ded61c8 __sighndlr+0xc(0x0000000000000010, 0x000001001bdd8de0, 0x000001001bdd8b00, 0x00000000808bf4ec, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec9d2c call_user_handler+0x3e0(0xffffffff7e000200, 0xffffffff7e000200, 0x000001001bdd8b00, 0x0000000000000008, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec9f24 sigacthandler+0x54(0x0000000000000000, 0x000001001bdd8de0, 0x000001001bdd8b00, 0xffffffff7e000200, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0xffffffff7dec78d4 write+0x60(0x0000000000000001, 0x000001001bdd9100, 0x000000000000006b, 0x0000000000000000, 0x000000000000ff00)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b1ccc b_cerrlog_uio+0x94(0x000001001bdd9100, 0x000001001bdd9100, 0x0000000081133400, 0xffffffffffffffd3, 0x00000000801fbd84)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b0a88 uciverrlog+0x34(0x000000000000000a, 0x000000000002e6bd, 0x000001001bdd9440, 0x000000000a57327b, 0x0000000000009800)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x00000000808b096c ucierrlog+0x20(0x000000000000000a, 0x000000000002e6bd, 0x0000000000000002, 0x000001008ae1fb87, 0xffffffff7ecbc8a0)
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000802aca98 hdl_backout installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x0000000080273024 login+0x1784(0x000000000000a400, 0x000001008ae160b0, 0x0000000000400000, 0x0000000000007800, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000802aca98 hdl_backout installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x0000000080201030 conn_hdlr+0x7c0(0x00000000000076b8, 0x0000000000001400, 0x000001008ae15804, 0x0000000000007400, 0xffffffffffffffff)
00:00000:01604:2014/07/02 22:02:29.26 kernel pc: 0x000000008090cc48 _coldstart(0x000000000000061f, 0x0000000080200870, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:00000:01604:2014/07/02 22:02:29.26 kernel end of stack trace, spid 1604, kpid 1248856949, suid 14
08:00000:01980:2014/07/02 22:02:29.27 server DBCC TRACEON 3604, SPID 1980
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29649637/viewspace-1207286/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/29649637/viewspace-1207286/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
