Connection resource issue

[Nino]

Any assistance is appreciated! We are using SQL Authentication with a user called ‘AtlassianAdmin’. We are able to login to our DB with this user from outside from other applications and SQL Management Studio, but not the Atlassian Confluence. The issue happened after we migrated from version 5.8.9 to 6.15.9. We tried items below:

1. Installed a new instance of SQL Server.
2. Changed the version of our JDBC driver and upgraded it to the latest version.
3. Changed the SQL from SQL Authentication to Mixed mode (SQL And Windows authentication)
4. Tried using Windows Authentication
5. Tried using integrated security
6. Re-Installed the Atlassian

Here are the error logs below:

2019-09-24 17:26:18,457 WARN [C3P0PooledConnectionPoolManager[identityToken->1hge1t7a5s2gnn91qpcxqs|2b2dbea6]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1e3e58bb -- 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: Login failed for user ‘AtlassianAdmin’. ClientConnectionId:879b2c98-29f1-4355-83a6-880b1d1cd6ee

                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)

2019-09-24 17:26:18,457 WARN [C3P0PooledConnectionPoolManager[identityToken->1hge1t7a5s2gnn91qpcxqs|2b2dbea6]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@647b858a is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

2019-09-24 17:26:18,457 ERROR [Catalina-utility-1] [confluence.setup.dbcheck.SqlServerChecker] checkIsolationLevel SQL Server isolation level could not be read

java.sql.SQLException: Connections could not be acquired from the underlying database!

                at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)

                at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)

                at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)

                at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:36)

                at com.atlassian.config.db.DatabaseHelper.getConnection(DatabaseHelper.java:134)

                at com.atlassian.confluence.setup.dbcheck.SqlServerChecker.checkIsolationLevel(SqlServerChecker.java:41)

                at com.atlassian.confluence.setup.dbcheck.SqlServerChecker.verifyDatabaseSetup(SqlServerChecker.java:35)

                at com.atlassian.confluence.setup.DefaultBootstrapManager.checkConfigurationOnStartup(DefaultBootstrapManager.java:686)

                at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.checkConfigurationOnStartup(BootstrapApplicationStartupListener.java:23)

                at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.onApplicationEvent(BootstrapApplicationStartupListener.java:17)

                at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.onApplicationEvent(BootstrapApplicationStartupListener.java:12)

                at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172)

                at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165)

                at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139)

                at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:393)

                at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:399)

                at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:347)

                at com.atlassian.spring.container.SpringContainerContext.contextReloaded(SpringContainerContext.java:164)

                at com.atlassian.spring.container.ContainerContextLoaderListener.contextInitialized(ContainerContextLoaderListener.java:40)

                at com.atlassian.confluence.setup.ConfluenceBootstrappedContextLoaderListener.contextInitialized(ConfluenceBootstrappedContextLoaderListener.java:38)

                at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4682)

                at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5143)

                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)

                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)

                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)

                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

                at java.lang.Thread.run(Thread.java:748)

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

                at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)

                at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)

                at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)

                at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)

                at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)

                ... 30 more

2019-09-24 17:26:18,488 WARN [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade

2019-09-24 17:26:19,673 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve

[Andrew]

Hi @Nino ,

Could You please provide version SQL?

https://confluence.atlassian.com/conf615/supported-platforms-967338803.html

Also I recommend check driver https://confluence.atlassian.com/conf615/database-jdbc-drivers-967338417.html

B.R.

[Nino]

Andrew,

Thank you for your reply! We upgraded to SQL Server 2017 and using the JDBC Driver when we upgraded to the newest version on Confluence.

Anything else you can recommend will be appreciated! Thank you.

-Nino