• Resolved friendlyblogger

    (@friendlyblogger)


    Hello,

    I know what you think: Another “Error establishing a database connection” thread. Well yes, but mine seems to be different and even after hours of research I couldn’t find someone who had the same problem.

    Anyways, let me tell you about my issue.

    I’ve upgraded my dedicated server and I’m now on a 2 x 2.8 Ghz AMD Opteron(tm) Processor with 4GB of Ram. I think that should be enough to run a wordpress blog.
    And my blog usually runs without a problem.
    However, I’ve noticed that i get the infamous “Error establishing a database connection” when DOUBLE CLICKING or repeatedly (3-5 times) clicking on a blog entry. Ok, I admit that’s not the way to navigate the internet. I discovered it by accident and as you can imagine it really bothers me. I’m pretty sure it would also happen when single clicking on a post, if only enough people were doing it at the same time.

    So, what to do now? I’m no expert, but I’m pretty sure it is somehow related to my MySQL setup. When I click on a post to show the entire entry, wordpress hits my database and gets the record. When double (or even more times) clicking it submits the query several times and then shows me this error. Then I can simply navigate back and the site loads just fine. Weird isn’t it?

    I tried editing my.cnf and give MySQL more resources, but that didn’t change a thing. I’d really appreciate, if someone had an idea. Thanks in advance.

    Irony: I didn’t have this problem on my old 2 Ghz single CPU with 512 MB Ram server πŸ™‚

Viewing 4 replies - 1 through 4 (of 4 total)
  • I thought I remembered something recently (of course I can’t find it now) where someone had a database connection problem and it was related to permalinks or their .htaccess file. So might delete any .htaccess and visit Administration > Settings > Permalinks and update your permalinks.

    If that doesn’t do it might also look at deactivating plugins and switching to the WordPress Default theme.

    Thread Starter friendlyblogger

    (@friendlyblogger)

    Hi, thanks for your reply.

    I tried what you suggested (updated permalinks and stuff). However, it didn’t solve my problem. I even installed a brand new copy (default theme, no plugins) of wordpress on my server, but the problem persists.

    Possible, there is a bug in the MySQL version I’m using? – MySQL 5.0.42

    Today, I noticed something very interesting. When I force this error by repeatedly clicking on a link, I can see this in console:

    *** glibc detected *** /usr/sbin/mysqld: free(): invalid pointer: 0x00000000011edf50 ***
    ======= Backtrace: =========
    /lib64/libc.so.6[0x7f18ca90421d]
    /lib64/libc.so.6(cfree+0x76)[0x7f18ca905f76]
    /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECTD0Ev+0x65)[0x61dc25]
    /usr/sbin/mysqld[0x5d39dc]
    /usr/sbin/mysqld[0x5d3ba6]
    /usr/sbin/mysqld(_ZN4JOIN4execEv+0x484)[0x5dc4f4]
    /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_select_lex+0x188)[0x5de478]
    /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x153)[0x5dee53]
    /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x13d3)[0x58bf33]
    /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x19d)[0x59020d]
    /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xcf3)[0x591003]
    /usr/sbin/mysqld(_Z10do_commandP3THD+0xb6)[0x591a66]
    /usr/sbin/mysqld(handle_one_connection+0x653)[0x592203]
    /lib64/libpthread.so.0[0x7f18cb79b020]
    /lib64/libc.so.6(clone+0x6d)[0x7f18ca95b28d]
    ======= Memory map: ========
    00400000-009b6000 r-xp 00000000 09:05 9130033                            /usr/sbin/mysqld
    00bb5000-00c07000 r--p 005b5000 09:05 9130033                            /usr/sbin/mysqld
    00c07000-00c5f000 rw-p 00607000 09:05 9130033                            /usr/sbin/mysqld
    00c5f000-0130c000 rw-p 00c5f000 00:00 0                                  [heap]
    4067e000-4067f000 ---p 4067e000 00:00 0
    4067f000-40e7f000 rw-p 4067f000 00:00 0
    40e7f000-40e80000 ---p 40e7f000 00:00 0
    40e80000-41680000 rw-p 40e80000 00:00 0
    41680000-41681000 ---p 41680000 00:00 0
    41681000-41e81000 rw-p 41681000 00:00 0
    41e81000-41e82000 ---p 41e81000 00:00 0
    41e82000-42682000 rw-p 41e82000 00:00 0
    42682000-42683000 ---p 42682000 00:00 0
    42683000-42e83000 rw-p 42683000 00:00 0
    42e83000-42e84000 ---p 42e83000 00:00 0
    42e84000-43684000 rw-p 42e84000 00:00 0
    43684000-43685000 ---p 43684000 00:00 0
    43685000-43e85000 rw-p 43685000 00:00 0
    43e85000-43e86000 ---p 43e85000 00:00 0
    43e86000-44686000 rw-p 43e86000 00:00 0
    44686000-44687000 ---p 44686000 00:00 0
    44687000-446c7000 rw-p 44687000 00:00 0
    446c7000-446c8000 ---p 446c7000 00:00 0
    446c8000-44708000 rw-p 446c8000 00:00 0
    7f18891a3000-7f18a93a9000 rw-p 7f18891a3000 00:00 0
    7f18a96b9000-7f18ca278000 rw-p 7f18a96b9000 00:00 0
    7f18ca278000-7f18ca282000 r-xp 00000000 09:01 92960                      /lib64/libnss_files-2.6.1.so
    7f18ca282000-7f18ca481000 ---p 0000a000 09:01 92960                      /lib64/libnss_files-2.6.1.so
    7f18ca481000-7f18ca483000 rw-p 00009000 09:01 92960                      /lib64/libnss_files-2.6.1.so
    7f18ca483000-7f18ca48c000 r-xp 00000000 09:01 93053                      /lib64/libnss_nis-2.6.1.so
    7f18ca48c000-7f18ca68c000 ---p 00009000 09:01 93053                      /lib64/libnss_nis-2.6.1.so
    7f18ca68c000-7f18ca68e000 rw-p 00009000 09:01 93053                      /lib64/libnss_nis-2.6.1.so
    7f18ca68e000-7f18ca695000 r-xp 00000000 09:01 93056                      /lib64/libnss_compat-2.6.1.so
    7f18ca695000-7f18ca894000 ---p 00007000 09:01 93056                      /lib64/libnss_compat-2.6.1.so
    7f18ca894000-7f18ca896000 rw-p 00006000 09:01 93056                      /lib64/libnss_compat-2.6.1.so
    7f18ca896000-7f18ca9d2000 r-xp 00000000 09:01 93089                      /lib64/libc-2.6.1.so
    7f18ca9d2000-7f18cabd2000 ---p 0013c000 09:01 93089                      /lib64/libc-2.6.1.so
    7f18cabd2000-7f18cabd5000 r--p 0013c000 09:01 93089                      /lib64/libc-2.6.1.so
    7f18cabd5000-7f18cabd7000 rw-p 0013f000 09:01 93089                      /lib64/libc-2.6.1.so
    7f18cabd7000-7f18cabdc000 rw-p 7f18cabd7000 00:00 0
    7f18cabdc000-7f18cabe9000 r-xp 00000000 09:01 93112                      /lib64/libgcc_s.so.1
    7f18cabe9000-7f18cade8000 ---p 0000d000 09:01 93112                      /lib64/libgcc_s.so.1
    7f18cade8000-7f18cadea000 rw-p 0000c000 09:01 93112                      /lib64/libgcc_s.so.1
    7f18cadea000-7f18cae3c000 r-xp 00000000 09:01 92958                      /lib64/libm-2.6.1.so
    7f18cae3c000-7f18cb03b000 ---p 00052000 09:01 92958                      /lib64/libm-2.6.1.so
    7f18cb03b000-7f18cb03d000 rw-p 00051000 09:01 92958                      /lib64/libm-2.6.1.so
    7f18cb03d000-7f18cb129000 r-xp 00000000 09:05 13254671                   /usr/lib64/libstdc++.so.6.0.9
    7f18cb129000-7f18cb329000 ---p 000ec000 09:05 13254671                   /usr/lib64/libstdc++.so.6.0.9
    7f18cb329000-7f18cb32f000 r--p 000ec000 09:05 13254671                   /usr/lib64/libstdc++.so.6.0.9
    7f18cb32f000-7f18cb332000 rw-p 000f2000 09:05 13254671                   /usr/lib64/libstdc++.so.6.0.9
    7f18cb332000-7f18cb345000 rw-p 7f18cb332000 00:00 0
    7f18cb345000-7f18cb359000 r-xp 00000000 09:01 93041                      /lib64/libnsl-2.6.1.so
    7f18cb359000-7f18cb558000 ---p 00014000 09:01 93041                      /lib64/libnsl-2.6.1.so
    7f18cb558000-7f18cb55a000 rw-p 00013000 09:01 93041                      /lib64/libnsl-2.6.1.so
    7f18cb55a000-7f18cb55c000 rw-p 7f18cb55a000 00:00 0
    7f18cb55c000-7f18cb564000 r-xp 00000000 09:01 93052                      /lib64/libcrypt-2.6.1.so
    7f18cb564000-7f18cb764000 ---p 00008000 09:01 93052                      /lib64/libcrypt-2.6.1.so
    7f18cb764000-7f18cb767000 rw-p 00008000 09:01 93052                      /lib64/libcrypt-2.6.1.so
    7f18cb767000-7f18cb795000 rw-p 7f18cb767000 00:00 0
    7f18cb795000-7f18cb7aa000 r-xp 00000000 09:01 93058                      /lib64/libpthread-2.6.1.so
    7f18cb7aa000-7f18cb9aa000 ---p 00015000 09:01 93058                      /lib64/libpthread-2.6.1.so
    7f18cb9aa000-7f18cb9ac000 rw-p 00015000 09:01 93058                      /lib64/libpthread-2.6.1.so
    7f18cb9ac000-7f18cb9b0000 rw-p 7f18cb9ac000 00:00 0
    7f18cb9b0000-7f18cb9b2000 r-xp 00000000 09:01 93072                      /lib64/libdl-2.6.1.so
    7f18cb9b2000-7f18cbbb2000 ---p 00002000 09:01 93072                      /lib64/libdl-2.6.1.so
    7f18cbbb2000-7f18cbbb4000 rw-p 00002000 09:01 93072                      /lib64/libdl-2.6.1.so
    7f18cbbb4000-7f18cbbbc000 r-xp 00000000 09:01 93084                      /lib64/libwrap.so.0.7.6
    7f18cbbbc000-7f18cbdbb000 ---p 00008000 09:01 93084                      /lib64/libwrap.so.0.7.6
    7f18cbdbb000-7f18cbdbd000 rw-p 00007000 09:01 93084                      /lib64/libwrap.so.0.7.6
    7f18cbdbd000-7f18cbdbe000 rw-p 7f18cbdbd000 00:00 0
    7f18cbdbe000-7f18cbdd2000 r-xp 00000000 09:01 92965                      /lib64/libz.so.1.2.3
    7f18cbdd2000-7f18cbfd1000 ---p 00014000 09:01 92965                      /lib64/libz.so.1.2.3
    7f18cbfd1000-7f18cbfd3000 rw-p 00013000 09:01 92965                      /lib64/libz.so.1.2.3
    7f18cbfd3000-7f18cbfdb000 r-xp 00000000 09:01 93088                      /lib64/librt-2.6.1.so
    7f18cbfdb000-7f18cc1da000 ---p 00008000 09:01 93088                      /lib64/librt-2.6.1.so
    7f18cc1da000-7f18cc1dc000 rw-p 00007000 09:01 93088                      /lib64/librt-2.6.1.so
    7f18cc1dc000-7f18cc1f8000 r-xp 00000000 09:01 93116                      /lib64/ld-2.6.1.so
    7f18cc2c1000-7f18cc3ee000 rw-p 7f18cc2c1000 00:00 0
    7f18cc3f5000-7f18cc3f7000 rw-p 7f18cc3f5000 00:00 0
    7f18cc3f7000-7f18cc3f9000 rw-p 0001b000 09:01 93116                      /lib64/ld-2.6.1.so
    7fffd43e3000-7fffd43f8000 rw-p 7ffffffea000 00:00 0                      [stack]
    7fffd43fe000-7fffd43ff000 r-xp 7fffd43fe000 00:00 0                      [vdso]
    ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]

    Let me also share two different versions of my.cnf with you. Maybe you can find something in there, that might cause my problem.

    my.cnf – default version:

    # The MySQL server
    [mysqld]
    set-variable=local-infile=0
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 16M
    max_allowed_packet = 1M
    table_cache = 64
    sort_buffer_size = 512K
    net_buffer_length = 8K
    read_buffer_size = 256K
    read_rnd_buffer_size = 512K
    myisam_sort_buffer_size = 8M
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [isamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M
    
    [myisamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    Modified version of my.cnf:

    # The MySQL server
    [mysqld]
    set-variable=local-infile=0
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 512M
    max_allowed_packet = 16M
    max_connections = 1000
    max_connect_errors = 9999999
    table_cache = 5000
    binlog_cache_size = 1M
    max_heap_table_size = 128M
    sort_buffer_size = 32M
    join_buffer_size = 32M
    thread_cache_size = 100
    thread_concurrency = 16
    query_cache_size = 512M
    query_cache_limit = 8M
    query_cache_min_res_unit = 2K
    tmp_table_size = 384M
    net_buffer_length = 8K
    read_buffer_size = 32M
    read_rnd_buffer_size = 32M
    myisam_sort_buffer_size = 8M
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [isamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M
    
    [myisamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    It doesn’t seem to matter what version of my.cnf I’m using. The problem persists.

    Thread Starter friendlyblogger

    (@friendlyblogger)

    Alright, I solved it the “rough” way. Did a complete new setup of my system (updated OS and updated mysql) and now it works.

    I got same problem with you. But how i can find that file
    my hosting on hostgator

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘“Error establishing a database connection” – Different than usual!’ is closed to new replies.