Hi Experts,
After we materialize master database, we found that the DSI of the master of companion ASE going down due to DR_maint unable to connect the companion ASE. After I changed the DR_maint's password (same as the one specified while running setup_hadr.rs file on companion host) of the connection, I am able to resume the DSI and the transactions in the queue replicated. However, I would like to get advised on the below questions to take care.
1. Why DSI is failing to connect after materialization ?
2. Before materialization I was using password 'password' without any issues and after materialization due to DSI down, I altered the connection to set password to 'pasword'. What change/modification internally happened?
3. Are there any pre-requisities w.r.t DR_maint and DR_admin we need to follow before materializing master database?
Error:
I. 2023/11/10 19:51:35. The server needs to be rebooted to allocate SQM readers for large transactions. Currently, DSI/E threads on connection 'LE1_NewDelhi.master' will not handle early dispatched transactions from disk (transactions removed from the SQT cache).
E. 2023/11/10 19:51:35. ERROR #1028 DSI(103 LE1_NewDelhi.master) - /generic/useful/cm.c(5349)
Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.'
E. 2023/11/10 19:51:35. ERROR #1027 DSI(103 LE1_NewDelhi.master) - /generic/useful/cm.c(5349)
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. 2023/11/10 19:51:35. ERROR #13045 DSI(103 LE1_NewDelhi.master) - /generic/useful/cm.c(5353)
Failed to connect to server 'LE1_NewDelhi' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
I. 2023/11/10 19:51:35. The DSI thread for database 'LE1_NewDelhi.master' is shutdown.
Regards,
Dilip Voora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.