I've been trying to debug a migration which works in development
using sqllite but fails on heroku with the error below. Has anyone
else encountered this before and have a solution?
An error has occurred, this and all later migrations canceled:
PGError: ERROR: current transaction is aborted, commands ignored
until end of transaction block
: SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'roles'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
connection_adapters/abstract_adapter.rb:202:in `log'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
connection_adapters/postgresql_adapter.rb:483:in `query'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
connection_adapters/postgresql_adapter.rb:617:in `table_exists?'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
connection_adapters/abstract/schema_statements.rb:159:in
`create_table'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:383:in `send'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:383:in `method_missing'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:359:in `say_with_time'
/usr/ruby1.8.7/lib/ruby/1.8/benchmark.rb:293:in `measure'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:359:in `say_with_time'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:379:in `method_missing'
/disk1/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-
cdb73b97e7d5/mnt/db/migrate/20100913234704_create_refinery_schema.rb:
100:in `up_without_benchmarks'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:312:in `send'
/home/slugs/370586_c72ee18_d915-2974e81d-7aac-410c-922b-cdb73b97e7d5/
mnt/.bundle/gems/ruby/1.8/gems/activerecord-3.0.3/lib/active_record/
migration.rb:312:in `migrate'
/usr/ruby1.8.7/lib/ruby/1.8/benchmark.rb:293:in `measure'
--
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.
