(HY000): Lock wait timeout exceeded

[philippe rudnicki]

Hi All,

I am MySQL newbie with no DBA skills at all - Bad start already !!!
No seriously, any help is more than welcome , please see below :



mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0

Connection id: 1310
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.45-community-log MySQL Community Edition (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 9 days 7 hours 44 min 7 sec

Threads: 2 Questions: 374174 Slow queries: 26489 Opens: 11094 Flush tables: 1 Open tables: 64 Queries per second avg: 0.465


mysql> describe hardware;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| DEVICEID | varchar(255) | NO | PRI | | |
| NAME | varchar(255) | YES | MUL | NULL | |
| WORKGROUP | varchar(255) | YES | | NULL | |
| COMMUNITY | varchar(255) | YES | | NULL | |
| OSNAME | varchar(255) | YES | | NULL | |
| OSVERSION | varchar(255) | YES | | NULL | |
| OSCOMMENTS | varchar(255) | YES | | NULL | |
| PROCESSORT | varchar(255) | YES | | NULL | |
| processorS | varchar(11) | YES | | NULL | |
| PROCESSORN | smallint(6) | YES | | NULL | |
| MEMORY | int(11) | YES | | NULL | |
| SWAP | int(11) | YES | | NULL | |
| IPADDR | varchar(255) | YES | | NULL | |
| ETIME | datetime | YES | | NULL | |
| LASTDATE | datetime | YES | | NULL | |
| LASTCOME | datetime | YES | | NULL | |
| QUALITY | decimal(4,3) | YES | | 0.000 | |
| FIDELITY | bigint(20) | YES | | 1 | |
| USERID | varchar(255) | YES | | NULL | |
| TYPE | int(11) | YES | | NULL | |
| DESCRIPTION | varchar(255) | YES | | NULL | |
| WINCOMPANY | varchar(255) | YES | | NULL | |
| WINOWNER | varchar(255) | YES | | NULL | |
| WINPRODID | varchar(255) | YES | | NULL | |
| WINPRODKEY | varchar(255) | YES | | NULL | |
| USERAGENT | varchar(50) | YES | | NULL | |
| CHECKSUM | int(11) | YES | MUL | 131071 | |
| STATUS | varchar(200) | YES | | NULL | |
| LOCATION | varchar(200) | YES | | NULL | |
| COST_CENTER | varchar(200) | YES | | NULL | |
| REFERENCE | varchar(80) | YES | | NULL | |
| MAINTENANCE | varchar(200) | YES | | NULL | |
| PROVIDER | varchar(200) | YES | | NULL | |
| PROVIDERID | varchar(200) | YES | | NULL | |
| BUSINESSRELEVANCE | varchar(200) | YES | | NULL | |
| BACKUPINFORMATIONS | varchar(200) | YES | | NULL | |
| NOTES | varchar(200) | YES | | NULL | |
| PURCHASE_DATE | date | YES | | NULL | |
| NETWORK_PLUG | varchar(200) | YES | | NULL | |
| INFOUPDATED | varchar(200) | YES | | NULL | |
| TIMESTAMP | varchar(200) | YES | | NULL | |
| TYPE_HARDWARE | varchar(80) | YES | | NULL | |
| MODEL | varchar(200) | YES | | NULL | |
| SN | varchar(100) | YES | | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
45 rows in set (0.01 sec)

mysql> insert into hardware (NAME) values ('AAAA');
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction