090201 0:54:18 - mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=629145600 read_buffer_size=1044480 max_used_connections=4 max_connections=300 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1534797 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x1221570 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x442dffe0, backtrace may not be correct. Stack range sanity check OK, backtrace follows: (nil) New value of fp=0x1221570 failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x149e8a0 = SELECT thread.threadid FROM thread AS thread WHERE thread.forumid IN(79, 37, 47, 86, 88, 98, 100, 102, 96, 93, 38, 53, 89, 61, 54, 99, 62, 63, 64, 60, 39, 52, 45, 58, 42, 48, 46, 65, 81, 82, 83, 84, 85, 41, 50, 51, 40, 92, 55, 87, 67, 56, 71, 57, 49, 74, 75, 76, 77) AND thread.lastpost >= 1233359658 AND thread.visible IN (0,1,2) AND thread.sticky IN (0,1) AND thread.open <> 10 ORDER BY thread.lastpost DESC LIMIT 500 thd->thread_id=32 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 090201 00:54:18 mysqld restarted 090201 0:54:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090201 0:54:18 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 4292574. InnoDB: Doing recovery: scanned up to log sequence number 0 4292574 090201 0:54:18 InnoDB: Started; log sequence number 0 4292574 090201 0:54:18 [Note] /usr/sbin/mysqld: ready for connections. Version vb 3.8.1, mysql 5.0.45 Knut Müller 01.02.2009 01:51 Datenbankfehler in vBulletin 3.8.1: Invalid SQL: SELECT thread.threadid FROM thread AS thread WHERE thread.forumid IN(79, 90, 80, 91, 68, 101, 78, 97, 37, 47, 86, 88, 98, 100, 102, 96, 93, 38, 53, 89, 61, 54, 99, 62, 63, 64, 60, 39, 52, 45, 58, 42, 48, 46, 65, 81, 82, 83, 84, 85, 41, 50, 51, 40, 92, 55, 87, 67, 56, 71, 57, 49, 74, 75, 76, 77) AND thread.lastpost >= 1233363035 AND thread.visible IN (0,1,2) AND thread.sticky IN (0,1) AND thread.open <> 10 ORDER BY thread.lastpost DESC LIMIT 500; MySQL-Fehler : MySQL server has gone away Fehler-Nr. : 2006 Fehler-Zeit : Sunday, 01.02.2009 @ 01:50:35 Datum : Sunday, 01.02.2009 @ 01:50:35 Skript : http://www.tt-board.de/forum/search.php?do=getdaily Referrer : http://www.tt-board.de/portal.php IP-Adresse : 84.134.93.48 Benutzername : Klassenname : vB_Database MySQL-Version : *** glibc detected *** /usr/sbin/mysqld: munmap_chunk(): invalid pointer: 0x0000000001224ee8 *** ======= Backtrace: ========= /lib64/libc.so.6[0x7f7b5a10621d] /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[0x7f7b5af9d020] /lib64/libc.so.6(clone+0x6d)[0x7f7b5a15d28d] ======= Memory map: ======== 00400000-009b6000 r-xp 00000000 08:05 9139057 /usr/sbin/mysqld 00bb5000-00c07000 r--p 005b5000 08:05 9139057 /usr/sbin/mysqld 00c07000-00c5f000 rw-p 00607000 08:05 9139057 /usr/sbin/mysqld 00c5f000-1469a000 rw-p 00c5f000 00:00 0 [heap] 403fe000-403ff000 ---p 403fe000 00:00 0 403ff000-40bff000 rw-p 403ff000 00:00 0 40bff000-40c00000 ---p 40bff000 00:00 0 40c00000-41400000 rw-p 40c00000 00:00 0 41400000-41401000 ---p 41400000 00:00 0 41401000-41c01000 rw-p 41401000 00:00 0 41c01000-41c02000 ---p 41c01000 00:00 0 41c02000-42402000 rw-p 41c02000 00:00 0 42402000-42403000 ---p 42402000 00:00 0 42403000-42c03000 rw-p 42403000 00:00 0 42c03000-42c04000 ---p 42c03000 00:00 0 42c04000-43404000 rw-p 42c04000 00:00 0 43404000-43405000 ---p 43404000 00:00 0 43405000-43c05000 rw-p 43405000 00:00 0 43c05000-43c06000 ---p 43c05000 00:00 0 43c06000-44406000 rw-p 43c06000 00:00 0 44406000-44407000 ---p 44406000 00:00 0 44407000-44447000 rw-p 44407000 00:00 0 44447000-44448000 ---p 44447000 00:00 0 44448000-44488000 rw-p 44448000 00:00 0 44488000-44489000 ---p 44488000 00:00 0 44489000-444c9000 rw-p 44489000 00:00 0 7f7b2e1a5000-7f7b53bab000 rw-p 7f7b2e1a5000 00:00 0 7f7b53ebb000-7f7b59a7a000 rw-p 7f7b53ebb000 00:00 0 7f7b59a7a000-7f7b59a84000 r-xp 00000000 08:01 62048 /lib64/libnss_files-2.6.1.so 7f7b59a84000-7f7b59c83000 ---p 0000a000 08:01 62048 /lib64/libnss_files-2.6.1.so 7f7b59c83000-7f7b59c85000 rw-p 00009000 08:01 62048 /lib64/libnss_files-2.6.1.so 7f7b59c85000-7f7b59c8e000 r-xp 00000000 08:01 62141 /lib64/libnss_nis-2.6.1.so 7f7b59c8e000-7f7b59e8e000 ---p 00009000 08:01 62141 /lib64/libnss_nis-2.6.1.so 7f7b59e8e000-7f7b59e90000 rw-p 00009000 08:01 62141 /lib64/libnss_nis-2.6.1.so 7f7b59e90000-7f7b59e97000 r-xp 00000000 08:01 62144 /lib64/libnss_compat-2.6.1.so 7f7b59e97000-7f7b5a096000 ---p 00007000 08:01 62144 /lib64/libnss_compat-2.6.1.so 7f7b5a096000-7f7b5a098000 rw-p 00006000 08:01 62144 /lib64/libnss_compat-2.6.1.so 7f7b5a098000-7f7b5a1d4000 r-xp 00000000 08:01 62177 /lib64/libc-2.6.1.so 7f7b5a1d4000-7f7b5a3d4000 ---p 0013c000 08:01 62177 /lib64/libc-2.6.1.so 7f7b5a3d4000-7f7b5a3d7000 r--p 0013c000 08:01 62177 /lib64/libc-2.6.1.so 7f7b5a3d7000-7f7b5a3d9000 rw-p 0013f000 08:01 62177 /lib64/libc-2.6.1.so 7f7b5a3d9000-7f7b5a3de000 rw-p 7f7b5a3d9000 00:00 0 7f7b5a3de000-7f7b5a3eb000 r-xp 00000000 08:01 62200 /lib64/libgcc_s.so.1 7f7b5a3eb000-7f7b5a5ea000 ---p 0000d000 08:01 62200 /lib64/libgcc_s.so.1 7f7b5a5ea000-7f7b5a5ec000 rw-p 0000c000 08:01 62200 /lib64/libgcc_s.so.1 7f7b5a5ec000-7f7b5a63e000 r-xp 00000000 08:01 62046 /lib64/libm-2.6.1.so 7f7b5a63e000-7f7b5a83d000 ---p 00052000 08:01 62046 /lib64/libm-2.6.1.so 7f7b5a83d000-7f7b5a83f000 rw-p 00051000 08:01 62046 /lib64/libm-2.6.1.so 7f7b5a83f000-7f7b5a92b000 r-xp 00000000 08:05 13250799 /usr/lib64/libstdc++.so.6.0.9 7f7b5a92b000-7f7b5ab2b000 ---p 000ec000 08:05 13250799 /usr/lib64/libstdc++.so.6.0.9 7f7b5ab2b000-7f7b5ab31000 r--p 000ec000 08:05 13250799 /usr/lib64/libstdc++.so.6.0.9 7f7b5ab31000-7f7b5ab34000 rw-p 000f2000 08:05 13250799 /usr/lib64/libstdc++.so.6.0.9 7f7b5ab34000-7f7b5ab47000 rw-p 7f7b5ab34000 00:00 0 7f7b5ab47000-7f7b5ab5b000 r-xp 00000000 08:01 62129 /lib64/libnsl-2.6.1.so 7f7b5ab5b000-7f7b5ad5a000 ---p 00014000 08:01 62129 /lib64/libnsl-2.6.1.so 7f7b5ad5a000-7f7b5ad5c000 rw-p 00013000 08:01 62129 /lib64/libnsl-2.6.1.so 7f7b5ad5c000-7f7b5ad5e000 rw-p 7f7b5ad5c000 00:00 0 7f7b5ad5e000-7f7b5ad66000 r-xp 00000000 08:01 62140 /lib64/libcrypt-2.6.1.so 7f7b5ad66000-7f7b5af66000 ---p 00008000 08:01 62140 /lib64/libcrypt-2.6.1.so 7f7b5af66000-7f7b5af69000 rw-p 00008000 08:01 62140 /lib64/libcrypt-2.6.1.so 7f7b5af69000-7f7b5af97000 rw-p 7f7b5af69000 00:00 0 7f7b5af97000-7f7b5afac000 r-xp 00000000 08:01 62146 /lib64/libpthread-2.6.1.so 7f7b5afac000-7f7b5b1ac000 ---p 00015000 08:01 62146 /lib64/libpthread-2.6.1.so 7f7b5b1ac000-7f7b5b1ae000 rw-p 00015000 08:01 62146 /lib64/libpthread-2.6.1.so 7f7b5b1ae000-7f7b5b1b2000 rw-p 7f7b5b1ae000 00:00 0 7f7b5b1b2000-7f7b5b1b4000 r-xp 00000000 08:01 62160 /lib64/libdl-2.6.1.so 7f7b5b1b4000-7f7b5b3b4000 ---p 00002000 08:01 62160 /lib64/libdl-2.6.1.so 7f7b5b3b4000-7f7b5b3b6000 rw-p 00002000 08:01 62160 /lib64/libdl-2.6.1.so 7f7b5b3b6000-7f7b5b3be000 r-xp 00000000 08:01 62172 /lib64/libwrap.so.0.7.6 7f7b5b3be000-7f7b5b5bd000 ---p 00008000 08:01 62172 /lib64/libwrap.so.0.7.6 7f7b5b5bd000-7f7b5b5bf000 rw-p 00007000 08:01 62172 /lib64/libwrap.so.0.7.6 7f7b5b5bf000-7f7b5b5c0000 rw-p 7f7b5b5bf000 00:00 0 7f7b5b5c0000-7f7b5b5d4000 r-xp 00000000 08:01 62053 /lib64/libz.so.1.2.3 7f7b5b5d4000-7f7b5b7d3000 ---p 00014000 08:01 62053 /lib64/libz.so.1.2.3 7f7b5b7d3000-7f7b5b7d5000 rw-p 00013000 08:01 62053 /lib64/libz.so.1.2.3 7f7b5b7d5000-7f7b5b7dd000 r-xp 00000000 08:01 62176 /lib64/librt-2.6.1.so 7f7b5b7dd000-7f7b5b9dc000 ---p 00008000 08:01 62176 /lib64/librt-2.6.1.so 7f7b5b9dc000-7f7b5b9de000 rw-p 00007000 08:01 62176 /lib64/librt-2.6.1.so 7f7b5b9de000-7f7b5b9fa000 r-xp 00000000 08:01 62204 /lib64/ld-2.6.1.so 7f7b5bacd000-7f7b5bbef000 rw-p 7f7b5bacd000 00:00 0 7f7b5bbf7000-7f7b5bbf9000 rw-p 7f7b5bbf7000 00:00 0 7f7b5bbf9000-7f7b5bbfb000 rw-p 0001b000 08:01 62204 /lib64/ld-2.6.1.so 7fff63be6000-7fff63bfb000 rw-p 7ffffffea000 00:00 0 [stack] 7fff63bff000-7fff63c00000 r-xp 7fff63bff000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]