nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fresh server install and get java error when setting up the database

Adam_Loghides

I am just attempting to setup a confluence install on a linux server and I get the same error no matter which type of database I am trying to connect to (built-in, mysql, MSSQL). I've followed the setup instructions for each type of DB when trying to install. Not sure what I am doing wrong.

Type Exception Report

Message Cannot call sendError() after the response has been committed

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

Exception

java.lang.IllegalStateException: Cannot call sendError() after the response has been committed

Accepted answers

Shannon S

Hi Adam,

This error is usually indicative of another issue. The best way to check that is for you to review the Confluence server logs and see what other error message is being served with that error.

Please also confirm your Confluence version as well as the database versions you tried.

Regards,

Shannon

All comments

Shannon S

Hi Adam,

This error is usually indicative of another issue. The best way to check that is for you to review the Confluence server logs and see what other error message is being served with that error.

Please also confirm your Confluence version as well as the database versions you tried.

Regards,

Shannon

Adam_Loghides

removed this - I meant to reply above

Adam_Loghides

Hi Shannon,

I am trying to use the latest version of confluence (6.10 I think) and a fresh install. I get this error when attempting to use the built-in database just to evaluate the product; however, I went ahead and tried using a MSSQL and local MySQL databse with no luck.

Here is what I see in the logs when trying to setup the server with the built-in database:

2018-08-23 20:27:09,330 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2018-08-23 20:30:12,103 INFO [http-nio-8090-exec-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2018-08-23 20:30:21,199 INFO [http-nio-8090-exec-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2018-08-23 20:30:42,547 INFO [http-nio-8090-exec-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 30443 ms
2018-08-23 20:30:45,379 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] shutdown Preparing to shut down the plugin system
2018-08-23 20:30:45,382 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2018-08-23 20:30:45,435 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] earlyStartup Plugin system earlyStartup begun
2018-08-23 20:30:45,649 WARN [http-nio-8090-exec-1] [osgi.container.felix.ExportsBuilder] getUrlClassPath Cannot deep scan non file 'http://felix.extensions:9/'
-- referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | url: /setup/setupembeddeddb-default.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:31:18,041 WARN [ThreadPoolAsyncTaskExecutor::Thread 7] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
-- referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | url: /setup/setupembeddeddb-default.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:31:19,228 WARN [ThreadPoolAsyncTaskExecutor::Thread 11] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
-- referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | url: /setup/setupembeddeddb-default.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:31:50,210 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2018-08-23 20:32:04,082 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupembeddeddb-default.action | referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:32:13,923 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupembeddeddb-default.action | referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:32:23,923 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/setupembeddeddb-default.action | referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
2018-08-23 20:32:27,241 WARN [C3P0PooledConnectionPoolManager[identityToken->2s9zl19xszn4s1r57135|26165205]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1606a562 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
-- referer: http://[IP ADDRESS]:8090/setup/setupdbchoice-start.action | url: /setup/setupembeddeddb-default.action | traceId: 0066d94f620e3bdd | userName: anonymous | action: setupembeddeddb-default
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:dcad6b47-e0b5-4d22-a5e5-53cfb9aa9783
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:260)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:108)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4507)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3374)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:85)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7342)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2688)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2236)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1897)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1738)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1062)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:572)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

Thank you,

Adam

Shannon S

Adam,

It appears we're missing a few things from these logs (note that there are WARN and INFO lines, but no ERROR lines). However, I see a message about the SQL database (not the built-in database) and the user 'sa'.

To resolve that, try the following:

Create a new database according to Database Setup for SQL Server. Pay special attention to steps 4 and 5 under section 2:
1. Using your SQL administrator permissions, create a new SQL user account for Confluence (for example, confluenceuser).
2. Give this user full create, read and write permissions for the database tables. Confluence must be able to create its own schema. Refer to the SQL Server documentation for how to do this.
3. Note: It appears that right now the 'sa' database account is used to access the database.
Stop the current Confluence service.
Uninstall existing Confluence installation, and remove existing Confluence installation directories (both Confluence and Application Data).
Re-install Confluence from the installer. Provide database credentials, and click on Test Connection to ensure it passes.

Regards,
Shannon

Adam_Loghides

Hi Shannon,

Thank you - I thought I had created a confluenceuser sql account with the appropriate permissions, but after doubling back and confirming the permissions... I found that I did not apply them to the correct database.

Thank you so much - I am up and running now!

Thank you,

Adam

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server