4 messages in com.mysql.lists.bugsmysql C API hang
FromSent OnAttachments
Karl03 Apr 2005 06:02 
Erich Dollansky03 Apr 2005 09:14 
Karl03 Apr 2005 11:57 
Erich Dollansky03 Apr 2005 19:28 
Subject:mysql C API hang
From:Karl (ka@infotek.ee)
Date:04/03/2005 06:02:49 AM
List:com.mysql.lists.bugs

Hello,

sry about my bad english.

in code is something this: sprintf(query,"update database.table set something='something else' where username='someone'"); mysql_query(&mysql,query);

and it works. This program runs long time (always connected to mysql) and after 6-7 days same query hang it.

(gdb) bt #0 0x40128f14 in __libc_read () from /lib/libc.so.6 #1 0x40069554 in _no_db_ () from /usr/lib/libmysqlclient.so.10 #2 0x40058895 in net_real_write () from /usr/lib/libmysqlclient.so.10 #3 0x40058ab6 in my_net_read () from /usr/lib/libmysqlclient.so.10 #4 0x40054d27 in _init () from /usr/lib/libmysqlclient.so.10 #5 0x40056d0d in mysql_read_query_result () from /usr/lib/libmysqlclient.so.10 #6 0x40057cba in mysql_real_query () from /usr/lib/libmysqlclient.so.10 #7 0x40057c49 in mysql_query () from /usr/lib/libmysqlclient.so.10 #8 0x80578a9 in save_user_details (user=0x81517b8, save_current=1) at myprogram.c:3482

any ideas?