Andrey Kotrekhov writes:
> Hi!
>
>
> I am not agree. I take _another program_ which work fine during ~2 year
> with previouse mysql version (mysql-3.23.44 for example).
> And I send dump from this program.
>
> Why I interested libmysqlclient_r?
> I have a program, which try to connect to mysql twice.
> But the second connection freeze in mysql_real_connect.
> I use libmysqlclient.so (mysql-3.23.42 & FreeBSD-4.4RC)
> I try to upgrade to mysql-3.23.49 and use mysqlclient_r on test
> computer and have many problems (I write about their before).
> But now I attach to working process which freese and see:
> (gdb) bt
> #0 0x18237970 in _thread_kern_sched () from /usr/lib/libc_r.so.4
> #1 0x182382d2 in _thread_kern_sched_state () from /usr/lib/libc_r.so.4
> #2 0x1823b791 in _thread_fd_lock_debug () from /usr/lib/libc_r.so.4
> #3 0x1826df86 in _close () from /usr/lib/libc_r.so.4
> #4 0x1823eb72 in _res_close () from /usr/lib/libc_r.so.4
> #5 0x1823dc49 in res_send () from /usr/lib/libc_r.so.4
> #6 0x182418ad in res_query () from /usr/lib/libc_r.so.4
> #7 0x18241d88 in res_querydomain () from /usr/lib/libc_r.so.4
> #8 0x18241aca in res_search () from /usr/lib/libc_r.so.4
> #9 0x1824d692 in _gethostbydnsname () from /usr/lib/libc_r.so.4
> #10 0x1824c14c in gethostbyname2 () from /usr/lib/libc_r.so.4
> #11 0x1824c0c9 in gethostbyname () from /usr/lib/libc_r.so.4
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> #12 0x180e7cdc in mysql_real_connect ()
> from /usr/local/mysql/lib/libmysqlclient.so.10
> #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18,
> db=0x80fe8b0 "zzz", host=0x80fb040 "xxx.xxx.xxx",
> user=0x80fe910 "xxx", passwd=0x80c26aa "", port=3306, compress=1,
> connect_timeout=60, socket_name=0x80c26be "", client_flag=0)
> at connection.cc:52
> #14 0x808384f in QueueModule::Run (this=0x80c9c00) at QModule.cc:166
> #15 0x8068a8b in start_Module (ptr=0x80c9c00) at Module.cc:23
> #16 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
> #17 0x0 in ?? ()
>
> Under FreeBSD gethostbyname is not thread-safe
> And there is no thread-safe gethostbyname_r
> (function exist but not thread-safe)
>
> Are mysql know about this!!!
>
>
> Best regards.
> _______________________________________
> Andrey Kotrekhov [EMAIL PROTECTED]
> ISP Alkar Teleport
> ΤΕΜ. +380 562 34-00-44
The above crash is caused by using functions, like gethostbyname,
which is not thread safe.
This is explained in our fine manual.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.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
