lhh3371 发表于 2011-3-31 14:02:44

sybase运行报timeslice错误,求解答

redhat4 32位操作系统安装sybase12.5版本。

执行存储过程太频繁会报下面的错误,timeslice,调整time slice和cpu grace time参数都不管用。

编译时连接单线程库和多线程库都报同样的错误。


00:00000:00001:2011/03/28 11:08:00.10 serverMaster device size: 800 megabytes, or 409600 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00013:2011/03/28 11:24:02.22 kerneltimeslice -501, current process infected
00:00000:00013:2011/03/28 11:24:02.22 kerneltimeslice -501, current process infected
00:00000:00013:2011/03/28 11:24:02.22 kernel************************************
00:00000:00013:2011/03/28 11:24:02.22 kerneltimeslice -501, current process infected
00:00000:00013:2011/03/28 11:24:02.22 kernel************************************
00:00000:00013:2011/03/28 11:24:02.22 kernelSQL causing error : select id=identity(12),t1.role_index,t1.role_name,t1.role_desc into #tmp00001 from t_role t1 where 1=1 and exists (select * from t_admin_role where ad
00:00000:00013:2011/03/28 11:24:02.22 kernel************************************
00:00000:00013:2011/03/28 11:24:02.22 serverSQL Text: select id=identity(12),t1.role_index,t1.role_name,t1.role_desc into #tmp00001 from t_role t1 where 1=1 and exists (select * from t_admin_role where admin_index=1 and role_index=t1.role_index and role_state=1) order by role_index asc    select role_index,role_name,role_desc from #tmp00001 where id>=1 and id<=50drop table #tmp00001
00:00000:00013:2011/03/28 11:24:02.22 kernelcurdb = 2 pstat = 0x10000 lasterror = 0
00:00000:00013:2011/03/28 11:24:02.22 kernelpreverror = 0 transtate = 0
00:00000:00013:2011/03/28 11:24:02.22 kernelcurcmd = 0 program = IKEY-S
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x862e2a9 ucbacktrace+0x89(0x0,0x1,0x8d4694c,0xb5e3fc64,0xb645d04c)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x810b647 terminate_process+0xb13(0x0,0xffffffff,0xb7f6eff4,0x0,0xe)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x867b161 kaclkintr+0x451(0xe,0xb5e3fd48,0xb5e3fdc8,0x3a73,0xb5b54240)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb7f6c28c init_dummy+0xaf6a3f78(0xe,0xb5e3fd48,0xb5e3fdc8,0xe,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb7e60a00 init_dummy+0xaf5986ec(0xb5e400cc,0x20,0xb5e400cc,0x0,0x10)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb7f68728 init_dummy+0xaf6a0414(0x8da98c0,0x0,0xb5e401a0,0x819ad0f,0xb5cb30d0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb7f68eb0 init_dummy+0xaf6a0b9c(0xb5e40280,0xb5e4028c,0xb5a998d0,0x8dd1968,0xb5a9f170)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb5a99868 init_dummy+0xad1d1554(0xb5e403ec,0x8635ee9,0xb6968d6c,0x8d4694c,0xb6968d68)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0xb5a9a360 init_dummy+0xad1d204c(0xb6968d6c,0x8d4694c,0xb6968d68,0x8b81c1c,0xb6968d6c)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x8635ee9 rt__daiostart+0xd1(0x6,0xb6968d68,0x8d4694c,0x3,0xb5e40444)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x86365ed basis_daiostart+0x21(0x6,0xb6968d68,0x8d4694c,0xb6968d68,0x6)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x863684d basis_dstart+0x1d5(0x6,0xb6968d68,0x800,0x8d4694c,0xb6968d68)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x8637fdc dstart+0x21c(0xb6958940,0xb6968d68,0x8d4694c,0x0,0xb6968d68)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x8637c4f dstartio+0x11b(0xb6958940,0xb6968d68,0x1,0x8d4694c,0xb6462760)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x8632cb3 udstartio+0x3bb(0xb6968d68,0x0,0x8d4694c,0xb6462760,0xb5b55e80)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x818f03b bufawrite+0x6db(0xb7a86bdc,0xffffffff,0x1,0x8d4694c,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x81a0da3 cm_writedes+0x43b(0x0,0xb62af3b8,0x39d2,0x0,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x8194fe0 bufwritedes_log+0x148(0xb62af3b8,0x39d2,0x0,0x8d4694c,0xb5b55e80)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x818ec24 bufawrite+0x2c4(0xb7a87ae0,0xffffffff,0x0,0x8d4694c,0xb7a87ae0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x818e924 bufwrite+0x198(0xb7a87ae0,0xb645d9d4,0x8d4694c,0xb5e417f8,0xb5e41c38)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x82fe6c6 crt_fmtind+0x7ba(0x80000000,0xb5e4153c,0x0,0xe,0x17d)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x82fb4f3 crt_main+0x1faf(0xb5e41ca8,0x8d4694c,0xb6c484fc,0x0,0xb6c463e8)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x81860e3 ex_cleanup(0xb6c484fc,0xb6c4898c,0xb6c1c520,0x1,0xb645d04c)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x81860e3 ex_cleanup(0xb6c1c6f4,0xb6c4898c,0x0,0x8d4694c,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x81860e3 ex_cleanup(0x0,0x8d4694c,0x0,0x0,0x2320656c)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x83c6b33 sequencer+0x287(0xb6c1c000,0x8d4694c,0x0,0x0,0x811aaba)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x81860e3 ex_cleanup(0x0,0x0,0x0,0x0,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x813d829 conn_hdlr+0x2531(0x7,0xb5e42284,0x895eed31,0x0,0x0)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x83e07d9 tmp_definition+0xbd(0x0,0x0,0x0,0xb5d12100,0x13)
00:00000:00013:2011/03/28 11:24:02.22 kernelpc 0x895eed31 init_dummy+0x80d26a1d(0x0,0xb5d12100,0x13,0x1,0x5374616b)
00:00000:00013:2011/03/28 11:24:02.22 kernelend of stack trace, spid 13, kpid 1179666, suid 3
:00000:00013:2011/03/28 11:24:02.22 kernelend of stack trace, spid 13, kpid 1179666, suid 3
李海宏 14:13:25
00:00000:00001:2011/03/09 08:04:21.29 serverRedo pass of recovery has processed 10 committed and 1 aborted transactions.

ehxz 发表于 2011-3-31 16:37:02

看不懂,不过好久没看偶系统的错误日志了{:lh_23:}
页: [1]
查看完整版本: sybase运行报timeslice错误,求解答

免责声明:
本站所发布的一切破解补丁、注册机和注册信息及软件的解密分析文章仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。本站信息来自网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,购买注册,得到更好的正版服务。如有侵权请邮件与我们联系处理。

Mail To:Admin@SybaseBbs.com