From: | "Carlos T(dot) Groero Carmona" <ctonetg(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Lista PostgreSql <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: Error: Found xmin xxxx from before relfrozenxid xxxx |
Date: | 2019-04-29 00:10:54 |
Message-ID: | CABh6Tc0kfc4=tt1EKGrh+mrYcpMb=WmX6C-LFE=h7EkwdK+efg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Alvaro gracias por su rapida respuesta como siempre.
Estoy usando postgres 9.3.23, y el ultimo minor es 9.3.25 y a continuacion
un poco mas de detalle.
-bash-4.1$ /usr/pgsql-9.3/bin/pg_controldata
pg_control version number: 937
Catalog version number: 201306121
Database system identifier: 6018733356291129113
Database cluster state: in production
pg_control last modified: Sun 28 Apr 2019 06:42:57 PM CDT
Latest checkpoint location: 9CAD/95897290
Prior checkpoint location: 9CAC/DAC74AD0
Latest checkpoint's REDO location: 9CAC/EC2913C8
Latest checkpoint's REDO WAL file: 0000000200009CAC000000EC
Latest checkpoint's TimeLineID: 2
Latest checkpoint's PrevTimeLineID: 2
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 11/1998179644
Latest checkpoint's NextOID: 1148211966
Latest checkpoint's NextMultiXactId: 2
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 935163740
Latest checkpoint's oldestXID's DB: 3228382502
Latest checkpoint's oldestActiveXID: 1998179642
Latest checkpoint's oldestMultiXid: 2
Latest checkpoint's oldestMulti's DB: 16406
Time of latest checkpoint: Sun 28 Apr 2019 05:48:57 PM CDT
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/0
Min recovery ending loc's timeline: 0
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current max_connections setting: 600
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 1024
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
Por lo que he estado leyendo:
https://www.postgresql.org/message-id/1527193504642.36340%40amazon.com
https://lwn.net/Articles/757761/
se debe eliminar el pg_internal.init, lo que noe stoy seguro cual de todos,
en la primera url que pongo dice que el gloval
-bash-4.1$ locate pg_internal.init
/san/pgsql-fs/data/base/1/pg_internal.init
/san/pgsql-fs/data/base/123761101/pg_internal.init
/san/pgsql-fs/data/base/12891/pg_internal.init
/san/pgsql-fs/data/base/12896/pg_internal.init
/san/pgsql-fs/data/base/151092199/pg_internal.init
/san/pgsql-fs/data/base/16406/pg_internal.init
/san/pgsql-fs/data/base/3228382502/pg_internal.init
/san/pgsql-fs/data/base/514364880/pg_internal.init
/san/pgsql-fs/data/base/517509567/pg_internal.init
/san/pgsql-fs/data/global/pg_internal.init
El problema es en todas las base de datos, en ese servidor tengo 9 base de
datos como vio en mi primer correo y cada vez que voy a ejecutar el
vacuumdb -za o solo un vacuum analyze a pg_database resulta en el mismo
error sin importar de que base de datos lo este ejecutando.
Una vez mas gracia spor la ayuda...
Carlos.
On Sun, Apr 28, 2019 at 2:12 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
> Carlos T. Groero Carmona escribió:
> > Leyendo un poco mas en este site:
> > https://lwn.net/Articles/757761/
> > encontre que la tabla que tiene problema es pg_database
>
> si mal no recuerdo, tienes que actualizar al último minor (no dijiste
> qué versión tienes), luego borrar el pg_internal.init, luego hacer
> vacuum de pg_database (¿en todas las dbs? no me acuerdo)
>
> un reporte de problema SIEMPRE tiene que indicar la versión.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2019-04-29 12:29:24 | Re: Error: Found xmin xxxx from before relfrozenxid xxxx |
Previous Message | Alvaro Herrera | 2019-04-28 15:04:18 | Re: Error: Found xmin xxxx from before relfrozenxid xxxx |