Rails - Mar 2010 - ActiveRecord::Base.transaction MySQL Lock Errors...

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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.