Bug #57622 Client program hang up when perform query

• Submitted: 21 Oct 2010 10:40
• Modified: 22 Nov 2010 9:56
• Reporter: zhang quanbin
• Status: No Feedback
• Category: Connector / C
• Severity: S2 (Serious)
• Version: 5.0.83
• OS: Linux (RHEL AS 4)
• CPU Architecture: Any

[21 Oct 2010 10:40] zhang quanbin

Description:
we have an online game sever use Mysql as DB, and sometimes after running two or three days, the server program hang up and can not response anymore, then we inspect the program using gdb ( program running on gdb ), check the backtrace see:
#0  0x00000033e6e0b25f in __read_nocancel () from /lib64/tls/libpthread.so.0
#1  0x00000000005396c8 in vio_read_buff ()
#2  0x000000000053a4a3 in my_real_read ()
#3  0x000000000053a8c5 in my_net_read ()
#4  0x0000000000533778 in cli_safe_read ()
#5  0x0000000000534f09 in cli_read_query_result ()
#6  0x00000000005352b2 in mysql_real_query ()
#7  0x0000000000409c8c in MySQL::Query (this=0x706240,pbuf=0x10f49678 "SELECT `uid`,`country`,`sex`,`img_id`,`name`,"...) at ./../../Mysql.h:80

use mysql client found the connection that program used is gone.
mysql> show processlist;
+---------+------+-----------+-------------+---------+------+-------+------------------+
| Id      | User | Host      | db          | Command | Time | State | Info             |
+---------+------+-----------+-------------+---------+------+-------+------------------+
| 2919448 | root | localhost | NULL        | Query   |    0 | NULL  | show processlist |
+---------+------+-----------+-------------+---------+------+-------+------------------+

and the problem occurs when program running about 2~3 days, sometimes it occurs when perform insert statement or update statement.

i don't know why, and i searched the buglist but i can not find any idea so i report this.

Mysql version is 5.0.83, Linux is RHEL AS 4 Nahant Update 7, gdb 6.3.0

How to repeat:
i don't know how to repeat but this issue repeat again and again.

[21 Oct 2010 16:44] Sveta Smirnova

Thank you for the report.

But version 5.0.83 as old. Please try current version 5.0.91 and if problem still exists send us full query which causes the crash and full error log file.

[21 Oct 2010 17:13] Peter Laursen

@Sveta .. there are no binaries released after 5.0.90.  You cannot assume that people should/could/would build themselves if they are not familiar with building MySQL.

[21 Oct 2010 17:26] Sveta Smirnova

@Peter: binaries are at http://downloads.mysql.com/archives.php?p=mysql-5.0&v=5.0.91

[21 Oct 2010 17:53] Peter Laursen

they should be added to FTP mirrors too
(like ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.0/

.. or 5.0 FTP mirrors should be deleted 
(and then please delete delete hopelessly outdated 5.2 (and maybe 5.4 mirrors) as well) 

ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.2/
ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.4/)

.. just to avoid confusion!

[21 Oct 2010 18:02] Peter Laursen

and btw: I only see 'mysql-essentials' builds - no FULL packages for Windows. The 'mysql-essentials' builds are completely ridiculous nowadays!

[22 Oct 2010 4:04] zhang quanbin

okey, I'll try version 5.0.91 or 5.1.51, and thanks alot.

[23 Nov 2010 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".