Hi everybody, I've got a web project using turbine/torque for accessing a mySql database. It all worked fine. Now I decided to introduce transactions and so I changed some tables to type=innoDB. Now I've got some problems and I think they could come from tourque, not from my code: If I do an insert into the databse via a torque object, I get an error saying that a foreign key dependendy is wrong. I found no wrong foreign keys. Than I tried to insert the same values via the peer object and I got an error saying "timeout expired when waiting for a lock". My operation was the only database operation going on. Then I tried to insert the same values directly via SQL and it worked. That behaviour strikes me as odd. So my question is: Does somebody have experiences with tourque and InnoDB ? Did somebody have similar problems? Thanks for answers Stefan
-- Stefan Kuhn M. A. MPI of Chemical Ecology, Winzerlaer Str. 10, Beutenberg Campus, 07745 Jena, Germany Tel: +49(0)3641 571261 - Fax: +49(0)3641 571202 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
