[Buildbot] #3302: [nine] Changes not populating correctly

Buildbot trac trac at buildbot.net
Sun Jul 12 10:08:23 UTC 2015


#3302: [nine] Changes not populating correctly
---------------------------------+----------------------
Reporter:  joeholley             |       Owner:
    Type:  defect                |      Status:  new
Priority:  major                 |   Milestone:  0.9.0b1
 Version:  master                |  Resolution:
Keywords:  changes, changelists  |
---------------------------------+----------------------

Comment (by tardyp):

 I can reproduce the problem.

 Here is the dump of the db.

 Interestingly, there are only 2 sourcestamps.
 {{{

 sqlite3 state.sqlite .dump |grep -i insert |grep -v logchu |grep -v ptardy
 INSERT INTO "buildsets" VALUES(1,NULL,'The SingleBranchScheduler scheduler
 named ''job1 scheduler'' triggered this
 build',1436694539,1,1436694541,0,NULL,NULL);
 INSERT INTO "buildsets" VALUES(2,NULL,'The SingleBranchScheduler scheduler
 named ''broken scheduler'' triggered this
 build',1436694540,1,1436694540,0,NULL,NULL);
 INSERT INTO "buildsets" VALUES(3,NULL,'The SingleBranchScheduler scheduler
 named ''broken scheduler'' triggered this
 build',1436694541,1,1436694541,0,NULL,NULL);
 INSERT INTO "buildsets" VALUES(4,NULL,'The SingleBranchScheduler scheduler
 named ''job2 scheduler'' triggered this
 build',1436694541,1,1436694547,0,NULL,NULL);
 INSERT INTO "objects" VALUES(1,'broken
 scheduler','buildbot.schedulers.basic.SingleBranchScheduler');
 INSERT INTO "objects" VALUES(2,'job1
 scheduler','buildbot.schedulers.basic.SingleBranchScheduler');
 INSERT INTO "objects" VALUES(3,'job2
 scheduler','buildbot.schedulers.basic.SingleBranchScheduler');
 INSERT INTO "builders"
 VALUES(1,'broken',NULL,'0b8a1caec23d75d1154b8d9bef9cec6c03697638');
 INSERT INTO "builders"
 VALUES(2,'job2',NULL,'6362af2cb6ba28bb5a8769ac6d3992d8ae83f36d');
 INSERT INTO "builders"
 VALUES(3,'job1',NULL,'803e16c8f2d5e702463cb1fa5270a534eebc8e47');
 INSERT INTO "buildslaves" VALUES(1,'slave','{"admin": null, "host": null,
 "version": "0.9.0b1-35-gdd9e199", "access_uri": null}');
 INSERT INTO "changesources"
 VALUES(1,'PBChangeSource:None','50dc25ec34aca4aa2dda681c938f2f3d900641c8');
 INSERT INTO "schedulers" VALUES(1,'broken
 scheduler','b4e06d038f372c68bd9d2ccfc54609a3cd971424');
 INSERT INTO "schedulers" VALUES(2,'job1
 scheduler','ca5bd471fc208c6502ab00ad5daeb16e2b373066');
 INSERT INTO "schedulers" VALUES(3,'job2
 scheduler','ef5e09203a5794bdb77845499caebb5403ee6bff');
 INSERT INTO "sourcestamps"
 VALUES(1,'fffd6c7d63d32dd40d3fe7520b269fb27946cc50','main','48849',NULL,'test','','',1.43669453908565497397e+09);
 INSERT INTO "sourcestamps"
 VALUES(2,'ee49f9cd6dce86b0d89ad01e4791ef49f919c0ab','main','3',NULL,'test','','',1.43669454009563589101e+09);
 INSERT INTO "changesource_masters" VALUES(1,1);
 INSERT INTO "builder_masters" VALUES(1,1,1);
 INSERT INTO "builder_masters" VALUES(2,2,1);
 INSERT INTO "builder_masters" VALUES(3,3,1);
 INSERT INTO "connected_buildslaves" VALUES(1,1,1);
 INSERT INTO "buildset_properties" VALUES(1,'scheduler','["job1 scheduler",
 "Scheduler"]');
 INSERT INTO "buildset_properties" VALUES(2,'scheduler','["broken
 scheduler", "Scheduler"]');
 INSERT INTO "buildset_properties" VALUES(3,'scheduler','["broken
 scheduler", "Scheduler"]');
 INSERT INTO "buildset_properties" VALUES(4,'scheduler','["job2 scheduler",
 "Scheduler"]');
 INSERT INTO "buildrequests" VALUES(1,1,3,0,1,0,1436694539,1436694541,0);
 INSERT INTO "buildrequests" VALUES(2,2,1,0,1,0,1436694540,1436694540,0);
 INSERT INTO "buildrequests" VALUES(3,3,1,0,1,0,1436694541,1436694541,0);
 INSERT INTO "buildrequests" VALUES(4,4,2,0,1,0,1436694541,1436694547,0);
 INSERT INTO "changes"
 VALUES(1,'user','','main','48849','',1436694539,'cat1','test','','',1,NULL);
 INSERT INTO "changes"
 VALUES(2,'user','','main','3','',1436694540,'broken','test','','',2,1);
 INSERT INTO "changes"
 VALUES(3,'user','','main','3','',1436694541,'broken','test','','',2,2);
 INSERT INTO "changes"
 VALUES(4,'user','','main','48849','',1436694541,'cat2','test','','',1,3);
 INSERT INTO "builds"
 VALUES(1,1,3,1,1,1,1436694539.16285,1.43669454137539505953e+09,'finished',0);
 INSERT INTO "builds"
 VALUES(2,1,1,2,1,1,1.43669454020036888117e+09,1.43669454043189692496e+09,'finished',0);
 INSERT INTO "builds"
 VALUES(3,2,1,3,1,1,1.43669454119141292575e+09,1.43669454148307895657e+09,'finished',0);
 INSERT INTO "builds"
 VALUES(4,1,2,4,1,1,1436694542.04719,1.4366945473732960224e+09,'finished',0);
 INSERT INTO "configured_buildslaves" VALUES(1,1,1);
 INSERT INTO "configured_buildslaves" VALUES(2,2,1);
 INSERT INTO "configured_buildslaves" VALUES(3,3,1);
 INSERT INTO "buildrequest_claims" VALUES(1,1,1436694539);
 INSERT INTO "buildrequest_claims" VALUES(2,1,1436694540);
 INSERT INTO "buildrequest_claims" VALUES(3,1,1436694541);
 INSERT INTO "buildrequest_claims" VALUES(4,1,1436694542);
 INSERT INTO "buildset_sourcestamps" VALUES(1,1,1);
 INSERT INTO "buildset_sourcestamps" VALUES(2,2,2);
 INSERT INTO "buildset_sourcestamps" VALUES(3,3,2);
 INSERT INTO "buildset_sourcestamps" VALUES(4,4,1);
 INSERT INTO "build_properties"
 VALUES(1,'MASTER_PORT_9989_TCP_ADDR','"localhost"','SlaveEnvironment');
 INSERT INTO "build_properties"
 VALUES(1,'MASTER_PORT_9989_TCP_PORT','"19989"','SlaveEnvironment');
 INSERT INTO "build_properties" VALUES(1,'branch','"main"','Build');
 INSERT INTO "build_properties" VALUES(1,'buildername','"job1"','Builder');
 INSERT INTO "build_properties" VALUES(1,'buildnumber','1','Build');
 INSERT INTO "build_properties" VALUES(1,'codebase','""','Build');
 INSERT INTO "build_properties" VALUES(1,'project','""','Build');
 INSERT INTO "build_properties" VALUES(1,'repository','"test"','Build');
 INSERT INTO "build_properties" VALUES(1,'revision','"48849"','Build');
 INSERT INTO "build_properties" VALUES(1,'scheduler','"job1
 scheduler"','Scheduler');
 INSERT INTO "build_properties"
 VALUES(1,'slavename','"slave"','BuildSlave');
 INSERT INTO "build_properties" VALUES(2,'branch','"main"','Build');
 INSERT INTO "build_properties"
 VALUES(2,'buildername','"broken"','Builder');
 INSERT INTO "build_properties" VALUES(2,'buildnumber','1','Build');
 INSERT INTO "build_properties" VALUES(2,'codebase','""','Build');
 INSERT INTO "build_properties" VALUES(2,'myproperty','"foo"','Change');
 INSERT INTO "build_properties" VALUES(2,'project','""','Build');
 INSERT INTO "build_properties" VALUES(2,'repository','"test"','Build');
 INSERT INTO "build_properties" VALUES(2,'revision','"3"','Build');
 INSERT INTO "build_properties" VALUES(2,'scheduler','"broken
 scheduler"','Scheduler');
 INSERT INTO "build_properties"
 VALUES(2,'slavename','"slave"','BuildSlave');
 INSERT INTO "build_properties" VALUES(3,'branch','"main"','Build');
 INSERT INTO "build_properties"
 VALUES(3,'buildername','"broken"','Builder');
 INSERT INTO "build_properties" VALUES(3,'buildnumber','2','Build');
 INSERT INTO "build_properties" VALUES(3,'codebase','""','Build');
 INSERT INTO "build_properties" VALUES(3,'myproperty','"foo"','Change');
 INSERT INTO "build_properties" VALUES(3,'project','""','Build');
 INSERT INTO "build_properties" VALUES(3,'repository','"test"','Build');
 INSERT INTO "build_properties" VALUES(3,'revision','"3"','Build');
 INSERT INTO "build_properties" VALUES(3,'scheduler','"broken
 scheduler"','Scheduler');
 INSERT INTO "build_properties"
 VALUES(3,'slavename','"slave"','BuildSlave');
 INSERT INTO "build_properties"
 VALUES(4,'MASTER_PORT_9989_TCP_ADDR','"localhost"','SlaveEnvironment');
 INSERT INTO "build_properties"
 VALUES(4,'MASTER_PORT_9989_TCP_PORT','"19989"','SlaveEnvironment');
 INSERT INTO "build_properties" VALUES(4,'branch','"main"','Build');
 INSERT INTO "build_properties" VALUES(4,'buildername','"job2"','Builder');
 INSERT INTO "build_properties" VALUES(4,'buildnumber','1','Build');
 INSERT INTO "build_properties" VALUES(4,'codebase','""','Build');
 INSERT INTO "build_properties" VALUES(4,'project','""','Build');
 INSERT INTO "build_properties" VALUES(4,'repository','"test"','Build');
 INSERT INTO "build_properties" VALUES(4,'revision','"48849"','Build');
 INSERT INTO "build_properties" VALUES(4,'scheduler','"job2
 scheduler"','Scheduler');
 INSERT INTO "build_properties"
 VALUES(4,'slavename','"slave"','BuildSlave');
 INSERT INTO "change_properties" VALUES(2,'myproperty','["foo",
 "Change"]');
 INSERT INTO "change_properties" VALUES(3,'myproperty','["bar",
 "Change"]');
 INSERT INTO "steps"
 VALUES(1,0,'SetPropertiesFromEnv',1,1.43669453918509197228e+09,1.43669453923100090024e+09,'Set',0,'[]',0);
 INSERT INTO "steps"
 VALUES(2,1,'shell',1,1.43669453928981208801e+09,1.43669453935477399821e+09,'''/bin/echo
 "{u''MASTER_PORT_9989_TCP_ADDR'': ...''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(3,2,'shell_1',1,1.43669453939670610422e+09,1.43669454021646308895e+09,'''buildbot
 sendchange ...''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(4,0,'shell',2,1.43669454024388599392e+09,1436694540.30937,'''/bin/echo
 "{u''branch'': ...''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(5,3,'shell_2',1,1.43669454031876301768e+09,1.43669454119284200665e+09,'''buildbot
 sendchange ...''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(6,0,'shell',3,1.43669454125417399401e+09,1.43669454134607100484e+09,'''/bin/echo
 "{u''branch'': ...''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(7,0,'SetPropertiesFromEnv',4,1.43669454206995391839e+09,1.43669454211288094517e+09,'Set',0,'[]',0);
 INSERT INTO "steps"
 VALUES(8,1,'shell',4,1.43669454220234489444e+09,1.43669454725236701961e+09,'''sleep
 5''',0,'[]',0);
 INSERT INTO "steps"
 VALUES(9,2,'shell_1',4,1.43669454728515100477e+09,1.43669454733373689646e+09,'''/bin/echo
 "{u''MASTER_PORT_9989_TCP_ADDR'': ...''',0,'[]',0);
 INSERT INTO "logs" VALUES(1,'properties','properties',1,1,2,'t');
 INSERT INTO "logs" VALUES(2,'stdio','stdio',2,1,44,'s');
 INSERT INTO "logs" VALUES(3,'stdio','stdio',3,1,43,'s');
 INSERT INTO "logs" VALUES(4,'stdio','stdio',4,1,41,'s');
 INSERT INTO "logs" VALUES(5,'stdio','stdio',5,1,43,'s');
 INSERT INTO "logs" VALUES(6,'stdio','stdio',6,1,41,'s');
 INSERT INTO "logs" VALUES(7,'properties','properties',7,1,2,'t');
 INSERT INTO "logs" VALUES(8,'stdio','stdio',8,1,42,'s');
 INSERT INTO "logs" VALUES(9,'stdio','stdio',9,1,44,'s');
 }}}

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


More information about the bugs mailing list