Problems starting confluence

Question

Hello specs below, we are getting problems with confluence loading after a reboot, no updates or patching has happened for either appliication server or SQL.

Slightly confused as DB is ready and can be accessed, and App server has not been changed at all.

Ubuntu 18.04 both App & SQL

Postgres 11

Confluence 7.12

JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [XX001]; error code [0]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

unknown · Answer

Hello, I tried these when researching last night,

\c wikidb - Didnt work, changed db name of course

SET zero_damaged_pages = on; - Worked

VACUUM FULL public.scheduler_run_details; - See below

ERROR: could not access status of transaction 2332315064 DETAIL: Could not open file "pg_xact/08B0": No such file or directory. SQL state: 58P01

VACUUM ANALYZE public.scheduler_run_details;

ERROR: could not access status of transaction 2332315064 DETAIL: Could not open file "pg_xact/08B0": No such file or directory. CONTEXT: while scanning block 3266 of relation "public.scheduler_run_details" SQL state: 58P01

REINDEX DATABASE wikidb;

ERROR: MultiXactId 157223 has not been created yet -- apparent wraparound SQL state: XX000

might just need to restore an old backup

Mirek · Answer

Hi @Matthew Alexander ,

You might be facing similar problem as this one

https://community.atlassian.com/t5/Confluence-questions/Confluence-startup-fails-SQL-state-XX001-could-not-extract/qaq-p/1086827