Database error after upgrade

Question

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

Soheil Gharedaghi_jv1bfx · Answer

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.

Alexis Robert · Answer

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