Re: Runaway dbaccess process
Posted in 1997
We have also had this problem several times, without knowing why a
dbaccess process keeps on running.
Does any body know if this problem only is in versions prior to Informix
OnLine 7.22 ?.
Bjarne W. Jensen /Alm. Brand Denmark
Cosmo Lee wrote :
} We had the same problem. I think we have the problem less w/ the 7.22
} upgrade. It looks like a bug. (Unixware 2.1, Compaq Proliant 1500 w/ 2
} PPro 200Mhz).
}Ron M. Flannery wrote:
}> On our current application, users start dbaccess and sometimes
}> disconnect
}> without properly exiting (turning off terminal, etc.). The dbaccess
}> process hangs and proceeds to take over ALL of CPU 1 or 2. When I do
}> a top
}> or sar, one of the CPUs is pegged by the dbaccess process! I was able
}> to
}> easily reproduce this by starting dbaccess, doing "select * from
}> customer"
}> and disconnecting.
}>
}> The process is eating CPU time but not Informix time. Neither the
}> session
}> nor the thread was accruing any reads or writes, but the process was
}> chewing CPU like crazy.
}>
}> Here's the config: We're running HP-UX 10.20 with ODS 7.20. We have
}> three
}> CPUs and the following settings: