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
JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [XX001]; error code ; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet
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
Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events