Could not truncate directory "pg_subtrans": apparent wraparound

Поиск
Список
Период
Сортировка
От Rafael Martinez
Тема Could not truncate directory "pg_subtrans": apparent wraparound
Дата
Msg-id 5289F612.2050207@usit.uio.no
обсуждение исходный текст
Список 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-----


В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: N prefix and ::bpchar
Следующее
От: Chris Ernst
Дата:
Сообщение: Re: Primary Key Index Bloat?