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


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to