Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound - Mailing list pgsql-bugs

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@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@2ndquadrant.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