|
Hi Team, Need some support for below issue . I have created streaming replication with two nodes . One is primary and 2nd one is standby but after doing any DML or DDL operation on primary Walreceiver process is terminated on standby and standby database is opening in read write mode. Below are the error details . 2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: recovery stopping before commit of transaction 25627, time 2023-11-22 03:39:58.013764-05 2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: redo done at 1/260059E0 system usage: CPU: user: 0.02 s, system: 0.04 s, elapsed: 5197.90 s 2023-11-22 03:39:58 EST [1276846]: user=,db=,app=,client=FATAL: terminating walreceiver process due to administrator command ERROR: [037]: archive-get command requires option: pg1-path HINT: does this stanza exist? 2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: selected new timeline ID: 37 ERROR: [037]: archive-get command requires option: pg1-path HINT: does this stanza exist? 2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: archive recovery complete 2023-11-22 03:39:58 EST [1275940]: user=,db=,app=,client=LOG: checkpoint starting: end-of-recovery immediate wait 2023-11-22 03:39:58 EST [1275940]: user=,db=,app=,client=LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.022 s, sync=0.003 s, total=0.033 s; sync files=6, longest=0.002 s, average=0.001
s; distance=22 kB, estimate=34772 kB 2023-11-22 03:39:58 EST [1275938]: user=,db=,app=,client=LOG: database system is ready to accept connections Thanks & Regards Vijaykumar Database Operations
Maersk Global Service Centre, Pune. The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachments. Maersk will as part of our communication and interaction with you collect and process your personal data. You can read more about Maersk’s collection and processing of your personal data and your rights as a data subject in our privacy policy Please consider the environment before printing this email.
Classification: Internal |
