Re: [Info-Ingres] Application hangs

#1

On Sep 14, 2010, at 4:43 PM, Ingres Forums wrote:

Quote:

I have an EJB 3 application that I have successfully run on MySQL and
PostgreSQL. It hangs on this first part of the application. Let me
explain.
...
This code loops through creating Customer entities that have a
PricingMethod (one-to-one relationship), and persists them in a batch,
based on the batchSize that passed into the method (which comes from a
simple web form). I also pass in the number of customers to create,
which in this case is 1,000,000. So, it should create 1 million
Customer entities and 1 million PricingMethod entities.

At the moment it hangs after creating 77,000 Customer entities and
77,000 PricingMethod entities.

What version of Ingres? and what is the batch size?

It would also be useful to know what the DBMS server session is doing
when it hangs; is it hanging on a lock, or a mutex, or on input from the
client, or spinning in a CPU loop, or what. You can use the iimonitor
tool (basic, command line) or ipm (nicer but character-forms based
and sometimes people get hung up on finding the right "terminal
type" to get the function keys to work). The most basic way is,
at a shell / command line prompt:
iinamu
show ingres
some number NNN comes out
quit
iimonitor NNN
show sessions [formatted]
format sessionid (id comes from the show sessions list)
quit

Karl

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [Info-Ingres] Application hangs

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Application hangs - 09-14-2010 , 04:12 PM