timeslice -501。。。。sybase突然DOWN掉，请教是什么原因

zhangerwen

Adaptive Server Enterprise/12.5.2/EBF 11793/P/RS6000/AIX 5.1/ase1252/1831/64-bit/FBO/Fri
以下是sybase的错误日志
00:00000:00687:2009/03/20 00:31:05.63 kernel  timeslice -501, current process infected
00:00000:00687:2009/03/20 00:31:09.61 kernel  Spinlocks held by  kpid 1835036

00:00000:00687:2009/03/20 00:31:09.61 kernel  Spinlock Kernel->kssocktab_spinlock at address 00000001605b0da0 owned by 1835036
00:00000:00687:2009/03/20 00:31:09.94 kernel  End of spinlock display.
00:00000:00687:2009/03/20 00:31:11.79 kernel  pc: 0x00000001002bbb8c pcstkwalk+0x80()
00:00000:00687:2009/03/20 00:31:11.79 kernel  pc: 0x00000001002bc2d8 ucstkgentrace+0x228()
00:00000:00687:2009/03/20 00:31:11.79 kernel  pc: 0x00000001002bac08 ucbacktrace+0x78()
00:00000:00687:2009/03/20 00:31:14.03 kernel  pc: 0x000000010038a330 terminate_process__fdpr_3+0x30()
00:00000:00687:2009/03/20 00:31:14.06 kernel  pc: 0x000000010039a2cc kaclkintr__fdpr_11+0x108()
00:00000:00687:2009/03/20 00:31:14.06 kernel  pc: 0x0000000000000020 ()
00:00000:00687:2009/03/20 00:31:15.32 kernel  pc: 0x0000000100041234 usrfill__fdpr_1+0x9c()
00:00000:00687:2009/03/20 00:31:16.11 kernel  pc: 0x0000000100087314 recvhost__fdpr_6+0x14()
00:00000:00687:2009/03/20 00:31:17.06 kernel  pc: 0x0000000100264a98 tdsrecv_paramfmt__fdpr_1+0xa8()
00:00000:00687:2009/03/20 00:31:18.34 kernel  pc: 0x0000000100756888 tdsrecv_language__fdpr_2+0x288()
00:00000:00687:2009/03/20 00:31:19.15 kernel  [Handler pc: 0x0000000100258b08 hdl_backout installed by the following function:-]
00:00000:00687:2009/03/20 00:31:21.07 kernel  [Handler pc: 0x00000001004730b4 ut_handle installed by the following function:-]
00:00000:00687:2009/03/20 00:31:21.07 kernel  [Handler pc: 0x00000001004730b4 ut_handle installed by the following function:-]
00:00000:00687:2009/03/20 00:31:21.60 kernel  pc: 0x0000000100090604 lock_logical__fdpr_24+0xec()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000100015e10 kpcoldstart+0x1c()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000100015dcc kpinitproc__fdpr_1+0x1c()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.63 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  pc: 0x0000000000000000 ()
00:00000:00687:2009/03/20 00:31:21.64 kernel  end of stack trace, spid 687, kpid 1835036, suid 5
00:00000:00687:2009/03/20 00:31:21.64 kernel  ueshutdown: exiting


重启数据库后恢复正常，请教是什么原因？？？？？

[ 本帖最后由 zhangerwen 于 2009-3-20 09:20 编辑 ]

WFCJZ

从这个报错来看吧:
00:00000:00687:2009/03/20 00:31:21.64 kernel  end of stack trace, spid 687, kpid 1835036, suid 5
你的数据内可能有对象坏了,尝试用DBCC针对上面的报错看一下吧!

3sun

具体的查看方法能给说一下吗 谢谢

3sun

08:00000:00966:2010/03/01 23:09:12.54 kernel  timeslice -501, current process infected
08:00000:00966:2010/03/01 23:09:25.14 kernel  Spinlocks held by  kpid 449184197

08:00000:00966:2010/03/01 23:09:25.14 kernel  Spinlock Kernel->kssocktab_spinlock[i] at address 00000001602a0fc0 owned by 449184197
08:00000:00966:2010/03/01 23:09:51.82 kernel  End of spinlock display.
08:00000:00966:2010/03/01 23:09:51.86 kernel  pc: 0x0000000100356a88 .pcstkwalk+0x88()
08:00000:00966:2010/03/01 23:09:51.86 kernel  pc: 0x0000000100357140 .ucstkgentrace+0x238()
08:00000:00966:2010/03/01 23:09:51.86 kernel  pc: 0x0000000100355ed0 .ucbacktrace+0x78()
08:00000:00966:2010/03/01 23:09:51.87 kernel  pc: 0x00000001002236f0 .terminate_process[3]+0x2c()
08:00000:00966:2010/03/01 23:09:51.88 kernel  pc: 0x000000010059b80c .kaclkintr[10]+0x124()
08:00000:00966:2010/03/01 23:09:51.88 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.92 kernel  pc: 0x0000000100036530 .usrfill[1]+0xac()
08:00000:00966:2010/03/01 23:09:51.93 kernel  [Handler pc: 0x00000001001da5bc .hdl_backout installed by the following function:-]
08:00000:00966:2010/03/01 23:09:51.94 kernel  [Handler pc: 0x0000000100454f28 .ut_handle installed by the following function:-]
08:00000:00966:2010/03/01 23:09:51.94 kernel  [Handler pc: 0x0000000100454f28 .ut_handle installed by the following function:-]
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000100038dcc .conn_hdlr[1]+0x80()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000100015740 +0x1c()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x000000010001571c .kpinitproc[1]+0x1c()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  pc: 0x0000000000000000 ()
08:00000:00966:2010/03/01 23:09:51.94 kernel  end of stack trace, spid 966, kpid 449184197, suid 1
08:00000:00966:2010/03/01 23:09:51.94 kernel  ueshutdown: exiting


服务也是莫名 死掉了

andkylee

是AIX  上的SMP环境吧。
感觉像是发生了Spinlocks  螺旋锁争用。
Spinlock Contention” reports the number of times an engine encountered spinlock contention on the cache, and had to wait, as a percentage of the total spinlock requests for that cache. This is meaningful for SMP environments only.

When a user task makes any changes to a cache, a spinlock denies all other tasks access to the cache while the changes are being made. Although spinlocks are held for extremely brief durations, they can slow performance in multiprocessor systems with high transaction rates. If spinlock contention is more than 10%, consider using named caches or adding cache partitions.

添加高速命名缓存，或者将已有高速缓存分区吧！