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 |
+-------------------------------------------------------------------+
