Carl Youngblood
2006-Jan-31 09:44 UTC
[Rails] "cannot start a transaction within a transaction" sqlite error on OS X Tiger but not Windows
I''ve been editing a rails app on Windows for a little while now. I
just checked it into source control and started editing on my iMac.
Everything seems to run normally, except that when I attempt to modify
the database in any way (I''m running sqlite), I get a weird error:
"cannot start a transaction within a transaction"
/usr/local/lib/ruby/site_ruby/1.8/sqlite/resultset.rb:71:in `compile''
/usr/local/lib/ruby/site_ruby/1.8/sqlite/resultset.rb:71:in `commence''
/usr/local/lib/ruby/site_ruby/1.8/sqlite/resultset.rb:65:in
`initialize''
/usr/local/lib/ruby/site_ruby/1.8/sqlite/statement.rb:104:in `execute''
/usr/local/lib/ruby/site_ruby/1.8/sqlite/database.rb:194:in `execute''
/usr/local/lib/ruby/site_ruby/1.8/sqlite/database.rb:571:in
`transaction''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/sqlite_adapter.rb:171:in
`begin_db_transaction''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/database_statements.rb:48:in
`transaction''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/transactions.rb:91:in
`transaction''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/transactions.rb:118:in
`transaction''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/transactions.rb:126:in
`save''
#{RAILS_ROOT}/app/controllers/message_controller.rb:29:in `create''
I don''t get this error on windows. Has anyone seen this? If so, does
anyone know of a fix for it? I''m running the latest stable version of
rails on both machines.
Thanks,
Carl
