Hi there, is there any known issues when using ActiveRecord::Base.transaction with models who tables have constraints applied?
I have two models: one (is associated with model two) two (has MySQL foreign key and unique key constraints) I'm doing something like this: ActiveRecord::Base.transaction one.create two.create(reference to one) one.create two.create(reference to one) end ... which leads to something hanging and the transaction failing with MySQL table lock errors. What's strange is that all works if I wrap each pair of creates within a Base.transaction of their own. Any pointers on the cause? Thanks in advance! -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
