cannot login to confluence after upgrade

Question

Hi,

after upgrade confluence from 6.4.0 to 8.0.0 I'm not able to login

The following error(s) occurred:

* Sorry, an error occurred trying to log you in. Please try again

Confluence connects to jira server for authentication

2022-12-02 11:30:19,247 WARN [https-jsse-nio-8443-exec-5] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.user.DefaultUserAccessor.authenticate]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #136661692)
-- url: /dologin.action | referer: https://my.server.com/dologin.action | traceId: 5af1d3dcb2188dcf

Help me,

please

Christian Attanasio · Answer

hi,

any suggestions?

Christian Attanasio · Answer

Hi,

after database restore the situation is:

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Max Foerster - K15t · Answer

Hi @Christian Attanasio

Do you have a local admin account in the local user directory in Confluence that you could try to log in with? (General advice: You should have one. Always 😉 some helpful docs: Restore Passwords To Recover Admin User Rights)

Best, Max