You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
While trying to upgrade from the version in the subject line I was getting java exception errors. I found out that PostgreSQL 11 wasn't supported and upgraded to PGSQL 13 on RHEL 8. I tried upgrading Java 11 as well.
However I am still running into issues:
This is much earlier in the day yesterday. I have the ability to roll everything back:
2022-11-30 16:00:00,149 WARN [Caesium-1-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:00,149 WARN [Caesium-1-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #509388788)
2022-11-30 16:00:00,149 ERROR [Caesium-1-3] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=conversionQueueMonitor,deadline=1669845600000]
java.lang.NullPointerException
2022-11-30 16:00:00,150 ERROR [Caesium-1-2] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:00,150 ERROR [Caesium-1-2] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:00,151 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:00,151 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #363384019)
2022-11-30 16:00:00,152 ERROR [Caesium-1-2] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=reminderJob,deadline=1669845600000]
java.lang.NullPointerException
2022-11-30 16:00:00,153 ERROR [Caesium-1-4] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:00,154 ERROR [Caesium-1-4] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:00,154 WARN [Caesium-1-4] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:00,154 WARN [Caesium-1-4] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1450820172)
2022-11-30 16:00:00,155 ERROR [Caesium-1-4] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=JmxAppLoggingJob,deadline=1669845600000]
java.lang.NullPointerException
2022-11-30 16:00:00,171 ERROR [Caesium-1-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:00,172 ERROR [Caesium-1-1] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:00,173 WARN [Caesium-1-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:00,173 WARN [Caesium-1-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1615710568)
2022-11-30 16:00:00,173 ERROR [Caesium-1-1] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=summaryEmail,deadline=1669845600000]
java.lang.NullPointerException
2022-11-30 16:00:02,099 ERROR [Caesium-1-3] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:02,099 ERROR [Caesium-1-3] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:02,100 WARN [Caesium-1-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:02,100 WARN [Caesium-1-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1373303802)
2022-11-30 16:00:02,101 ERROR [Caesium-1-3] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=SearchAuditListener,deadline=1669845602096]
java.lang.NullPointerException
2022-11-30 16:00:02,103 ERROR [Caesium-1-2] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:02,103 ERROR [Caesium-1-2] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:02,104 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:02,129 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1669873621)
2022-11-30 16:00:02,130 ERROR [Caesium-1-2] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=SystemMaintenanceTaskQueueFlusherScheduledJob,deadline=1669845602098]
java.lang.NullPointerException
2022-11-30 16:00:05,128 ERROR [Caesium-1-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: could not read block 20974 in file "base/16385/26642": read only 0 of 8192 bytes
2022-11-30 16:00:05,129 ERROR [Caesium-1-1] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]
2022-11-30 16:00:05,130 WARN [Caesium-1-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: null
2022-11-30 16:00:05,130 WARN [Caesium-1-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.impl.schedule.caesium.SchedulerRunDetailsDao.addRunDetails]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #799832907)
2022-11-30 16:00:05,130 ERROR [Caesium-1-1] [scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=migration-plugin:queue-broker-job-id,deadline=1669845605097]
java.lang.NullPointerException
2022-11-30 16:00:05,852 INFO [Catalina-utility-3] [com.atlassian.confluence.lifecycle] destroy Shutting down long running task service
2022-11-30 16:00:05,856 INFO [Catalina-utility-3] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$7 Preparing to shut down the plugin system
2022-11-30 16:00:05,970 INFO [Catalina-utility-3] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$7 Shutting down the plugin system
2022-11-30 16:00:07,615 INFO [FelixShutdown] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] stopProcess Stopping Synchrony...
2022-11-30 16:00:10,623 INFO [FelixShutdown] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] stopProcess Stopping Synchrony...
2022-11-30 16:00:11,988 WARN [FelixShutdown] [addons.analytics.scheduler.EventLimiterScheduleManagerImpl] destroy Destroying Event Limiter Schedule
2022-11-30 16:00:11,990 WARN [FelixShutdown] [addons.analytics.scheduler.DataRetentionScheduleManagerImpl] destroy Destroying Data Retention Schedule
2022-11-30 16:00:13,717 WARN [pool-17-thread-2] [atlassian.upm.pac.MpacApplicationCacheManager] fetchMpacAppInfo Error when querying application info from MPAC: java.lang.IllegalStateException: Connection pool shut down
2022-12-01 10:08:42,952 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.19.1 [build 8804 based on commit hash 5edffe31bc2e032d43ffb30ff7143f30974f0954] - synchrony version 4.1.1
2022-12-01 10:08:53,047 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2022-12-01 10:09:00,298 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2022-12-01 10:09:22,994 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 29946 ms
2022-12-01 10:09:23,052 ERROR [Catalina-utility-1] [atlassian.confluence.setup.BootstrapApplicationStartupListener] checkConfigurationOnStartup Confluence will not start up because the build number in the home directory [8804] doesn't match the build number in the database [8901].
2022-12-01 10:09:23,067 WARN [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade
2022-12-01 10:09:24,065 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2022-12-01 10:09:57,046 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$7 Preparing to shut down the plugin system
2022-12-01 10:09:57,146 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$7 Shutting down the plugin system
2022-12-01 10:09:57,149 WARN [Catalina-utility-1] [atlassian.plugin.servlet.DefaultServletModuleManager] onPluginFrameworkShutdownEvent PluginController passed via the PluginFrameworkShutdownEvent did not match that passed via PluginFrameworkStartedEvent
2022-12-01 10:09:57,160 WARN [Catalina-utility-1] [atlassian.plugin.jmx.JmxUtil] unregister Failed to unregister, instance not found: com.atlassian.plugin:instance=0,type=PluginManager
2022-12-01 10:09:57,288 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] destroy Shutting down long running task service
2022-12-01 10:09:57,335 WARN [Catalina-utility-1] [beans.factory.support.DisposableBeanAdapter] destroy Invocation of close method failed on bean with name 'sessionFactory5': com.atlassian.confluence.tenant.VacantException: Confluence is vacant, a call to tenanted [public abstract void org.hibernate.SessionFactory.close() throws org.hibernate.HibernateException] is not allowed.
2022-12-01 10:09:57,335 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] shutdownCacheManager Shutting down EhCache cache manager
2022-12-01 10:09:57,343 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] shutdownCacheManager Shutting down EhCache cache manager
2022-12-01 10:09:57,346 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextDestroyed Stopping Confluence
[confluence@confluence02 ~]$
@Andrew Meyer Could you please review this link: https://confluence.atlassian.com/doc/confluence-7-20-upgrade-notes-1142251041.html
Could you please let me know were it is mentioned that Postgres 11 is not supported ?
It is on this page - https://confluence.atlassian.com/conf720/supported-platforms-1168862619.html
Yellow exclamation point next to PostgreSQL 11.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe that Yellow exclamation is a warning regarding changes on confluence 8.x about supporting PostgreSQL 11 will not be available.
HTH
Nicolas
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.
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.
@Andrew Meyer could you please try upgrading from 7.19.1 to 7.19.(latest) and then to 7.20 to 7.20.latest ?
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.
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.