postgres MultiXact 9.3 corruption resolved but advice needed - Mailing list pgsql-general

From Yvonne Murphy
Subject postgres MultiXact 9.3 corruption resolved but advice needed
Date
Msg-id CY4PR05MB3126D4F8B960DE304F3D795FDDDE0@CY4PR05MB3126.namprd05.prod.outlook.com
Whole thread Raw
Responses Re: postgres MultiXact 9.3 corruption resolved but advice needed  (Eduardo Morras <emorrasg@yahoo.es>)
List pgsql-general

Our application runs against postgres 9.3.9.0-2921310. We recently run into the dreaded ERROR:  MultiXactId 82578299 has not been created yet -- apparent wraparound.

We’ve truncated this big table. Will truncating save us from getting this error soon again or does this bug have nothing to do with the size of the table?

The application has also been tested against. 9.3.12 will upgrading to this reduce the chance of us hitting the bug until we can get the application tested in 9.5. thanks

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: could not connect to server
Next
From: Eduardo Morras
Date:
Subject: Re: postgres MultiXact 9.3 corruption resolved but advice needed