#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
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
