Looker Jar version : 21.30.x
OS : AWS Linux 2
Java: 1.8.x
We are trying to migrate the internal Hypersql DB to Mysql, Please find the migration logs below:
[gclooker@ip-xxx-xx-xx-xxx looker]$ java -Xms26000m -Xmx26000m -jar looker.jar migrate_internal_data looker-db.yml
Source database connection successful
Destination database connection successful
Tables created
Begin copying data
Begin copying records for table: access_token
Copied 0 for access_token in 0.00460505485534668 sec
Begin copying records for table: action_hub_secret_user_state
Copied 0 for action_hub_secret_user_state in 0.001283884048461914 sec
Begin copying records for table: action_hub_state_authentication
Copied 0 for action_hub_state_authentication in 0.005942821502685547 sec
Begin copying records for table: active_data_maintenance_task
Copied 0 for active_data_maintenance_task in 0.008505105972290039 sec
Begin copying records for table: active_derived_table
Copied 1 for active_derived_table in 0.01741194725036621 sec
Sequel::DatabaseError: Java::JavaSql::SQLSyntaxErrorException: (conn=46678) Table 'looker_alpha.active_pdt_materialize_task' doesn't exist
raise_error at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/misc.rb:421
statement at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/adapters/jdbc.rb:701
statement at uri:classloader:/helltool-component-build/lib/helltool/core_ext/sequel/jdbc.class:37
execute at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/adapters/jdbc.rb:261
hold at uri:classloader:/helltool-component-build/lib/helltool/db/pool.class:39
synchronize at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/connecting.rb:306
execute at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/adapters/jdbc.rb:260
execute_ddl at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/adapters/jdbc.rb:288
execute_ddl at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/dataset/actions.rb:1140
truncate at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/dataset/actions.rb:899
migrate at uri:classloader:/helltool-component-build/lib/helltool/utils/cross_db_migration.class:119
each at org/jruby/RubyArray.java:1809
migrate at uri:classloader:/helltool-component-build/lib/helltool/utils/cross_db_migration.class:113
_transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:224
transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:199
hold at uri:classloader:/helltool-component-build/lib/helltool/db/pool.class:55
synchronize at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/connecting.rb:306
transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:165
migrate at uri:classloader:/helltool-component-build/lib/helltool/utils/cross_db_migration.class:112
_transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:224
transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:199
hold at uri:classloader:/helltool-component-build/lib/helltool/db/pool.class:55
synchronize at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/connecting.rb:306
transaction at uri:classloader:/bundler/gems/sequel-084253ffa73d/lib/sequel/database/transactions.rb:165
migrate at uri:classloader:/helltool-component-build/lib/helltool/utils/cross_db_migration.class:111
migrate_internal_data at uri:classloader:/helltool-component-build/lib/helltool/cli.class:175
run at uri:classloader:/gems/thor-0.15.4/lib/thor/task.rb:27
invoke_task at uri:classloader:/gems/thor-0.15.4/lib/thor/invocation.rb:120
dispatch at uri:classloader:/gems/thor-0.15.4/lib/thor.rb:275
start at uri:classloader:/gems/thor-0.15.4/lib/thor/base.rb:425
<main> at uri:classloader:/helltool-component-build/bin/helltool:41
load at org/jruby/RubyKernel.java:1009
<main> at uri:classloader:/META-INF/main.rb:1
require at org/jruby/RubyKernel.java:974
require at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:54
<main> at <script>:3
ERROR: org.jruby.embed.EvalFailedException: (DatabaseError) Java::JavaSql::SQLSyntaxErrorException: (conn=46678) Table 'looker_alpha.active_pdt_materialize_task' doesn't exist