麻烦各位大侠帮我分析下 sybase复制日志

q410853651

最近这几天，复制服务器老是中端，重启的话可以解决，但这不是长久之计。谢谢。以下是日志：
E. 2011/08/09 21:20:49. ERROR #1027 DSI EXEC(134(1) yndsdev2.yndsquery) - /dsiutil.c(326)
        Open Client Client-Library error: Error: 84083975, Severity 5 -- 'ct_send(): network packet layer: internal net library error: Net-Library operati
on terminated due to disconnect'.
E. 2011/08/09 21:20:49. ERROR #5097 DSI EXEC(134(1) yndsdev2.yndsquery) - /dsiutil.c(329)
        The ct-lib function 'ct_send' returns FAIL for database 'yndsdev2.yndsquery'. The errors are retryable. The DSI thread will restart automatically.
See ct-lib messages for more information.
N. 2011/08/09 21:22:49. INTERNAL ERROR #24040 DSI(134 yndsdev2.yndsquery) - t/sqtint.c(152
        The transaction  '0000000ad5f7878a0015' kmdsdbKMDS is in an unexpected state 'TRAN_CLOSED' for a delete request.
T. 2011/08/09 21:22:49. (1: Dumping memory trace.
T. 2011/08/09 21:22:49. (1: ***************STACK TRACE***************
T. 2011/08/09 21:22:49. (1: *****thread DSI(134 yndsdev2.yndsquery)*******
T. 2011/08/09 21:22:49. (1:  pc: 0x100d2dec + 014c, .exc__appDumpStack ()
T. 2011/08/09 21:22:49. (1:  pc: 0x100d2584 + 02cc, .exc_terminate ()
T. 2011/08/09 21:22:49. (1:  pc: 0x100d0594 + 00e0, .exc_reraise_exception ()
T. 2011/08/09 21:22:49. (1:  pc: 0x100d07dc + 03b0, .exc_raise_exception ()
T. 2011/08/09 21:22:49. (1:  pc: 0x10344834 + 02f4, ._sqt_del_from_cache ()
T. 2011/08/09 21:22:49. (1:  pc: 0x10157ca4 + 0090, .sqt_delete_tran ()
T. 2011/08/09 21:22:49. (18):  pc: 0x1022cc58 + 00e8, ._dsi_delete_xact ()
T. 2011/08/09 21:22:49. (18):  pc: 0x10258134 + 005c, .dsi__ReleaseGroup ()
T. 2011/08/09 21:22:49. (18):  pc: 0x1025acfc + 02a8, .dsi__ProcessSpecial ()
T. 2011/08/09 21:22:49. (18):  pc: 0x1025c6a0 + 0068, .dsi__DispatchGroups ()
T. 2011/08/09 21:22:49. (18):  pc: 0x1025d178 + 0150, .dsi__SchedulerBody ()
T. 2011/08/09 21:22:49. (18):  pc: 0x1025e120 + 062c, .dsi__SchedulerWrapper ()
T. 2011/08/09 21:22:49. (18):  pc: 0x10006144 + 0198, .srv__start_function ()
T. 2011/08/09 21:22:49. (18):  pc: 0xd010d784, unknown dynamic function
T. 2011/08/09 21:22:49. (18): *****End of stack trace.****
T. 2011/08/09 21:22:49. (18): Internal error. Attempting to produce a core file
T. 2011/08/09 21:22:49. (18): Thread DSI(134 yndsdev2.yndsquery) infected with signal 6
T. 2011/08/09 21:22:49. (18): Dumping context structure:
T. 2011/08/09 21:22:49. (18): pc(iar) = d03d9fac
T. 2011/08/09 21:22:49. (18): stackfix = 0
T. 2011/08/09 21:22:49. (18): Registers: g0=ffffffff, g1=31075c10, g2=ffffffff, g3=0, g4=ffffffff, g5=ffffffff, g6=ffffffff, g7=ffffffff, g8=ffffffff, g9f
fffffff, g10=ffffffff, g11=ffffffff, g12=ffffffff, g13=23913, g14=0, g15=0
T. 2011/08/09 21:22:49. (18): Registers: g16=0, g17=0, g18=0, g19=0, g20=100b32f0, g2130204178, g22=0, g23=0, g24=0, g25=301f6e98, g26=3139eb44, g27=30e4c
9f8, g28=30055500, g29=1, g30=300011f0, g31=3026e7d8
T. 2011/08/09 21:22:49. (18): 000:  00000000 f9fee007 00000002 00000000
T. 2011/08/09 21:22:49. (18): 010:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 020:  00000000 00000000 d03d9fac 0000d032
T. 2011/08/09 21:22:49. (18): 030:  00402000 ffffffff 00009304 ffffffff
T. 2011/08/09 21:22:49. (18): 040:  ffffffff 00000000 00004000 01000000
T. 2011/08/09 21:22:49. (18): 050:  0004b4e5 4000d032 00000000 00000000
T. 2011/08/09 21:22:49. (18): 060:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 070:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 080:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 090:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 0a0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 0b0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 0c0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 0d0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 0e0:  ffffffff 31075c10 ffffffff 00000000
T. 2011/08/09 21:22:49. (18): 0f0:  ffffffff ffffffff ffffffff ffffffff
T. 2011/08/09 21:22:49. (18): 100:  ffffffff ffffffff ffffffff ffffffff
T. 2011/08/09 21:22:49. (18): 110:  ffffffff 00023913 00000000 00000000
T. 2011/08/09 21:22:49. (18): 120:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 130:  100b32f0 30204178 00000000 00000000
T. 2011/08/09 21:22:49. (18): 140:  00000000 301f6e98 3139eb44 30e4c9f8
T. 2011/08/09 21:22:49. (18): 150:  30055500 00000001 300011f0 3026e7d8
T. 2011/08/09 21:22:49. (18): 160:  00000000 00000000 3ff00000 00000000
T. 2011/08/09 21:22:49. (18): 170:  3c980000 00000000 c0af0000 00000000
T. 2011/08/09 21:22:49. (18): 180:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 190:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1a0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1b0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1c0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1d0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1e0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 1f0:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 200:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 210:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 220:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 230:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 240:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): 250:  00000000 00000000 00000000 00000000
T. 2011/08/09 21:22:49. (18): Internal error. Attempting to produce a core file

Eisen

看上去象queue里面一个segment包含一个错误tran导致的，清除这个错误可用sysadmin purge_first_open，但是恐怕隐藏的问题还在于主点的syslogs上有bad page或block吧。

q410853651

谢谢了。。有人说是BUG哦。。我也不太懂

liaoliaofannao

呵呵这方面不太很懂？？不过帮你召唤召唤

hobbylu

重建一下队列