Hello Andre, > We have a serious problem with sapdb version 7.4.3.31 (on SuSE-Linux) > - We have clients with long running transactions, all with > isolationlevel 1. > - Many of them do many SELECTS without commit. > - These SELECTS sometimes keep Locks, which block other > clients when they > trying to write on those tables.
It would be useful going a little into detail here, e.g. describing what kind are your SELECTs, what are the commands that are blocked and hang, and what is the content of LOCKSTATISTICS at that time. > - I was told, that these behaviour was a bug of version 7.3, > and that I should upgrade to 7.4. Those problems made your issues probably only much more worse, and showed up first. > - It seems that the problem still exists. I think the problem has the same symptoms, but is not necessarily the same ... so please send a little more information. Regards Alexander Schr�der SAP DB, SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
