RE: Serialization failure 40001 or -11037

Enrique- You can use "trace" to find out which procedure is failing and why. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of eferreyra Sent: Friday, February 02, 2007 9:12 AM To: informix-list@iiug.org Subject: 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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list