Announcement

Collapse
No announcement yet.

DB error - Lock wait timeout exceeded

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DB error - Lock wait timeout exceeded

    Hi ,

    I have this DB error :

    Code:
    Database error in vBulletin 4.2.2:
    Code:
    Invalid SQL:
    
    SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread
    LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE forumid IN (3,8,9,72,124,144,81,178,65) ORDER BY lastpost DESC LIMIT 0, 10;
    
    MySQL Error   : Lock wait timeout exceeded; try restarting transaction
    Error Number  : 1205


    our server my.cnf file :

    Code:
    [mysqld]
    tmpdir = /tmp
    # skip-networking
    local-infile = 0
    back_log = 100
    #skip-innodb
    #innodb=OFF
    max_connections = 500
    key_buffer_size = 2048M
    myisam_sort_buffer_size = 256M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 2M
    read_buffer_size = 2M
    sort_buffer_size = 4M
    table_definition_cache = 8000
    table_open_cache = 8000
    thread_cache_size = 256
    wait_timeout = 120
    interactive_timeout = 60
    connect_timeout = 10
    tmp_table_size = 512M
    max_heap_table_size = 256M
    max_allowed_packet = 64M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 1M
    bulk_insert_buffer_size = 8M
    query_cache_limit = 8M
    query_cache_size = 128M
    query_cache_type = 1
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    range_alloc_block_size = 4096
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    max_write_lock_count = 4
    lock_wait_timeout=100
    
    # mysql 5.5 specific
    innodb_buffer_pool_instances=2
    innodb_file_per_table = 0
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 1024M
    innodb_additional_mem_pool_size = 32M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 5M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 8
    innodb_lock_wait_timeout=50
    
    innodb_io_capacity = 200
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    long_query_time=1
    slow_query_log=0
    slow_query_log_file=/var/log/slow_qurey_log
    
    open_files_limit=6140
    [mysqld_safe]
    nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 64M
    
    [myisamchk]
    key_buffer_size = 2048M
    sort_buffer_size = 1M
    read_buffer_size = 1M
    write_buffer_size = 1M
    
    [mysqlhotcopy]
    interactive-timeout


    Any help and suggestion would be great.

    thanks



  • #2
    Please try the following:

    1. To disable the plugin/hook system completely, edit includes/config.php and add the following code:
    Just below
    <?php
    enter
    define('DISABLE_HOOKS', true);

    2. Now go to AdminCP > Style Manager
    and create a new style with no parent.
    Now browse your forum using this new style.

    Does the problem still occur?
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.2 Demo
    AdminAmmo - My Cloud Demo

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X