MySQL Query problem, possible bug?
Hello, Today, I tried to move a part of one of my websites, a forum (vBulletin, www.vbulletin.com) to a new server: a FreeBSD server. I installed the package mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed to work perfectly: installation complete, and phpMyAdmin worked perfectly. I reinstalled the forums on the new FreeBSD server (the old one was RH-Linux 7.0), that also went good: I entered the admin, it worked good. Then, I tried to enter the forums, and got a database error: SQL Query: SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'1') ORDER BY replacementsetid DESC,replacementid DESC Error: Lost connection to MySQL server during query I found out the connection was lost because MySQL crashes: /usr/libexec/ld-elf.so.1: ./mysqld: Undefined symbol "strtoll" Anyone is familliar with this problem? This query DID work on the previous server, the RedHat one, but just doesn't work on the FreeBSD server. The databases are EXACTLY the same, so there shouldn't be any problems. Or should it? Anyway, thanks in advance for your replies, Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. ICQ: 55677353
Re: Problem - Possible Bug?
Also, it's not a specific query that crashes it, only select queries apparently. >I can do better than that I can give you root access to my machine. You can >corrupt the data as much as you want I have backups on my other machine. >Contact me at my email for the login details. > >>From: Sasha Pachev <[EMAIL PROTECTED]> >>To: "Andrei Cojocaru" <[EMAIL PROTECTED]> >>CC: [EMAIL PROTECTED], [EMAIL PROTECTED] >>Subject: Re: Problem - Possible Bug? >>Date: Mon, 16 Apr 2001 08:25:26 -0600 >>MIME-Version: 1.0 >>Received: from [209.181.82.108] by hotmail.com (3.2) with ESMTP id >>MHotMailBCA44C0900BA4004314BD1B5526C11DD0; Mon Apr 16 07:26:18 2001 >>Received: from mysql ([127.0.0.1])by mysql.sashanet.com >>(8.10.2/8.10.2/SuSE >>Linux 8.10.0-0.3) with SMTP id f3GEPTE17218;Mon, 16 Apr 2001 08:25:29 >>-0600 >>From [EMAIL PROTECTED] Mon Apr 16 07:27:11 2001 >>X-Authentication-Warning: mysql.sashanet.com: Host [127.0.0.1] claimed to >>be mysql >>Organization: MySQL >>X-Mailer: KMail [version 1.2] >>References: <[EMAIL PROTECTED]> >>In-Reply-To: <[EMAIL PROTECTED]> >>Message-Id: <01041608252602.17185@mysql> >>X-MIME-Autoconverted: from 8bit to quoted-printable by mysql.sashanet.com >>id f3GEPTE17218 >> >>On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote: >> > 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); >> > >> > ... >> > >> > (gdb) back >> > #0 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 >> > #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 >> > #2 0x809219f in mysql_parse (thd=0x824a818, >> > inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from >> > planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and >> > pfs.planetid=3647", length=137) at sql_parse.cc:2298 >> > #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 >> > #4 0x808cba0 in handle_one_connection (arg=0x824a818) at >>sql_parse.cc:551 >> > #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 >> > #6 0xbfadcffc in ?? () >> > #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 >> > #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 >> > #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 >> > #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 >> > #11 0x804b29d in _start () >> > >> > ... >> > >> > (gdb) info locals >> > tmp_table = (TABLE *) 0x92cc018 >> > error = 0 >> > tmp = 0 >> > need_tmp = true >> > hidden_group_fields = false >> > simple_order = false >> > simple_group = false >> > no_order = false >> > cond_value = COND_OK >> > select = (SQL_SELECT *) 0x92dab20 >> > keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment >>= >>64, >> > size_of_element = 20} >> > join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = >>0x92da760, >> > table = 0
Re: Problem - Possible Bug?
as I said before I can give you root access on the machine which I believe would be easier for you to disagnose the problem. >From: Sasha Pachev <[EMAIL PROTECTED]> >To: "Andrei Cojocaru" <[EMAIL PROTECTED]> >Subject: Re: Problem - Possible Bug? >Date: Mon, 16 Apr 2001 08:31:54 -0600 >MIME-Version: 1.0 >Received: from [209.181.82.108] by hotmail.com (3.2) with ESMTP id >MHotMailBCA44D7700C640043714D1B5526C11E30; Mon Apr 16 07:32:24 2001 >Received: from mysql ([127.0.0.1])by mysql.sashanet.com (8.10.2/8.10.2/SuSE >Linux 8.10.0-0.3) with SMTP id f3GEVtE17248for <[EMAIL PROTECTED]>; >Mon, 16 Apr 2001 08:31:55 -0600 >From [EMAIL PROTECTED] Mon Apr 16 07:33:58 2001 >X-Authentication-Warning: mysql.sashanet.com: Host [127.0.0.1] claimed to >be mysql >Organization: MySQL >X-Mailer: KMail [version 1.2] >References: <[EMAIL PROTECTED]> >In-Reply-To: <[EMAIL PROTECTED]> >Message-Id: <01041608315404.17185@mysql> > >I think I forgot to give you the address where to drop off your tables. >ftp://support.mysql.com/pub/mysql/secret/ > >-- >MySQL Development Team >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ >/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ><___/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Re: Problem - Possible Bug?
On Sunday 15 April 2001 19:40, Andrei Cojocaru wrote: > 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); > > ... > > (gdb) back > #0 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 > #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 > #2 0x809219f in mysql_parse (thd=0x824a818, > inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from > planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and > pfs.planetid=3647", length=137) at sql_parse.cc:2298 > #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 > #4 0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551 > #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 > #6 0xbfadcffc in ?? () > #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 > #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 > #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 > #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 > #11 0x804b29d in _start () > > ... > > (gdb) info locals > tmp_table = (TABLE *) 0x92cc018 > error = 0 > tmp = 0 > need_tmp = true > hidden_group_fields = false > simple_order = false > simple_group = false > no_order = false > cond_value = COND_OK > select = (SQL_SELECT *) 0x92dab20 > keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, > size_of_element = 20} > join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, > table = 0x0, all_tables = 0x92da7e0, > sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, > sort_and_group = false, first_record = false, > full_join = true, group = false, no_field_update = 76, const_table_map = > 0, outer_join = 0, send_records = 1, found_records = 2, > positions = {{records_read = 14, table = 0x92da648, key = 0x0}, > {records_read = 14, table = 0x92da648, key = 0x0}, { > records_read = 3.497926695968519e-115, table = 0x92e0180, key = > 0x92d9274}, {records_read = 8.8208146916688224e-314, > table = 0xbfaba66c, key = 0x92d9274}, {records_read = > 6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, { > records_read = 1.9019183611868367e-269, table = 0x92d9000, key = > 0xbfaba6ac}, {records_read = 3.497926695968519e-115, > table = 0x820d6ac, key = 0x92d9274}, {records_read = > 1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, { > records_read = 1.9019183611868367e-269, table = 0x1, key = > 0xbfaba7e0}, {records_read = 3.497926695968519e-115, > table = 0x820d6ac, key = 0x0}, {records_read = > 1.8993304345295969e-269, table = 0xbfaba6dc, key = 0xbfaba71c}, { > records_read = 3.497926695968519e-115, table = 0x822c4d4, key = > 0x92d9274}, {records_read = 3.4979266959743929e-115, > table = 0xbfaba6fc, key = 0x92d9274}, {records_read = > 1.8993304345295969e-269, table = 0x822c4d8, key = 0xbfaba74c}, { > records_read = 3.497926695968519e-115, table = 0x822c4d4, key = > 0x92d9274}, {records_read = 1.8992611150717832e-269, > table = 0xbfaba72c, key = 0xbfaba74c}, {records_read = > 1.8993304345295969e-269, table = 0x92e0198, key = 0x92d9274}, { > records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x0}, > {records_read = 3.4978027730273331e-115, > table = 0xbfaba75c, key = 0x0}, {records_read = > 3.497926695968519e-115, table = 0xbfaab000, key = 0x3c}, { > records_read = 1.8611437758736926e-264, table = 0xbfaba77c, key = > 0x43f}, {records_read = 1.8520806496858815e-264, > table = 0x12e0198, key = 0xbfaba7cc}, {records_read = > 1.8520805311109313e-264, table = 0xbfaba7f8, key = 0x1}, { > records_read = 3.4979266959805738e-115, table = 0x820d6ac, key = > 0xbfaba
Re: Problem - Possible Bug?
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); > .. 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
Problem - Possible Bug?
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); ... (gdb) back #0 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 #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 #2 0x809219f in mysql_parse (thd=0x824a818, inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and pfs.planetid=3647", length=137) at sql_parse.cc:2298 #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 #4 0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551 #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 #6 0xbfadcffc in ?? () #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 #11 0x804b29d in _start () ... (gdb) info locals tmp_table = (TABLE *) 0x92cc018 error = 0 tmp = 0 need_tmp = true hidden_group_fields = false simple_order = false simple_group = false no_order = false cond_value = COND_OK select = (SQL_SELECT *) 0x92dab20 keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, size_of_element = 20} join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, table = 0x0, all_tables = 0x92da7e0, sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, sort_and_group = false, first_record = false, full_join = true, group = false, no_field_update = 76, const_table_map = 0, outer_join = 0, send_records = 1, found_records = 2, positions = {{records_read = 14, table = 0x92da648, key = 0x0}, {records_read = 14, table = 0x92da648, key = 0x0}, { records_read = 3.497926695968519e-115, table = 0x92e0180, key = 0x92d9274}, {records_read = 8.8208146916688224e-314, table = 0xbfaba66c, key = 0x92d9274}, {records_read = 6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, { records_read = 1.9019183611868367e-269, table = 0x92d9000, key = 0xbfaba6ac}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x92d9274}, {records_read = 1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, { records_read = 1.9019183611868367e-269, table = 0x1, key = 0xbfaba7e0}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x0}, {records_read = 1.8993304345295969e-269, table = 0xbfaba6dc, key = 0xbfaba71c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 3.4979266959743929e-115, table = 0xbfaba6fc, key = 0x92d9274}, {records_read = 1.8993304345295969e-269, table = 0x822c4d8, key = 0xbfaba74c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 1.8992611150717832e-269, table = 0xbfaba72c, key = 0xbfaba74c}, {records_read = 1.8993304345295969e-269, table = 0x92e0198, key = 0x92d9274}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x0}, {records_read = 3.4978027730273331e-115, table = 0xbfaba75c, key = 0x0}, {records_read = 3.497926695968519e-115, table = 0xbfaab000, key = 0x3c}, { records_read = 1.8611437758736926e-264, table = 0xbfaba77c, key = 0x43f}, {records_read = 1.8520806496858815e-264, table = 0x12e0198, key = 0xbfaba7cc}, {records_read = 1.8520805311109313e-264, table = 0xbfaba7f8, key = 0x1}, { records_read = 3.4979266959805738e-115, table = 0x820d6ac, key = 0xbfaba7dc}, {records_read = 1.901849041729023e-269, table = 0x282b11c0, key = 0xbfaba7dc}, {records_read = 3.7004632531246594e-115, table = 0x1, key = 0x92d9274}, { records_read = 3.4979266959743929e-115, table = 0x822c4d8, key = 0x92d9274}, {records