[debian-mysql] Bug#444422: mysql_library_end() complains about threads not exiting

[Paul Millar]

Package: libmysqlclient15off
Version: 5.0.45-1
Severity: normal

--- Please enter the report below this line. ---

When a multi-threaded MySQL client makes more than one connection to the DB, 
mysql_library_end() pauses for about 5 seconds, then gives an error message 
on stderr.  The exact error message depends on the number of threads that 
were active, i.e. the number of established DB connections.

For a single thread, there is no error; the code terminates cleanly.

When run with 2 threads (so, 2 DB connections), the error msg is:
Error in my_thread_global_end(): 1 threads didn't exit

When run with 3 threads, the error is:
Error in my_thread_global_end(): 2 threads didn't exit

For 4 threads, the error msg complains about 3 threads, etc.

I've written a small program that demonstrates this problem.  The code is 
available from:
  http://ppewww.physics.gla.ac.uk/~paul/mysql/mysql-problem.c

Instructions on how to compile and use the program are given within the code.

--- System information. ---
Architecture: i386
Kernel:       Linux 2.6.22-2-686

Debian Release: lenny/sid
  500 unstable        www.mirrorservice.org 
  500 unstable        www.debian-multimedia.org 
  500 stable          security.debian.org 

--- Package information. ---
Depends                      (Version) | Installed
======================================-+-======================
mysql-common             (>= 5.0.45-1) | 5.0.45-1
libc6                       (>= 2.6-1) | 2.6.1-5
zlib1g           (>= 1:1.2.3.3.dfsg-1) | 1:1.2.3.3.dfsg-5