sybase replication dsi down
Posted on 2011-05-05
i am getting the following error in my rep server log and dsi is down
The DSI thread for database 'SYB_RSSD_GEN.test_2' is being shutdown. DSI received data server error #10330 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. 2011/05/05 19:20:07. The DSI thread for database 'SYB_RSSD_GEN.test_2' is shutdown.
I. 2011/05/05 19:20:48. The DSI thread for database 'SYB_RSSD_GEN.test_2' is started.
I. 2011/05/05 19:30:50. Connection to server 'SYB_RSSD_GEN' as user 'test_2_maint' has been faded out (closed).
H. 2011/05/05 19:41:44. THREAD FATAL ERROR #5189 DSI EXEC(108(1) SYB_RSSD_GEN.test_2) - /dsiutil.c(715)
The DSI thread for the 'SYB_RSSD_GEN.test_2' database is being shut down. DSI received Replication Server error #5185 which is mapped to STOP_REPLICATION or RETRY_STOP_REPLICATION. See the Replication Server log for more information.
W. 2011/05/05 19:41:44. WARNING #5185 DSI EXEC(108(1) SYB_RSSD_GEN.test_2) - /dsiexec.c(5048)
Row count mismatch for the command executed on 'SYB_RSSD_GEN.test_2'. The command impacted 0 rows but it should impact 1 rows.
I. 2011/05/05 19:41:44. The DSI thread for database 'SYB_RSSD_GEN.test_2' is shutdown.
The DSI is down because in my source table i have 20 records which got replicated to target database too (20 records), now what i did was i deleted the 10 records from target database whoich were not needed in target.
the next day someone deleted 5 records from those 10 records on the promary side (source side), obviously the dsi didnot find those records in target and hence went down. Now how should i ignore this error from happeneing aagain. I do not want this warning -- row mismatch to bring down my dsi..." the warning can be fine but dsi shud not go down.
How shud i do this ?
even if i dont want to see these warning (row mismacth) in erro log , how can this be done??