Server don't start after update to latest version 8

[Franco Gaudiano]

Hello,

After installation of the latest version of Confluence the program don't start.

This the error message.

Cause

    Une exception s'est produite lors du traitement de [errors.jsp] à la ligne [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%>; Stacktrace:

    Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

    Unable to acquire JDBC Connection

    Connections could not be acquired from the underlying database!

    A ResourcePool could not acquire a resource from its primary factory or source.

    Communications link failure The last packet successfully received from the server was 0 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.

    No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

Referer URL

http://localhost:8090/errors.jsp

Thank you for help.
Best regards

Franco Gaudiano

[Rilwan Ahmed]

Hi @Franco Gaudiano ,

This could be due to multiple reasons.

1. Check your database is up and running
2. Check that your username and password for your database is correct and hasn't been changed. This is configured in confluence.cfg.xml.
3. Check your DB connection pool settings as mentioned here
4. More causes and resolutions are described in https://confluence.atlassian.com/confkb/connections-could-not-be-acquired-from-the-underlying-database-104825087.html

[Frank]

Hello,

Thank you for your response. In fact, I had to change the MySql connector during the update. Now, I have another issue:

"Detected tables with non-default character encoding. See  link to error ".

However, I have already changed all the tables in the Confluence database to use utf8mb4 encoding.

Do I need to change other tables in the database or is there another solution?

Thank you.
Best regards

[Rilwan Ahmed]

Hi @Frank ,

Please check if t his solution resolves your query

https://confluence.atlassian.com/confkb/confluence-does-not-start-with-detected-tables-with-non-default-character-encoding-collation-message-392888396.html

Also check https://confluence.atlassian.com/confkb/mysql-collation-repair-table-level-changes-670958169.html and https://confluence.atlassian.com/confkb/mysql-collation-repair-database-level-changes-670958163.html

[Frank]

Thank you,

I tried all of these posts and all works on database and tables, but not on the TRIGGERS and Stored Procedures.

You can have a look at the images bellow.

Thank you for help.