Can get Confluence to startup, even after working throught recommendation on page

[Will Miller]

Confluence had problems starting up

This page is for Confluence administrators. If you're seeing this page, your Confluence administrator is probably working to restore the service.

I have log files for you to review, if need.  I didn't see where to upload.  I really need this system back up, we have alot of import data in it.

[Zak Laughton]

Hi William,

From your logs, it looks like Confluence is having a hard time connecting to the database. The key portion here is:

Last acquisition attempt exception:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "Conf" requested by the login. The login failed. 

• Were there any changes to your environment around the time this started happening?
• Can you connect to the database using the same credentials in a third-party database application such as SQL Server management studio?

– Zak

[William Miller]

I figure it out.  The log file on the sql database needed to be shrinked.  It had grown to large.  Once I shrinked it, everything came online.  I will be looking to move it to cloud..

[Zak Laughton]

Glad to hear you got it working, William!

And the cloud instance is a great alternative to not need to deal with these types of database admin issues. In case it helps, we just put out a new server-to-cloud migration planning guide in addition to our other migration documentation. See the announcement here: NEW: Confluence Server to Cloud migration planning guide.

[Grigory Salnikov]

Hi @William Miller  and welcome to our Community!

You can always upload logs as text.

[William Miller]

2019-02-22 07:53:53,142 WARN [C3P0PooledConnectionPoolManager[identityToken->1hgeek2a152tvig1d0ef7n|285dcc1a]-HelperThread-#2] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@e3cdce7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-02-22 07:53:53,142 WARN [C3P0PooledConnectionPoolManager[identityToken->1hgeek2a152tvig1d0ef7n|285dcc1a]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4ea2baf4 -- 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:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "Conf" requested by the login. The login failed. ClientConnectionId:172443ba-459b-420c-8f52-5719473037f6
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)