Re: SE 7.12 Lockup?

Joseph Cullipher wrote: > > On Mon, 3 Feb 1997, John Prideaux wrote: > > > We are running SE 7.12UC1 and RDS 6.03.UC1 on SCO Unix 5.0.0. This > > evening, one of our sqlexec processes apparently locked sysusers and > > the refused to release it. We were unable to kill the process, so no > > one was able to use the database until we rebooted the system. Does > > this > > ring a bell with anybody out there? > > I haved had this problem since...since...well it's been a long time. > It first appeared with SE 6.00UE1 on SCO 3.2.4.2 after about 2 months > with tech support trying to figure it out we upgraded to 7.10UC1 > The problem is still occurring and tech support still has the case open. > They have told me that I have been the only one to ever report this but > I have seen some similar problems listed in this forum by others. > At times the engine may lockup 6 or 7 times a week and then go 2 to 3 > weeks without a problem. We have been looking into TCP as a possible > cause but cannot find anything definative. If it happens to you again, > you should try a kill -15 on the sqlexec process. Make sure no user is > trying to connect or this will not kill the process(lots of experience > with this). If you need any more info or if you find the solution to > the problem let me know. TCP? Have you configured your STREAMS buffers? I believe these are critical in 3.2.4.x. Run netstat -m and look at the last column (fail). If there are failures, then that buffer size (first column) is under-configured. You configure these in the kernal parameters. Just a thought, I have seen these to be a problem with terminal emulators. Maybe they cause Informix problems too. Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+