Lock wait timeout error

--0016e647ecfc1feae804696219f6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Here is the table structure.

CREATE TABLE `UP_UserEx` (
`UserId` INT(11) NOT NULL,
`UserNationality` CHAR(2) NOT NULL DEFAULT '',
`UserProvince` CHAR(2) NOT NULL DEFAULT '',
`UserCity` CHAR(4) NOT NULL DEFAULT '',
`HomePhone` VARCHAR(32) NOT NULL DEFAULT '',
`WorkPhone` VARCHAR(32) NOT NULL DEFAULT '',
`OtherPhone` VARCHAR(32) NOT NULL DEFAULT '',
`PersonalEmail` VARCHAR(64) NOT NULL DEFAULT '',
`WorkEmail` VARCHAR(64) NOT NULL DEFAULT '',
`OtherEmail` VARCHAR(64) NOT NULL DEFAULT '',
`PrimaryEmail` SMALLINT(6) NOT NULL DEFAULT '0',
`Company` VARCHAR(128) NOT NULL DEFAULT '',
`CompanyWebsite` VARCHAR(128) NOT NULL DEFAULT '',
`Occupation` VARCHAR(64) NOT NULL DEFAULT '',
`JobTitle` VARCHAR(64) NOT NULL DEFAULT '',
`Interest` VARCHAR(128) NOT NULL DEFAULT '',
`Profile` VARCHAR(256) NOT NULL DEFAULT '',
`Phrases` LONGTEXT NOT NULL,
`LunarAnimal` SMALLINT(6) NOT NULL DEFAULT '0',
`Horoscope` SMALLINT(6) NOT NULL DEFAULT '0',
`BloodType` SMALLINT(6) NOT NULL DEFAULT '0',
`ReservedFlag` INT(11) NOT NULL DEFAULT '0',
`ReservedXml` LONGTEXT,
PRIMARY KEY (`UserId`)
) ENGINE=INNODB DEFAULT CHARSET=utf8

The lock table timeout error display when I use the following statement.
UPDATE UP_UserEx SET Phrases ='' WHERE UserID = 1;

I don't know why?
Thanks for your patient read.

--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog.cn
Comanpy: http://www.actionsky.com

--0016e647ecfc1feae804696219f6--