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
Hi @Matthew Alexander ,
You might be facing similar problem as this one
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.