Problem installing Confluence 6.15.2 with MySQL

[Eric Merkel]

I am having problems installing Confluence on CentOS 7 with MySQL. I get to the point where the installer wants to install the database. I put in my database information and test the connection and it says it can connect OK. I then go complete the installation and it says it is going to setup the database, etc and this will take a while. The process just sits there and spins for a couple minutes at which point java / confluence completely stops running and needs to be restarted to being the installation process again. I really don't see anything in the atlassian-confluence.log. I also do a "show processlist;" in MySQL while it is spinning but it looks like nothing is happening in MySQL. Below is the output during the install process. Anyone have ideas what the issue could be?

2019-04-12 21:55:19,374 INFO [http-nio-8090-exec-8] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2019-04-12 21:56:19,188 INFO [http-nio-8090-exec-8] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 70324 ms
2019-04-12 21:56:19,336 INFO [http-nio-8090-exec-8] [atlassian.plugin.manager.DefaultPluginManager] shutdown Preparing to shut down the plugin system
2019-04-12 21:56:19,352 INFO [http-nio-8090-exec-8] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2019-04-12 21:56:19,805 INFO [http-nio-8090-exec-8] [atlassian.plugin.manager.DefaultPluginManager] earlyStartup Plugin system earlyStartup begun
2019-04-12 21:56:26,156 WARN [http-nio-8090-exec-8] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'javax.annotation' with different versions. Files: javax.annotation-api-1.3.2.jar and jsr305-3.0.1.jar
'/opt/atlassian/confluence/confluence/WEB-INF/lib/javax.annotation-api-1.3.2.jar'
'/opt/atlassian/confluence/confluence/WEB-INF/lib/jsr305-3.0.1.jar'
-- referer: http://docs.sozo.tech:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00842c821ce754d0 | userName: anonymous | action: setupdbtype
2019-04-12 21:56:32,187 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
-- referer: http://docs.sozo.tech:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00842c821ce754d0 | userName: anonymous | action: setupdbtype

[Chris Nicosia]

Hi @Eric Merkel - what version of MySQL are you using? The first step is to make sure all your environment choices are supported. You can check out the list here: https://confluence.atlassian.com/doc/supported-platforms-207488198.html

[Eric Merkel]

I am running the following:

OS: CentOS 7

MySQL 5.6: mysql-community-server-5.6.43-2.el7.x86_64

Java: java-1.8.0-openjdk-1.8.0.201.b09-2.el7_6.x86_64 
        java-1.8.0-openjdk-headless-1.8.0.201.b09-2.el7_6.x86_64

Here are the MySQL Settings:

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
sql_mode = NO_AUTO_VALUE_ON_ZERO
transaction-isolation=READ-COMMITTED
binlog_format=row
bind-address = 127.0.0.1

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Let me know if there are any other environmental setting that might be relevant.

Best regards,

Eric

[Chris Nicosia]

@Eric Merkel - I haven't experience this particular issue before but here are a few things to try based on other similar articles:

1. Ensure you have followed all the recommended steps when setting up the MySQL database and environment.
   1. Reference: https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html
2. Review the MySQL Troubleshooting FAQ to see if there are any other suggestion actions that you can try.
   1. Reference: https://confluence.atlassian.com/confkb/database-troubleshooting-for-mysql-13138.html
3. Try deleting the partial installation folder before trying again.
   1. Reference: https://community.atlassian.com/t5/Confluence-questions/Getting-system-error-after-installing-Confluence-server/qaq-p/620294
4. Use the bundled JDK that comes with 5.15.2 (now u202)  
   1. References:
      1. https://community.atlassian.com/t5/Confluence-questions/Confluence-Error-after-building-Database/qaq-p/893100
      2. https://confluence.atlassian.com/doc/issues-resolved-in-6-15-2-968671976.html

I hope something sticks out to you in one of these articles.  If you go through these and are still running into issues, maybe you can try to install on the bundled database instead during the install wizard so you can eliminate anything else being an issue besides the MySQL DB.

[Eric Merkel]

I will try those. One question I have is I am wanting to migrate an existing confluence site which uses MySQL. It is a fairly small site used by a handful of users. Would it work to import my site that was in MySQL into the built in database?

Eric

[Eric Merkel]

Actually, tried installing the Confluence with Postgres and built in database with the bundled jre and all of them fail. I am not sure what to try next. This is a plain CentOS 7 install with nothing else on it. The server only has 1G of RAM. Could that potentially be the issue?

Eric

[Chris Nicosia]

Yes not having enough Ram could definitely affect the process.  I would increase this to at least 6 GB.   I would review the full list here: https://confluence.atlassian.com/doc/server-hardware-requirements-guide-30736403.html