Hello.
I have a problem with mysqld 3.23.49 .
My program consists of a father process and n children.
The children do a UPDATE at a certain time and the father might do a
SELECT at the 'same time'.
I suspect strongly that this is the problem. Any ways the father process
hangs at random situations
that involve the children doing UPDATEs and the father SELECT.
I am not sure of this.
What could be the problem?
/Mattias
Program received signal SIGINT, Interrupt.
0x40137544 in __libc_read () from /lib/i686/libc.so.6
(gdb) bt
#0 0x40137544 in __libc_read () from /lib/i686/libc.so.6
#1 0x0806fcd0 in ?? ()
#2 0x0805c46e in my_net_read ()
#3 0x0805893c in net_safe_read ()
#4 0x0805a662 in mysql_read_query_result ()
#5 0x0805b76f in mysql_query ()
#6 0x0804d678 in dataQuery (mysql=0x806e600,
query=0xbffff680 "SELECT ID FROM AccessServer WHERE
UPPER('192.168.0.123') LIKE UPPER(AddressPattern)", num_rows=0xbffff6e8,
store=1) at datamanager.c:71
#7 0x0804da30 in dataAccessServerHandle (address=0x80772d8 "192.168.0.123")
at datamanager.c:326
#8 0x0804d5ec in adminClientType (ip_address=0x80772d8 "192.168.0.123",
dispatcher_handle=0x8077034) at administrator.c:53
#9 0x08049f62 in initClientInfo (client=0x8077298) at controller.c:253
#10 0x0805593f in newClient (socket_fd=13, socket_name=0xbffff7b0)
at client.c:356
#11 0x08055dca in communicateClients (server=0xbffff910,
client_list_top=0x0,
timeout=0xbffff908) at client.c:682
#12 0x0804a142 in startServer () at controller.c:415
#13 0x0804a2d6 in main (argc=4, argv=0xbffffa14) at controller.c:650
#14 0x40073507 in __libc_start_main (main=0x804a25c <main>, argc=4,
ubp_av=0xbffffa14, init=0x804958c <_init>, fini=0x8062ff0 <_fini>,
rtld_fini=0x4000dc14 <_dl_fini>, stack_end=0xbffffa0c)
at ../sysdeps/generic/libc-start.c:129
--
----------------------------------------
Mattias Barthel
----------------------------------------
---------------------------------------------------------------------
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
