Project

General

Profile

Actions

Bug #31736

open

ERROR: index "dynflow_actions_execution_plan_uuid_id_index" does not exist

Added by Ohad Levy about 3 years ago. Updated about 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
DB migrations
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

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)
Actions #1

Updated by Ohad Levy about 3 years ago

any update on this? this makes my environment break and unable to load?

Actions

Also available in: Atom PDF