Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
865 questions
Postmaster has commanded server process to rollback the current statement and exit in repica server created by PgLogical
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 21%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mani Mahesh Sivakumar
56
Reputation points
Team,
I am Facing below mentioned error in Postgresql flexible server when two subscriptions are created.
WARNING: 57P02: terminating connection because of crash of another server process","detail": "The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","hint": "In a moment you should be able to reconnect to the database and repeat your command.
Architecture overview looks like this
primary1--PGLogical-->Secondary1--->Pglogical( specirfic tables)--->Secondary2
Primary2---PgLogical--->Secondary2
Secondary 1 and Secondary2 are present in same flexible server cluster. After creating replication from secondary1__>secondary2 getting above mentioned error frequently and Database system is going down. After disabling replication between secondary1 and secondary2. Database behaving normally. Kindly help me to identify the issue and rectify the same. Unable to find anything logs except highlighted data above.
{count} votes
-
GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee2022-10-21T16:08:58.84+00:00 Hi, @Mani Mahesh Sivakumar Thanks for posting your question in the Microsoft Q&A forum.
My understanding of the request is connection was terminated on the Azure Database for the PostgreSQL Flexible server due to the error “terminating the connection because of the crash of another server process” . Please correct me if my understanding is not accurate.
Error seems to be PG is getting crashed, something may be wrong with the replication settings. I recommend raising a support case for deeper investigation.Regards
Geetha -
GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee
2022-10-28T17:54:55.197+00:00 Hi, @Mani Mahesh Sivakumar Did you get a chance to raise a support case, please let me know if you need any help.
Regards
Geetha
Sign in to comment