<HTML dir=ltr><HEAD></HEAD>
<BODY>
<DIV id=idOWAReplyText42018 dir=ltr>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2>Sure, here is the contents of my build.log file:</FONT></DIV>
<DIV dir=ltr><FONT face=Tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2></FONT> </DIV>
<DIV dir=ltr> -> 0.0038s<BR>== CreateProjects: migrated (0.0039s) =========================================</DIV>
<DIV dir=ltr>== CreateObjectives: migrating ================================================<BR>-- create_table(:objectives)<BR> -> 0.0052s<BR>-- execute("alter table objectives add constraint fk_objectives_projects foreign key (project_id) references projects(id)")<BR> -> 0.0057s<BR>== CreateObjectives: migrated (0.0109s) =======================================</DIV>
<DIV dir=ltr>== CreateMeasurements: migrating ==============================================<BR>-- create_table(:measurements)<BR> -> 0.0018s<BR>-- execute("alter table measurements add constraint fk_measurements_objectives foreign key (objective_id) references objectives(id)")<BR> -> 0.0037s<BR>== CreateMeasurements: migrated (0.0057s) =====================================</DIV>
<DIV dir=ltr>== CreateBenchmarks: migrating ================================================<BR>-- create_table(:benchmarks)<BR> -> 0.0019s<BR>-- execute("alter table benchmarks add constraint fk_benchmarks_measurements foreign key (measurement_id) references measurements(id)")<BR> -> 0.0038s<BR>== CreateBenchmarks: migrated (0.0058s) =======================================</DIV>
<DIV dir=ltr>== CreateMetrics: migrating ===================================================<BR>-- create_table(:metrics)<BR> -> 0.0029s<BR>-- execute("alter table metrics add constraint fk_metrics_measurements foreign key (measurement_id) references measurements(id)")<BR> -> 0.0035s<BR>== CreateMetrics: migrated (0.0065s) ==========================================</DIV>
<DIV dir=ltr>== AddSessions: migrating =====================================================<BR>-- create_table(:sessions)<BR> -> 0.0024s<BR>-- add_index(:sessions, :session_id)<BR> -> 0.0031s<BR>-- add_index(:sessions, :updated_at)<BR> -> 0.0079s<BR>== AddSessions: migrated (0.0136s) ============================================</DIV>
<DIV dir=ltr>** Invoke db:schema:dump (first_time)<BR>** Invoke environment<BR>** Execute db:schema:dump<BR>[CruiseControl] Invoking Rake task "test"<BR>** Invoke test (first_time)<BR>** Execute test<BR>** Invoke test:units (first_time)<BR>** Invoke db:test:prepare (first_time)<BR>** Invoke environment<BR>** Execute db:test:prepare<BR>** Invoke db:test:clone (first_time)<BR>** Invoke db:schema:dump<BR>** Invoke db:test:purge<BR>** Execute db:test:clone<BR>** Invoke db:schema:load (first_time)<BR>** Invoke environment<BR>** Execute db:schema:load<BR>** Invoke test:functionals (first_time)<BR>** Invoke db:test:prepare<BR>** Execute test:functionals<BR>Loaded suite /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader<BR>Started<BR>........<BR>Finished in 0.056911 seconds.</DIV>
<DIV dir=ltr>8 tests, 20 assertions, 0 failures, 0 errors<BR>/usr/local/bin/ruby -Ilib:test "/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb"<BR>** Invoke test:integration (first_time)<BR>** Invoke db:test:prepare<BR>** Execute test:integration<BR>Mysql::Error: #42S01Table 'measurements' already exists: CREATE TABLE measurements (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `qualifier` varchar(255) DEFAULT NULL, `objective_id` int(11) DEFAULT NULL) ENGINE=InnoDB<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in `create_table'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:353:in `create_table'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in `send'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in `method_missing'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:259:in `say_with_time'<BR>/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:259:in `say_with_time'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in `method_missing'<BR>./db/schema.rb:16<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/schema.rb:43:in `instance_eval'<BR>/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/schema.rb:43:in `define'<BR>./db/schema.rb:5<BR>/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in `load'<BR>/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in `load'<BR>/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:342:in `new_constants_in'<BR>/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in `load'<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:31<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:76<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:153<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:369:in `invoke_prerequisites'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in `send'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in `each'<BR>/usr/local/lib/ruby/gems/1.rake aborted!<BR>Test failures<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/testing.rake:53<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake:5:in `invoke_rake_task'<BR>/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake:59<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run'<BR>-e:1<BR>8/gems/rake-0.7.3/lib/rake.rb:368:in `invoke_prerequisites'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:361:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/testing.rake:45<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/testing.rake:43:in `collect'<BR>/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/testing.rake:43<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake:5:in `invoke_rake_task'<BR>/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake:59<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling'<BR>/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run'<BR>-e:1</DIV>
<DIV dir=ltr>dir : /usr/lib/cruisecontrolrb-1.1.0/projects/goalkeeper/work<BR>command : ruby -e "require 'rubygems' rescue nil; require 'rake'; load '/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake'; ARGV << '--nosearch' << '--trace' << 'cc:build'; Rake.application.run"<BR>executed command : echo /usr/lib/cruisecontrolrb-1.1.0/projects/goalkeeper/work twalters$ ruby -e "require 'rubygems' rescue nil; require 'rake'; load '/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake'; ARGV << '--nosearch' << '--trace' << 'cc:build'; Rake.application.run" >> /usr/lib/cruisecontrolrb-1.1.0/projects/goalkeeper/build-42/build.log && ruby -e "require 'rubygems' rescue nil; require 'rake'; load '/usr/lib/cruisecontrolrb-1.1.0/tasks/cc_build.rake'; ARGV << '--nosearch' << '--trace' << 'cc:build'; Rake.application.run" >> /usr/lib/cruisecontrolrb-1.1.0/projects/goalkeeper/build-42/build.log 2>&1<BR>exitstatus: 1<BR>STDERR TAIL START</DIV>
<DIV dir=ltr>STDERR TAIL END<BR>[root@Ricdev3 build-42]#<BR></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>here's a trace run from running rake test manually against the same code base:</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>[root@Ricdev3 work]# rake test<BR>(in /usr/lib/cruisecontrolrb-1.1.0/projects/goalkeeper/work)<BR>/usr/local/bin/ruby -Ilib:test "/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb" "test/unit/project_test.rb"<BR>Loaded suite /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader<BR>Started<BR>....<BR>Finished in 0.022967 seconds.</DIV>
<DIV dir=ltr>4 tests, 7 assertions, 0 failures, 0 errors<BR>/usr/local/bin/ruby -Ilib:test "/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb" "test/functional/admin_controller_test.rb"<BR>Loaded suite /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader<BR>Started<BR>........<BR>Finished in 0.058725 seconds.</DIV>
<DIV dir=ltr>8 tests, 20 assertions, 0 failures, 0 errors<BR>/usr/local/bin/ruby -Ilib:test "/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb"<BR>[root@Ricdev3 work]#<BR></DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B></B></FONT> </DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> Thibaut Barrère<BR><B>Sent:</B> Mon 8/6/2007 3:21 AM<BR><B>To:</B> Travis Walters<BR><B>Cc:</B> cruisecontrolrb-users@rubyforge.org<BR><B>Subject:</B> Re: [Cruisecontrolrb-users] rake build issue related to foreign key constraints?<BR></FONT><BR></DIV></DIV>
<DIV>Hi Travis<BR><BR>could you copy your cc failing building logs to give more details ?<BR><BR>best<BR><BR>Thibaut </DIV></BODY></HTML>