Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5 - Mailing list pgsql-bugs

From molofeev
Subject Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5
Date
Msg-id d58a6c78-4bee-8465-28aa-c290083f5b10@gmail.com
Whole thread Raw
In response to Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
Thank you for reply.
Output of pg_controldata:

pg_control version number:            942
Catalog version number:               201510051
Database system identifier:           6520087809676833048
Database cluster state:               in production
pg_control last modified:             вт, 03-кві-2018 14:43:46 +0300
Latest checkpoint location:           327/D0544BA0
Prior checkpoint location:            327/D03F3D88
Latest checkpoint's REDO location:    327/D0544BA0
Latest checkpoint's REDO WAL file:    0000000100000327000000D0
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/1564
Latest checkpoint's NextOID:          10750280
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        615
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
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:            вт, 03-кві-2018 14:43:23 +0300
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:                    minimal
wal_log_hints setting:                off
max_connections setting:              100
max_worker_processes setting:         8
max_prepared_xacts setting:           0
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


Output of [select datminmxid from pg_database where datname = 
current_database();]:

datminmxid
------------
           1

> PG Bug reporting form wrote:
>
>> My version of software:  PostgreSQL 9.5.12 on x86_64-pc-linux-gnu, compiled
>> by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609, 64-bit
>> When I run updating a table(table size ~100Gb) I got an error.
>> For example, vacuum analyze command output:
>> ERROR:  MultiXactId 7629921 has not been created yet -- apparent
>> wraparound
>> Autovacuum is on.
> Can you please show the output of pg_controldata in this directory?
> Also:
>   select datminmxid from pg_database where datname = current_database();
> for the database where the error occurred.
>
> Thanks
>



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5