MySQL commands: Difference between revisions

Jump to navigation Jump to search
341 bytes added ,  23 November 2017
+ERROR 1205: Lock wait timeout exceeded; try restarting transaction
No edit summary
(+ERROR 1205: Lock wait timeout exceeded; try restarting transaction)
Line 227: Line 227:
Possible solution
Possible solution
* Because the partition is full or almost full, free some hard-disk space<ref>[http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full mysql - ERROR 1114 (HY000): The table is full - Stack Overflow]</ref>.
* Because the partition is full or almost full, free some hard-disk space<ref>[http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full mysql - ERROR 1114 (HY000): The table is full - Stack Overflow]</ref>.
==== ERROR 1205: Lock wait timeout exceeded; try restarting transaction ====
Solution: [https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im mysql - Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction - Stack Overflow]


==== ERROR 1206: The total number of locks exceeds the lock table size ====
==== ERROR 1206: The total number of locks exceeds the lock table size ====

Navigation menu