List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:May 8 2009 8:05am
Subject:Lock wait timeout error
View as plain text  
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

Thread
Lock wait timeout errorMoon's Father8 May