maria-discuss team mailing list archive

["Philip Stoev" <pstoev@xxxxxxxxxxxx>]

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@xxxxxxxxxx>
To: <maria-discuss@xxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp