Failed to upgrade to 9.1.1

[Andy]

I attempted to upgrade my standalone confluence instance to 9.1.1, and get this error:

`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: Upgrade task com.atlassian.confluence.upgrade.upgradetask.LabelUniqueIndexUpgradeTask@14921b54 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [alter table LABEL add column OWNER_NOT_NULL VARCHAR(255) GENERATED ALWAYS AS (COALESCE(OWNER, '')) STORED]`

How do I resolve this?

[Andrew Laden]

I worked with support. They eventually just had me drop the column from the table. The upgrade then re-created it.

ALTER TABLE label DROP COLUMN owner_not_null;

[Andy]

I get this error:
`ERROR: relation "label" does not exist`

[Robert Wen_Cprime_]

Hi @Andy 

Looks like there was a problem when upgrading your DB schema before Confluence came up.  Can you provide some details about the system (server, OS version,  database, etc) you're using for Confluence?  Also, the previous version will help too.

This Community question refers to the same error on a PostgreSQL database.  https://community.atlassian.com/t5/Confluence-questions/Posgresql-Error-when-I-try-Install-Confluence/qaq-p/2861793

[Andy]

Standalone, Rocky Linux 8.10

How do I find my previous version I was running? /opt/atlassian/confluence/confluence/META-INF/maven/com.atlassian.confluence/confluence-webapp/pom.properties shows 9.1.1.

I am using postgresql.

EDIT:

I am going to say previous version was atlassian-confluence-8.5.3-x64.bin.

[Robert Wen_Cprime_]

Ok, what version of PostgreSQL?  I see several End of Support notices for PostgreSQL versions 9.4, 9.5, and 9.6 between Jira 8.5.3 and 9.1.1

PDF documentation is here https://confluence.atlassian.com/alldoc/jira-documentation-directory-71598773.html

[Andy]

`psql (PostgreSQL) 10.23`