Problem upgrade 8.2.3 > 8.3.0 or newer

Olifel November 20, 2023

i have upgraded form 8.2.2 to 8.2.3 no problems, When trying to update to the new versions it gives an error.

"Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:pluginframeworkdependentupgrades (Run all the upgrades that require the plugin framework to be available)"
"

Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection

"

LOG
(2023-11-19 15:40:37,737 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 8.3.0 [build 9008 based on commit hash 772d7d39c1c255e19461f1a4a0fc1604aaef62b4] - synchrony version 5.0.9
2023-11-19 15:40:37,768 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM Eclipse Adoptium 17.0.6
2023-11-19 15:40:37,769 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Dcatalina.home=C:\\Program Files\\Atlassian\\Confluence
2023-11-19 15:40:37,770 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -XX:+UseG1GC
2023-11-19 15:40:37,770 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -XX:G1ReservePercent=20
2023-11-19 15:40:37,770 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -XX:ReservedCodeCacheSize=256m
2023-11-19 15:40:37,771 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -XX:+IgnoreUnrecognizedVMOptions
2023-11-19 15:40:37,771 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -XX:+ExplicitGCInvokesConcurrent
2023-11-19 15:40:37,772 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Xlog:gc*:file=\"C:\\Program Files\\Atlassian\\Confluence\\logs\\gc-%t.log\":tags,time,uptime,level:filecount=5,filesize=2M
2023-11-19 15:40:37,774 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Dorg.apache.tomcat.websocket.DEFAULT_BUFFER_SIZE=32768
2023-11-19 15:40:37,774 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Dsynchrony.enable.xhr.fallback=true
2023-11-19 15:40:37,775 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Djava.awt.headless=true
2023-11-19 15:40:37,776 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Datlassian.plugins.enable.wait=300
2023-11-19 15:40:37,776 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Dcatalina.base=C:\\Program Files\\Atlassian\\Confluence
2023-11-19 15:40:37,777 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Dignore.endorsed.dirs=C:\\Program Files\\Atlassian\\Confluence\\endorsed
2023-11-19 15:40:37,777 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Djava.io.tmpdir=C:\\Program Files\\Atlassian\\Confluence\\temp
2023-11-19 15:40:37,778 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
2023-11-19 15:40:37,779 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Djava.util.logging.config.file=C:\\Program Files\\Atlassian\\Confluence\\conf\\logging.properties
2023-11-19 15:40:37,779 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/java.lang=ALL-UNNAMED
2023-11-19 15:40:37,779 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/java.net=ALL-UNNAMED
2023-11-19 15:40:37,780 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/java.io=ALL-UNNAMED
2023-11-19 15:40:37,782 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/java.util=ALL-UNNAMED
2023-11-19 15:40:37,783 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/java.util.concurrent.atomic=ALL-UNNAMED
2023-11-19 15:40:37,783 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/sun.net.www.protocol.jar=ALL-UNNAMED
2023-11-19 15:40:37,783 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/sun.net.www.protocol.http=ALL-UNNAMED
2023-11-19 15:40:37,783 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/sun.net.www.protocol.https=ALL-UNNAMED
2023-11-19 15:40:37,784 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.base/sun.util.locale=ALL-UNNAMED
2023-11-19 15:40:37,784 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-opens=java.management/javax.management=ALL-UNNAMED
2023-11-19 15:40:37,784 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-exports=java.base/sun.security.action=ALL-UNNAMED
2023-11-19 15:40:37,785 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-exports=java.naming/com.sun.jndi.ldap=ALL-UNNAMED
2023-11-19 15:40:37,785 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-exports=java.xml/com.sun.org.apache.xml.internal.utils=ALL-UNNAMED
2023-11-19 15:40:37,785 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-exports=java.desktop/sun.font=ALL-UNNAMED
2023-11-19 15:40:37,786 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument --add-exports=java.base/sun.security.util=ALL-UNNAMED
2023-11-19 15:40:37,787 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument exit
2023-11-19 15:40:37,787 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument abort
2023-11-19 15:40:37,787 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Xms1024m
2023-11-19 15:40:37,787 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Using JVM argument -Xmx1024m
2023-11-19 15:40:51,191 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2023-11-19 15:41:03,174 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2023-11-19 15:41:46,888 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 55695 ms
2023-11-19 15:41:47,884 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$5 Plugin system earlyStartup begun
2023-11-19 15:41:50,877 WARN [Catalina-utility-1] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'org.cyberneko.html.xercesbridge' with different versions. Files: net.sourceforge.nekohtml_xerces-bridge-2-2-1.9.22-atlassian-2.jar and net.sourceforge.nekohtml_xerces-bridge-2-3-1.9.22-atlassian-2.jar\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-2-2-1.9.22-atlassian-2.jar'\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-2-3-1.9.22-atlassian-2.jar'
2023-11-19 15:41:50,887 WARN [Catalina-utility-1] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'org.cyberneko.html.xercesbridge' with different versions. Files: net.sourceforge.nekohtml_xerces-bridge-2-0-1.9.22-atlassian-2.jar and net.sourceforge.nekohtml_xerces-bridge-2-2-1.9.22-atlassian-2.jar\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-2-0-1.9.22-atlassian-2.jar'\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-2-2-1.9.22-atlassian-2.jar'
2023-11-19 15:41:50,888 WARN [Catalina-utility-1] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'org.cyberneko.html.xercesbridge' with different versions. Files: net.sourceforge.nekohtml_xerces-bridge-1.9.22-atlassian-2.jar and net.sourceforge.nekohtml_xerces-bridge-2-0-1.9.22-atlassian-2.jar\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-1.9.22-atlassian-2.jar'\n 'C:\\Program Files\\Atlassian\\Confluence\\confluence\\WEB-INF\\lib\\net.sourceforge.nekohtml_xerces-bridge-2-0-1.9.22-atlassian-2.jar'
2023-11-19 15:41:58,059 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2023-11-19 15:43:10,201 WARN [Catalina-utility-1] [plugin.osgi.util.OsgiHeaderUtil] stripDuplicatePackages removing duplicate import package com.atlassian.confluence.api.service.network~ for plugin com.atlassian.streams.confluence - it is likely that a duplicate package was supplied in the OSGi instructions in the plugin's MANIFEST.MF
2023-11-19 15:43:42,443 WARN [ThreadPoolAsyncTaskExecutor::Thread 6] [scanner.runtime.impl.ComponentImportBeanFactoryPostProcessor] loadServiceClass Unable to load class 'com.atlassian.jira.user.UserKeyService' for component importation purposes. Skipping...
2023-11-19 15:43:42,443 WARN [ThreadPoolAsyncTaskExecutor::Thread 6] [scanner.runtime.impl.ComponentImportBeanFactoryPostProcessor] loadServiceClass Unable to load class 'com.atlassian.jira.util.I18nHelper' for component importation purposes. Skipping...
2023-11-19 15:43:54,168 WARN [ThreadPoolAsyncTaskExecutor::Thread 3] [owasp.validator.html.Policy] <init> The directive \"noopenerAndNoreferrerAnchors\" is not enabled by default. It is recommended to enable it to prevent reverse tabnabbing attacks.
2023-11-19 15:44:12,577 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2023-11-19 15:44:13,092 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeManager] beforeUpgrade Generating pre-upgrade recovery file...
2023-11-19 15:44:13,481 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin Starting
2023-11-19 15:44:13,499 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] logTask Starting DATABASE_INFORMATION
2023-11-19 15:44:13,687 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] logTask Finishing DATABASE_INFORMATION
2023-11-19 15:44:13,703 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] logTask Starting TABLE_DEFINITION
2023-11-19 15:44:15,873 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] logTask Finishing TABLE_DEFINITION
2023-11-19 15:44:15,873 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] totalNumberOfTables Total number of tables: 195
2023-11-19 15:44:15,873 INFO [Catalina-utility-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] logTask Starting TABLES_DATA
2023-11-19 15:44:59,655 WARN [Catalina-utility-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:\n ->[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #98583272)
2023-11-19 23:45:07,154 WARN [Catalina-utility-1] [zaxxer.hikari.pool.ProxyConnection] checkException HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@129e0c8f marked as broken because of SQLSTATE(08007), ErrorCode(0)
java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1807)
at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:396)
at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:121)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:304)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)
at org.springframework.orm.hibernate5.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:672)
at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateTransactionManager.doRollback(ConfluenceHibernateTransactionManager.java:71)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:835)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:809)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at jdk.proxy4/jdk.proxy4.$Proxy106.rollback(Unknown Source)
at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:168)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:144)
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.beforeUpgrade(DefaultUpgradeManager.java:175)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:146)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.launchUpgrades(PluginFrameworkContextListener.java:122)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:82)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4491)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4939)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
2023-11-19 23:45:07,217 ERROR [Catalina-utility-1] [springframework.transaction.support.TransactionTemplate] rollbackOnException Application exception overridden by rollback exception
com.atlassian.confluence.upgrade.recovery.DbDumpException: Failed to generate recovery file
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.lambda$generate$0(DefaultRecoveryFileGenerator.java:77)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.beforeUpgrade(DefaultUpgradeManager.java:175)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:146)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.launchUpgrades(PluginFrameworkContextListener.java:122)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:82)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4491)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4939)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.atlassian.confluence.upgrade.recovery.DbDumpException: Problem with table "null":
at com.atlassian.confluence.upgrade.recovery.RecoveryErrorService.newImportExportSqlException(RecoveryErrorService.java:21)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:57)
at com.atlassian.dbexporter.exporter.DataExporter.lambda$export$1(DataExporter.java:50)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:29)
at com.atlassian.dbexporter.exporter.DataExporter.export(DataExporter.java:48)
at com.atlassian.dbexporter.DbExporter.exportData(DbExporter.java:65)
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.lambda$generate$0(DefaultRecoveryFileGenerator.java:71)
... 17 more
Caused by: java.sql.SQLException: Index 62 out of bounds for length 62
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:2014)
at com.zaxxer.hikari.pool.ProxyConnection.setAutoCommit(ProxyConnection.java:414)
at com.zaxxer.hikari.pool.HikariProxyConnection.setAutoCommit(HikariProxyConnection.java)
at com.atlassian.config.db.DelegatingConnection.setAutoCommit(DelegatingConnection.java:53)
at jdk.internal.reflect.GeneratedMethodAccessor315.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.activeobjects.spi.ConnectionHandler.delegate(ConnectionHandler.java:39)
at com.atlassian.activeobjects.spi.ConnectionHandler.invoke(ConnectionHandler.java:34)
at jdk.proxy4/jdk.proxy4.$Proxy2515.setAutoCommit(Unknown Source)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:54)
... 22 more
Caused by: com.mysql.cj.exceptions.CJException: Index 62 out of bounds for length 62
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:123)
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:691)
at com.mysql.cj.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:2005)
... 32 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 62 out of bounds for length 62
at com.mysql.cj.protocol.a.NativePacketPayload.readInteger(NativePacketPayload.java:376)
at com.mysql.cj.protocol.a.ColumnDefinitionReader.unpackField(ColumnDefinitionReader.java:115)
at com.mysql.cj.protocol.a.ColumnDefinitionReader.read(ColumnDefinitionReader.java:68)
at com.mysql.cj.protocol.a.ColumnDefinitionReader.read(ColumnDefinitionReader.java:40)
at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1648)
at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:68)
at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:48)
at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1661)
at com.mysql.cj.protocol.a.NativeProtocol.readAllResults(NativeProtocol.java:1715)
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1065)
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:998)
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:655)
... 33 more
2023-11-19 23:45:07,233 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Error initialising plugin manager: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.springframework.orm.hibernate5.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:675)
at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateTransactionManager.doRollback(ConfluenceHibernateTransactionManager.java:71)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:835)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:809)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at jdk.proxy4/jdk.proxy4.$Proxy106.rollback(Unknown Source)
at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:168)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:144)
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.beforeUpgrade(DefaultUpgradeManager.java:175)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:146)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.launchUpgrades(PluginFrameworkContextListener.java:122)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:82)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4491)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4939)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:127)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:304)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)
at org.springframework.orm.hibernate5.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:672)
... 28 more
Caused by: java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1807)
at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:396)
at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:121)
... 31 more
2023-11-19 23:45:07,421 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue Waiting to find if plugin dependent upgrades are required. Maximum wait time will be 90 seconds.
2023-11-19 23:45:07,421 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue plugin dependent upgrades are required : true.
2023-11-19 23:45:07,437 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue Waiting to find if plugin dependent upgrades are complete. Maximum wait time will be 1800 seconds.
2023-11-19 23:49:37,521 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue Still waiting to find if plugin dependent upgrades are complete. Remaining wait time is 1500 seconds.
2023-11-19 23:54:37,595 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue Still waiting to find if plugin dependent upgrades are complete. Remaining wait time is 1200 seconds.
2023-11-19 23:59:37,686 INFO [Catalina-utility-1] [confluence.upgrade.impl.DefaultUpgradeGate] waitForBooleanValue Still waiting to find if plugin dependent upgrades are complete. Remaining wait time is 900 seconds.)

2 answers

1 vote
BHUSHAN PATIL
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 24, 2023

Hi @Olifel  ,

There are few possible causes to this problem:

  1. Multiple copies of Applinks and/or plugin JARs are present in your installation. These JARs can be checked under the following directories:
    <Confluence-Installation-Directory>/confluence/WEB-INF/atlassian-bundled-plugins
  2. The application initialises slowly and the plugin start up times-out
  3. A corrupt plugin JAR cache exist
  4. An unsupported version of Java has recently been installed.

Follow the below steps to troubleshoot

1. Remove Duplicate JAR Files
Remove the multiple copies of plugin JARs from under the following directories ensuring that there is only a single copy of each under the <Confluence-Installation-Directory>/confluence/WEB-INF/atlassian-bundled-plugins folder:

2. Increase the JAR Timeout Threshold
The default plugin timeout is 60 seconds. Increase the timeout by providing the following additional JVM parameter via the environment variable JAVA_OPTS.

-Datlassian.plugins.enable.wait=300 

3. Remove Corrupt JAR Cache

Delete the following plugin cache folders and restart Confluence:

      • <confluence-home>/bundled-plugins
      • <confluence-home>/plugins-cache
      • <confluence-home>/plugins-osgi-cache
      • confluence-home>/plugins-temp

4. Check and verify the Installation and home directory permissions

For Linux run the commands below then restart Confluence.
Modify the below commands accordingly 

sudo chown -R <confluence-user>:<confluence-user> <confluence-install-folder>

sudo chown -R <confluence-user>:<confluence-user> <confluence-home-folder>

For windows

  1. Right click on <confluence-home-folder> and hit Properties.
  2. Navigate to the Security Tab and make sure that the user running Confluence has Full Control of this folder. 
  3. Do the same for the <confluence-install-folder> and <confluence-shared-home-folder> folders.
  4. Restart Confluence.

Also, if you feel my input help you please accept the answer as this help grow my Atlassian profile.

Regards,
Bhushan

Olifel December 12, 2023

hi, I tried several solutions without success

I can't find duplicate files, I increased the timeout to 300, deleted jar cache and validated the permissions on the folders. continues to give error when starting.

I have the same problem as posted  here  https://jira.atlassian.com/browse/CONFSERVER-81022 about duplicates files, i tried to keep only the most recent file but the layout started to have errors

I don't have any ideas how to solve it
image.png

0 votes
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 20, 2023

Have you upgraded the addons as you upgraded to each version?

Olifel November 22, 2023

hi,

I only have the plugins that came with the installation and yes, they are updated.
-Atlassian Troubleshooting and supportstolls
-Altassian Universal plugin Manager Plugin
-Confluence cloud Migration assistant
-sso for atlassian Data Centeimagem_2023-11-22_092528509.png

Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 12, 2023

I see the Data Center SSO plugin. Are you Server or Data Center?  Do you have the right package?

Olifel December 14, 2023

i have the server version.
I had already seen this plugin installed and I think it was already installed.
I uninstalled the application and ran the update, but it still gives the same error on startup

Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2023

Have you gone thru the troubleshooting steps at the bottom of this page? https://confluence.atlassian.com/confkb/unable-to-start-due-to-net-sf-hibernate-exception-genericjdbcexception-cannot-open-connection-128843899.html

Are you able to roll back to 8.2.3 and verify Confluence comes up and the database isn't corrupt? 

Olifel December 15, 2023

version 8.2.3 is working, I am updating on a VM to test the update,
now I added <property name="hibernate.c3p0.max_size">100</property>  and changed <property name="hibernate.hikari.maximumPoolSize">100</property> to test. I'm waiting for it to start, it takes a long time.

Do you suggest replacing the folders to 8.2.3 without restoring the 8.2.3 database backup?


Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 15, 2023

No I wouldn't recommend that.

I would recommend verifying that you have a working 8.2.3 Confluence in the VM before attempting the upgrade.  Start with a fresh VM.

Olifel December 19, 2023

That's what I've done, I copied confluence from the production server to the VM, I logged in to check if it was working and then I updated it.

Suggest an answer

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

Atlassian Community Events