It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Connection resource issue

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

1 answer

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

294 views 9 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you