gzumaglini
New Member
Hallo Leute,
Habe ein Problem mit meinem Root-Server (1&1), MySQL schmiert hier unerklärlicherweise ab. Das tritt hier im Zusammenspiel mit Magento auf.
System:
openSUSE 10.3 (64-Bit)
PHP Version 5.2.8
Apache 2.2.4
MySQL 5.0.67
Meldung im Browser:
Meldung auf der Konsole:
my.cnf:
MOD: Bitte [noparse]
[/noparse]-Tags um Ausgaben, Code, etc. verwenden (im Editor auch mit '#' erreichbar). Danke!
Kann mir da jemand einen Tipp geben?
Vielen Dank!
Habe ein Problem mit meinem Root-Server (1&1), MySQL schmiert hier unerklärlicherweise ab. Das tritt hier im Zusammenspiel mit Magento auf.
System:
openSUSE 10.3 (64-Bit)
PHP Version 5.2.8
Apache 2.2.4
MySQL 5.0.67
Meldung im Browser:
Code:
General error: 2013 Lost connection to MySQL server during query
Meldung auf der Konsole:
Code:
# *** glibc detected *** /usr/sbin/mysqld: double free or corruption (!prev): 0x0000000002345250 ***
======= Backtrace: =========
/lib64/libc.so.6[0x7fd2dd18321d]
/lib64/libc.so.6(cfree+0x76)[0x7fd2dd184f76]
/usr/sbin/mysqld[0x5dad5c]
/usr/sbin/mysqld[0x5daf1b]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x49e)[0x5e328e]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP 18st_select_lex_unitP13st_select_lex+0x19b)[0x5e50eb]
/usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x153)[0x5e5a53]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3eb)[0x59046b]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x1cc)[0x59584c]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe1f)[0x59674f]
/usr/sbin/mysqld(handle_one_connection+0x719)[0x5977f9]
/lib64/libpthread.so.0[0x7fd2de01a020]
/lib64/libc.so.6(clone+0x6d)[0x7fd2dd1da28d]
======= Memory map: ========
00400000-009c2000 r-xp 00000000 09:05 9112826 /usr/sbin/mysqld
00bc2000-00c17000 r--p 005c2000 09:05 9112826 /usr/sbin/mysqld
00c17000-00c6f000 rw-p 00617000 09:05 9112826 /usr/sbin/mysqld
00c6f000-02453000 rw-p 00c6f000 00:00 0 [heap]
40102000-40103000 ---p 40102000 00:00 0
40103000-40903000 rw-p 40103000 00:00 0
40b38000-40b39000 ---p 40b38000 00:00 0
40b39000-40b79000 rw-p 40b39000 00:00 0
40d1a000-40d1b000 ---p 40d1a000 00:00 0
40d1b000-4151b000 rw-p 40d1b000 00:00 0
4151b000-4151c000 ---p 4151b000 00:00 0
4151c000-41d1c000 rw-p 4151c000 00:00 0
41d1c000-41d1d000 ---p 41d1c000 00:00 0
41d1d000-41d5d000 rw-p 41d1d000 00:00 0
41f17000-41f18000 ---p 41f17000 00:00 0
41f18000-42718000 rw-p 41f18000 00:00 0
42718000-42719000 ---p 42718000 00:00 0
42719000-42f19000 rw-p 42719000 00:00 0
42f19000-42f1a000 ---p 42f19000 00:00 0
42f1a000-4371a000 rw-p 42f1a000 00:00 0
4371a000-4371b000 ---p 4371a000 00:00 0
4371b000-43f1b000 rw-p 4371b000 00:00 0
43f1b000-43f1c000 ---p 43f1b000 00:00 0
43f1c000-4471c000 rw-p 43f1c000 00:00 0
7fd2dbb23000-7fd2dbd28000 rw-p 7fd2dbb23000 00:00 0
7fd2dc038000-7fd2dcaf7000 rw-p 7fd2dc038000 00:00 0
7fd2dcaf7000-7fd2dcb01000 r-xp 00000000 09:01 20 /lib64/libnss_files-2.6.1.so
7fd2dcb01000-7fd2dcd00000 ---p 0000a000 09:01 20 /lib64/libnss_files-2.6.1.so
7fd2dcd00000-7fd2dcd02000 rw-p 00009000 09:01 20 /lib64/libnss_files-2.6.1.so
7fd2dcd02000-7fd2dcd0b000 r-xp 00000000 09:01 113 /lib64/libnss_nis-2.6.1.so
7fd2dcd0b000-7fd2dcf0b000 ---p 00009000 09:01 113 /lib64/libnss_nis-2.6.1.so
7fd2dcf0b000-7fd2dcf0d000 rw-p 00009000 09:01 113 /lib64/libnss_nis-2.6.1.so
7fd2dcf0d000-7fd2dcf14000 r-xp 00000000 09:01 116 /lib64/libnss_compat-2.6.1.so
7fd2dcf14000-7fd2dd113000 ---p 00007000 09:01 116 /lib64/libnss_compat-2.6.1.so
7fd2dd113000-7fd2dd115000 rw-p 00006000 09:01 116 /lib64/libnss_compat-2.6.1.so
7fd2dd115000-7fd2dd251000 r-xp 00000000 09:01 149 /lib64/libc-2.6.1.so
7fd2dd251000-7fd2dd451000 ---p 0013c000 09:01 149 /lib64/libc-2.6.1.so
7fd2dd451000-7fd2dd454000 r--p 0013c000 09:01 149 /lib64/libc-2.6.1.so
7fd2dd454000-7fd2dd456000 rw-p 0013f000 09:01 149 /lib64/libc-2.6.1.so
7fd2dd456000-7fd2dd45b000 rw-p 7fd2dd456000 00:00 0
7fd2dd45b000-7fd2dd468000 r-xp 00000000 09:01 172 /lib64/libgcc_s.so.1
7fd2dd468000-7fd2dd667000 ---p 0000d000 09:01 172 /lib64/libgcc_s.so.1
7fd2dd667000-7fd2dd669000 rw-p 0000c000 09:01 172 /lib64/libgcc_s.so.1
7fd2dd669000-7fd2dd6bb000 r-xp 00000000 09:01 18 /lib64/libm-2.6.1.so
7fd2dd6bb000-7fd2dd8ba000 ---p 00052000 09:01 18 /lib64/libm-2.6.1.so
7fd2dd8ba000-7fd2dd8bc000 rw-p 00051000 09:01 18 /lib64/libm-2.6.1.so
7fd2dd8bc000-7fd2dd9a8000 r-xp 00000000 09:05 13343372 /usr/lib64/libstdc++.so.6.0.9
7fd2dd9a8000-7fd2ddba8000 ---p 000ec000 09:05 13343372 /usr/lib64/libstdc++.so.6.0.9
7fd2ddba8000-7fd2ddbae000 r--p 000ec000 09:05 13343372 /usr/lib64/libstdc++.so.6.0.9
7fd2ddbae000-7fd2ddbb1000 rw-p 000f2000 09:05 13343372 /usr/lib64/libstdc++.so.6.0.9
7fd2ddbb1000-7fd2ddbc4000 rw-p 7fd2ddbb1000 00:00 0
7fd2ddbc4000-7fd2ddbd8000 r-xp 00000000 09:01 101 /lib64/libnsl-2.6.1.so
7fd2ddbd8000-7fd2dddd7000 ---p 00014000 09:01 101 /lib64/libnsl-2.6.1.so
7fd2dddd7000-7fd2dddd9000 rw-p 00013000 09:01 101 /lib64/libnsl-2.6.1.so
7fd2dddd9000-7fd2ddddb000 rw-p 7fd2dddd9000 00:00 0
7fd2ddddb000-7fd2ddde3000 r-xp 00000000 09:01 112 /lib64/libcrypt-2.6.1.so
7fd2ddde3000-7fd2ddfe3000 ---p 00008000 09:01 112 /lib64/libcrypt-2.6.1.so
7fd2ddfe3000-7fd2ddfe6000 rw-p 00008000 09:01 112 /lib64/libcrypt-2.6.1.so
7fd2ddfe6000-7fd2de014000 rw-p 7fd2ddfe6000 00:00 0
7fd2de014000-7fd2de029000 r-xp 00000000 09:01 118 /lib64/libpthread-2.6.1.so
7fd2de029000-7fd2de229000 ---p 00015000 09:01 118 /lib64/libpthread-2.6.1.so
7fd2de229000-7fd2de22b000 rw-p 00015000 09:01 118 /lib64/libpthread-2.6.1.so
7fd2de22b000-7fd2de22f000 rw-p 7fd2de22b000 00:00 0
7fd2de22f000-7fd2de231000 r-xp 00000000 09:01 132 /lib64/libdl-2.6.1.so
7fd2de231000-7fd2de431000 ---p 00002000 09:01 132 /lib64/libdl-2.6.1.so
7fd2de431000-7fd2de433000 rw-p 00002000 09:01 132 /lib64/libdl-2.6.1.so
7fd2de433000-7fd2de43b000 r-xp 00000000 09:01 144 /lib64/libwrap.so.0.7.6
7fd2de43b000-7fd2de63a000 ---p 00008000 09:01 144 /lib64/libwrap.so.0.7.6
7fd2de63a000-7fd2de63c000 rw-p 00007000 09:01 144 /lib64/libwrap.so.0.7.6
7fd2de63c000-7fd2de63d000 rw-p 7fd2de63c000 00:00 0
7fd2de63d000-7fd2de651000 r-xp 00000000 09:01 25 /lib64/libz.so.1.2.3
7fd2de651000-7fd2de850000 ---p 00014000 09:01 25 /lib64/libz.so.1.2.3
7fd2de850000-7fd2de852000 rw-p 00013000 09:01 25 /lib64/libz.so.1.2.3
7fd2de852000-7fd2de85a000 r-xp 00000000 09:01 148 /lib64/librt-2.6.1.so
7fd2de85a000-7fd2dea59000 ---p 00008000 09:01 148 /lib64/librt-2.6.1.so
7fd2dea59000-7fd2dea5b000 rw-p 00007000 09:01 148 /lib64/librt-2.6.1.so
7fd2dea5b000-7fd2dea77000 r-xp 00000000 09:01 176 /lib64/ld-2.6.1.so
7fd2dea7b000-7fd2dec6e000 rw-p 7fd2dea7b000 00:00 0
7fd2dec70000-7fd2dec76000 rw-p 7fd2dec70000 00:00 0
7fd2dec76000-7fd2dec78000 rw-p 0001b000 09:01 176 /lib64/ld-2.6.1.so
7fffe6c62000-7fffe6c77000 rw-p 7ffffffea000 00:00 0 [stack]
7fffe6dfe000-7fffe6dff000 r-xp 7fffe6dfe000 00:00 0 [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
my.cnf:
Code:
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
[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
server-id = 1
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[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
[mysqlhotcopy]
interactive-timeout
Code:
...
Kann mir da jemand einen Tipp geben?
Vielen Dank!
Last edited by a moderator: