Skip to content

Instantly share code, notes, and snippets.

@yarmand
Created September 14, 2012 11:00
Show Gist options
  • Save yarmand/3721309 to your computer and use it in GitHub Desktop.
Save yarmand/3721309 to your computer and use it in GitHub Desktop.
2012-09-14 migration error
rake db:migrate
(in /opt/workfeed)
== PreMigrateTask: started.
-- /opt/workfeed/db/pre_migrate/000_pg_log_type.sql
NOTICE: drop cascades to 13 other objects
DETAIL: drop cascades to function "pg_log$get_log_data"(timestamp without time zone,timestamp without time zone,text,boolean)
drop cascades to view all_queries_td
drop cascades to view all_queries_wk
drop cascades to view all_queries_mn
drop cascades to view ddl_queries_td
drop cascades to view ddl_queries_wk
drop cascades to view ddl_queries_mn
drop cascades to view dml_queries_td
drop cascades to view dml_queries_wk
drop cascades to view dml_queries_mn
drop cascades to view log_errors_td
drop cascades to view log_errors_wk
drop cascades to view log_errors_mn
-- /opt/workfeed/db/pre_migrate/100_db_util.sql
-- /opt/workfeed/db/pre_migrate/200_misc_util.sql
-- /opt/workfeed/db/pre_migrate/300_pg_log_util.sql
-- /opt/workfeed/db/pre_migrate/400_ut.sql
-- /opt/workfeed/db/pre_migrate/500_views.sql
-- /opt/workfeed/db/pre_migrate/600_ddl_views.sql
-- /opt/workfeed/db/pre_migrate/700_dml_views.sql
-- /opt/workfeed/db/pre_migrate/800_error_log_views.sql
-- /opt/workfeed/db/pre_migrate/900_monitor_views.sql
NOTICE: drop cascades to view mn_unused_public_indexes
NOTICE: view "mn_unused_public_indexes" does not exist, skipping
NOTICE: drop cascades to view mn_waiting_locks
NOTICE: view "mn_waiting_locks" does not exist, skipping
== PreMigrateTask: done (0.0697s).
== DevOnlySetupFailoverTables: migrating =====================================
RUNNING: echo 'create database yam_shards' | psql -w -U postgres -h localhost
ERROR: database "yam_shards" already exists
NOTICE: relation "network_shards_groups" already exists, skipping
NOTICE: relation "network_shards_info" already exists, skipping
NOTICE: relation "network_shards_map" already exists, skipping
NOTICE: relation "vertical_shards_info" already exists, skipping
NOTICE: relation "legacy_shards_info" already exists, skipping
rake aborted!
An error has occurred, this and all later migrations canceled:
Sharding::DifferentTransactionOpenError
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment