friendlyblogger
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: “Error establishing a database connection” – Different than usual!Alright, I solved it the “rough” way. Did a complete new setup of my system (updated OS and updated mysql) and now it works.
Forum: Fixing WordPress
In reply to: “Error establishing a database connection” – Different than usual!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 = 2MModified 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 = 2MIt doesn’t seem to matter what version of my.cnf I’m using. The problem persists.