Re: Lock wait timeout exceeded; try restarting transaction

[Harshdeep Khatri]

First of all thanks Rick for your kind interest.

Please collect the information that has been asked....

CREATE TABLE `cfidentity` (
`tablename` VARCHAR(255) NOT NULL,
`lastunkid` BIGINT(20) UNSIGNED NOT NULL,
`hotel_code` INT(11) DEFAULT NULL,
KEY `primary_idx_cgindetity` (`tablename`,`hotel_code`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Primary Key Table';

yes, I am confirming that there is a possibility of long running select, but surely it is not intended for this table.

by default autocommit is true whenever needed in some of SP i have used begin commit.

almost all tables are Innodb except where I am sure there is no need of Innodb.