Hi there,
On Wed, 17 Jan 2001, Sinisa Milivojevic wrote:
>
> First of all, you should not over-complicated things. Even in our
> server we do not call fork, as we have threads.
I don't want to call fork, because there are advantages of using threads
in this process (not involving mysql) that I then loose. I was just
trying to show that the problem only occurs when the thread is in a
process with other threads with connections to the mysql server.
>
> The error is possibly in your db_connect() wrapper. You must use each
> time a different MYSQL * pointer for each mysql_real_connect and
> separate query , result and row pointers too.
Yes, I'm doing this. The dbm structure I pass to that wrapper (stands for
database module) contains the MYSQL * pointer within it. I'm now thinking
that the problem must stem from calling dlopen() on libmysqlclient_r from
different threads is the most likely cause of the problem. I'm going to
investigate with calling it just once in the original thread and see if
that corrects the problem.
By the way, this is mysql 3.23.28-gamma on a Solaris 8 box using pthreads
in the client lib, server, and my program.
Kyle
> >
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
---------------------------------------------------------------------
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
