免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1611 | 回复: 2
打印 上一主题 下一主题

问一个关于cache的问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-12-21 09:29 |只看该作者 |倒序浏览
我自己建立了一个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里都试验过了,都存在这个问题,是什么原因啊?

论坛徽章:
0
2 [报告]
发表于 2005-12-21 09:55 |只看该作者

bug! muti tempdb 和muti named cache

论坛徽章:
0
3 [报告]
发表于 2005-12-21 10:18 |只看该作者
thanks
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP