Chinaunix

标题: 有谁精通SYBASE复制的,帮帮忙,老是报同样的错 [打印本页]

作者: happyfei    时间: 2008-01-24 09:37
标题: 有谁精通SYBASE复制的,帮帮忙,老是报同样的错
是做的整库复制,
1、开始一直报以下错误,但把复制端的链接重新添加一次就好了,但为什么经常出现报sa无法登陆复制库
2008/01/23 18:19:33. ERROR #1028 DSI EXEC(104(1) SYBREP.ecourt) - seful/cm.c(
3459)
        Message from server: Message: 4002, State 1, Severity 14 -- 'Login faile
d.
'.
E. 2008/01/23 18:19:34. ERROR #1027 DSI EXEC(104(1) SYBREP.dbname) - seful/cm.c(
3459)
        Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_con
nect(): protocol specific layer: external error: The attempt to connect to the s
erver failed.'.
E. 2008/01/23 18:19:34. ERROR #13045 DSI EXEC(104(1) SYBREP.dbname) - seful/cm.c
(3463)
        Failed to connect to server 'SYBREP' as user 'sa'. See CT-Lib and/or ser
ver error messages for more information.
I. 2008/01/23 18:19:34. The DSI thread for database 'SYBREP.dbname' is shutdown.
作者: happyfei    时间: 2008-01-24 09:39
2、复制服务器总会有写字段复制不过去,报以下错
ata row associated with the rs_writetext is missing. The data row is needed for the DSI to generate the rs_get_textptr command.
W. 2008/01/24 09:22:08. WARNING #5066 DSI(106 SYBREP.dbname) - /dsiutil.c(3641)
        When writing a transaction for database 'SYBREP.ecourt' into the exceptions log, the function string mapping for command '23' failed. No mapped output commands for this source command are logged. See an earlier message for details of the error.
I. 2008/01/24 09:22:09. The first transaction for database 'SYBREP.dbname' has been logged into the exceptions log and skipped.
E. 2008/01/24 09:25:30. ERROR #5149 DSI EXEC(106(1) SYBREP.dbname) - /dsiexec.c(3673)
        Function 'rs_get_textptr' for 'JZ' returned no rows.
I. 2008/01/24 09:25:30. The DSI thread for database 'SYBREP.dbname' is shutdown.
作者: happyfei    时间: 2008-01-24 11:19
应该是TEXT,image等大字段复制出现的问题,有没有能彻底解决的好方法啊
作者: hobbylu    时间: 2008-01-24 16:42
首先同步两边的数据
作者: happyfei    时间: 2008-01-24 19:15
数据是同步的,用了几天都是好的,突然这样,以前也是经常这样
作者: BlueAeri    时间: 2008-01-24 19:29
原帖由 happyfei 于 2008-1-24 19:15 发表
数据是同步的,用了几天都是好的,突然这样,以前也是经常这样


数据应该是有差异的。。。你仔细查查,不要想当然。
作者: Eisen    时间: 2008-01-25 12:45
问题1你最好看看rssd库中的rs_users表,然后对比一下你在ase中有无对应的用户名密码的login,以及该用户在复制库上的权限
问题2请参看版主hobbylu的建议
作者: happyfei    时间: 2008-01-30 15:49
同步一次好麻烦啊,160G数据,整个dump,load要五六个小时




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2