From: Eric Bergen Date: July 1 2004 1:06am Subject: Re: threading problems in linux C client List-Archive: http://lists.mysql.com/mysql/168223 Message-Id: <11b1bd9904063018062de4d3aa@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit If you have multiple threads accessing the same connection remember to make sure that only one thread enters mysql_query() mysql_connect() or mysql_store_result() after you store the result another thread will be able to use that connection without problems. -Eric On Wed, 30 Jun 2004 11:01:35 +0000, darren wrote: > > Hi all, > > I am writing a multi-threaded client that requires shared access to a single MySQL connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm installed and compiled with -l libmysqlclient_r. > > The connection is made from the main thread and a MYSQL_RES* myres declared from the child thread is used to fetch results back to the thread. I get a Segmentation fault the first instance my child thread (only one) accesses MYSQL_RES through mysql_num_rows(myres). (gdb informed me that this is due to mysql_num_rows from libmysqlclient_r.so.10) > > I have read a few docs about writing MySQL multi-threaded clients and have called my_init() in my main prog and my_thread_init() at the first line of my thread handler. > > Any ideas? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eric.bergen@stripped > >