Deadlocks Detected

Posted in 1997

Chris Burton — Mon, 17 Mar 1997 19:52:14 GMT — source: Informix-list mailing list archive (1991-1998)

I am running 7.11.UC1 on HP-UX 9.04 - H50 I have a large table 14M records fragmented over 2 spaces with row level locking. I am loading it with ESQL/C (it also does some lookups for populating other columns), and when more than one load is loading at a time, I get -217, deadlocks detected on the insert statement. The reason this looks funny is that the table was just recently fragmented. It was in a dbspace by itself, and there were not any problems then. I have run onchecks galore to make sure that the table is not corrupted. Any help is appreciated. Chris Burton cburton@gte.net

Related threads

How to get the sequence value in ESQL/C program?