Re: Informix halts for no obvious reason ?!

Milen Metodiev (dbadmin@svilosa.bis.bg) wrote: : RSAM Version 5.01.UD2 -- On-Line (CKPT REQ) -- Up 01:14:09 -- 20288 Kbytes : Users : address flags pid user tty wait tout locks nreads nwrites : 804020f0 B-B-X-- 1415 petkova ttya01 80644010 0 3 3395 26 User is in a critical section, waiting for buffer 80644010. : Buffers : address user flgs pagenum memaddr nslots pgflgs xflgs owner waitlist : 80644010 0 2 123b1b 807f3800 0 b0 100 0 804020f0 Buffer 80644010 is owned by user 0 (not a valid user). Sounds like bug 13587. Fixed in 5.02.UC1 and later. I recommend you go to 5.08 or something like that, however. Also, you have a lot of errors in your online.log that you should look at sometime. tbcheck your tables. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: ? (don't want Billy Wheeler to know) ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.