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

From: molofeev <molofeev3(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5
Date: 2018-04-03 13:17:58
Message-ID: d58a6c78-4bee-8465-28aa-c290083f5b10@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-04-03 13:23:19 Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5
Previous Message Alvaro Herrera 2018-04-03 13:02:45 Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5