I'm not sure, but you might want to try upgrading your database to GoCD 20.4.0 the 'normal way' first and then see if you can migrate that upgraded 20.4.0 database.
If that doesn't work your H2DB might have some corruption that needs fixing before migrating (usually done by doing an export to sql and import to a new db file) On Wed, 23 Oct 2024, 08:51 Ash, <a.nay...@gmail.com> wrote: > Hi, I am trying to migrate gocd from 19.2.0 to latest version and trying > to backup the database and insert into new postgress SQL. > When running db migration script, I am getting following error > > ./gocd-database-migrator --insert > --source-db-url='jdbc:h2:/var/tmp/cruise' --source-db-user='sa' > --target-db-url='jdbc:h2:/var/tmp/gocd/newdb/cruise' > --target-db-user='target-sa' --target-db-password='target-sa > -password' > > > ERROR > > INFO: No `--source-db-driver-class` is specified. Setting > `--source-db-driver-class='org.h2.Driver'`. > INFO: No `--target-db-driver-class` specified. Setting > `--target-db-driver-class='org.h2.Driver'`. > 2024-10-23 09:52:27,032 INFO [main] DbSync:77 - Using dialect H2 for > source database. > 2024-10-23 09:52:27,100 INFO [main] DbSync:78 - Using dialect H2 for > target database. > Reading change scripts from directory > /apps/installs/gocd-database-migrator-1.0.4/h2deltas... > dbdeploy v2.11 > Changes currently applied to database: > 1..90, 221001, 230001..230009, 240001, 240002, 300001..300011, > 1202001..1202003, 1203002..1203005, 1301001, 1302001, 1303001..1303004, > 1304001, 1401001, 1403001, 1403002, 1501001..1501003, 1502001, 1503001, > 1503002, 1606001, 1606002, 1607001, 1610001, 1701001, 1702001, > 1704001..1704003, 1708001, 1801001..1801007, 1802001, 1802002, 1804001, > 1805001, 1807001, 1807002, 1808001, 1808002, 1901001, 1902001..1902008 > Scripts available: > 1..90, 221001, 230001..230009, 240001, 240002, 300001..300011, > 1202001..1202003, 1203002..1203005, 1301001, 1302001, 1303001..1303004, > 1304001, 1401001, 1403001, 1403002, 1501001..1501003, 1502001, 1503001, > 1503002, 1606001, 1606002, 1607001, 1610001, 1701001, 1702001, > 1704001..1704003, 1708001, 1801001..1801007, 1802001, 1802002, 1804001, > 1805001, 1807001, 1807002, 1808001, 1808002, 1901001, 1902001..1902008, > 1903001..1903003, 1909001, 1910001..1910006 > To be applied: > 1903001..1903003, 1909001, 1910001..1910006 > 2024-10-23 09:52:27,191 ERROR [main] DbSync:99 - null > org.h2.jdbc.JdbcSQLNonTransientException: General error: > "java.lang.NullPointerException: Cannot invoke > ""org.h2.index.Index.getRowCountApproximation()"" because > ""this.scanIndex"" is null"; SQL statement: > > > --------------- Fragment begins: #1903001: > 1903001_add_status_and_message_to_server_backup.sql --------------- > INSERT INTO changelog (change_number, delta_set, start_dt, applied_by, > description) VALUES (1903001, 'DDL', CURRENT_TIMESTAMP, USER(), > '1903001_add_status_and_message_to_server_backup.sql'); [50000-200] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:505) > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:429) > at org.h2.message.DbException.get(DbException.java:194) > at org.h2.message.DbException.convert(DbException.java:347) > at org.h2.command.Command.executeUpdate(Command.java:259) > at > org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:228) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) > at > com.thoughtworks.go.dbsync.DbSync.lambda$export$2(DbSync.java:86) > at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:97) > at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:80) > at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46) > Caused by: java.lang.NullPointerException: Cannot invoke > "org.h2.index.Index.getRowCountApproximation()" because "this.scanIndex" is > null > at > org.h2.pagestore.db.PageStoreTable.getRowCountApproximation(PageStoreTable.java:510) > at > org.h2.pagestore.db.PageDataIndex.getCost(PageDataIndex.java:284) > at org.h2.table.Table.getBestPlanItem(Table.java:761) > at org.h2.table.TableFilter.getBestPlanItem(TableFilter.java:251) > at org.h2.command.dml.Update.prepare(Update.java:284) > at org.h2.command.CommandList.executeRemaining(CommandList.java:46) > at org.h2.command.CommandList.update(CommandList.java:67) > at org.h2.command.CommandList.executeRemaining(CommandList.java:59) > at org.h2.command.CommandList.update(CommandList.java:67) > at org.h2.command.Command.executeUpdate(Command.java:251) > ... 8 common frames omitted > java.lang.RuntimeException: org.h2.jdbc.JdbcSQLNonTransientException: > General error: "java.lang.NullPointerException: Cannot invoke > ""org.h2.index.Index.getRowCountApproximation()"" because > ""this.scanIndex"" is null"; SQL statement: > > > --------------- Fragment begins: #1903001: > 1903001_add_status_and_message_to_server_backup.sql --------------- > INSERT INTO changelog (change_number, delta_set, start_dt, applied_by, > description) VALUES (1903001, 'DDL', CURRENT_TIMESTAMP, USER(), > '1903001_add_status_and_message_to_server_backup.sql'); [50000-200] > at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:100) > at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:80) > at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46) > Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: > "java.lang.NullPointerException: Cannot invoke > ""org.h2.index.Index.getRowCountApproximation()"" because > ""this.scanIndex"" is null"; SQL statement: > > > --------------- Fragment begins: #1903001: > 1903001_add_status_and_message_to_server_backup.sql --------------- > INSERT INTO changelog (change_number, delta_set, start_dt, applied_by, > description) VALUES (1903001, 'DDL', CURRENT_TIMESTAMP, USER(), > '1903001_add_status_and_message_to_server_backup.sql'); [50000-200] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:505) > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:429) > at org.h2.message.DbException.get(DbException.java:194) > at org.h2.message.DbException.convert(DbException.java:347) > at org.h2.command.Command.executeUpdate(Command.java:259) > at > org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:228) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) > at > com.thoughtworks.go.dbsync.DbSync.lambda$export$2(DbSync.java:86) > at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:97) > ... 2 more > Caused by: java.lang.NullPointerException: Cannot invoke > "org.h2.index.Index.getRowCountApproximation()" because "this.scanIndex" is > null > at > org.h2.pagestore.db.PageStoreTable.getRowCountApproximation(PageStoreTable.java:510) > at > org.h2.pagestore.db.PageDataIndex.getCost(PageDataIndex.java:284) > at org.h2.table.Table.getBestPlanItem(Table.java:761) > at org.h2.table.TableFilter.getBestPlanItem(TableFilter.java:251) > at org.h2.command.dml.Update.prepare(Update.java:284) > at org.h2.command.CommandList.executeRemaining(CommandList.java:46) > at org.h2.command.CommandList.update(CommandList.java:67) > at org.h2.command.CommandList.executeRemaining(CommandList.java:59) > at org.h2.command.CommandList.update(CommandList.java:67) > at org.h2.command.Command.executeUpdate(Command.java:251) > > > > -- > You received this message because you are subscribed to the Google Groups > "go-cd" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to go-cd+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/go-cd/845613bb-1405-4a3a-a0cf-dcc72215e543n%40googlegroups.com > <https://groups.google.com/d/msgid/go-cd/845613bb-1405-4a3a-a0cf-dcc72215e543n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/CAA1RwH8bqqECP0MTg3LH%3D90DGajrDGV-%2BRcjybMLDBZQxniTww%40mail.gmail.com.
