[Warm-Standby] master replication problem
I established warm standby replication for master database:
For most actions like: adding login (or db user), role grants it works fine.
There is one problem which I cannot resolve.
On my Active site I have configured a password policy (each login MUST change password after first logon) - it is expired by default.
On my Standby site I have identical master..syslogins table (so all logins are also expired by default).
When someone changes his password on ACTIVE site, DSI thread goes down:
E. 2015/09/10 11:29:21. ERROR #13045 DSI EXEC(125(1) clininet_standby.master) - seful\cm.c(3784)
Failed to connect to server 'clininet_standby' as user 'test'. See CT-Lib and/or server error messages for more information.
I. 2015/09/10 11:29:21. Message from server: Message: 4022, State 1, Severity 10 -- 'The password has expired, but you are still allowed to log in. You must change your password before you can continue. If a login trigger is set, it will not be executed.
I. 2015/09/10 11:29:21. Message from server: Message: 5701, State 2, Severity 10 -- 'Changed database context to 'master'.
E. 2015/09/10 11:29:21. ERROR #1028 DSI EXEC(125(1) clininet_standby.master) - seful\cm.c(3784)
Message from server: Message: 7742, State 3, Severity 16 -- 'You must change your password using the sp_password system stored procedure before you can continue.
DSI is shutdown becouse of Message: 4022.
I tried to resolve this by:
1. Adding custom error class and binding it to my STANDBY connection
2. Assigning action WARN for errors.
Replication Server/15.6/EBF 20155 ESD#3/X64/Windows
Error still occurs.
Maybe someone knows how to solve this. Without proper password replication there is no point to replicate master database at all.
I would be grateful for any information.