Hi I recently upgraded to 7.5 to 7.3 and now experience the following problem which did not occur on the older version:
I have an insert statement that inserts about 10,000 rows into a single database table. The batch takes about 70 minutes or so to run over JDBC using a single transaction which I commit at the end. While this batch is running, I am unable to insert any other data into the database and get "[500]: Lock request timeout" errors. These other inserts are running from a different client machine and are not even trying to enter data into the same table as the batch. I believe I have ruled out a simple problem of row locking as if I run the batch as a different user (and schema) on the same instance, I still get the problem, but if I run the batch on a different instance on the same physical machine, I don't. Does anybody have any idea what may be blocking the insertion of data in this way? Thanks Ashley Hollands XSDI Limited [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
