Andrei Cojocaru writes:
> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am
> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the
> same problem, I upgraded to 3.23.36 today and it had the same problem. I
> have recompiled mysql in full debug and done a stack trace and it keeps on
> crashing in mysql_select(), here they are:
>
> trace #1:
>
> www# cd /usr/local/mysql/libexec
> www# gdb mysqld
>
> (gdb) run --user=mysql
> Starting program: /usr/local/mysql/libexec/mysqld --user=mysql
> 010415 19:08:47 Warning: setrlimit returned ok, but didn't change limits.
> Max open files is 1064
> 010415 19:08:47 Warning: Changed limits: max_connections: 300 table_cache:
> 377
> /usr/local/mysql/libexec/mysqld: ready for connections
>
> Program received signal SIGSEGV, Segmentation fault.
> 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8,
> fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0,
> group=0x0, having=0x0, proc_param=0x0, select_options=42505217,
> result=0x92da518) at sql_select.cc:799
> 799 DBUG_RETURN(error);
<cut>
> ..
Hi!
Thank you for your effort, but the above info is not enough.
What we need to know is whether that query ALWAYS crashes MySQL
server or not.
If it crashes it always, we would need copies of the table(s)
involved, plus query itself. You can upload table(s) to
ftp://support.mysql.com:/pub/mysql/Incoming.
Also, please let us know whether you are on 4.2 STABLE or on some
developement version. A full mysqlbug report is alsw required.
Many thanks in advance.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
