Tony Leake wrote:
Hi,
I have a query:
UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid =
100000798
intOrderUid is the primary key
There are 25 columns in the table and a further 8 of these have indexes
on them. The table is innodb
I have just tried to run the above query 3 times and i got the follwing
error
Invalid Query Lock wait timeout exceeded; try restarting transaction
- try using SHOW INNODB STATUS. That will give you more info on table locks.
- ian
--
+-------------------------------------------------------------------+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer http://www.ebuyer.com |
+-------------------------------------------------------------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
