Problems in resynch db in replication

262 Views

There was a problem in replication in which the db in both sides are not synchronized,,, so I need to re-synch the DB. I stop the rep agent and truncate the secondary point. Drop the connections, an error encountered something like this "Database is the primary replication cannot drop the connection in it". So I install the replication server from the rs_init and I re-configure the Replication server.

I have already created a bi-directional replication , choose the dump marker option and it displays complete on my screen, however, when i check up the REP Server error log i found out that it doesn't work. I have already tested all the connections individually but still the error exists, can any one help me about this? how to continue,, I need help please

error log is:

I. 2015/06/29 08:59:11. SQM starting: 102:0 PSMBFI.psmbfi

I. 2015/06/29 08:59:11. The DSI thread for database 'PSMBFI.psmbfi' is started.

I. 2015/06/29 08:59:11. DIST for 'PSMBFI.psmbfi' is Starting

E. 2015/06/29 08:59:11. ERROR #1028 DSI(102 PSMBFI.psmbfi) - seful\cm.c(3546)

Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.

'.

E. 2015/06/29 08:59:11. ERROR #1027 DSI(102 PSMBFI.psmbfi) - seful\cm.c(3546)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/06/29 08:59:11. ERROR #13045 DSI(102 PSMBFI.psmbfi) - seful\cm.c(3550)

Failed to connect to server 'PSMBFI' as user 'psmbfi_maint'. See CT-Lib and/or server error messages for more information.

I. 2015/06/29 08:59:11. The DSI thread for database 'PSMBFI.psmbfi' is shutdown.

E. 2015/06/29 08:59:11. ERROR #1028 DSI(103 STANDBY_SVR.psmbfi) - seful\cm.c(3546)

Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.

'.

E. 2015/06/29 08:59:11. ERROR #1027 DSI(103 STANDBY_SVR.psmbfi) - seful\cm.c(3546)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/06/29 08:59:11. ERROR #13045 DSI(103 STANDBY_SVR.psmbfi) - seful\cm.c(3550)

Failed to connect to server 'STANDBY_SVR' as user 'psmbfi_maint'. See CT-Lib and/or server error messages for more information.

I. 2015/06/29 08:59:11. The DSI thread for database 'STANDBY_SVR.psmbfi' is shutdown.

I. 2015/06/29 09:03:11. REPLICATE Replication Server: Defining subscription <psmbfi_1> for database replication definition <psmbfi_1> with primary at <PSMBFI.psmbfi> with replicate at <STANDBY_SVR.psmbfi>

I. 2015/06/29 09:03:11. PRIMARY Replication Server: Defining subscription <psmbfi_1> for database replication definition <psmbfi_1> with primary at <PSMBFI.psmbfi> with replicate at <STANDBY_SVR.psmbfi>

E. 2015/06/29 09:03:11. ERROR #1028 USER(sa) - seful\cm.c(3546)

Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.

'.

E. 2015/06/29 09:03:11. ERROR #1027 USER(sa) - seful\cm.c(3546)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/06/29 09:03:11. ERROR #13045 USER(sa) - seful\cm.c(3550)

Failed to connect to server 'PSMBFI' as user 'sa'. See CT-Lib and/or server error messages for more information.

I. 2015/06/29 09:03:11. REPLICATE Replication Server: Defining subscription <psmbfi_1> for database replication definition <psmbfi_1> with primary at <STANDBY_SVR.psmbfi> with replicate at <PSMBFI.psmbfi>

I. 2015/06/29 09:03:11. PRIMARY Replication Server: Defining subscription <psmbfi_1> for database replication definition <psmbfi_1> with primary at <STANDBY_SVR.psmbfi> with replicate at <PSMBFI.psmbfi>

E. 2015/06/29 09:03:12. ERROR #1028 USER(sa) - seful\cm.c(3546)

Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.

'.

E. 2015/06/29 09:03:12. ERROR #1027 USER(sa) - seful\cm.c(3546)

Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.

E. 2015/06/29 09:03:12. ERROR #13045 USER(sa) - seful\cm.c(3550)

Failed to connect to server 'STANDBY_SVR' as user 'sa'. See CT-Lib and/or server error messages for more information.