Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    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.

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