Could not truncate directory "pg_subtrans": apparent wraparound

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Could not truncate directory "pg_subtrans": apparent wraparound
Date: 2013-11-18 11:12:18
Message-ID: 5289F612.2050207@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello

We got this error in our logs yesterday.

2013-11-17 19:01:02.278 CET,,,29356,,52565a6f.72ac,1,,2013-10-10
09:42:39 CEST,,0,LOG,00000,"could not truncate directory
""pg_subtrans"": apparent wraparound",,,,,,,,,""

2013-11-17 19:06:02.027 CET,,,29356,,52565a6f.72ac,2,,2013-10-10
09:42:39 CEST,,0,LOG,00000,"could not truncate directory
""pg_subtrans"": apparent wraparound",,,,,,,,,""

I have searched the archive for a similar subject but none of the
threads about this error came to a conclusion.

This postgres installation was done from scratch, the contents were
loded from pg_dump files, no replication, no HS, no pg_upgrade.

Any ideas?

$ ls -l $PGDATA/pg_subtrans/
total 8
- -rw-------. 1 postgres postgres 8192 Nov 18 10:46 0001

# SELECT txid_current();
txid_current
- --------------
67017
(1 row)

# SELECT txid_current_snapshot();
txid_current_snapshot
- -----------------------
67018:67018:

# SELECT version(); version

- ----------------------------------------------------------------------
PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit

regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAlKJ9hEACgkQBhuKQurGihSIiQCfcJCX7KDcmOYi08w7jVgenjBT
Ta4AmwQhdam5HmNztkf+nUw0gC7fuP7r
=UYfv
-----END PGP SIGNATURE-----

Browse pgsql-general by date

  From Date Subject
Next Message Chris Ernst 2013-11-18 13:38:54 Re: Primary Key Index Bloat?
Previous Message Albe Laurenz 2013-11-18 11:01:04 Re: N prefix and ::bpchar