transcript_alembic_confict

 1 ==================================================================================
  2 TESTING: new db/sqlite, pre-conflict dev (current dev minus 3a29, caa7)
  3 ==================================================================================
  4 - manage_db.sh init
  5 
  6 - manage_db.sh version
  7     9540a051226e (gxy) (head)
  8     d4a650f47a3c (tsi) (head)
  9 - manage_db.sh dbversion
 10     9540a051226e (head)
 11     d4a650f47a3c (head)
 12 - run_alembic.sh history
 13     d0583094c8cd -> 9540a051226e (gxy) (head), preferred_object_store_ids
 14     c39f1de47a04 -> d0583094c8cd (gxy), add quota source labels
 15     3100452fa030 -> c39f1de47a04 (gxy), Add skipped state to collection_job_state_summary_view
 16     518c8438a91b -> 3100452fa030 (gxy), Add reason column on invocation table
 17     59e024ceaca1 -> 518c8438a91b (gxy), Add when_expression column
 18     e0e3bb173ee6 -> 59e024ceaca1 (gxy), add export association table
 19     186d4835587b -> e0e3bb173ee6 (gxy), add column deleted to API keys
 20     6a67bf27e6a6 -> 186d4835587b (gxy), drop job_state_history.update_time column
 21     b182f655505f -> 6a67bf27e6a6 (gxy), deferred data tables
 22     e7b6dcb09efd -> b182f655505f (gxy), add workflow.source_metadata column
 23     <base> -> e7b6dcb09efd (gxy), create gxy branch
 24     <base> -> d4a650f47a3c (tsi) (head), create tsi branch
 25     
 26 - move to conflict state: add 2 revisions from 23.0
 27 
 28 - manage_db.sh version
 29     caa7742f7bca (gxy) (head)
 30     9540a051226e (gxy) (head)
 31     d4a650f47a3c (tsi) (head)
 32 - run_alembic.sh history
 33     3a2914d703ca -> caa7742f7bca (gxy) (head), add index workflow_request_input_parameters__workflow_invocation_id  [THIS IS NEW]
 34     c39f1de47a04 -> 3a2914d703ca (gxy), add index workflow_request_step_states__workflow_invocation_id              [THIS IS NEW]
 35     d0583094c8cd -> 9540a051226e (gxy) (head), preferred_object_store_ids
 36     c39f1de47a04 -> d0583094c8cd (gxy), add quota source labels
 37     3100452fa030 -> c39f1de47a04 (gxy) (branchpoint), Add skipped state to collection_job_state_summary_view
 38     518c8438a91b -> 3100452fa030 (gxy), Add reason column on invocation table
 39     59e024ceaca1 -> 518c8438a91b (gxy), Add when_expression column
 40     e0e3bb173ee6 -> 59e024ceaca1 (gxy), add export association table
 41     186d4835587b -> e0e3bb173ee6 (gxy), add column deleted to API keys
 42     6a67bf27e6a6 -> 186d4835587b (gxy), drop job_state_history.update_time column
 43     b182f655505f -> 6a67bf27e6a6 (gxy), deferred data tables
 44     e7b6dcb09efd -> b182f655505f (gxy), add workflow.source_metadata column
 45     <base> -> e7b6dcb09efd (gxy), create gxy branch
 46     <base> -> d4a650f47a3c (tsi) (head), create tsi branch
 47     
 48 - manage_db.sh upgrade
 49     FAILED: Multiple head revisions are present
 50     
 51 - run_alembic.sh merge caa7 9540
 52 
 53 - manage_db.sh version
 54     198536dccff0 (gxy) (head)
 55     d4a650f47a3c (tsi) (head)
 56 - run_alembic.sh history
 57     caa7742f7bca, 9540a051226e -> 198536dccff0 (gxy) (head) (mergepoint), empty message    [THIS IS NEW]
 58     3a2914d703ca -> caa7742f7bca (gxy), add index workflow_request_input_parameters__workflow_invocation_id
 59     c39f1de47a04 -> 3a2914d703ca (gxy), add index workflow_request_step_states__workflow_invocation_id
 60     d0583094c8cd -> 9540a051226e (gxy), preferred_object_store_ids
 61     c39f1de47a04 -> d0583094c8cd (gxy), add quota source labels
 62     <base> -> d4a650f47a3c (tsi) (head), create tsi branch
 63     3100452fa030 -> c39f1de47a04 (gxy) (branchpoint), Add skipped state to collection_job_state_summary_view
 64     518c8438a91b -> 3100452fa030 (gxy), Add reason column on invocation table
 65     59e024ceaca1 -> 518c8438a91b (gxy), Add when_expression column
 66     e0e3bb173ee6 -> 59e024ceaca1 (gxy), add export association table
 67     186d4835587b -> e0e3bb173ee6 (gxy), add column deleted to API keys
 68     6a67bf27e6a6 -> 186d4835587b (gxy), drop job_state_history.update_time column
 69     b182f655505f -> 6a67bf27e6a6 (gxy), deferred data tables
 70     e7b6dcb09efd -> b182f655505f (gxy), add workflow.source_metadata column
 71     <base> -> e7b6dcb09efd (gxy), create gxy branch
 72     
 73 - manage_db.sh upgrade [FULL TRANSCRIPT]
 74     Activating virtualenv at .venv
 75     INFO:alembic.runtime.migration:Context impl SQLiteImpl.
 76     INFO:alembic.runtime.migration:Will assume non-transactional DDL.
 77     INFO:alembic.runtime.migration:Running upgrade c39f1de47a04 -> 3a2914d703ca, add index workflow_request_step_states__workflow_invocation_id
 78     INFO:galaxy.model.migrations.util:Index with name ix_workflow_request_step_states_workflow_invocation_id on workflow_request_step_states already exists. Skipping revision.
 79     DEBUG:alembic.runtime.migration:new branch insert 3a2914d703ca
 80     INFO:alembic.runtime.migration:Running upgrade 3a2914d703ca -> caa7742f7bca, add index workflow_request_input_parameters__workflow_invocation_id
 81     INFO:galaxy.model.migrations.util:Index with name ix_workflow_request_input_parameters_workflow_invocation_id on workflow_request_input_parameters already exists. Skipping revision.
 82     DEBUG:alembic.runtime.migration:update 3a2914d703ca to caa7742f7bca
 83     INFO:alembic.runtime.migration:Running upgrade caa7742f7bca, 9540a051226e -> 198536dccff0, empty message
 84     DEBUG:alembic.runtime.migration:merge, delete ['caa7742f7bca'], update 9540a051226e to 198536dccff0
 85     INFO:alembic.runtime.migration:Context impl SQLiteImpl.
 86     INFO:alembic.runtime.migration:Will assume non-transactional DDL.
 87 
 88 - manage_db.sh dbversion
 89     d4a650f47a3c (head)
 90     198536dccff0 (head) (mergepoint)
 91 
 92 - manage_db.sh downgrade 23.0
 93 
 94 - manage_db.sh dbversion
 95     9540a051226e
 96     d4a650f47a3c (head)
 97     caa7742f7bca
 98 
 99 - manage_db.sh upgrade
100 
101 - manage_db.sh dbversion
102     198536dccff0 (head) (mergepoint)
103     d4a650f47a3c (head)
104 
105 NO ERROR!