Last month, I upgraded my Confluence install to 6.15.1 using the same in-place procedure I've used repeatedly in the past. It started and ran successfully at the time, but now, a month later, a simple system reboot has resulted in:
Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)
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
Confluence is installed on an AMD Zen-based Proxmox VM server, in a Linux container running CentOS 7 (kernel 4.15.18-14-pve). The database is PostgreSQL 9.6 (9.6+181+deb9u2) in a separate Linux container running Debian 9. The database server also holds a database for a JIRA instance that's in a third Linux container; the JIRA instance is working fine. The three containers share a private VLAN that does not leave the VM server for database connections (that is, PostgreSQL only binds to that VLAN).
The sequence of events leading to the error:
Troubleshooting already tried:
I tried looking for Confluence backups. I had previously had Confluence set to automatically take backups. It appears that at some point in the last few months, that setting was lost, possibly as a result of migration to the current VM architecture or the in-place upgrade to 6.15.1. So, I only have the backups created nightly by the Proxmox VM.
What is the cause of this error, and how can I resolve it?
The database table public.scheduler_run_details was corrupted. I was able to get Confluence up again by running the following psql commands:
SET zero_damaged_pages = on;
VACUUM FULL public.scheduler_run_details;
VACUUM ANALYZE public.scheduler_run_details;
REINDEX DATABASE wikidb;
After which I restarted the Confluence instance and it came up to the "didn't start last time but did now" screen, after which it appears to work normally.
I'm not sure if the corruption was due to the Proxmox shutdown sequence, an artifact of the recent Confluence in-place upgrade, or a combination...
Hi Atlassian's, How is your journey with #Atlympics 2021 so far....excited! Me too, same excitement. Here's my typical team planning and vision dashboard which I used to share to my management and ...
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