vb.org Archive - MySQL Error: Lock wait timeout exceeded

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - MySQL Error: Lock wait timeout exceeded (https://vborg.vbsupport.ru/showthread.php?t=250145)

milleniumstudio

09-08-2010 10:07 AM

MySQL Error: Lock wait timeout exceeded

I have vBulletin 4.0.3 on MySQL 5.0.32 and sometimes get these errors:

Quote:

Database error in vBulletin 4.0.3:

Invalid SQL:

REPLACE INTO vb_searchlog
(userid,ipaddress,searchhash,sortby,sortorder,sear chtime,dateline,completed,criteria,results)
VALUES
(...)

MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : (...)
Error Date : (...)
Script : /search.php?do=getnew&contenttype=vBForum_Post
Referrer : (...)
IP Address : (...)
Username : (...)
Classname : vB_Database_MySQLi
MySQL Version :

What's the cause and to solve them?

Marco van Herwaarden

09-08-2010 10:55 AM

What is the "innodb_lock_wait_timeout" set to in the MySQL config?

Videx

09-09-2010 02:19 AM

And can we assume the CPU loads around the times of the errors are acceptable? Is this shared hosting?

milleniumstudio

09-09-2010 08:37 AM

innodb_lock_wait_timeout is set to 50. The average total queries per second is 34. Do you think increasing timeout will do?

Marco van Herwaarden

09-09-2010 10:34 AM

Should already be enough. Most likely another process locking things up. Try to get a innodb ststus when this happens.

All times are GMT. The time now is 07:21 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01169 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: