I'm using PostgreSQL version 8.2.1 with the driver postgresql-8.2-504.jdbc3.jar.
On Wed, 2007-02-21 at 17:18 -0700, David E. Jones wrote: > David, > > I have seen this sort of thing happen before, but the trick is there > are a lot of things that can cause it. One common one is the JDBC > driver... which database and JDBC driver are you using? > > -David J. > > > On Feb 21, 2007, at 7:05 AM, David Shere wrote: > > > We have a local Java service that imports legacy data from our old > > ordering system. Last night while working on a 130,000 record import, > > it was sailing along until it got to 118392, at which time the Ofbiz > > Java process jumped to 99%, and the import froze. No messages from > > the > > service, no notice that the service had stopped. The load average > > hovered around 1.0, and Ofbiz was otherwise working normally. > > > > I'm glad to see that what appears to be a runaway process/infinite > > loop > > didn't stop Ofbiz completely, and was "contained". I stopped and > > restarted Ofbiz, the problem went away, and the import picked up where > > it left off. 118392 was imported properly. > > > > In this case, I presume could also have stopped the service to fix the > > problem, but that's only because I knew which one it was that was > > maxing > > out the CPU usage. Is it possible/rare/common that something like > > this > > could happen, and I wouldn't know which service it was? And in that > > case would I have other options than stopping and restarting Ofbiz? > > > > -- > > David Shere > > Information Technology Services > > Steele Rubber Products > > 704-483-9343 x277 > > > -- David Shere Information Technology Services Steele Rubber Products 704-483-9343 x277
