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-----
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 |