Michael Schoen
2006-Jul-06 04:50 UTC
Rails AR/Oracle Unit Test: [4472] failed (getting worse)
"bitsweat" has kicked AR/Oracle while it was down... http://dev.rubyonrails.org/changeset/4472 ------------------------------------------------------------------------ r4472 | bitsweat | 2006-06-20 12:54:35 -0700 (Tue, 20 Jun 2006) | 3 lines r4669@asus: jeremy | 2006-06-20 12:53:36 -0700 Getting picayune with locking_test. Closes #4871. ------------------------------------------------------------------------ U activerecord/test/locking_test.rb U . Updated to revision 4472. 1) Failure: test_to_xml(BasicsTest) [./test/base_test.rb:1239]: <false> is not true. 2) Error: test_add_column_not_null_with_default(MigrationTest): ActiveRecord::StatementInvalid: OCIError: ORA-01400: cannot insert NULL into ("ARUNIT"."TESTINGS"."ID"): insert into testings (foo) values (''hello'') ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in `execute'' ./test/migration_test.rb:176:in `test_add_column_not_null_with_default'' 3) Failure: test_sane_find_with_lock(PessimisticLockingTest) [./test/locking_test.rb:90]: Exception raised: Class: <ActiveRecord::StatementInvalid> Message: <"OCIError: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM people WHERE (people.id = 1) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 FOR UPDATE"> ---Backtrace--- ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in `execute'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:477:in `select'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:268:in `select_all'' ./test/../lib/active_record/base.rb:416:in `find_by_sql'' ./test/../lib/active_record/base.rb:950:in `find_every'' ./test/../lib/active_record/base.rb:944:in `find_initial'' ./test/../lib/active_record/base.rb:978:in `find_one'' ./test/../lib/active_record/base.rb:967:in `find_from_ids'' ./test/../lib/active_record/base.rb:408:in `find'' ./test/locking_test.rb:93:in `test_sane_find_with_lock'' ./test/../lib/active_record/base.rb:899:in `with_scope'' ./test/locking_test.rb:92:in `test_sane_find_with_lock'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:51:in `transaction'' ./test/../lib/active_record/transactions.rb:86:in `transaction'' ./test/locking_test.rb:91:in `test_sane_find_with_lock'' ./test/locking_test.rb:90:in `test_sane_find_with_lock'' --------------- 4) Failure: test_sane_lock_method(PessimisticLockingTest) [./test/locking_test.rb:101]: Exception raised: Class: <ActiveRecord::StatementInvalid> Message: <"OCIError: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM people WHERE (people.id = 1) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 FOR UPDATE"> ---Backtrace--- ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:277:in `execute'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:477:in `select'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:268:in `select_all'' ./test/../lib/active_record/base.rb:416:in `find_by_sql'' ./test/../lib/active_record/base.rb:950:in `find_every'' ./test/../lib/active_record/base.rb:944:in `find_initial'' ./test/../lib/active_record/base.rb:978:in `find_one'' ./test/../lib/active_record/base.rb:967:in `find_from_ids'' ./test/../lib/active_record/base.rb:408:in `find'' ./test/../lib/active_record/base.rb:1550:in `reload'' ./test/../lib/active_record/locking/pessimistic.rb:72:in `lock!'' ./test/locking_test.rb:105:in `test_sane_lock_method'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:51:in `transaction'' ./test/../lib/active_record/transactions.rb:86:in `transaction'' ./test/locking_test.rb:102:in `test_sane_lock_method'' ./test/locking_test.rb:101:in `test_sane_lock_method'' --------------- 900 tests, 3165 assertions, 3 failures, 1 errors rake aborted! Command failed with status (1): [/usr/pkg/ruby184/bin/ruby -Ilib:test:test/...] (See full trace by running task with --trace)