Actions
Bug #31736
open
ERROR: index "dynflow_actions_execution_plan_uuid_id_index" does not exist
Status:
New
Priority:
Normal
Assignee:
-
Category:
DB migrations
Target version:
-
Description
When trying to spin up a new foreman instance the following error was visible during rake db:migrate
rake aborted! Sequel::DatabaseError: PG::UndefinedObject: ERROR: index "dynflow_actions_execution_plan_uuid_id_index" does not exist /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `exec' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `block in execute_query' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/logging.rb:43:in `log_connection_yield' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `execute_query' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:144:in `block in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:120:in `check_disconnect_errors' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:144:in `execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:500:in `_execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `block (2 levels) in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:522:in `check_database_errors' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `block in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/connection_pool/threaded.rb:88:in `hold' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/connecting.rb:269:in `synchronize' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/query.rb:50:in `execute_dui' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/query.rb:43:in `execute_ddl' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `block in apply_alter_table' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `each' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `apply_alter_table' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:433:in `apply_alter_table_generator' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:70:in `alter_table' /home/foreman/vendor/ruby/2.7.0/gems/dynflow-1.4.7/lib/dynflow/persistence_adapters/sequel_migrations/020_drop_duplicate_indices.rb:4:in `block (2 levels) in <top (required)>' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:110:in `instance_exec' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:110:in `apply' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:563:in `block (2 levels) in run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:258:in `_transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:233:in `block in transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/connection_pool/threaded.rb:92:in `hold' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/connecting.rb:269:in `synchronize' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:195:in `transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:479:in `checked_transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:562:in `block in run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:559:in `each' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:559:in `run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:406:in `run' /home/foreman/vendor/ruby/2.7.0/gems/dynflow-1.4.7/lib/dynflow/persistence_adapters/sequel.rb:254:in `migrate_db' /home/foreman/lib/tasks/dynflow.rake:23:in `block (2 levels) in <top (required)>' /home/foreman/lib/tasks/dynflow.rake:42:in `block (2 levels) in <top (required)>' /home/foreman/vendor/ruby/2.7.0/gems/rake-13.0.3/exe/rake:27:in `<top (required)>' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `load' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `kernel_load' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:28:in `run' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:476:in `exec' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor.rb:399:in `dispatch' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:30:in `dispatch' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/base.rb:476:in `start' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:24:in `start' /usr/share/gems/gems/bundler-2.1.4/libexec/bundle:46:in `block in <top (required)>' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/friendly_errors.rb:123:in `with_friendly_errors' /usr/share/gems/gems/bundler-2.1.4/libexec/bundle:34:in `<top (required)>' //bin/bundle:23:in `load' //bin/bundle:23:in `<main>' Caused by: PG::UndefinedObject: ERROR: index "dynflow_actions_execution_plan_uuid_id_index" does not exist /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `exec' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `block in execute_query' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/logging.rb:43:in `log_connection_yield' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:156:in `execute_query' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:144:in `block in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:120:in `check_disconnect_errors' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:144:in `execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:500:in `_execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `block (2 levels) in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:522:in `check_database_errors' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `block in execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/connection_pool/threaded.rb:88:in `hold' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/connecting.rb:269:in `synchronize' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/adapters/postgres.rb:318:in `execute' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/query.rb:50:in `execute_dui' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/query.rb:43:in `execute_ddl' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `block in apply_alter_table' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `each' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:420:in `apply_alter_table' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:433:in `apply_alter_table_generator' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/schema_methods.rb:70:in `alter_table' /home/foreman/vendor/ruby/2.7.0/gems/dynflow-1.4.7/lib/dynflow/persistence_adapters/sequel_migrations/020_drop_duplicate_indices.rb:4:in `block (2 levels) in <top (required)>' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:110:in `instance_exec' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:110:in `apply' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:563:in `block (2 levels) in run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:258:in `_transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:233:in `block in transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/connection_pool/threaded.rb:92:in `hold' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/connecting.rb:269:in `synchronize' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/database/transactions.rb:195:in `transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:479:in `checked_transaction' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:562:in `block in run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:559:in `each' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:559:in `run' /home/foreman/vendor/ruby/2.7.0/gems/sequel-5.40.0/lib/sequel/extensions/migration.rb:406:in `run' /home/foreman/vendor/ruby/2.7.0/gems/dynflow-1.4.7/lib/dynflow/persistence_adapters/sequel.rb:254:in `migrate_db' /home/foreman/lib/tasks/dynflow.rake:23:in `block (2 levels) in <top (required)>' /home/foreman/lib/tasks/dynflow.rake:42:in `block (2 levels) in <top (required)>' /home/foreman/vendor/ruby/2.7.0/gems/rake-13.0.3/exe/rake:27:in `<top (required)>' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `load' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `kernel_load' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:28:in `run' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:476:in `exec' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor.rb:399:in `dispatch' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:30:in `dispatch' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/base.rb:476:in `start' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/cli.rb:24:in `start' /usr/share/gems/gems/bundler-2.1.4/libexec/bundle:46:in `block in <top (required)>' /usr/share/gems/gems/bundler-2.1.4/lib/bundler/friendly_errors.rb:123:in `with_friendly_errors' /usr/share/gems/gems/bundler-2.1.4/libexec/bundle:34:in `<top (required)>' //bin/bundle:23:in `load' //bin/bundle:23:in `<main>' Tasks: TOP => dynflow:migrate (See full trace by running task with --trace)
Updated by Ohad Levy over 3 years ago
any update on this? this makes my environment break and unable to load?
Actions