Hello,
From the information you provided I was able to reproduce the problem and I filed a bug in LaunchPad
https://bugs.launchpad.net/maria/+bug/819716 It seems that nesting of derived tables and a variable is required to cause this crash. Launchpad provides a way to subscribe yourself to receive updates for the bug. Thank you. Philip Stoev ----- Original Message ----- From: "Carsten Bernhard" <carstenb@bmedien.eu> To: <maria-discuss@lists.launchpad.net> Sent: Friday, July 29, 2011 11:18 AM Subject: [Maria-discuss] MariaDB 5.3 on lenny crashing about every 8 minutes 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 --------------------------------------------------------------------------------
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp