| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | molofeev3(at)gmail(dot)com, 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:02:45 |
| Message-ID: | 20180403130245.hhrnj5mhapnjvh7f@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | molofeev | 2018-04-03 13:17:58 | Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5 |
| Previous Message | PG Bug reporting form | 2018-04-03 11:42:55 | BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5 |