https://redmine.tokyo/
https://redmine.tokyo/welcome/index/themes/redmine_tokyo_theme/favicon/favicon.ico?1665553863
2018-03-26T01:14:17Z
redmine.tokyo
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5089
2018-03-26T01:14:17Z
Tamura Shinji
<ul></ul><p>traceオプションを付けた結果は以下になります。</p>
<pre>
** Invoke db:data:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:data:load
rake aborted!
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
: DELETE FROM "projects"
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:71:in `rescue in truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:67:in `truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:78:in `load_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:64:in `block (2 levels) in load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `block in load_documents'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `each'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:61:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:63:in `block in load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:62:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:37:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/rake_tasks.rb:13:in `data_load_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/tasks/yaml_db_tasks.rake:21:in `block (3 levels) in <top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:213:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:193:in `invoke_with_call_chain'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:182:in `invoke'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:160:in `invoke_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:125:in `run_with_threads'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:110:in `top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:83:in `block in run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:186:in `standard_exception_handling'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:80:in `run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `kernel_load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:424:in `exec'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Caused by:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:71:in `rescue in truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:67:in `truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:78:in `load_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:64:in `block (2 levels) in load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `block in load_documents'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `each'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:61:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:63:in `block in load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:62:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:37:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/rake_tasks.rb:13:in `data_load_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/tasks/yaml_db_tasks.rake:21:in `block (3 levels) in <top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:213:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:193:in `invoke_with_call_chain'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:182:in `invoke'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:160:in `invoke_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:125:in `run_with_threads'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:110:in `top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:83:in `block in run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:186:in `standard_exception_handling'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:80:in `run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `kernel_load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:424:in `exec'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Caused by:
ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: cannot truncate a table referenced in a foreign key constraint
DETAIL: Table "easy_settings" references "projects".
HINT: Truncate table "easy_settings" at the same time, or use TRUNCATE ... CASCADE.
: TRUNCATE "projects"
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:69:in `truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:78:in `load_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:64:in `block (2 levels) in load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `block in load_documents'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `each'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:61:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:63:in `block in load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:62:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:37:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/rake_tasks.rb:13:in `data_load_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/tasks/yaml_db_tasks.rake:21:in `block (3 levels) in <top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:213:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:193:in `invoke_with_call_chain'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:182:in `invoke'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:160:in `invoke_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:125:in `run_with_threads'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:110:in `top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:83:in `block in run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:186:in `standard_exception_handling'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:80:in `run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `kernel_load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:424:in `exec'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Caused by:
PG::FeatureNotSupported: ERROR: cannot truncate a table referenced in a foreign key constraint
DETAIL: Table "easy_settings" references "projects".
HINT: Truncate table "easy_settings" at the same time, or use TRUNCATE ... CASCADE.
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:69:in `truncate_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:78:in `load_table'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:64:in `block (2 levels) in load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:62:in `block in load_documents'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `each'
/usr/local/lib/ruby/2.4.0/psych/deprecated.rb:32:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db.rb:61:in `load_documents'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:63:in `block in load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:62:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/serialization_helper.rb:37:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/yaml_db/rake_tasks.rb:13:in `data_load_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/yaml_db-0.6.0/lib/tasks/yaml_db_tasks.rake:21:in `block (3 levels) in <top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `block in execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:271:in `execute'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:213:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:193:in `invoke_with_call_chain'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/task.rb:182:in `invoke'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:160:in `invoke_task'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `each'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:116:in `block in top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:125:in `run_with_threads'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:110:in `top_level'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:83:in `block in run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:186:in `standard_exception_handling'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/lib/rake/application.rb:80:in `run'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `load'
/var/www/redmine/site/rtest/vendor/bundle/ruby/2.4.0/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:75:in `kernel_load'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:424:in `exec'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Tasks: TOP => db:data:load
</pre>
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5090
2018-03-26T04:38:07Z
Tamura Shinji
<ul></ul><p>ちなみに、mariadb -> mariadb はちゃんと動いてくれています。</p>
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5092
2018-03-26T12:42:14Z
奈良 裕記
<ul></ul><p>Pluginの無いplainな環境でも再現しますか?</p>
<p>後半のエラーはeasyredmine関連ですね。</p>
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5094
2018-03-27T03:06:33Z
Tamura Shinji
<ul></ul><p>まだ、plainな状態では試せてないんです。<br />データ減らしながら試してみようかと思っています。</p>
<p>とはいえ、mariadb -> mariadb がうまくいっているのでpostgres側の何かあるのかなぁと。。。。</p>
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5217
2018-04-24T14:39:16Z
奈良 裕記
<ul></ul><p>tapsでMySQLからPostgreSQLに移行した後に起きたトラブル事例<br /><a class="external" href="https://blog.n-z.jp/blog/2014-01-12-taps-trouble.html">https://blog.n-z.jp/blog/2014-01-12-taps-trouble.html</a></p>
<p>mysql->postgresql DBのdefaultの違いも随分とあるんですね。</p>
<p>>別途クリーンな環境を用意して生成した db/schema.rb と比較するなどのチェックも必要でした。</p>
Unofficial Redmine Cooking - QA #782: yaml_dbを使ったDBのマイグレーションで失敗する
https://redmine.tokyo/issues/782?journal_id=5224
2018-04-24T23:45:06Z
Tamura Shinji
<ul></ul><p>あぅ。。。メインの仕事が忙しくて手が付けられてないです。。。</p>
<p>migrateするファイルを見る限りは違いはないんですが、一度入れてしまってからだとデフォルトの違いはあるようですねぇ。。。</p>