Re: assertion failure 9.3.4
От | Josh Berkus |
---|---|
Тема | Re: assertion failure 9.3.4 |
Дата | |
Msg-id | 535549E0.4050909@agliodbs.com обсуждение исходный текст |
Ответ на | Re: assertion failure 9.3.4 (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Список | pgsql-hackers |
> Can you get the infomask bits..? What's does pg_controldata report wrt > the MultiXid's? Can't get the infomask bits. pg_controldata attached, with some redactions. Unfortunately, it appears that they've continued to do tests on this system, so the XID counter has advanced somewhat. pg_control version number: 937 Catalog version number: {redacted} Database system identifier: {redacted} Database cluster state: in production pg_control last modified: Mon 21 Apr 2014 04:28:30 PM UTC Latest checkpoint location: 8/C8B05F98 Prior checkpoint location: 8/C663A4B0 Latest checkpoint's REDO location: 8/C6DC9A10 Latest checkpoint's REDO WAL file: 0000000300000008000000C6 Latest checkpoint's TimeLineID: 3 Latest checkpoint's PrevTimeLineID: 3 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0/11214375 Latest checkpoint's NextOID: 32769 Latest checkpoint's NextMultiXactId: 28939 Latest checkpoint's NextMultiOffset: 58004 Latest checkpoint's oldestXID: 674 Latest checkpoint's oldestXID's DB: 1 Latest checkpoint's oldestActiveXID: 11214375 Latest checkpoint's oldestMultiXid: 1 Latest checkpoint's oldestMulti's DB: 1 Time of latest checkpoint: Mon 21 Apr 2014 04:21:02 PM UTC 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 Current wal_level setting: hot_standby Current max_connections setting: 100 Current max_prepared_xacts setting: 0 Current max_locks_per_xact setting: 64 -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
В списке pgsql-hackers по дате отправления: