Hi,
I have installed MariaDB 5.3 from the apt packages on a lenny amd64 machine. Initial setup went fine and the database is working correctly. When I give some load to the machine I get crashes about every 8 minutes.
This is what the log shows:
Jul 29 00:36:17 svn mysqld: 110729 0:36:17 [ERROR] mysqld got signal 11 ;
Jul 29 00:36:17 svn mysqld: This could be because you hit a bug. It is also poss
ible that this binary
Jul 29 00:36:17 svn mysqld: or one of the libraries it was linked against is cor
rupt, improperly built,Jul 29 00:36:17 svn mysqld: or misconfigured. This error can also be caused by m
alfunctioning hardware.
Jul 29 00:36:17 svn mysqld: We will try our best to scrape up some info that will hopefully help diagnose
Jul 29 00:36:17 svn mysqld: the problem, but since we have already crashed, some
thing is definitely wrongJul 29 00:36:17 svn mysqld: and this may fail.
Jul 29 00:36:17 svn mysqld:
Jul 29 00:36:17 svn mysqld: key_buffer_size=0
Jul 29 00:36:17 svn mysqld: read_buffer_size=2097152
Jul 29 00:36:17 svn mysqld: max_used_connections=13
Jul 29 00:36:17 svn mysqld: max_threads=102
Jul 29 00:36:17 svn mysqld: threads_connected=1
Jul 29 00:36:17 svn mysqld: It is possible that mysqld could use up toJul 29 00:36:17 svn mysqld: key_buffer_size + (read_buffer_size + sort_buffer_si
ze)*max_threads = 627994 K
Jul 29 00:36:17 svn mysqld: bytes of memoryJul 29 00:36:17 svn mysqld: Hope that's ok; if not, decrease some variables in t
he equation.
Jul 29 00:36:17 svn mysqld:
Jul 29 00:36:17 svn mysqld: Thread pointer: 0x7f1740013780Jul 29 00:36:17 svn mysqld: Attempting backtrace. You can use the following info
rmation to find outJul 29 00:36:17 svn mysqld: where mysqld died. If you see no messages after this
, something went
Jul 29 00:36:17 svn mysqld: terribly wrong...
Jul 29 00:36:17 svn mysqld: stack_bottom = 0x41614110 thread_stack 0x48000Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7f176c
0dc1de]Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_segfault+0x448) [0x7f176bce3
de8]
Jul 29 00:36:17 svn mysqld: /lib/libpthread.so.0 [0x7f176a281a80]Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0x22) [0x7f176bd68
c52]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_derived_optimize(THD*, st_lex*, TABLE_LIST*)+0x12e) [0x7f176be52fbe]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_handle_single_derived(st_lex*, TABLE_LIST*, unsigned int)+0x10e) [0x7f176be53c3e]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(st_select_lex::handle_derived(st_lex*, unsigned int)+0x48) [0x7f176bc07528]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0xb2) [0x7f176bd68ce2]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_derived_optimize(THD*, st_lex*, TABLE_LIST*)+0x12e) [0x7f176be52fbe]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_handle_single_derived(st_lex*, TABLE_LIST*, unsigned int)+0x10e) [0x7f176be53c3e]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(st_select_lex::handle_derived(st_lex*, unsigned int)+0x48) [0x7f176bc07528]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0xb2) [0x7f176bd68ce2]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x104) [0x7f176bd70a84]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x171) [0x7f176bd714c1]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld [0x7f176bcef8fb]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x1ef9) [0x7f176bcf2239]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c1) [0x7f176bcf6181]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xde1) [0x7f176bcf8941]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(do_command(THD*)+0x100) [0x7f176bcf9230]
Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_one_connection+0xe4) [0x7f176bceacf4]
Jul 29 00:36:17 svn mysqld: /lib/libpthread.so.0 [0x7f176a279fc7]
Jul 29 00:36:17 svn mysqld: /lib/libc.so.6(clone+0x6d) [0x7f176985764d]
Jul 29 00:36:17 svn mysqld:
Jul 29 00:36:17 svn mysqld: Trying to get some variables.
Jul 29 00:36:17 svn mysqld: Some pointers may be invalid and cause the dump to abort.
Jul 29 00:36:17 svn mysqld: Query (0x7f176ec35988): SELECT * FROM (
Jul 29 00:36:17 svn mysqld: SELECT @rn := if( @lc = l.l_contentid, @rn +1, 0 ) AS rnum, @lc := l_contentid, l.*
Jul 29 00:36:17 svn mysqld: FROM vb3_vbseo_likes l, (SELECT @rn :=0, @lc :=0) r
Jul 29 00:36:17 svn mysqld: WHERE l_ctype = 1 AND l_cgroup =39820 AND l_contentid IN (289195,289196 )
Jul 29 00:36:17 svn mysqld: ORDER BY l_contentid
Jul 29 00:36:17 svn mysqld: ) as nest
Jul 29 00:36:17 svn mysqld: where rnum<3
Jul 29 00:36:17 svn mysqld: Connection ID (thread ID): 511
Jul 29 00:36:17 svn mysqld: Status: NOT_KILLED
Jul 29 00:36:17 svn mysqld:
Jul 29 00:36:17 svn mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jul 29 00:36:17 svn mysqld: information that should help you find out what is causing the crash.
Jul 29 00:36:17 svn mysqld_safe: Number of processes running now: 0
Jul 29 00:36:17 svn mysqld_safe: mysqld restarted
Just to confirm the installed packages:
dpkg --get-selections | grep maria
libmariadbclient16 install
mariadb-client-5.3 install
mariadb-client-core-5.3 install
mariadb-server-5.3 install
mariadb-server-core-5.3 install
Any pointers?
Cheers,
Carsten