Re: your mail

} } In article <1dbtpnINNqac@emory.mathcs.emory.edu> johnl@obelix.informix.com (Jonathan Leffler) writes: } >}From: uunet!gauss.rutgers.edu!manmetha (Rajesh Malhotra) } >}Subject: Erratic error 408 from ESQL/C } >}Date: 4 Nov 92 22:26:16 GMT } >}X-Informix-List-Id: <news.2057> } >} } >}Fellow Informix'ers, } >} } >} Every now and then a query in our application fails } >}with an error code of 408. We have'nt been able to duplicate the } >}scenario and make the error occur again. The manual's description } >}of 408 does not seem to make sense. } >} } >} Any ideas / suggestions? } >} } >}BTW we are running Informix online 5.0 and ESQL/C on an IBM RS600 } >}running AIX 3.2 } > } >The key info here is probably the RS6000. AIX detects when it is getting } >low on swap space (or some other virtual memory resource), and it then } >arbitrarily kills a process or processes to relieve the pressure. Sometimes } >you are lucky and it is only an sqlturbo it kills -- sometimes it kills } >tbinit instead. And sometimes you are unlucky and it kills an sqlturbo in a } >critical section so OnLine has to abort. } > } >AIX is wonderful, really:-( } > } >Yours, } >Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h> } } This error occurs every time in one of my load module. To work around this } problem, I have to move/rearrange codes around. } } It is a mystery to me, and I don't think it have any thing to do with the } machine (my application is on Pyramid 7080 series). } } I am still investigating....\\8-( } } Zombie (dinguyen@wam.umd.edu) } We have gotten this error when somehow our tables were damaged. If this had been a large production table, I would have run tbchecks against the table. Since there were a small number of rows in the table, I created a new empty table, and copied from one table to another (select * from oldtable, insert into newtable), and the problem was resolved. -- Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu Enthusiasm is caught, In tennis, not taught. love means nothing.