CDO Database Migration #95
Unanswered
IvanSeregin
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
I have an old project based on CDO 3.0.x, now we're migrating to the latest CDO (actually we are on 2024_08 now). Is there any way to perform databse migration? I successfully updated CDO in the project and I can start my app with the clean database and CDO creates all the tables in the DB with no issue. However; when I tried to start my updated app against 3.0 CDO DB, I got an exception in my logs. The log messages I see in Karaf console suggest that CDO is able to do migration automatically but probably not from such an old version.
If there is no way to automatically migrate my databse, which options do I have? My EMF models were not changed just regenerated.
This is what I see in Karaf debug console, just two lines
karaf@my_project()> [INFO] Migrating schema from version 1 to version 2...[INFO] Migrating schema from version 2 to version 3...And this is what I see in my application log
Caused by: org.postgresql.util.PSQLException: ERROR: relation "cdo_lobs" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) ~[?:?] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) ~[?:?] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371) ~[?:?] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502) ~[?:?] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419) ~[?:?] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341) ~[?:?] at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326) ~[?:?] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302) ~[?:?] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297) ~[?:?] at org.eclipse.emf.cdo.server.internal.db.DBStore$2.migrateSchema(DBStore.java:1246) ~[?:?] at org.eclipse.emf.cdo.server.internal.db.DBStore.migrateSchema(DBStore.java:1164) ~[?:?] at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:684) ~[?:?]All reactions