Re: problem with libmysqlclient_r.so

2002-05-16 Thread Michael Widenius


Hi!

 Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:

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

cut

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

Just a note about this problem:

We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2
that will fix things for OS where gethostbyname is not threadsafe.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   ___/   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




Re: problem with libmysqlclient_r.so

2002-05-16 Thread Andrey Kotrekhov

Hi!

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

 Just a note about this problem:

 We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2
 that will fix things for OS where gethostbyname is not threadsafe.


Thank you very mach.
And now I use libmysqlclient.so and each mysql_real_connect include in
pthread_mutex_lock(), pthread_mutex_unlock() construction. :)
It helps me in thread programs.

 Regards,
 Monty


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




Re: problem with libmysqlclient_r.so

2002-05-16 Thread Michael Widenius


Hi!

 Michael == Michael Chang [EMAIL PROTECTED] writes:

 For example, have you called mysql_thread_init() before calling
 mysql_real_connect() in all your threads ?

Michael However, to my understanding, mysql_thread_init() is not needed if
Michael only one database connection is used, and that database connection
Michael is established when the program starts, before any threads have been
Michael created.

Sorry, but this in not true.

You have to call mysql_thread_init() for each thread that is not
calling mysql_real_connect()

This is needed to setup some thread local variables MySQL needs to
make things threadsafe.

Michael  That is, if you call mysql_real_connect() at the top
Michael of main(), for example, and you let the connection persist for the
Michael lifetime of the program, then mysql_thread_init() is not necessary,

It is necessary

Michael and the only thing that you must worry about is to make sure that
Michael critical sections (like between mysql_real_query() and 
Michael mysql_store_result()) are sandwiched in-between a mutex lock.

Michael If the above is incorrect, please let me know.

Please read the manual section about how to make a thread safe
client. This explains in detail what you have to do!


Regards,
Monty

-
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




Re: problem with libmysqlclient_r.so

2002-05-16 Thread Michael Widenius


Hi!

 Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes:

Andrey -L .-A
Andrey Are mysql know about this!!!
 
 Sorry but if your OS doesn't support gethostbyname_r(), then
 mysql_real_connect() is not thread safe (I have just updated our
 documentation about this)

Andrey Thank you.

I have now also patched the 3.23.51 source to ensure that
gethostbyname() is called in a thread-safe manner.

cut

 For example, have you called mysql_thread_init() before calling
 mysql_real_connect() in all your threads ?
 

Andrey Hmm... I use mysql_init() in each thread but:

Try calling 'my_thread_init()' instead.

Andrey 8.4.4.4 my_thread_init()
Andrey .
Andrey This is automatically called by my_init() and mysql_connect().
Andrey ~

The above should work if you all your threads calls the above
functions.  If you have a thread that calls mysql_xxx_query()
directly, this will die if you don't call my_thread_init() first.


Andrey And in manual:
Andrey To get a threaded client where you can interrupt the client from other
Andrey threads and set timeouts when talking with the MySQL server, you should
Andrey use the -lmysys, -lstring, and -ldbug libraries...
Andrey -lstring - where can I find it?
Andrey Is it -lmystrings ?

Yes;  I have now updated the manual with this.

Regards,
Monty

-
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




Re: problem with libmysqlclient_r.so

2002-04-26 Thread Michael Widenius


Hi!

 Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes:

cut

Andrey #12 0x180e7cdc in mysql_real_connect ()
Andreyfrom /usr/local/mysql/lib/libmysqlclient.so.10
Andrey #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18,
Andrey db=0x80fe8b0 zzz, host=0x80fb040 xxx.xxx.xxx,
Andrey user=0x80fe910 xxx, passwd=0x80c26aa , port=3306, compress=1,
Andrey connect_timeout=60, socket_name=0x80c26be , client_flag=0)
Andrey at connection.cc:52
Andrey #14 0x808384f in QueueModule::Run (this=0x80c9c00) at QModule.cc:166
Andrey #15 0x8068a8b in start_Module (ptr=0x80c9c00) at Module.cc:23
Andrey #16 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
Andrey #17 0x0 in ?? ()

Andrey Under FreeBSD gethostbyname is not thread-safe
Andrey And there is no thread-safe gethostbyname_r
Andrey (function exist but not thread-safe)

Andrey Are mysql know about this!!!

Sorry but if your OS doesn't support gethostbyname_r(), then
mysql_real_connect() is not thread safe (I have just updated our
documentation about this)

Another issue is that if your client dies in the dbug_ code, this
means that you have probably not followed the instructions in the
manual section:

'How to Make a Threaded Client'

For example, have you called mysql_thread_init() before calling
mysql_real_connect() in all your threads ?

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   ___/   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




Re: problem with libmysqlclient_r.so

2002-04-26 Thread Andrey Kotrekhov

äÏÂÒÙÊ ÄÅÎØ.

 Andrey Are mysql know about this!!!

 Sorry but if your OS doesn't support gethostbyname_r(), then
 mysql_real_connect() is not thread safe (I have just updated our
 documentation about this)

Thank you.


 Another issue is that if your client dies in the dbug_ code, this
 means that you have probably not followed the instructions in the
 manual section:

 'How to Make a Threaded Client'

 For example, have you called mysql_thread_init() before calling
 mysql_real_connect() in all your threads ?


Hmm... I use mysql_init() in each thread but:

8.4.4.4 my_thread_init()
.
This is automatically called by my_init() and mysql_connect().
~

And in manual:
To get a threaded client where you can interrupt the client from other
threads and set timeouts when talking with the MySQL server, you should
use the -lmysys, -lstring, and -ldbug libraries...
-lstring - where can I find it?
Is it -lmystrings ?

 Regards,
 Monty

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




Re: problem with libmysqlclient_r.so

2002-04-26 Thread Sinisa Milivojevic

Andrey Kotrekhov writes:
 äÏÂÒÙÊ ÄÅÎØ.
 
 
 Hmm... I use mysql_init() in each thread but:
 
 8.4.4.4 my_thread_init()
 .
 This is automatically called by my_init() and mysql_connect().
 ~
 
 And in manual:
 To get a threaded client where you can interrupt the client from other
 threads and set timeouts when talking with the MySQL server, you should
 use the -lmysys, -lstring, and -ldbug libraries...
 -lstring - where can I find it?
 Is it -lmystrings ?
 
 Best regards.
 ___
   Andrey Kotrekhov [EMAIL PROTECTED]
   ISP Alkar Teleport
   ÔÅÌ. +380 562 34-00-44
 
 
No, just -lstrings 

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




Re: problem with libmysqlclient_r.so

2002-04-26 Thread Michael Chang


 For example, have you called mysql_thread_init() before calling
 mysql_real_connect() in all your threads ?

However, to my understanding, mysql_thread_init() is not needed if
only one database connection is used, and that database connection
is established when the program starts, before any threads have been
created.  That is, if you call mysql_real_connect() at the top
of main(), for example, and you let the connection persist for the
lifetime of the program, then mysql_thread_init() is not necessary,
and the only thing that you must worry about is to make sure that
critical sections (like between mysql_real_query() and 
mysql_store_result()) are sandwiched in-between a mutex lock.

If the above is incorrect, please let me know.


Michael



On Fri, 26 Apr 2002, Michael Widenius wrote:

 
 Hi!
 
  Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes:
 
 cut
 
 Andrey #12 0x180e7cdc in mysql_real_connect ()
 Andreyfrom /usr/local/mysql/lib/libmysqlclient.so.10
 Andrey #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18,
 Andrey db=0x80fe8b0 zzz, host=0x80fb040 xxx.xxx.xxx,
 Andrey user=0x80fe910 xxx, passwd=0x80c26aa , port=3306, compress=1,
 Andrey connect_timeout=60, socket_name=0x80c26be , client_flag=0)
 Andrey at connection.cc:52
 Andrey #14 0x808384f in QueueModule::Run (this=0x80c9c00) at QModule.cc:166
 Andrey #15 0x8068a8b in start_Module (ptr=0x80c9c00) at Module.cc:23
 Andrey #16 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
 Andrey #17 0x0 in ?? ()
 
 Andrey Under FreeBSD gethostbyname is not thread-safe
 Andrey And there is no thread-safe gethostbyname_r
 Andrey (function exist but not thread-safe)
 
 Andrey Are mysql know about this!!!
 
 Sorry but if your OS doesn't support gethostbyname_r(), then
 mysql_real_connect() is not thread safe (I have just updated our
 documentation about this)
 
 Another issue is that if your client dies in the dbug_ code, this
 means that you have probably not followed the instructions in the
 manual section:
 
 'How to Make a Threaded Client'
 
 For example, have you called mysql_thread_init() before calling
 mysql_real_connect() in all your threads ?
 
 Regards,
 Monty
 
 

-- 
/*--
* It might look like I'm doing nothing, but at the cellular level
* I'm really quite busy.
*  ---anonymous
*
*
* -BEGIN GEEK CODE BLOCK-
* Version: 3.1
* GCS/P/H/L/O d- s-:-- a26 C++(+++) UL+++$ P++ L+++ !E W+++ N- o? K-
* w--(---) !O M+ !V PS+ PE- Y-- PGP- t+ 5-(--) X(-) R* tv b+ DI-- D-- G e+++
* h+ r* y--
* --END GEEK CODE BLOCK--
--*/


-
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




Re: problem with libmysqlclient_r.so

2002-04-26 Thread Sinisa Milivojevic

Michael Chang writes:
 
  For example, have you called mysql_thread_init() before calling
  mysql_real_connect() in all your threads ?
 
 However, to my understanding, mysql_thread_init() is not needed if
 only one database connection is used, and that database connection
 is established when the program starts, before any threads have been
 created.  That is, if you call mysql_real_connect() at the top
 of main(), for example, and you let the connection persist for the
 lifetime of the program, then mysql_thread_init() is not necessary,
 and the only thing that you must worry about is to make sure that
 critical sections (like between mysql_real_query() and 
 mysql_store_result()) are sandwiched in-between a mutex lock.
 
 If the above is incorrect, please let me know.
 
 
 Michael
 
 

It is required in any case when multi-threaded program is made, which
uses our C API.

In 4.0 it is automatically invoked in my_init() if library is built
thread-safe. 

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




Re: problem with libmysqlclient_r.so

2002-04-25 Thread Andrey Kotrekhov

äÏÂÒÙÊ ÄÅÎØ.

 Andrey Kotrekhov writes:
  Hi!
 
  % g++ -v
  Using builtin specs.
  gcc version 2.95.3 20010315 (release) [FreeBSD]
  And libstdc++ is include in compiller
  How can I see version of libstdc++ ?
  In /usr/src/contrib/libstdc++/Makefile.in I see
  VERSION = 2.10.0
  INTERFACE = 3
  Is there right?
 
  Best regards.
  ___
  Andrey Kotrekhov [EMAIL PROTECTED]
  ISP Alkar Teleport
  ÔÅÌ. +380 562 34-00-44
 
 
  -


 Compiler is OK.

 But your program is multithreaded, so check with `ldd` whether you
 have linked in libstdc++ ...
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)

this is configure parameters
./configure  \
--prefix=/usr/local/mysql \
--with-debug \
--with-charset=koi8_ru \
--with-extra-charset=koi8_ukr,win1251,win1251ukr \
--with-mysqld-user=mysql \
--without-berkeley-db \
--with-innodb \
--enable-thread-safe-client


 --
 Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
 /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
___/   www.mysql.com



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




Re: problem with libmysqlclient_r.so

2002-04-25 Thread Andrey Kotrekhov

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




Re: problem with libmysqlclient_r.so

2002-04-25 Thread Sinisa Milivojevic

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




Re: problem with libmysqlclient_r.so

2002-04-24 Thread Andrey Kotrekhov

Hi!

 Andrey Kotrekhov writes:
 
 
  my program crash in another plase
  (gdb) bt
  #0  _db_enter_ (_func_=0x280fe4dc mysql_ping,
  _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c,
  _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48)
  at dbug.c:712
  #1  0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248
  #2  0x80832d2 in QueueModule::Run (this=0x80c9c00)
  at /usr/local/mysql++/include/connection1.hh:80
  #3  0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23
  #4  0x282063af in _thread_start () from /usr/lib/libc_r.so.4
  #5  0x0 in ?? ()
  (gdb) p state
  $1 = (CODE_STATE *) 0x0
  (gdb)
  why code_state() return NULL?
  Is this right?
 
  
 
  Best regards.
  ___
  Andrey Kotrekhov [EMAIL PROTECTED]
  ISP Alkar Teleport
  ÔÅÌ. +380 562 34-00-44
 

 Does not seem like our bug !

 Because last time it crashed in a completely different place. Plus, it
I change version MySQL, maybe this is the reason?

 is unlikely that it would crash in ping. Check out your compiler
 version and whether libstdc++ got linked into the binary.

% g++ -v
Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
And libstdc++ is include in compiller
How can I see version of libstdc++ ?
In /usr/src/contrib/libstdc++/Makefile.in I see
VERSION = 2.10.0
INTERFACE = 3
Is there right?

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




Re: problem with libmysqlclient_r.so

2002-04-24 Thread Sinisa Milivojevic

Andrey Kotrekhov writes:
 Hi!
 
 % g++ -v
 Using builtin specs.
 gcc version 2.95.3 20010315 (release) [FreeBSD]
 And libstdc++ is include in compiller
 How can I see version of libstdc++ ?
 In /usr/src/contrib/libstdc++/Makefile.in I see
 VERSION = 2.10.0
 INTERFACE = 3
 Is there right?
 
 Best regards.
 ___
   Andrey Kotrekhov [EMAIL PROTECTED]
   ISP Alkar Teleport
   ÔÅÌ. +380 562 34-00-44
 
 
 -


Compiler is OK.

But your program is multithreaded, so check with `ldd` whether you
have linked in libstdc++ ...

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




Re: problem with libmysqlclient_r.so

2002-04-23 Thread Andrey Kotrekhov

äÏÂÒÙÊ ÄÅÎØ.

  program crash in my_fopen
 
  this is stack of program :
  (gdb) bt
  #0  0x180ef7f2 in my_fopen () from
  /usr/local/mysql/lib/libmysqlclient_r.so.10
  #1  0x180f0b20 in search_default_file ()
 from /usr/local/mysql/lib/libmysqlclient_r.so.10

 [skip]

 Hi!

 First of all, what version of limysql are you using ??


OK. I got mysql-3.23.49, configure it:
./configure  \
--prefix=/usr/local/mysql \
--with-debug \
--with-charset=koi8_ru \
--with-extra-charset=koi8_ukr,win1251,win1251ukr \
--with-mysqld-user=mysql \
--without-berkeley-db \
--with-innodb \
--enable-thread-safe-client

OS: FreeBSD 4.5-STABLE (cvsup today :) )

my program crash in another plase
(gdb) bt
#0  _db_enter_ (_func_=0x280fe4dc mysql_ping,
_file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c,
_sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48)
at dbug.c:712
#1  0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248
#2  0x80832d2 in QueueModule::Run (this=0x80c9c00)
at /usr/local/mysql++/include/connection1.hh:80
#3  0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23
#4  0x282063af in _thread_start () from /usr/lib/libc_r.so.4
#5  0x0 in ?? ()
(gdb) p state
$1 = (CODE_STATE *) 0x0
(gdb)
why code_state() return NULL?
Is this right?

 Second, please do : frame 1 and let us know the values for the
 following parameters :

   const char *dir, const char *config_file,  const char *ext, TYPELIB *group)


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




Re: problem with libmysqlclient_r.so

2002-04-23 Thread Sinisa Milivojevic

Andrey Kotrekhov writes:
 
 
 my program crash in another plase
 (gdb) bt
 #0  _db_enter_ (_func_=0x280fe4dc mysql_ping,
 _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c,
 _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48)
 at dbug.c:712
 #1  0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248
 #2  0x80832d2 in QueueModule::Run (this=0x80c9c00)
 at /usr/local/mysql++/include/connection1.hh:80
 #3  0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23
 #4  0x282063af in _thread_start () from /usr/lib/libc_r.so.4
 #5  0x0 in ?? ()
 (gdb) p state
 $1 = (CODE_STATE *) 0x0
 (gdb)
 why code_state() return NULL?
 Is this right?
 
 
 
 Best regards.
 ___
   Andrey Kotrekhov [EMAIL PROTECTED]
   ISP Alkar Teleport
   ÔÅÌ. +380 562 34-00-44
 
 
Does not seem like our bug !

Because last time it crashed in a completely different place. Plus, it
is unlikely that it would crash in ping. Check out your compiler
version and whether libstdc++ got linked into the binary.

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




Re: problem with libmysqlclient_r.so

2002-04-22 Thread Andrey Kotrekhov

Hi,
I use mysql++
And each object Connection use own
MYSQL mysql;

mysql_init called in Connection constructor.

 Hi,
 You use and two different mysql_init ?
 Regards,
 Gelu

 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Andrey Kotrekhov [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, April 21, 2002 4:55 PM
 Subject: problem with libmysqlclient_r.so


 Hello, All!

 I have program which try to connect to different mysql servers twice at
 the same time.
 When I use libmysqlclient.so sometimes one or two mysql connection freeze
 in mysql_real_connect

 But when I try to use libmysqlclient_r.so
 program crash in my_fopen

 this is stack of program :
 (gdb) bt
 #0  0x180ef7f2 in my_fopen () from
 /usr/local/mysql/lib/libmysqlclient_r.so.10
 #1  0x180f0b20 in search_default_file ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #2  0x180f085f in load_defaults ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #3  0x180e776b in mysql_read_default_options ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #4  0x180e8054 in mysql_real_connect ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
 db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net,
 user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1,
 connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
 at connection.cc:52
 #6  0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138
 #7  0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23
 #8  0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
 #9  0x0 in ?? ()
 (gdb) frame 5
 #5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
 db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net,
 user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1,
 connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
 at connection.cc:52
 52  if (mysql_real_connect(mysql,host,user,passwd,db,
 port,socket_name,client_flag))
 (gdb) p host
 $1 = (cchar *) 0x80fa040 xxx.xxx.net
 (gdb) p user
 $2 = (cchar *) 0x80fd910 test
 (gdb) p passwd
 $3 = (cchar *) 0x80c1bca 
 (gdb) p db
 $4 = (cchar *) 0x80fd8b0 kuku
 (gdb) p port
 $5 = 3306
 (gdb) p socket_name
 $6 = 0x80c1bde 
 (gdb) p client_flag
 $7 = 0
 (gdb)

 OS FreeBSD 4.4-RC
 mysql version 3.23.42, but I try to use 3.23.49 with the same effect

 Will anybody help me?

 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





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




Re: problem with libmysqlclient_r.so

2002-04-22 Thread Gelu

Hi,
OK.I don't have(NULL) mysql++ experience.Anyway, i believe is something
wrong with MYSQL structure initialisation(referencing pointer or some like
that).I don't see other reason, considering mysql++ use functions from
libmysqlclient too.
Good luck,
Gelu

- Original Message -
From: Andrey Kotrekhov [EMAIL PROTECTED]
To: Gelu [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 12:30 PM
Subject: Re: problem with libmysqlclient_r.so


Hi,
I use mysql++
And each object Connection use own
MYSQL mysql;

mysql_init called in Connection constructor.

 Hi,
 You use and two different mysql_init ?
 Regards,
 Gelu

 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Andrey Kotrekhov [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, April 21, 2002 4:55 PM
 Subject: problem with libmysqlclient_r.so


 Hello, All!

 I have program which try to connect to different mysql servers twice at
 the same time.
 When I use libmysqlclient.so sometimes one or two mysql connection freeze
 in mysql_real_connect

 But when I try to use libmysqlclient_r.so
 program crash in my_fopen

 this is stack of program :
 (gdb) bt
 #0  0x180ef7f2 in my_fopen () from
 /usr/local/mysql/lib/libmysqlclient_r.so.10
 #1  0x180f0b20 in search_default_file ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #2  0x180f085f in load_defaults ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #3  0x180e776b in mysql_read_default_options ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #4  0x180e8054 in mysql_real_connect ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10
 #5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
 db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net,
 user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1,
 connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
 at connection.cc:52
 #6  0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138
 #7  0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23
 #8  0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
 #9  0x0 in ?? ()
 (gdb) frame 5
 #5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
 db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net,
 user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1,
 connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
 at connection.cc:52
 52  if (mysql_real_connect(mysql,host,user,passwd,db,
 port,socket_name,client_flag))
 (gdb) p host
 $1 = (cchar *) 0x80fa040 xxx.xxx.net
 (gdb) p user
 $2 = (cchar *) 0x80fd910 test
 (gdb) p passwd
 $3 = (cchar *) 0x80c1bca 
 (gdb) p db
 $4 = (cchar *) 0x80fd8b0 kuku
 (gdb) p port
 $5 = 3306
 (gdb) p socket_name
 $6 = 0x80c1bde 
 (gdb) p client_flag
 $7 = 0
 (gdb)

 OS FreeBSD 4.4-RC
 mysql version 3.23.42, but I try to use 3.23.49 with the same effect

 Will anybody help me?

 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





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




-
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




Re: problem with libmysqlclient_r.so

2002-04-22 Thread Sinisa Milivojevic

Andrey Kotrekhov writes:
 Hello, All!
 
 I have program which try to connect to different mysql servers twice at
 the same time.
 When I use libmysqlclient.so sometimes one or two mysql connection freeze
 in mysql_real_connect
 
 But when I try to use libmysqlclient_r.so
 program crash in my_fopen
 
 this is stack of program :
 (gdb) bt
 #0  0x180ef7f2 in my_fopen () from
 /usr/local/mysql/lib/libmysqlclient_r.so.10
 #1  0x180f0b20 in search_default_file ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10

[skip]

Hi!

First of all, what version of limysql are you using ??

Second, please do : frame 1 and let us know the values for the
following parameters :

  const char *dir, const char *config_file,  const char *ext, TYPELIB *group)

 OS FreeBSD 4.4-RC
 mysql version 3.23.42, but I try to use 3.23.49 with the same effect
 
 Will anybody help me?
 
 Best regards.
 ___
   Andrey Kotrekhov [EMAIL PROTECTED]
   ISP Alkar Teleport
   ÔÅÌ. +380 562 34-00-44
 
 
 
 

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




Re: problem with libmysqlclient_r.so

2002-04-22 Thread Andrey Kotrekhov

äÏÂÒÙÊ ÄÅÎØ.

 Andrey Kotrekhov writes:
  Hello, All!
 
  I have program which try to connect to different mysql servers twice at
  the same time.
  When I use libmysqlclient.so sometimes one or two mysql connection freeze
  in mysql_real_connect
 
  But when I try to use libmysqlclient_r.so
  program crash in my_fopen
 
  this is stack of program :
  (gdb) bt
  #0  0x180ef7f2 in my_fopen () from
  /usr/local/mysql/lib/libmysqlclient_r.so.10
  #1  0x180f0b20 in search_default_file ()
 from /usr/local/mysql/lib/libmysqlclient_r.so.10

 [skip]

 Hi!

 First of all, what version of limysql are you using ??

?
this example is from mysql 3.23.42
libmysqlclient_r.so.10



 Second, please do : frame 1 and let us know the values for the
 following parameters :

   const char *dir, const char *config_file,  const char *ext, TYPELIB *group)

#1  0x180f0b20 in search_default_file ()
from /usr/local/mysql/lib/libmysqlclient_r.so.10

Will I need to compile mysql with --with-debug option to see parameters?


  OS FreeBSD 4.4-RC
  mysql version 3.23.42, but I try to use 3.23.49 with the same effect
 
  Will anybody help me?
 
  Best regards.
  ___
  Andrey Kotrekhov [EMAIL PROTECTED]
  ISP Alkar Teleport
  ÔÅÌ. +380 562 34-00-44
 
 
 
 

 --
 Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
 /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
___/   www.mysql.com



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




Re: problem with libmysqlclient_r.so

2002-04-22 Thread Sinisa Milivojevic

Andrey Kotrekhov writes:
 äÏÂÒÙÊ ÄÅÎØ.
 
 #1  0x180f0b20 in search_default_file ()
 from /usr/local/mysql/lib/libmysqlclient_r.so.10
 
 Will I need to compile mysql with --with-debug option to see parameters?
 
 Best regards.
 ___
   Andrey Kotrekhov [EMAIL PROTECTED]
   ISP Alkar Teleport
   ÔÅÌ. +380 562 34-00-44
 

Yes, including libmysys source files .

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




Re: problem with libmysqlclient_r.so

2002-04-21 Thread Gelu

Hi,
You use and two different mysql_init ?
Regards,
Gelu

_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Andrey Kotrekhov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 21, 2002 4:55 PM
Subject: problem with libmysqlclient_r.so


Hello, All!

I have program which try to connect to different mysql servers twice at
the same time.
When I use libmysqlclient.so sometimes one or two mysql connection freeze
in mysql_real_connect

But when I try to use libmysqlclient_r.so
program crash in my_fopen

this is stack of program :
(gdb) bt
#0  0x180ef7f2 in my_fopen () from
/usr/local/mysql/lib/libmysqlclient_r.so.10
#1  0x180f0b20 in search_default_file ()
   from /usr/local/mysql/lib/libmysqlclient_r.so.10
#2  0x180f085f in load_defaults ()
   from /usr/local/mysql/lib/libmysqlclient_r.so.10
#3  0x180e776b in mysql_read_default_options ()
   from /usr/local/mysql/lib/libmysqlclient_r.so.10
#4  0x180e8054 in mysql_real_connect ()
   from /usr/local/mysql/lib/libmysqlclient_r.so.10
#5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net,
user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1,
connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
at connection.cc:52
#6  0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138
#7  0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23
#8  0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4
#9  0x0 in ?? ()
(gdb) frame 5
#5  0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18,
db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net,
user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1,
connect_timeout=60, socket_name=0x80c1bde , client_flag=0)
at connection.cc:52
52  if (mysql_real_connect(mysql,host,user,passwd,db,
port,socket_name,client_flag))
(gdb) p host
$1 = (cchar *) 0x80fa040 xxx.xxx.net
(gdb) p user
$2 = (cchar *) 0x80fd910 test
(gdb) p passwd
$3 = (cchar *) 0x80c1bca 
(gdb) p db
$4 = (cchar *) 0x80fd8b0 kuku
(gdb) p port
$5 = 3306
(gdb) p socket_name
$6 = 0x80c1bde 
(gdb) p client_flag
$7 = 0
(gdb)

OS FreeBSD 4.4-RC
mysql version 3.23.42, but I try to use 3.23.49 with the same effect

Will anybody help me?

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




-
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