0

Hi,

today for the first time I get this error

Lock wait timeout exceeded; try restarting transaction

when using sentence

UPDATE info_psl SET eil_nr = eil_nr + 1 WHERE eil_nr >= 4

The table is such

CREATE TABLE IF NOT EXISTS `info_psl` (
  `psl_id` int(11) NOT NULL auto_increment,
  `pavadinimas` varchar(20) default NULL,
  `tekstas` text,
  `eil_nr` int(11) NOT NULL,
  PRIMARY KEY  (`psl_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

Never had problems using this, just made some correntions in my php file, but they should not affetct that.

I tried running this query in phpMyAdmin and of course get the same error. What should I do?

Edit: after writing this post I tested again and it works without errors :D what the hell was that? :D it would be interesting to know.

Edited by McLaren: works again

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by McLaren
0

thanks, now I don't restart, next time if I see this error, then restart

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.