9.4.1 -> 9.4.2 problem: could not access status of transaction 1

From: Steve Kehlet <steve(dot)kehlet(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Date: 2015-05-27 22:09:27
Message-ID: CA+bfosFDANiqS_M9_FbixNuFk9A8c-bk_3iLtRmfPOp-d1V2xQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I have a database that was upgraded from 9.4.1 to 9.4.2 (no pg_upgrade, we
just dropped new binaries in place) but it wouldn't start up. I found this
in the logs:

waiting for server to start....2015-05-27 13:13:00 PDT [27341]: [1-1] LOG:
database system was shut down at 2015-05-27 13:12:55 PDT
2015-05-27 13:13:00 PDT [27342]: [1-1] FATAL: the database system is
starting up
.2015-05-27 13:13:00 PDT [27341]: [2-1] FATAL: could not access status of
transaction 1
2015-05-27 13:13:00 PDT [27341]: [3-1] DETAIL: Could not open file
"pg_multixact/offsets/0000": No such file or directory.
2015-05-27 13:13:00 PDT [27340]: [1-1] LOG: startup process (PID 27341)
exited with exit code 1
2015-05-27 13:13:00 PDT [27340]: [2-1] LOG: aborting startup due to
startup process failure
stopped waiting

I poked around in pg_multixact/offsets and there are lots of other files in
there, just not 0000.

I tried launching postgres in standalone mode to try some debugging but it
yields the same error.

AFAICT, there's nothing wrong with hardware, it's a VM, and it's been
working okay. About a week ago we upgraded it from 9.3.5 to 9.4.1 via
pg_upgrade --link, which worked amazingly well.

I found [this report from a couple days ago](
https://bugs.archlinux.org/task/45071) from someone else that looks like
the same problem.

I put this box's [postgresql.conf up on a gist](
https://gist.github.com/skehlet/3589b0d83f2cafe19624).

What can I try next? Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2015-05-27 22:21:42 Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Previous Message PT 2015-05-27 21:31:40 Re: Fwd: Raster performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2015-05-27 22:16:07 Re: pg_upgrade resets timeline to 1
Previous Message Andrew Dunstan 2015-05-27 21:45:01 Re: Run pgindent now?