看不懂的日志!!!靠大家了

huangjq 2004-05-10 03:46:26
现在Sybase数据库在使用select、insert,delete等SQL语句操作时隔一段时间就会出错,调用部分Sybase自带的存储过程如,sp_helpdb等,也出错。3天前将200M的数据库导入(测试用),插入数据实用java平台和bcp命令相结合的,没有做优化方面的事。
然后在使用时就会经常出错(但数据库服务没死),重启动后用一段还会出错.
日志大致如下:
00:00000:00008:2004/05/10 12:13:17.94 kernel timeslice -501, current process infected
00:00000:00008:2004/05/10 12:13:17.94 kernel ************************************
00:00000:00008:2004/05/10 12:13:17.94 kernel SQL causing error : DELETE FROM cms_column where column_id > @p0?00:00000:00008:2004/05/10 12:13:17.94 kernel ************************************
00:00000:00008:2004/05/10 12:13:17.94 server SQL Text: DELETE FROM cms_column where column_id > @p0?00:00000:00008:2004/05/10 12:13:17.94 kernel curdb = 6 pstat = 0x10100 lasterror = 0
00:00000:00008:2004/05/10 12:13:17.94 kernel preverror = 0 transtate = 1
00:00000:00008:2004/05/10 12:13:17.94 kernel curcmd = 196 program =
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x862e2a9 ucbacktrace+0x89(0x0,0x1,0x8d4694c,0x426265a4,0x42a7fe28)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x810b647 terminate_process+0xb13(0x0,0xffffffff,0x40079b18,0x0,0x400778e8)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x867b161 kaclkintr+0x451(0xe,0x42626658,0x426266d8,0x4006efba,0x426269e4)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x4006f003 init_dummy+0x377a6cef(0xe,0x42626658,0x426266d8,0xe,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x42029090 init_dummy+0x39760d7c(0x426269e4,0x20,0x426269e4,0x0,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x4006e679 init_dummy+0x377a6365(0x400770a0,0x42626a94,0x94,0x4006e6c0,0x400770a0)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x4006e74c init_dummy+0x377a6438(0x42626b98,0x42626ba4,0x40093210,0x8dd5838,0x42626ba4)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x4009310d init_dummy+0x377cadf9(0x42a803b0,0x8d4694c,0x42626d18,0x8635ee9,0x42fb9b94)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x40093e33 init_dummy+0x377cbb1f(0x42fb9b94,0x8d4694c,0x42fb9b90,0x8b81c1c,0x42fb9b94)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8635ee9 rt__daiostart+0xd1(0x12,0x42fb9b90,0x8d4694c,0x4,0x42626d70)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x86365ed basis_daiostart+0x21(0x12,0x42fb9b90,0x8d4694c,0x42fb9b90,0x12)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x863684d basis_dstart+0x1d5(0x12,0x42fb9b90,0x800,0x8d4694c,0x42fb9b90)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8637fdc dstart+0x21c(0x42faa5a0,0x42fb9b90,0x8d4694c,0x0,0x42fb9b90)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8637c4f dstartio+0x11b(0x42faa5a0,0x42fb9b90,0x1,0x8d4694c,0x42a8553c)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8632cb3 udstartio+0x3bb(0x42fb9b90,0x0,0x8d4694c,0x42a8553c,0x421d1680)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x818f03b bufawrite+0x6db(0x442f9c0c,0xffffffff,0x1,0x8d4694c,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x81a0da3 cm_writedes+0x43b(0x0,0x42964cd8,0x141d,0x1,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8194fe0 bufwritedes_log+0x148(0x42964cd8,0x141d,0x1,0x8d4694c,0x421c5a40)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x82c6656 xls_flush+0x56(0x4301951c,0x8d4694c,0x4301951c,0x42a7fe28,0x8b81c1c)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8291469 finishlog+0x2b9(0x4301951c,0x2,0x8d4694c,0x1,0x42a7fe28)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8247be7 xact__endxact+0x19b(0x4301951c,0x2b,0x8d4694c,0x4301951c,0x42a7fe28)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x8247878 xact__commitxact+0x3d0(0x4301951c,0x8d4694c,0x824ce70,0x1,0x432575ac)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x824744e xact__commit_local+0xea(0x8d4694c,0x1,0x42627760,0x83b5abe,0x42627480)

00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x824ce75 xact_commit+0x41(0x42627480,0x8d4694c,0x0,0x0,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x83b5abe s_execute+0x4dda(0x8d4694c,0x0,0x42a7fe00,0x8d4694c,0x43259026)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x83c76fd sequencer+0xe51(0x4323b800,0x8d4694c,0x0,0x42a7fe00,0x811aaba)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x812ed62 tdsrecv_language+0x2de(0x1,0x0,0x0,0x0,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x813d829 conn_hdlr+0x2531(0x2,0x42627c50,0x895eed31,0x0,0x0)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x81860e3 ex_cleanup(0x0,0x0,0x0,0x42387900,0x2a)
00:00000:00008:2004/05/10 12:13:17.94 kernel pc 0x895eed31 init_dummy+0x80d26a1d(0x0,0x42387900,0x2a,0x1,0x5374616b)
00:00000:00008:2004/05/10 12:13:17.94 kernel end of stack trace, spid 8, kpid 39977001, suid 1


...全文
49 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
hobbylu 2004-05-13
  • 打赏
  • 举报
回复
打补丁,修复BUG
xyzhh 2004-05-12
  • 打赏
  • 举报
回复
日志上说得不明白,
你可以试一下把total memory,stack size,esp execution stacksize加大试一下。
charity 2004-05-12
  • 打赏
  • 举报
回复
打补丁先。

2,596

社区成员

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧