Assert Failed: ERROR - NO 'waitfor' locks in Critical Section!!!

dimple · #1 (**permalink**) 11-13-06, 00:14

This error has occured. What is the couse (if known). I am on Informix Dynamic Server Version 9.40.UC8.

Tyveleyn · #2 (**permalink**) 11-13-06, 04:46

From your description I would guess that there's no proper 'SET ISOLATION' and 'SET LOCK MODE' combination issued for the application. If not issued within the application the default isolation level of the database is used. If other than 'DIRTY READ' and an explicit 'SET LOCK MODE TO NOT WAIT' is in effect I expect an error message like yours. But it would clear up things if you could post the accompanying errorcode as well.

Regards,

Internet Services

Web Development

Digital Marketing

Consumer Tech