Обсуждение: BUG #13525: Database crashed with several error messages "Could not open file "pg_multixact/members/"

The following bug has been logged on the website:

Bug reference:      13525
Logged by:          Could not open file "pg_multixact/members/
Email address:      kumarsathishms@gmail.com
PostgreSQL version: 9.3.5
Operating system:   Ubuntu 12.04
Description:

Hi Team,

Recently our postgresql db crashed giving the error message Could not open
file "pg_multixact/members/<xxxx>" for the second time.

Architecture -
Master(read+write) and slave(read-only) database - Hot standby.
DB size : 159GB
Note: Both master + slave had same problem.
What we did to to recover from the situation -

Action-1: Drop and restore the DB on same server using PITR. Result : Still
the same error.
Action-2: Restore base and data using PITR. Result:Poor performance in DB
with loggings "WARNING: oldest multixact is far in the past"
Action-3: Remove Posgresql-9.3.5 and install postgresql-9.3.9 restore the
complete DB using pg_restore and did not use PITR. Worked well.

After lot of read-ups, the files were wrapped around and lost over time. So,
How can we avoid such situations in future?. Can this be controlled with
configurations to avoid the wraparounds?.

Any help on this topic would be really great to solve the issue. Let me know
if some more details are needed to analyze the cause.

Thanks a lot !

kumarsathishms@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13525
> Logged by:          Could not open file "pg_multixact/members/
> Email address:      kumarsathishms@gmail.com
> PostgreSQL version: 9.3.5
> Operating system:   Ubuntu 12.04
> Description:
>
> Hi Team,
>
> Recently our postgresql db crashed giving the error message Could not open
> file "pg_multixact/members/<xxxx>" for the second time.

There have been multiple fixes related to pg_multixact files in recent
releases.  Please upgrade to 9.3.9.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Thanks a lot ! We have upgraded to 9.3.9 and looking to upgrade to 9.4. How
stable is the version ?


On Wed, Jul 29, 2015 at 10:29 PM, Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:

> kumarsathishms@gmail.com wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference:      13525
> > Logged by:          Could not open file "pg_multixact/members/
> > Email address:      kumarsathishms@gmail.com
> > PostgreSQL version: 9.3.5
> > Operating system:   Ubuntu 12.04
> > Description:
> >
> > Hi Team,
> >
> > Recently our postgresql db crashed giving the error message Could not
> open
> > file "pg_multixact/members/<xxxx>" for the second time.
>
> There have been multiple fixes related to pg_multixact files in recent
> releases.  Please upgrade to 9.3.9.
>
> --
> =C3=81lvaro Herrera                http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>



--=20
Thanks & Regards,
Sathish kumar M