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; } } }

Tend to upgrade from 5.97 to 5.10 before move to Cloud

Bruce Yen

During upgrade, I got these error while restarting Confluence:

Wonder if anyone can help? Thanks a lot.

Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Caused by: com.atlassian.config.ConfigurationException: Cannot update schema
Caused by: net.sf.hibernate.HibernateException: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Caused by: org.postgresql.util.PSQLException: ERROR: relation "scheduler_clustered_jobs" does not exist
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.atlassian-whitelist-core-plugin]
Caused by: java.lang.RuntimeException: Could not get unique fields for table 'AO_21D670_WHITELIST_RULES'
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.confluence.plugins.confluence-feature-discovery-plugin]
Caused by: java.lang.RuntimeException: Could not get unique fields for table 'AO_6384AB_DISCOVERED'
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist

Accepted answers

All comments

Pavel Junek

Hi @Bruce Yen,

What version of PostgreSQL do you have? Confluence 5.10 is only compatible with PostgreSQL 9.2 and 9.3. Maybe this KB article will help you CONFSERVER-44216

Cheers

Pavel

Bruce Yen

Thanks for replying.

We are using 9.6.2 (on AWS RDS).

But 5.9.7 works with this version. But 5.10.0 doesn't? I'm confused.

Thanks again.

Pavel Junek

Yes, something may not work properly.

For each version of Confluence you need to look at Supported Platforms. According to the article https://jira.atlassian.com/browse/CONFSERVER-44216 should help upgrade the PostgreSQL driver.

Pavel

Bruce Yen

All right. I'll follow the instruction and add this new latest jdbc drive.

If possible, please don't close this thread. Because this problem has bothered us for a while.

Also, if we are converting Cloud version. Do we really need to get our 5.9.7 to 5.10.0 before we can do that? Can you confirm this? Or we don't need this step?

Thanks again. Much appreciated!

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