After confluence upgrade I am not able to start server

[Praveen]

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)

[Monique Khairuliana[ServiceRocket]]

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

[Praveen]

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.

[Lionel Seaw]

hi

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