- 论坛徽章:
- 0
|
我自己建立了一个tempdb_1,相关信息如下:
1。
sp_helpdb tempdb_1
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ----------------
dev_tempdb1 50.0 MB data and log
Jan 10 2006 3:09PM 48612
2。tempdb_1绑定了一个自定义的cache:tempdb1_cache
3。1> select @@version
2> go
-------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.2/EBF 12056 ESD#2/P/RS6000/AIX 5.1/ase1252/1844
/64-bit/FBO/Thu Aug 12 02:44:26 2004
现在每次启动后,使用一会就自动shutdown了,log里面的信息显示如下:
00:00000:00020:2005/12/20 08:27:47.74 kernel current process (0x170017) infected with 11
00:00000:00020:2005/12/20 08:27:47.84 kernel Error at address 0x0000000100024554 (bufdlink+0xac)
00:00000:00020:2005/12/20 08:27:47.92 kernel Spinlocks held by kpid 1507351
00:00000:00020:2005/12/20 08:27:47.92 kernel Spinlock tempdb1_cache at address 000000016025ce20 owned by 1507351
00:00000:00020:2005/12/20 08:27:47.92 kernel End of spinlock display.
00:00000:00020:2005/12/20 08:27:47.93 kernel pc: 0x000000010029baec pcstkwalk+0x7c()
00:00000:00020:2005/12/20 08:27:47.93 kernel pc: 0x000000010029c21c ucstkgentrace+0x238()
00:00000:00020:2005/12/20 08:27:47.94 kernel pc: 0x000000010029ac40 ucbacktrace+0xe4()
00:00000:00020:2005/12/20 08:27:47.95 kernel pc: 0x0000000100361a70 terminate_process__fdpr_3+0x30()
00:00000:00020:2005/12/20 08:27:47.96 kernel pc: 0x0000000100a8b608 kisignal+0x16c()
00:00000:00020:2005/12/20 08:27:47.96 kernel pc: 0x0000000000000000 ()
00:00000:00020:2005/12/20 08:27:47.96 kernel pc: 0x0000000100037234 bufdirty__fdpr_2+0x28()
00:00000:00020:2005/12/20 08:27:47.96 kernel pc: 0x0000000100032770 pg__getpgbuf__fdpr_1+0x34()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x000000010004b2d4 pg__allocate_completion+0x2dc()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x0000000100049f24 pg__allocate_near_target__fdpr_1+0x84()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x00000001000bc81c pg__allocate__fdpr_4+0x68()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x000000010004c964 pg_allocate+0x34()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x00000001000e1cbc pg__allocoam__fdpr_1+0x50()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x00000001000e1ea0 pg__allocate_in_oamcreate+0x68()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x00000001000e3950 pg__allocate__fdpr_7+0x14()
00:00000:00020:2005/12/20 08:27:47.97 kernel pc: 0x000000010004c964 pg_allocate+0x34()
00:00000:00020:2005/12/20 08:27:47.97 kernel [Handler pc: 0x0000000100433448 ut_handle installed by the following function:
-]
00:00000:00020:2005/12/20 08:27:47.98 kernel pc: 0x00000001001310b0 crt_work+0x240()
00:00000:00020:2005/12/20 08:27:47.98 kernel pc: 0x0000000100185a64 run_crtable__fdpr_1+0xc()
00:00000:00020:2005/12/20 08:27:47.98 kernel pc: 0x0000000100185c30 run__fdpr_110+0xb4()
00:00000:00020:2005/12/20 08:27:47.98 kernel pc: 0x0000000100025890 exec_eop__fdpr_10+0x20()
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x0000000100552980 execerr installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x00000001005cc960 jcsExHandler installed by the following
function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x000000010026a184 sortmerr installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x0000000100552980 execerr installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x0000000100552980 execerr installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x000000010024fd9c aritherr installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel pc: 0x0000000100009040 execute__fdpr_1+0x1c()
00:00000:00020:2005/12/20 08:27:47.99 kernel pc: 0x000000010000ab8c run__fdpr_2+0x144()
00:00000:00020:2005/12/20 08:27:47.99 kernel [Handler pc: 0x0000000100255d44 s_handle installed by the following function:-]
00:00000:00020:2005/12/20 08:27:47.99 kernel pc: 0x0000000100040344 sequencer__fdpr_1+0x168()
00:00000:00020:2005/12/20 08:27:47.99 kernel pc: 0x0000000100044db8 execproc__fdpr_1+0x268()
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x000000010009eb98 s_execute__fdpr_37+0xdc()
00:00000:00020:2005/12/20 08:27:48.00 kernel [Handler pc: 0x0000000100255d44 s_handle installed by the following function:-]
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x0000000100040344 sequencer__fdpr_1+0x168()
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x00000001000886a0 tdsrecv_language__fdpr_1+0x44()
00:00000:00020:2005/12/20 08:27:48.00 kernel [Handler pc: 0x0000000100235b58 hdl_backout installed by the following
function:-]
00:00000:00020:2005/12/20 08:27:48.00 kernel [Handler pc: 0x0000000100433448 ut_handle installed by the following function:
-]
00:00000:00020:2005/12/20 08:27:48.00 kernel [Handler pc: 0x0000000100433448 ut_handle installed by the following function:
-]
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x00000001000884ec oj_syboj_to_leftjoin+0x17c()
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x000000010001ac60 kpcoldstart+0x1c()
00:00000:00020:2005/12/20 08:27:48.00 kernel pc: 0x000000010001ac1c kpinitproc__fdpr_1+0x1c()
00:00000:00020:2005/12/20 08:27:48.00 kernel end of stack trace, spid 20, kpid 1507351, suid 1
00:00000:00020:2005/12/20 08:27:48.00 kernel ueshutdown: exiting
3。
我在不同的server里都试验过了,都存在这个问题,是什么原因啊? |
|