[Rails-core] AR UnitTests failing...

[Bob Silva]

Are you using the Rails provided MySQL driver? Or have you installed the
native gem?

Bob Silva
http://www.railtie.net/

> -----Original Message-----
> From: rails-core-bounces at lists.rubyonrails.org [mailto:rails-core-
> bounces at lists.rubyonrails.org] On Behalf Of Diego Algorta Casamayou
> Sent: Tuesday, February 14, 2006 3:36 AM
> To: rails-core at lists.rubyonrails.org
> Subject: [Rails-core] AR UnitTests failing...
> 
> I tried to post this 2 days ago but got bounced because the mail was
> too big. I've gzipped the attachment so it could pass the size limits
> now.
> ---------------------------------------------
> Hi there.
> 
> (first post here).
> 
> I have Ubuntu 5.10, Ruby 1.8.3 and Rake 0.7.0
> (Should I specify anything else?)
> 
> I've downloaded trunk rails Yesterday from SVN following instructions
> on http://dev.rubyonrails.org/
> 
> First, I'm getting an error while executing the mysql.sql commands:
> 
> ERROR 1005: Can't create table
> './activerecord_unittest/fk_test_has_fk.frm' (errno: 150)
> 
> I configured mysql's connection.rb to suit my system and tried to run
> the tests, but at the end I get:
> 
> 705 tests, 2080 assertions, 35 failures, 35 errors
> 
> I obviously suspect all failures and errors are related to the
> fk_test_has_fk table, so I created it without the foreign key
> constraint and tried again with no better results.
> 
> I know it's long, but I think i'd better show you my failed testing
> session...
> 
> 
> diego at antu:~/rails/trunk/activerecord$ sudo mysqladmin -p create
> activerecord_unittest
> Enter password:
> diego at antu:~/rails/trunk/activerecord$ sudo mysqladmin -p create
> activerecord_unittest2
> Enter password:
> diego at antu:~/rails/trunk/activerecord$ mysql -u rails
> activerecord_unittest
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 12 to server version: 4.0.24_Debian-10ubuntu2-
> log
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> \. test/fixtures/db_definitions/mysql.sql
> ...
> Query OK, 0 rows affected (0.12 sec)
> 
> ERROR 1005: Can't create table
> './activerecord_unittest/fk_test_has_fk.frm' (errno: 150)
> Query OK, 0 rows affected (0.11 sec)
> ...
> mysql> Bye
> diego at antu:~/rails/trunk/activerecord$ mysql -u rails
> activerecord_unittest2
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 13 to server version: 4.0.24_Debian-10ubuntu2-
> log
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> \. test/fixtures/db_definitions/mysql2.sql
> Query OK, 0 rows affected (0.19 sec)
> 
> mysql> Bye
> diego at antu:~/rails/trunk/activerecord$ sudo rake AR_TX_FIXTURES=yes
> test_mysql 2>&1 >rake.out
> /usr/bin/ruby1.8 -Ilib:test:test/connections/native_mysql
> "/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake/rake_test_loader.rb"
> "test/base_test.rb" "test/associations_extensions_test.rb"
> "test/deprecated_associations_test.rb"
> "test/aaa_create_tables_test.rb" "test/ar_schema_test.rb"
> "test/mixin_test.rb" "test/locking_test.rb" "test/reflection_test.rb"
> "test/associations_join_model_test.rb" "test/associations_test.rb"
> "test/unconnected_test.rb" "test/column_alias_test.rb"
> "test/defaults_test.rb" "test/fixtures_test.rb"
> "test/threaded_connections_test.rb" "test/schema_dumper_test.rb"
> "test/callbacks_test.rb" "test/adapter_test.rb"
> "test/readonly_test.rb" "test/pk_test.rb"
> "test/class_inheritable_attributes_test.rb" "test/binary_test.rb"
> "test/deprecated_finder_test.rb" "test/associations_go_eager_test.rb"
> "test/migration_test.rb" "test/inheritance_test.rb"
> "test/lifecycle_test.rb" "test/multiple_db_test.rb"
> "test/mixin_nested_set_test.rb" "test/method_scoping_test.rb"
> "test/finder_test.rb" "test/modules_test.rb"
> "test/transactions_test.rb" "test/aggregations_test.rb"
> "test/association_callbacks_test.rb" "test/validations_test.rb"
> diego at antu:~/rails/trunk/activerecord$
> 
> (rake.out is attached).
> 
> Thank you,
> Diego