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" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] --------------------------------- Post your free ad now! Yahoo! Canada Personals
