Rails - Jun 2006 - Rake vs Ruby for running tests (error discrepency)

I''m having (to me) a strange problem with errors when running my tests 
with rake as opposed to using ruby.  If I do rake test:units I get this 
error for several tests, but not all:

13) Error:
test_player_has_game_statistics_for_season(PlayerSeasonTest):
ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry
''22'' for
key 1: INSERT INTO positions (`name`, `id`, `position`) VALUES 
(''athlete'', ''22'', ''ATH'')
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in
`execute''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:288:in
`insert_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:287:in
`insert_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:257:in
`create_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:257:in
`create_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:255:in
`create_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:794:in
`silence''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:248:in
`create_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:565:in
`load_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:512:in
`setup_with_fixtures''
   
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:547:in
`setup''


However if I use "ruby test/unit/player_season_test.rb" I
don''t get any
errors.  Same thing happens with funtional tests.  Using rake to run the 
tests gives me this error about duplicate keys but running the 
functionals individually with Ruby passes fine.  Any 
hints/suggestions/solutions?  Seems like some kind of issue with the 
fixtures but I have no idea what I can or should be doing here.  Thanks 
for any help.

-- 
Posted via http://www.ruby-forum.com/.

I had this issue too. Turned out my user model was calling my country 
model somewhere (though nowhere I could think of -- although it did in 
the main layout -- go figure!). I added the countries fixtures to the 
tests and it sorted the prob. Suspect something similar is happening 
with you. Not sure why there''s the discrepancy. Please post back if you
ever find out...

Paul Cook wrote:
> I''m having (to me) a strange problem with errors when running my
tests
> with rake as opposed to using ruby.  If I do rake test:units I get this 
> error for several tests, but not all:
>
> 13) Error:
> test_player_has_game_statistics_for_season(PlayerSeasonTest):
> ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry
''22'' for
> key 1: INSERT INTO positions (`name`, `id`, `position`) VALUES 
> (''athlete'', ''22'',
''ATH'')
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
> `log''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in
> `execute''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:288:in
> `insert_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:287:in
> `insert_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:257:in
> `create_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:257:in
> `create_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
> `transaction''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:255:in
> `create_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:794:in
> `silence''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:248:in
> `create_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:565:in
> `load_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:512:in
> `setup_with_fixtures''
>    
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/fixtures.rb:547:in
> `setup''
>
>
> However if I use "ruby test/unit/player_season_test.rb" I
don''t get any
> errors.  Same thing happens with funtional tests.  Using rake to run the 
> tests gives me this error about duplicate keys but running the 
> functionals individually with Ruby passes fine.  Any 
> hints/suggestions/solutions?  Seems like some kind of issue with the 
> fixtures but I have no idea what I can or should be doing here.  Thanks 
> for any help.
>
>

Chris T wrote:
> I had this issue too. Turned out my user model was calling my country
> model somewhere (though nowhere I could think of -- although it did in
> the main layout -- go figure!). I added the countries fixtures to the
> tests and it sorted the prob. Suspect something similar is happening
> with you. Not sure why there''s the discrepancy. Please post back
if you
> ever find out...
I did have that as a similar problem but with different errors.  I 
finally figured that out and had added the fixtures that were needed for 
the association.  This is just stranger because it looks like its trying 
to load the fixtures and can''t because of the ID being a primary key. 
However the positions table (table/fixture in question here) are empty 
to begin with. I''ve even tried to preload them but using rake they just
get zapped anyway. Admittedly my knowledge of how the rake task for 
running tests works is low as is my knowledge of fixtures beyond making 
them correctly formatted yaml and calling them in my tests.  This just 
seems like a potential bug but I can''t even figure how or what exactly 
could be happening.  My understanding is that loading a fixture removes 
any prexisting data in the table before loading it so this error 
shouldn''t occur. It''s not like it''s a foreign key
error its a primary
key error and I''ve double checked that the fixture doesn''t
have
duplicate entries.

Something I noticed is that if I have say 3 of this error they will 
progress through the IDs:

1) Error:
ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry
''18'' for
key 1:

2) Error:
ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry
''19'' for
key 1:

3) Error:
ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry
''20'' for
key 1:

and so on.  Strange that it always ascends through the ID''s.  Maybe 
that''s a clue.

-- 
Posted via http://www.ruby-forum.com/.

On Jun 24, 2006, at 10:54 AM, Paul Cook wrote:
> I''m having (to me) a strange problem with errors when running my
tests
> with rake as opposed to using ruby.  If I do rake test:units I get  
> this
> error for several tests, but not all:
>
> [snip errors]
> However if I use "ruby test/unit/player_season_test.rb" I
don''t get
> any
> errors.  Same thing happens with funtional tests.  Using rake to  
> run the
> tests gives me this error about duplicate keys but running the
> functionals individually with Ruby passes fine.  Any
> hints/suggestions/solutions?  Seems like some kind of issue with the
> fixtures but I have no idea what I can or should be doing here.   
> Thanks
> for any help.
Take a look at your config/environment.rb file. Do you have a line  
that looks like this?

config.active_record.schema_format = :ruby

If so, change ":ruby" to ":sql" and try again. The problem
you are
having **might** be related to the lack of transactional support in  
MySQL''s default database engine. If you overrode your engine choice  
to use InnoDB, the ruby schema format doesn''t retain this  
characteristic when reloading your test database (via the test:*  
commands).

Anyway, check it out.

cr

Nice one Chris T.
I think my problem was closer to Chris'' one than the one of this post 
(no MySQL error for me).
But same effect: test run with ruby, ok.  Same test run with rake 
test:units, failed!
I did add a missing fixture/model to the test and it passed!
Thanks again.

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

The thread is old, however we got similar error recently with rails 2 
and mysql 5.1. It was related to missing fixtures, however the problem 
with mysql


our installation is mysql 5.1.22 on CentOS 5 and 5.1.30 on Debian
we were able to reproduce the error with simple seqence of sql commands

select version();

DROP TABLE IF EXISTS test_inc;
CREATE TABLE `test_inc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

select ''insert explicit 9. must become 10'';
insert into test_inc ( id, account_id) values (9,1);
select * from test_inc;
show create table test_inc \G
select ''delete all. stays 10'';
delete from test_inc;
select * from test_inc;
show create table test_inc \G

select ''insert autoincrement. must become 11'';
insert into test_inc ( account_id) values (1) ;
select * from test_inc ;
show create table test_inc \G
select ''delete all. stays 11'';
delete from test_inc ;
select * from test_inc ;
show create table test_inc \G

select ''insert explicit 11. must become 12, but stays 11'';
insert into test_inc ( id, account_id) values (11,1);
select * from test_inc;
show create table test_inc \G

/*
select ''insert explicit 12. must become 13'';
insert into test_inc ( id, account_id) values (12,1);
select * from test_inc;
show create table test_inc \G
*/

select * from test_inc;
show create table test_inc \G
select ''insert auto-increment'';
insert into test_inc ( account_id) values (1);
select * from test_inc;
show create table test_inc \G


I''ve opened a bug with mysql, however they ''closed''
it as unable to
reproduce

http://ep.blogware.com/blog/_archives/2009/1/9/4051185.html

http://bugs.mysql.com/bug.php?id=41984
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---