Re: Serialization failure 40001 or -11037
Everett, you are right, still cant see where the errors is but a i discover that the table has triggers as a part of a data replication module, and then calls a sp, this sp has 700 lines of code and calls other 9 sps, and i have no idea :-D Thanks for the help!, i continue checking the logic... Enrique Ferreyra Everett Mills ha escrito: > Enrique- > A few things to look at: > Does the table you're inserting into have an insert trigger on > it? If so, is it doing something with a serial column in the row you're > inserting or does it insert or update the same table you're inserting > into? Is the table set to lock mode row? > > --EEM > > > > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of eferreyra > Sent: Thursday, February 01, 2007 11:09 AM > To: informix-list@iiug.org > Subject: Serialization failure 40001 or -11037 > > Im getting this error via ODBC next to an insert statement ... > > I cant see how a dead-lock can occur, and always get in the same > insert of the same table. > > Some idea how to deal with this ? > > Using IBM INFORMIX ODBC DRIVER 2.90 (TC3, TC6) > > > Thanks > > A.U.S. Enrique Ferreyra > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
eferreyra wrote: > Everett, you are right, still cant see where the errors is but a i > discover that the table has triggers as a part of a data replication > module, and then calls a sp, this sp has 700 lines of code and calls > other 9 sps, and i have no idea :-D > > Thanks for the help!, i continue checking the logic... > It would be nice if some tool could make a "map" of the objects affected by a DML operation. Not sure if ServerStudio does it... I have a customer where this situation keeps happening. "How can a "simple" insert cause so many problems?!" Well... your Inserts are NOT simple :) Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...