Database error after upgrade

[Soheil Gharedaghi]

Hi mates,

I've upgraded my confluence from 7.1 to 7.5 and now the atlassian-confluence.log file throw these errors (actually I'm not gonna paste all error lines but caused lines)

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:10.6
- minor version:6
- major version:10
Driver:
- name:PostgreSQL JDBC Driver
- version:42.2.12

Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for sequence AO_9412A1_AONOTIFICATION_ID_seq

[Alexis Robert]

Hi @Soheil Gharedaghi , 

looks like a permission issue. Can you give more permissions to the user for the Confluence database ? Something like this :

GRANT ALL PRIVILEGES ON DATABASE confluencedb to confluence; 

Let me know if this helps,

--Alexis

[Soheil Gharedaghi]

Hi @Alexis Robert 

Thank you for your reply,

Actually the db user is the owner, but I've tried that before and didn't helped.