Fresh Installation of Confluence is failing when setting up mysql database

Question

Hi,

I am installing Confluence (atlassian-confluence-6.14.0-x64) on my machine which also includes Jira Service Desk. The database is MySQL 5.7.25 and the jdbc connector file is mysql-connector-java-5.1.47-bin.jar.

When I reach the database setup stage I get the following warning in the logs:

2019-02-02 14:00:20,707 WARN [Navlink Plugin Executor:thread-2] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0059f0e2c35a3af8 | userName: anonymous | action: setupdbtype

and then after that I get the following:

2019-02-02 14:05:21,111 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1867059831)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:21,147 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1368709900)

and then I get this:

2019-02-02 14:05:24,021 WARN [ThreadPoolAsyncTaskExecutor::Thread 22] [client.eventfilter.whitelist.AnalyticsWhitelistModuleDescriptor] readPluginWhitelist No whitelist resource file found at [mediaviewer/lib/analytics-whitelist.json] in plugin [com.atlassian.confluence.plugins.confluence-previews] (bundle entry not found)
-- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:24,021 WARN [ThreadPoolAsyncTaskExecutor::Thread 22] [client.eventfilter.whitelist.AnalyticsWhitelistModuleDescriptor] readPluginWhitelist No whitelist resource file found at [mediaviewer/lib/analytics-whitelist.json] in plugin [com.atlassian.confluence.plugins.confluence-previews] (null InputStream)
-- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths

and then I get errors that tables (users, os_user, groups, os_group) do not exist:

2019-02-02 14:05:32,998 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM users - Table 'cdb.users' doesn't exist
-- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdb.users' doesn't exist

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdb.os_user' doesn't exist
at sun.reflect.GeneratedConstructorAccessor299.newInstance(Unknown Source)
at [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM groups - Table 'cdb.groups' doesn't exist
-- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdb.groups' doesn't exist
at sun.reflect.GeneratedConstructorAccessor299.newInstance(Unknown Source)

2019-02-02 14:05:33,032 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM os_group - Table 'cdb.os_group' doesn't exist
-- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdb.os_group' doesn't exist
at sun.reflect.GeneratedConstructorAccessor299.newInstance(Unknown Source)
2019-02-02 14:05:36,889 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1241741416)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:38,699 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1091912885)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:38,727 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1274758558)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:39,690 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1621204663)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:39,851 WARN [active-objects-init-system tenant-0] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #26993969)
-- url: /setup/setuppaths.action | referer: http://localhost:8090/setup/setupdbtype-start.action | traceId: 0099636f81a718b9 | userName: anonymous | action: setuppaths
2019-02-02 14:05:40,116 INFO [http-nio-8090-exec-4] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system lateStartup ended
2019-02-02 14:06:17,344 WARN [SiteSummaryCalculator:thread-1] [hibernate.boot.internal.SessionFactoryOptionsBuilder] doLog org.hibernate.tool.schema.Action cannot be cast to java.lang.String Ignoring
-- url: /setup/setuppaths.action | traceId: 0099636f81a718b9 | userName: anonymous | referer: http://localhost:8090/setup/setupdbtype-start.action | action: setuppaths

I've spent quite a while trying to resolve this issue and uninstalled and reinstalled several times.

Anyone can help regarding this ASAP please?

Shannon S · Answer

Abdul,

It's not recommended that you have both the JDK and JRE installed at the same time, but it could work. However, if you intend to use the JRE, then you don't need to add any lines like you did.

I would recommend removing the lines you added so Confluence can use the included JRE.

As for MySQL, it sounds like you might possibly be trying to use the same database that Jira is installed on, which is not recommended and will cause issues.

If you did not yet create a separate database and user for Confluence, you need to do that now. Start from step #3 of the Database Setup for MySQL documentation, create your database user and database, and try setting up Confluence from the beginning.

Let me know if you have any questions about that.

Regards,

Shannon

Abdul Rahman El Soloh · Answer

For MySQL it was already installed for Jira Servicedesk but I change the parameters in the my.ini file as mentioned on this page:

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

After that I started installing confluence and after being installed and before the setup I stopped Confluence and copied the JDBC driver (mysql-connector-java-5.1.47-bin.jar) to (C:\Program Files\Atlassian\Confluence\confluence\WEB-INF\lib).

I also added the following lines to setenv.bat:

set JRE_HOME = C:\Program Files\Atlassian\Confluence\jre
set CATALINE_HOME = C:\Program Files\Atlassian\Confluence

And the following line to setenv.sh:

JRE_HOME="C:\Program Files\Atlassian\Confluence\jre"

It is a brand new installation of Confluence, I have tried several times to uninstall and delete all related folders and re-install again and everytime I do that I would drop the confluence database and restart mysql service.

As for JDK and JRE I have (jdk1.8.0_71, jre1.8.0_201, jre7) installed but I have already directed the installer to use the JRE from confluence directory itself.

Shannon S · Answer

Abdul,

Can you let me know exactly the steps you took so far to create your MySQL database and install Confluence? I want to know what method you used.

Please also confirm this is a brand-new installation of Confluence and that the MySQL database is brand-new and hasn't been used.

Lastly, are you using the JDK or the JRE for Java?

Regards,

Shannon