Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Problems starting confluence

Matthew Alexander
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 27, 2021

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

1 answer

Deleted user May 28, 2021

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.12
TAGS
AUG Leaders

Atlassian Community Events