Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound

Sure -

beacon=# select lp, lp_flags, t_xmin, t_xmax, t_field3, t_ctid,
beacon-# to_hex(t_infomask) as infomask, to_hex(t_infomask2)
as infomask2
beacon-# from heap_page_items(get_raw_page('reviews_2018', 382604)) h;
lp | lp_flags | t_xmin | t_xmax | t_field3 | t_ctid
| infomask | infomask2
----+----------+------------+------------+------------+--------------------+----------+-----------
1 | 1 | 0 | 2457403396 | 1048582 |
(151256864,239) | 200 | 0
2 | 2 | | | |
| |
3 | 2 | | | |
| |
4 | 1 | 25532455 | 26137203 | 0 | (382604,15)
| 2102 | c010
5 | 1 | 25532455 | 26137203 | 0 | (382604,16)
| 2103 | c010
6 | 1 | 1682137913 | 862335590 | 959460400 |
(892612660,26210) | 6439 | 6562
7 | 1 | 1179009631 | 1483293027 | 1382768435 |
(1717064302,26444) | 3133 | 4c76
8 | 1 | 1412509997 | 825899313 | 943012409 | (959330611,90)
| 0 | 0
9 | 1 | 862073140 | 1701209657 | 1265002032 |
(1697722679,25911) | 652d | 3031
10 | 1 | 25518614 | 0 | 0 | (382604,10)
| 2903 | 8010
11 | 2 | | | |
| |
12 | 2 | | | |
| |
13 | 2 | | | |
| |
14 | 2 | | | |
| |
15 | 1 | 26137203 | 0 | 0 | (382604,15)
| 2802 | 8010
16 | 1 | 26137203 | 0 | 0 | (382604,16)
| 2903 | 8010
17 | 0 | | | |
| |
(17 rows)

and

postgres(at)dallocalbeacondb01b:~$ pg_controldata /data/main/
pg_control version number: 1002
Catalog version number: 201707211
Database system identifier: 6619783480642413267
Database cluster state: in production
pg_control last modified: Tue 01 Jan 2019 12:30:04 AM UTC
Latest checkpoint location: 637/49000098
Prior checkpoint location: 637/48000098
Latest checkpoint's REDO location: 637/49000060
Latest checkpoint's REDO WAL file: 000000020000063700000049
Latest checkpoint's TimeLineID: 2
Latest checkpoint's PrevTimeLineID: 2
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0:26398877
Latest checkpoint's NextOID: 7299101
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 548
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 26398877
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Time of latest checkpoint: Tue 01 Jan 2019 12:30:04 AM UTC
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
wal_level setting: replica
wal_log_hints setting: on
max_connections setting: 1000
max_worker_processes setting: 8
max_prepared_xacts setting: 1000
max_locks_per_xact setting: 64
track_commit_timestamp setting: off
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
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
Mock authentication nonce:
65802e08ec705db32d404dc5484bdd1f1cbc4075825d6bc5b1b2a4806ad28bc0

On Mon, Dec 31, 2018 at 4:43 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>
> On 2018-Dec-31, PG Bug reporting form wrote:
>
> > Both selects against and pg_dumps of the table fail with the same error.
> >
> > We were able narrow down the selects to at least one row / page that seems
> > to have problems:
> >
> > select ctid,id from reviews_2018 where ctid = '(382604,16)'::tid;
> > ctid | id
> > -------------+----------------------------------
> > (382604,16) | 00ec91e42d21ce0b818fe8f63ab94c66
> >
> > select ctid,id from reviews_2018 where id =
> > '00ec91e42d21ce0b818fe8f63ab94c66';
> > ERROR: MultiXactId 1483293027 has not been created yet -- apparent
> > wraparound
>
> Can you please send
>
> select lp, lp_flags, t_xmin, t_xmax, t_field3, t_ctid,
> to_hex(t_infomask) as infomask, to_hex(t_infomask2) as infomask2
> from heap_page_items(get_raw_page('reviews_2018', 382604)) h;
>
> Also, please send the output of pg_controldata.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Phil Hildebrand
Sr. DBE @ Moz
206.696.3413