thr3ads.net - Rails core - Rails AR/Oracle Unit Test: [4577] failed (getting worse) [Jul 2006]

If this information is useful, please help other people find it:
Share via:
Michael Schoen
2006-Jul-07 14:32 UTC
Rails AR/Oracle Unit Test: [4577] failed (getting worse)

"bitsweat" has kicked AR/Oracle while it was down...

http://dev.rubyonrails.org/changeset/4577
------------------------------------------------------------------------
r4577 | bitsweat | 2006-07-07 03:58:22 -0700 (Fri, 07 Jul 2006) | 1 line

Clearer has_one/belongs_to model names (account has_one :user). Closes #5632.
------------------------------------------------------------------------

U  activerecord/lib/active_record/associations.rb
U  activerecord/CHANGELOG
Updated to revision 4577.

  1) 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:250:in
`execute''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:450:in
`select''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:241:in
`select_all''
./test/../lib/active_record/base.rb:422:in `find_by_sql''
./test/../lib/active_record/base.rb:956:in `find_every''
./test/../lib/active_record/base.rb:950:in `find_initial''
./test/../lib/active_record/base.rb:984:in `find_one''
./test/../lib/active_record/base.rb:973:in `find_from_ids''
./test/../lib/active_record/base.rb:414:in `find''
./test/locking_test.rb:93:in `test_sane_find_with_lock''
./test/../lib/active_record/base.rb:905: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''
---------------

  2) 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:250:in
`execute''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:450:in
`select''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:241:in
`select_all''
./test/../lib/active_record/base.rb:422:in `find_by_sql''
./test/../lib/active_record/base.rb:956:in `find_every''
./test/../lib/active_record/base.rb:950:in `find_initial''
./test/../lib/active_record/base.rb:984:in `find_one''
./test/../lib/active_record/base.rb:973:in `find_from_ids''
./test/../lib/active_record/base.rb:414:in `find''
./test/../lib/active_record/base.rb:1561: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''
---------------

  3) Error:
test_second_lock_waits(PessimisticLockingTest):
ActiveRecord::StatementInvalid: 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
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
    ./test/locking_test.rb:142:in `join''
    ./test/locking_test.rb:142:in `duel''
    ./test/locking_test.rb:118:in `test_second_lock_waits''

  4) Error:
test_association_collection_method_missing_scoping_not_readonly(ReadOnlyTest):
ActiveRecord::StatementInvalid: OCIError: ORA-00001: unique constraint
(ARUNIT.SYS_C00126619) violated: INSERT INTO comments (body, type, post_id, id)
VALUES (''Special type 2'', ''SpecialComment'',
4, 7)
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
    ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:250:in
`execute''
    ./test/../lib/active_record/fixtures.rb:288:in `insert_fixtures''
    ./test/../lib/active_record/fixtures.rb:287:in `insert_fixtures''
    ./test/../lib/active_record/fixtures.rb:257:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:257:in `create_fixtures''
   
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction''
    ./test/../lib/active_record/fixtures.rb:255:in `create_fixtures''
    ./test/../lib/active_record/base.rb:826:in `silence''
    ./test/../lib/active_record/fixtures.rb:248:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:576:in `load_fixtures''
    ./test/../lib/active_record/fixtures.rb:521:in `setup''

  5) Failure:
test_callback_rollback_in_save(TransactionTest)
[./test/transactions_test.rb:117]:
<false> is not true.

  6) Failure:
test_failing_on_exception(Tra
Rails core - Jul 2006 - Rails AR/Oracle Unit Test: [4577] failed (getting worse)

Rails AR/Oracle Unit Test: [4577] failed (getting worse)
