Hi!

> > Добрый день.
> >
> > I think problem is in libmysqlclient_r.so
> > becouse I compile program which work fine many month with
> > libmysqlclient_r.
> > And program died in the same place.
> > #0  _db_enter_ (_func_=0x28252311 "mysql_real_query",
> >     _file_=0x28251d48 "libmysql.c", _line_=1784, _sfunc_=0xbfafa80c,
> >     _sfile_=0xbfafa810, _slevel_=0xbfafa814, _sframep_=0xbfafa818)
> >     at dbug.c:712
> > 712         *_sfunc_ = state->func;
> > (gdb) p _sfunc_
> > $1 = (char **) 0x0
> > (gdb) p state->func
> > Cannot access memory at address 0x8.
> > (gdb)
> >
> >
> >     Best regards.
> > _______________________________________
> >     Andrey Kotrekhov [EMAIL PROTECTED]
> >     ISP Alkar Teleport
> >     тел. +380 562 34-00-44
> >
>
> You have built it with debug on , so our debug caught some error
> caused by your program.
>
> If you link your program with our binary libmysqlclient_r, then if you
> run your program it will die in mysql_real_query, instead in
> _db_enter. This is most likely a consequence of some error in your
> program.

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!!!

>
>
>
> --
> 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
>
>

    Best regards.
_______________________________________
        Andrey Kotrekhov [EMAIL PROTECTED]
        ISP Alkar Teleport
        тел. +380 562 34-00-44




---------------------------------------------------------------------
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

Reply via email to