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?

[Andy]

Can anyone please assist me? 

[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`

[Andrew Laden]

Make sure you are connected to the Jira database, not the usual default postgres one. 

[Andy]

I connected to the confluence db, and get this error when running that alter table command: "Error: column "owner_not_null" of 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`

[Andy]

*bump*

[Robert Wen_Cprime_]

@Andy  it really looks like your PostgreSQL is several versions out of support.  8.5 supported PostgreSQL 12, 13, and 14.  9.1 is deprecating 14, but supports 15 and 16.

https://confluence.atlassian.com/conf91/supported-platforms-1442849250.html

You might need to see about upgrading to 14, seeing if the upgrade can work, and then upgrade the database further.