复制服务器问题,请大家帮我看看
查了一天资料汗哪,就是没法处理请各位帮帮忙
问题如下
I. 2008/02/26 16:44:14. The DSI thread for database 'zf02.police' is started.
W. 2008/02/26 16:44:14. WARNING #24056 DSI(118 zf02.police) - t\sqtint.c(2959)
_sqt_add_to_cache(118:0 zf02.police): Statement for a transaction that has been committed was seen. It is ignored. tran=CMD263:41.
E. 2008/02/26 16:44:14. ERROR #1028 DSI EXEC(118(1) zf02.police) - dsiqmint.c(3034)
Message from server: Message: 208, State 1, Severity 16 -- 'dbo.clzf_opt_tmp not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
'.
H. 2008/02/26 16:44:14. THREAD FATAL ERROR #5049 DSI EXEC(118(1) zf02.police) - dsiqmint.c(3041)
The DSI thread for database 'zf02.police' is being shutdown. DSI received data server error #208 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #2 of the failed transaction.
I. 2008/02/26 16:44:14. The DSI thread for database 'zf02.police' is shutdown.
我用resume connection to zf02.police skip transaction 或 resume connection to zf02.police execute transaction 都报此错误
zf02.police 中确实没有clzf_opt_tmp,我用控制台定制的复制定义中确实也没有此表
我就想此表的日志不在zf02.police中同步
我用过rs_zeroltm命令也不行
还有我挺奇怪我在主服务器中用 sp_setreptable 也没查到我要复制的表
请大家帮帮忙,我是个新手
谢谢
回复 #1 maolinzhou 的帖子
看一下rs_helprep，再查一下rs_objects这个表，找找有没有提示的那个表。如果都找不到，可以从队列里用sysadmin sqm_zap_command命令把“tran=CMD263:41”这个事务删掉。
做这些操作前，最好重启一下RepServer和DataServer。 谢谢
我用resume connection to zf02.policeskip transaction
反复多次就好用了
页:
[1]