INEWUP'S BLOG

sybase 12.5.0.3 load 的时候timeslice -1501, current process infected

load 恢复数据库时发生问题

Caution: You have set up this database to include space on disk 14 for both data and the transaction log. This can make recovery impossible if that disk fails. Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically. The SQL Server is terminating this process.

56:00000:00014:2018/09/29 07:27:28.82 kernel timeslice -1501, current process infected 56:00000:00014:2018/09/29 07:27:28.82 kernel ****** 56:00000:00014:2018/09/29 07:27:28.82 kernel SQL causing error : load database xxxxx from '/data/xxxxx.dmp'

56:00000:00014:2018/09/29 07:27:28.82 kernel ****** 56:00000:00014:2018/09/29 07:27:28.82 server SQL Text: load database xxxxx from '/data/xxxxx.dmp' 56:00000:00014:2018/09/29 07:27:28.82 kernel curdb = 8 pstat = 0x1010000 lasterror = 0 56:00000:00014:2018/09/29 07:27:28.82 kernel preverror = 0 transtate = 1 56:00000:00014:2018/09/29 07:27:28.82 kernel curcmd = 316 program = isql 56:00000:00014:2018/09/29 07:27:28.82 kernel pc: 0x0000000100355e80 .pcstkwalk+0x88() 56:00000:00014:2018/09/29 07:27:28.82 kernel pc: 0x0000000100356538 .ucstkgentrace+0x238() 56:00000:00014:2018/09/29 07:27:28.82 kernel pc: 0x00000001003552c8 .ucbacktrace+0x78() 56:00000:00014:2018/09/29 07:27:28.82 kernel pc: 0x0000000100222d90 .terminate_process+0x7fc() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010059a5fc .kaclkintr+0x15c() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010002e24c .apl_getnext+0x178() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010000c91c .getnext+0x5c() 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x00000001007c7008 .crdb_procmark+0x11c() 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x00000001007c14e8 .lddb_main+0xe38() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010065b428 .s_execute+0x40a4() 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000100037260 .sequencer+0x174() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010007335c .tdsrecv_language+0x58() 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x00000001000732ec .result+0x6c() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000100015970 +0x1c() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x000000010001594c .kpinitproc+0x1c() 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel pc: 0x0000000000000000 () 56:00000:00014:2018/09/29 07:27:28.83 kernel end of stack trace, spid 14, kpid 35783202, suid 1

按照经验timeslice的问题加大cpu grace time 会有效,但是本次值为1500,后cpu grace time 改到6000 也没行,最后确认数据库备份文件存在异常。