(HY000): Lock wait timeout exceeded
Posted by: philippe rudnicki
Date: August 31, 2007 09:14AM
Date: August 31, 2007 09:14AM
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
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
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.