From: Date: October 4 2004 3:02pm
Subject: AW: MaxDB Hang on simultaneous connections
List-Archive: http://lists.mysql.com/maxdb/23429
Message-Id: <235EE6AC8AE9264CBF763FC6749E270105F737@dewdfe22.wdf.sap.corp>
MIME-Version: 1.0
Content-Type: text/plain


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