cannot login to confluence after upgrade

[Christian Attanasio]

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

[Max Foerster - K15t]

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

[Christian Attanasio]

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

[Christian Attanasio]

hi,

any suggestions?