Re: AW: MaxDB Hang on simultaneous connections

[Rajesh Ballal]

Elke,
 
Thanks for your quick response. I tried to copu and pase following link in my browser
which did not display anything. It's a blank page.
 
I tried to investigate the issue further, but could not find anything.
 
My Data area is 2GB and log 1GB. Data is 34% used and log 5%. There are 4% session (9) on
the database.
 
Does this give any hint? Database is using UNICODE as required by my appliction.
 
Once the connections hangs, I am not able to open any session to the database which
includes app as well as SQL Studio.
 
During hang situation, when I refresh my 'Activity' window on DBM I see value 1 for Lock
Owner and 1 for Lock Requester.
 
Please let me know if you any further information.
 
Thanks
Rajesh

"Zabach, Elke" <elke.zabach@stripped> wrote:

Rajesh Ballal wrote:
> 
> 
> Hi,
> 
> I have a brand new installation of MaxDB 7.5.00.16 on Linux 2.4.21-4.E. My
> program executes prepared insert statements to a table. If an
> other thread executes select statements on the same table simultaneously
> the program "hangs". All connection to the db opend so far, even from
> other programs, are "dead".
> 
> If i run MaxDB on Windows it seems to work fine.
> Can someone please figureout the problem?
> 
It is hard to believe that this difference occurs because of the different OS.

I think you have to check the size of your LOG area. Is your log full and the insert
cannot go on, waiting for an admin doing a backup for log?

Or: what do you mean with 'connections are dead' ?

You know of different isolation level making parallel selects and insert on the same table
possible / not possible with/without waiting. Please see
http://dev.mysql.com/doc/maxdb/en/5e/eba664440a11d3a98200a0c9449261/frameset.htm

Do the selects go on further when your insert has stopped (meaning: the lock-wait
situation does not exist any more)?

Elke
SAP Labs Berlin

> Thanks
> 
> Rajesh
> 
> 
> 
> 
> 
> 
> ---------------------------------
> Post your free ad now! Yahoo! Canada Personals

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=1




---------------------------------
Post your free ad now! Yahoo! Canada Personals