Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,331
Community Members
 
Community Events
165
Community Groups

After confluence upgrade I am not able to start server

I upgraded my Confluence from 6.12.2 to 7.5.2. Now my confluence server (windows 2016 server) is giving me following error. Please note my database (MSSQL 2014) is working fine, no DB password change, no change on SSL or anything. Please look below error and suggest. Thank you.

Type Exception Report

Message An exception occurred processing [errors.jsp] at line [13]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [errors.jsp] at line [13]

10:     <link rel="shortcut icon" href="johnson/fav-confluence.ico">
11:     <%
12:         JohnsonPageI18NProvider johnsonPageI18NProvider = (JohnsonPageI18NProvider) BootstrapUtils.getBootstrapContext().getBean("johnsonPageI18NProvider");
13:         String translations = johnsonPageI18NProvider.getTranslations().serialize();
14:     %>
15:     <script>
16:         window.i18n = <%=translations%>;

 More error:

Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:626)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:515)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

Root Cause

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
	org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:473)

Root Cause

net.sf.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:102)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:129)
	org.hibernate.internal.SessionImpl.connection(SessionImpl.java:514)

Root Cause

java.sql.SQLException: Connections could not be acquired from the underlying database!
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
	com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
	com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
	net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:36)
	com.atlassian.hibernate.adapter.adapters.ConnectionProviderV5Adapter.getConnection(ConnectionProviderV5Adapter.java:35)
	org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:99)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:129)
	org.hibernate.internal.SessionImpl.connection(SessionImpl.java:514)

Root Cause

com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
	com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
	com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)

Root Cause

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS12, TLS11]". ClientConnectionId:fcb43cb3-0784-4a70-a4f8-91218c0bf1dd
	com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2645)

 

Root Cause

javax.net.ssl.SSLHandshakeException: The server selected protocol version TLS10 is not accepted by client preferences [TLS12, TLS11]
	java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
	java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
	java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
	java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)

 

1 answer

The error message looks like complaining about SSL. When upgrading Confluence did the java got upgraded/changed as well? If yes, might want to re-do the SSL configuration (certs) again.

Try connecting confluence to MSSQL without SSL and see if that works or yielding different error message

Hi Monique,

Thank for your reply. There was no change on any application or software. In same server I have Jira which is working fine.

Now I tried to roll back confluence but getting DB connection error message:

Database: Database connection failed

Confluence failed to establish a connection to your database.
This could be because:

  • Your database isn't running
  • The configuration of your confluence.cfg.xml file is incorrect (user, password, or database URL etc.)
  • There is a network issue between Confluence and your database (e.g. firewall, database doesn't allow remote access etc.)

Sorry I am new to system administration. Can you help me to provide SSL config step/link for windows server? My server is hosted in AWS environment.

hi

Can i know if you eventually solved this and how did you do it?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.5.2
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

270 views 2 5
Read article

Community Events

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

Events near you