[Buildbot-commits] [Buildbot] #2158: db version 011 unintentionally drops indexes, foreign-key constraints on buildrequests

[Buildbot]

#2158: db version 011 unintentionally drops indexes, foreign-key constraints on
buildrequests
---------------------+--------------------
Reporter:  dustin    |       Owner:
    Type:  defect    |      Status:  new
Priority:  major     |   Milestone:  0.8.6
 Version:  0.8.5     |  Resolution:
Keywords:  database  |
---------------------+--------------------

Comment (by dustin):

 Ugh, sqlalchemy-migrate strikes again :(

 Logging this upgrade on sqlite shows:
 {{{
 2011-11-27 18:48:36-0600 [-] ALTER TABLE buildrequests RENAME TO
 migration_tmp
 2011-11-27 18:48:36-0600 [-] ()
 2011-11-27 18:48:36-0600 [-] COMMIT
 2011-11-27 18:48:36-0600 [-]⋅
 ▷⋅⋅⋅CREATE TABLE buildrequests (
 ▷⋅⋅⋅▷⋅⋅⋅id INTEGER NOT NULL,⋅
 ▷⋅⋅⋅▷⋅⋅⋅buildsetid INTEGER NOT NULL,⋅
 ▷⋅⋅⋅▷⋅⋅⋅buildername VARCHAR(256) NOT NULL,⋅
 ▷⋅⋅⋅▷⋅⋅⋅priority INTEGER DEFAULT '0' NOT NULL,⋅
 ▷⋅⋅⋅▷⋅⋅⋅claimed_by_incarnation VARCHAR(256),⋅
 ▷⋅⋅⋅▷⋅⋅⋅complete INTEGER DEFAULT '0',⋅
 ▷⋅⋅⋅▷⋅⋅⋅results SMALLINT,⋅
 ▷⋅⋅⋅▷⋅⋅⋅submitted_at INTEGER NOT NULL,⋅
 ▷⋅⋅⋅▷⋅⋅⋅complete_at INTEGER,⋅
 ▷⋅⋅⋅▷⋅⋅⋅PRIMARY KEY (id)
 ▷⋅⋅⋅)
 ▷⋅⋅⋅
 ▷⋅⋅⋅
 2011-11-27 18:48:36-0600 [-] ()
 2011-11-27 18:48:36-0600 [-] COMMIT
 2011-11-27 18:48:36-0600 [-] INSERT INTO buildrequests SELECT id
 ,buildsetid ,buildername ,priority ,claimed_by_incarnation ,complete
 ,results ,submitted_at ,complete_at from migration_tmp
 2011-11-27 18:48:36-0600 [-] ()
 2011-11-27 18:48:36-0600 [-] COMMIT
 2011-11-27 18:48:36-0600 [-] DROP TABLE migration_tmp
 2011-11-27 18:48:36-0600 [-] ()
 2011-11-27 18:48:36-0600 [-] COMMIT
 }}}

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2158#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation