Re: Informix halts for no obvious reason ?!

dbadmin@svilosa.bis.bg (Milen Metodiev) wrote: :Hi, folks. : :This is the umpteenth time this happens, so I wonder :if anyone can help. Even a few hints will be more than :welcome. : :When the system is busy enough ( 20-30 users of Informix ) :and people start issuing "heavy" queries, Informix falls into :a strange deadlock. It looks like one process is in a critical :section, and won't leave it. Informix waits for this process :to get out of its critical section, so that it can complete :the pending checkpoint. In the end, all users end up waiting :for this checkpoint, which never occurs. : :It happens to random users, using random programs, i.e. there :is no any consistency about this behaviour. : :Here is some information about our version of Informix, etc. : :====================================================== :Database: Informix OnLine 5.0.2.UC6 :OS : SCO OpenServer Enterprise System Release 3.0 :E-mail : dbadmin@svilosa.bis.bg :====================================================== These are realy old versions. I would think hard about an upgrade to SCO 5.0.4 and at least OnLine 5.08 or whatever is the latest version on SCO. You might be even better of with 7.22 or 7.23. :The following is a listing of a file containing a snapshot of :the system at the time of the failure: ...snip of data I don't have the time to look at now... :OK. I hope someone out there will have a clew what's going on, :because we at Svilosa don't. Please help !!!!!!!!!!!!!!!!!!!!! :BTW, we have already asked our Informix-support, but they don't :seem to be getting there fast and for a full support they now want :450000 DM. ( I kid you not. ) Is this German mark? If that's the case something is extremely wrong here. Extremly. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org