Confluence: The origin server did not find a current representation for the target resource ....

Lukas Brezina July 20, 2018

Hello,

 

will anybody help please?

After upgrad from 6.7. to 6.9.0 or 6.10.1 have this message.

Actually, the  problem started, when my server was out of space. So I made a space, but confluence was not working, even after restart, etc.. so I decided to do the update. I did update, but since then I have this message (Attached). Anybody has any idea?

 

Thank you!Capture.PNG

3 answers

1 vote
Maria Heij [Refined]
Contributor
January 22, 2020

For anyone getting this message, in my case it was as simple as me not adding the context path (in my case /jira) instead just accessing the port instead. Adding the /jira to the ip-address:port solved my problems. 

charleslcso
Contributor
October 24, 2020

You hero Maria!

0 votes
Lukas Brezina July 24, 2018

So, what I did. I found the backup of the HOME directory. And I have a backup of the SQL Database.

 

So

- I uninstalled confluence, deleted folders.

- downloaded version 6.7.0. installed this version and loaded back the HOME directory.

- It is still not running, DB access is OK, I checked the database name and password and port.

 

if I open the atlassian-confluence.log, I can see ...

 

2018-07-24 17:07:21,995 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1ktz3jr1b5vjvp|3deb97d7]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@32872c11 -- 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 'Confluence'. ClientConnectionId:07ad5860-c806-4c89-a193-398d5124a9cf
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)
2018-07-24 17:07:21,995 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1ktz3jr1b5vjvp|3deb97d7]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@715feaed is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

 

any help please? :(

AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 24, 2018

Hi Lukas,

Please double check the Confluence database account as we still see this in the log:

Login failed for user 'Confluence'. 

I was typing to you while you posted your last update so please check that post to change the password Confluence uses to connect to the database if necessary.

Thanks,

Ann

Lukas Brezina July 24, 2018

Hello @AnnWorley,

I changed password for SQL DB, and also changed that in the confluence.cfg.xml

- still not working,

 

Log here:

 

2018-07-24 17:26:06,435 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@3cbe4376 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2018-07-24 17:26:06,435 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#2] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@3cbe4376 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2018-07-24 17:26:06,435 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@70e46719 -- 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 'Confluence'. ClientConnectionId:0fd275b9-c6ce-4bd6-971b-1d38b884acb9
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)
2018-07-24 17:26:06,450 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#1] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@3cbe4376 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2018-07-24 17:26:06,450 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@39ae9965 -- 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 'Confluence'. ClientConnectionId:e1846511-26d7-460f-9bd9-d2a51ce05821
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)
2018-07-24 17:26:06,450 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kumegot1yoke|7d7fb914]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@3cbe4376 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

Lukas Brezina July 24, 2018

one more log here. Not so smart from it.. :-/

 

 

2018-07-24 17:50:04,185 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-AdminTaskTimer] [mchange.v2.async.ThreadPoolAsynchronousRunner] log com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@a1ea93e -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@540a44dc
on thread: C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#2
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@689a0f78
on thread: C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@60bde2e7
on thread: C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#1
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5d249c7a
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5b0e0fa6
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@63d73a70
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6cf25637
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@15ccd09f
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3e148ebf
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@644a37b7
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1af796e7
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@694ce50e
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@73b7ffee
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@467599a0
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@60136f27
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6e7982be
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@227d5810
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@48af6d66
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@33be4903
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@11f041b8
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#2,5,main]
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll0(Native Method)
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll(WindowsSelectorImpl.java:296)
sun.nio.ch.WindowsSelectorImpl$SubSelector.access$400(WindowsSelectorImpl.java:278)
sun.nio.ch.WindowsSelectorImpl.doSelect(WindowsSelectorImpl.java:159)
sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:86)
sun.nio.ch.SelectorImpl.select(SelectorImpl.java:97)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocketUsingJavaNIO(IOBuffer.java:2507)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2368)
com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:640)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2220)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1897)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1738)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1062)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:572)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#0,5,main]
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll0(Native Method)
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll(WindowsSelectorImpl.java:296)
sun.nio.ch.WindowsSelectorImpl$SubSelector.access$400(WindowsSelectorImpl.java:278)
sun.nio.ch.WindowsSelectorImpl.doSelect(WindowsSelectorImpl.java:159)
sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:86)
sun.nio.ch.SelectorImpl.select(SelectorImpl.java:97)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocketUsingJavaNIO(IOBuffer.java:2507)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2368)
com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:640)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2220)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1897)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1738)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1062)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:572)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kv31g26vblqt|575dfe1d]-HelperThread-#1,5,main]
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll0(Native Method)
sun.nio.ch.WindowsSelectorImpl$SubSelector.poll(WindowsSelectorImpl.java:296)
sun.nio.ch.WindowsSelectorImpl$SubSelector.access$400(WindowsSelectorImpl.java:278)
sun.nio.ch.WindowsSelectorImpl.doSelect(WindowsSelectorImpl.java:159)
sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:86)
sun.nio.ch.SelectorImpl.select(SelectorImpl.java:97)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocketUsingJavaNIO(IOBuffer.java:2507)
com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2368)
com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:640)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2220)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1897)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1738)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1062)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:572)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 24, 2018

MS SQL is still refusing the user credentials:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Confluence'. 

Please make sure the Windows authentication mode is set to mixed.Database Setup for SQL Server

SQL Server allows two types of authentication: SQL Server Authentication and Windows Authentication. To make sure Confluence will be able to connect to your database you'll need to set your SQL server to allow Mixed Authentication (both SQL Server and Windows modes). This setup is generally found under Properties > Security > Server Authentication.
Here is more info from Microsoft: Authentication in SQL Server
sm.park July 24, 2019

Hi

Lukas

Did you fix problum?

0 votes
AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 23, 2018

Hi Lukas,

What was the behavior when Confluence wouldn't start after the disk space was cleared? Was there an error then?

What steps did you take to upgrade Confluence?

Please check for errors in:

  • <confluence_install>/logs/ (anything recent in this directory)
  • <confluence_home>/logs/atlassian-confluence.log
    (Note) The <confluence_home> directory is the path defined in the following file: <confluence_install>/confluence/WEB-INF/classes/confluence-init.properties

Thanks,

Ann

Lukas Brezina July 24, 2018

Hello, It wont start, I have no idea about errors :(

 

I tried to update it to the latest version, but not succesfull. So I even uninstall it, install it again, i have the ZIP backup, but also not succesfull.

 

now, I am trying to run the 6.10.1 x64 version, logs are attached.

https://www.dropbox.com/s/bqoai0m3t5niaa9/logs.rar?dl=0

Java on server - latest version...

AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 24, 2018

Hi Lukas,

Thanks for the logs. Please check the the database user password has not expired, based on these entries:


2018-07-24 12:14:40,894 WARN [C3P0PooledConnectionPoolManager[identityToken->1mv4z2c9w1kjdv721j50fz4|2e472afa]-HelperThread-#0] [mchange.v2.resourcepool.BasicResourcePool] log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@35cd850c -- 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 'Confluence'. Reason: The password of the account has expired. ClientConnectionId:b32908e7-8fd7-4e37-9e1d-2fe5f2ecfb5b

I hope Confluence will start once the password is reset. Unless the new password is the same as the old one, it will also need to be reset in the confluence.cfg.xml in the line:

 <property name="hibernate.connection.username">username</property>

I hope Confluence starts as expected after making these changes.

Thanks,

Ann

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events