Can't upgrade plugins, getting errors in the log that start with:
org.postgresql.util.PSQLException: ERROR: relation "AO_6384AB_FEATURE_METADATA_AO_ID_seq" does not exist
Everything else seems to work OK...
Yan,
Can you tell us your current Confluence version, and the version you upgraded from? Please also confirm your PostgreSQL version.
Lastly, let us know exactly which steps you took to perform the upgrade.
Regards,
Shannon
I am running version 6.8.2, upgraded from a very recent version... 6.8.0 I think.
--------------------------
Database Information
--------------------------
Database Dialect: com.atlassian.confluence.impl.hibernate.dialect.PostgreSQLDialect
Database URL: jdbc:postgresql://localhost:5432/confluencedb
Database Driver Name: org.postgresql.Driver
Database Driver Version: 42.1.1
Database Name: PostgreSQL
Database Version: 9.6.6
Database Latency (ms): 0
For the upgrade, I executed the .bin file and followed all the prompts.
Thanks,
Yan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Yan.
So, it does seem there's an issue with the current database, so let's try this.
Let me know how it goes and if you have any questions.
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shannon,
Unfortunately, this will not work. I don't have the 6.8.0 installation files and perhaps too rashly deleted the backup I took before the upgrade.
Additional information:
The add-ons are actually up-to-date. I uninstalled them (no error) and re-installed them (same error). Yet, they all seem to work correctly.
Thank you,
Yan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yan,
In that case, you will need to directly modify the database, which is not recommended.
Before you proceed, please create a backup of your instance.
CREATE SEQUENCE "AO_6384AB_FEATURE_METADATA_AO_ID_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START WITH 1 NO CYCLE OWNED BY "AO_6384AB_FEATURE_METADATA_AO"."ID"
SELECT max("ID") from "AO_6384AB_FEATURE_METADATA_AO"
SELECT setval('"AO_6384AB_FEATURE_METADATA_AO_ID_seq"', +1 , true)
This should fix the missing sequence.
If you happen to get an error that mentions relation exist then it is likely a permissions issue.
Let me know if you have any questions.
Regards,
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yan,
Great news! Thank you for confirming.
Take care and have a pleasant rest of your week!
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.