Question

Looker migrate_internal_data to Mysql 5.7 is failing with table 'active_pdt_materialize_task' doesn't exist

  • 16 June 2022
  • 0 replies
  • 12 views

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
 

 


0 replies

Be the first to reply!

Reply