nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Failed to upgrade to 9.1.1

Andy_5ygdd2

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?

Accepted answers

All comments

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_5ygdd2

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

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_5ygdd2

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

Andy_5ygdd2

`psql (PostgreSQL) 10.23`

Andrew Laden

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

Andy_5ygdd2

Can anyone please assist me?

Andy_5ygdd2

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".

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

data-center

confluence-data-center