Re: Faulty BEGIN COMMIT on Informix 4.1

>From: andro@ibm.net (rk) >Date: 27 Oct 1995 04:03:41 GMT >X-Informix-List-Id: <news.18309> > >Need assistance from Informix gurus out there! > >Is there any guarrantee that statements inside a BEGIN-COMMIT would be >done atomically. We are using Informix 4.1 on top of AIX 3.2, and we >have discovered that several times the BEGIN-COMMIT in our programs >missed a statement or two without warning to users or rolling back the >transactions. It happens randomly both on small and large BEGIN-COMMIT >block. True this is rare, but we want to make sure that it >never happens at all. Are we talking about SE or OnLine? There are significant differences, and there are a number of statements which can be rolled back in OnLine but not rolled back in SE -- CREATE TABLE and GRANT are two that spring to mind. Otherwise, you may be hitting a bug -- but not one which I recall ever having heard about. The transaction control mechanisms have been 100% reliable for me, barring external influences such as running out of space for the SE transaction log! But I am immensely sceptical; I would take a lot of convincing that this is happening and is an engine-level bug. What sort of statements are missed? Which mode of database are you using? Is it reproducible? And what is the latest version for the platform? I'm reasonably confident that 4.1x engines are way out of date -- there should be a 5.0x version available, unless the operating system is also obsolete. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>