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]
