sybase运行报timeslice错误，求解答

lhh3371

免费乐捐，感谢支持

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

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

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


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

ehxz

看不懂，不过好久没看偶系统的错误日志了{:lh_23:}