Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5
От | molofeev |
---|---|
Тема | Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5 |
Дата | |
Msg-id | d58a6c78-4bee-8465-28aa-c290083f5b10@gmail.com обсуждение исходный текст |
Ответ на | Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet --apparent wraparound in v9.5 (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Список | 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 по дате отправления: