thr3ads.net - Rails - Rails 0.14.0 testing is weird... [Oct 2005]

If this information is useful, please help other people find it:
Share via:

Tom Mornini

2005-Oct-18 08:26 UTC

Rails 0.14.0 testing is weird...

It looks as though it''s selecting an index when it''s intending
to
select a sequence?

   1) Error:
test_truth(CategoryTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_categories_sellers1" is  
an index
:             SELECT setval(''public.idx_categories_sellers1'',
(SELECT
COALESCE(MAX(category_id)+(SELECT increment_by FROM  
public.idx_categories_sellers1), (SELECT min_value FROM  
public.idx_categories_sellers1)) FROM categories_sellers), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

-- 
-- Tom Mornini

Tom Mornini

2005-Oct-18 09:42 UTC

head link

Re: Rails 0.14.0 testing is weird...

I just noticed this is happening on HABTM joins.

I have fixtures for those, but no models. Fixtures are CSV format.

A complete error list included this time:

/usr/bin/ruby -Ilib:test "/usr/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/ 
rake/rake_test_loader.rb" "test/unit/category_test.rb"
"test/unit/
credit_card_test.rb" "test/unit/event_test.rb" "test/unit/ 
ledger_test.rb" "test/unit/photo_test.rb"
"test/unit/proxy_test.rb"
"test/unit/rating_test.rb" "test/unit/seller_test.rb"
"test/unit/
unit_test.rb" "test/unit/user_test.rb"
Loaded suite /usr/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake/ 
rake_test_loader
Started
E.EEEEE..EEEE
Finished in 1.959404 seconds.

   1) Error:
test_truth(CategoryTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_categories_sellers1" is  
an index
:             SELECT setval(''public.idx_categories_sellers1'',
(SELECT
COALESCE(MAX(category_id)+(SELECT increment_by FROM  
public.idx_categories_sellers1), (SELECT min_value FROM  
public.idx_categories_sellers1)) FROM categories_sellers), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   2) Error:
test_truth(EventTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_events_ledgers1" is an  
index
:             SELECT setval(''public.idx_events_ledgers1'',
(SELECT
COALESCE(MAX(event_id)+(SELECT increment_by FROM  
public.idx_events_ledgers1), (SELECT min_value FROM  
public.idx_events_ledgers1)) FROM events_ledgers), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   3) Error:
test_truth(LedgerTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_events_ledgers1" is an  
index
:             SELECT setval(''public.idx_events_ledgers1'',
(SELECT
COALESCE(MAX(event_id)+(SELECT increment_by FROM  
public.idx_events_ledgers1), (SELECT min_value FROM  
public.idx_events_ledgers1)) FROM events_ledgers), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   4) Error:
test_truth(PhotoTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_photos_users1" is an
index
:             SELECT setval(''public.idx_photos_users1'',
(SELECT
COALESCE(MAX(photo_id)+(SELECT increment_by FROM  
public.idx_photos_users1), (SELECT min_value FROM  
public.idx_photos_users1)) FROM photos_users), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   5) Error:
test_truth(ProxyTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_proxies_sellers1" is an  
index
:             SELECT setval(''public.idx_proxies_sellers1'',
(SELECT
COALESCE(MAX(proxy_id)+(SELECT increment_by FROM  
public.idx_proxies_sellers1), (SELECT min_value FROM  
public.idx_proxies_sellers1)) FROM proxies_sellers), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   6) Error:
test_truth(RatingTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_sellers_ratings1" is an  
index
:             SELECT setval(''public.idx_sellers_ratings1'',
(SELECT
COALESCE(MAX(sellers_id)+(SELECT increment_by FROM  
public.idx_sellers_ratings1), (SELECT min_value FROM  
public.idx_sellers_ratings1)) FROM sellers_ratings), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup_with_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:527:in `setup''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:526:in `setup''

   7) Error:
test_defaults(UserTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_photos_users1" is an
index
:             SELECT setval(''public.idx_photos_users1'',
(SELECT
COALESCE(MAX(photo_id)+(SELECT increment_by FROM  
public.idx_photos_users1), (SELECT min_value FROM  
public.idx_photos_users1)) FROM photos_users), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup''

   8) Error:
test_hash(UserTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_photos_users1" is an
index
:             SELECT setval(''public.idx_photos_users1'',
(SELECT
COALESCE(MAX(photo_id)+(SELECT increment_by FROM  
public.idx_photos_users1), (SELECT min_value FROM  
public.idx_photos_users1)) FROM photos_users), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup''

   9) Error:
test_login(UserTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_photos_users1" is an
index
:             SELECT setval(''public.idx_photos_users1'',
(SELECT
COALESCE(MAX(photo_id)+(SELECT increment_by FROM  
public.idx_photos_users1), (SELECT min_value FROM  
public.idx_photos_users1)) FROM photos_users), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup''

10) Error:
test_security_token(UserTest):
ActiveRecord::StatementInvalid: ERROR:  "idx_photos_users1" is an
index
:             SELECT setval(''public.idx_photos_users1'',
(SELECT
COALESCE(MAX(photo_id)+(SELECT increment_by FROM  
public.idx_photos_users1), (SELECT min_value FROM  
public.idx_photos_users1)) FROM photos_users), false)

     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract_adapter.rb:67:in `log''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:283:in `select''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:98:in  
`select_one''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/abstract/database_statements.rb: 
16:in `select_value''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/connection_adapters/postgresql_adapter.rb:210:in  
`reset_pk_sequence!''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:265:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `each''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:264:in `create_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:545:in `load_fixtures''
     /usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/ 
active_record/fixtures.rb:502:in `setup''

13 tests, 5 assertions, 0 failures, 10 errors
rake aborted!
Command failed with status (1): [/usr/bin/ruby -Ilib:test "/usr/lib/ 
ruby/ge...]

Jeremy Kemper

2005-Oct-18 15:26 UTC

head link

Re: Rails 0.14.0 testing is weird...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Oct 18, 2005, at 2:42 AM, Tom Mornini wrote:> I just noticed this is happening on HABTM joins.
>
>   1) Error:
> test_truth(CategoryTest):
> ActiveRecord::StatementInvalid: ERROR:  "idx_categories_sellers1"
> is an index
> :             SELECT
setval(''public.idx_categories_sellers1'',
> (SELECT COALESCE(MAX(category_id)+(SELECT increment_by FROM  
> public.idx_categories_sellers1), (SELECT min_value FROM  
> public.idx_categories_sellers1)) FROM categories_sellers), false)

Thanks for the report, Tom.  Could you post a bug to http:// 
dev.rubyonrails.org/newticket ?  We need to correct the query that  
automatically determines the sequence for the table''s primary key.

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDVRQQAQHALep9HFYRAjh/AKCGCcteBE2NrOAflPCxRo662YNmUACdGj+3
JiRvPN+hy4sXXmY7OrXgOyg=o7S+
-----END PGP SIGNATURE-----

Luke Redpath

2005-Oct-18 17:34 UTC

head link

Re: Rails 0.14.0 testing is weird...

I''m getting something similar with my tests, though the app itself
seems to
be working.

Just one example:

90) Error:
test_should_redirect_to_login_screen_on_logout(UserControllerTest):
ActiveRecord::StatementInvalid: ERROR C42809 M"role_has_permissions"
is an
index Fheapam.c L646 Rheap_openrv: SELECT setval(''
public.role_has_permissions'', (SELECT COALESCE(MAX(role_id)+(SELECT
increment_by FROM public.role_has_permissions), (SELECT min_value FROM
public.role_has_permissions)) FROM permissions_roles), false)

/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/abstract_adapter.rb:67:in
`log''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/postgresql_adapter.rb:113:in
`execute''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/postgresql_adapter.rb:283:in
`select''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/postgresql_adapter.rb:98:in
`select_one''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/abstract/database_statements.rb:16:in
`select_value''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/connection_adapters/postgresql_adapter.rb:210:in
`reset_pk_sequence!''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:265:in
`create_fixtures''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:264:in
`each''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:264:in
`create_fixtures''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:545:in
`load_fixtures''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:493:in
`setup_with_fixtures''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:527:in
`setup''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/active_record/fixtures.rb:526:in
`setup''

49 tests, 0 assertions, 0 failures, 90 errors

Cheers
Luke


On 10/18/05, Jeremy Kemper
<jeremy-w7CzD/W5Ocjk1uMJSBkQmQ@public.gmane.org>
wrote:>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Oct 18, 2005, at 2:42 AM, Tom Mornini wrote:
> > I just noticed this is happening on HABTM joins.
> >
> > 1) Error:
> > test_truth(CategoryTest):
> > ActiveRecord::StatementInvalid: ERROR:
"idx_categories_sellers1"
> > is an index
> > : SELECT setval(''public.idx_categories_sellers1'',
> > (SELECT COALESCE(MAX(category_id)+(SELECT increment_by FROM
> > public.idx_categories_sellers1), (SELECT min_value FROM
> > public.idx_categories_sellers1)) FROM categories_sellers), false)
>
>
> Thanks for the report, Tom. Could you post a bug to http://
> dev.rubyonrails.org/newticket <http://dev.rubyonrails.org/newticket>
? We
> need to correct the query that
> automatically determines the sequence for the table''s primary key.
>
> jeremy
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (Darwin)
>
> iD8DBQFDVRQQAQHALep9HFYRAjh/AKCGCcteBE2NrOAflPCxRo662YNmUACdGj+3
> JiRvPN+hy4sXXmY7OrXgOyg> =o7S+
> -----END PGP SIGNATURE-----
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>

_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

Tom Mornini

2005-Oct-18 18:08 UTC

head link

Re: Rails 0.14.0 testing is weird...

On Oct 18, 2005, at 8:26 AM, Jeremy Kemper wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Oct 18, 2005, at 2:42 AM, Tom Mornini wrote:
>
>> I just noticed this is happening on HABTM joins.
>>
>>   1) Error:
>> test_truth(CategoryTest):
>> ActiveRecord::StatementInvalid: ERROR: 
"idx_categories_sellers1"
>> is an index
>> :             SELECT
setval(''public.idx_categories_sellers1'',
>> (SELECT COALESCE(MAX(category_id)+(SELECT increment_by FROM  
>> public.idx_categories_sellers1), (SELECT min_value FROM  
>> public.idx_categories_sellers1)) FROM categories_sellers), false)
>
> Thanks for the report, Tom.  Could you post a bug to http:// 
> dev.rubyonrails.org/newticket ?  We need to correct the query that  
> automatically determines the sequence for the table''s primary key.
http://dev.rubyonrails.org/ticket/2507
-- 
-- Tom Mornini

Tom Mornini

2005-Oct-18 21:52 UTC

head link

Re: Rails 0.14.0 testing is weird...

On Oct 18, 2005, at 11:08 AM, Tom Mornini wrote:
> On Oct 18, 2005, at 8:26 AM, Jeremy Kemper wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On Oct 18, 2005, at 2:42 AM, Tom Mornini wrote:
>>
>>
>>> I just noticed this is happening on HABTM joins.
>>>
>>>   1) Error:
>>> test_truth(CategoryTest):
>>> ActiveRecord::StatementInvalid: ERROR: 
"idx_categories_sellers1"
>>> is an index
>>> :             SELECT
setval(''public.idx_categories_sellers1'',
>>> (SELECT COALESCE(MAX(category_id)+(SELECT increment_by FROM  
>>> public.idx_categories_sellers1), (SELECT min_value FROM  
>>> public.idx_categories_sellers1)) FROM categories_sellers), false)
>>>
>>
>> Thanks for the report, Tom.  Could you post a bug to http:// 
>> dev.rubyonrails.org/newticket ?  We need to correct the query that  
>> automatically determines the sequence for the table''s primary
key.
>>
>
> http://dev.rubyonrails.org/ticket/2507
I''ve just added patch to this ticket that resolves this issue to my  
satisfaction.

-- 
-- Tom Mornini

Rails - Oct 2005 - Rails 0.14.0 testing is weird...

Rails 0.14.0 testing is weird...

Re: Rails 0.14.0 testing is weird...

Re: Rails 0.14.0 testing is weird...

Re: Rails 0.14.0 testing is weird...

Re: Rails 0.14.0 testing is weird...

Re: Rails 0.14.0 testing is weird...