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.

Restart the mysql server.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.