sry, I mean innodb_lock_wait_timeout = 20. lock_wait_timeout is not set and it contains something strange:
mysql> show variables like "%lock_w%"; +--------------------------+----------+ | Variable_name | Value | +--------------------------+----------+ | innodb_lock_wait_timeout | 120 | | lock_wait_timeout | 31536000 | +--------------------------+----------+
sry, I mean innodb_ lock_wait_ timeout = 20. lock_wait_timeout is not set and it contains something strange:
mysql> show variables like "%lock_w%"; ------- ------- ------+ ------- ---+ ------- ------- ------+ ------- ---+ lock_wait_ timeout | 120 | ------- ------- ------+ ------- ---+
+------
| Variable_name | Value |
+------
| innodb_
| lock_wait_timeout | 31536000 |
+------