Re: MultiXactId Error in Autovacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Laurenz, 

thank you for looking into my issue. 


Do you know if you experienced transaction ID wraparound as the
message suggests?

I am not aware of a wraparound in the past. I am quite sure no. 


Are there any other questionable messages in the log?

The log shows nothing special except this error that is always associated with the same MultiXactId 2683601542.
 

What do you get for the following queries:

SELECT txid_current();

txid_current 
--------------
1673482898
 

SELECT datname, datfrozenxid FROM pg_database;


SELECT datname, datfrozenxid FROM pg_database;

datname  | datfrozenxid 
-----------+--------------
postgres  |   1497699916
template0 |   1497699916
MYDB      |   1335927866
template1 |   1497699916


 

SELECT current_setting('autovacuum_freeze_max_age'),
       current_setting('vacuum_freeze_min_age'),
       current_setting('vacuum_freeze_table_age');


current_setting | current_setting | current_setting 
-----------------+-----------------+-----------------
200000000       | 50000000        | 150000000


Thank you!
Best regards, 
Karl


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux