library/3238: MySQL compiled from ports tree crashing on OpenBSD 3.3

>Number: 3238
>Category: library
>Synopsis: MySQL compiled from ports tree crashing on OpenBSD 3.3
>Confidential: yes
net
>Environment:
        

	System      : OpenBSD 3.3
	Architecture: OpenBSD.i386
	Machine     : i386
	Kernel      : GENERIC
	Libraries   :
	/usr/local/libexec/mysqld:
		-lwrap.3 => /usr/lib/libwrap.so.3.0 (0x40241000)
		-lz.2 => /usr/lib/libz.so.2.0 (0x40249000)
		-lm.1 => /usr/lib/libm.so.1.0 (0x40256000)
		-lpthread.1 => /usr/lib/libpthread.so.1.0 (0x4026a000)
		-lc.29 => /usr/lib/libc.so.29.0 (0x40281000)

>Description:

	MySQL 3.23.55 (mysqld) from OpenBSD 3.3 ports tree is frequently crashing.
	After crash mysqld is restarted by safe_mysqld script. After some restarts mysqld
	stops responding to requests.

	MySQL error message from log file:
	pid 12096: Fatal error '_pq_first: pq_active' at line 219 in file /usr/src/lib/libpthread/uthread/uthread_priority_queue.c (errno = 35)
	Abort
	030427 23:47:51  mysqld restarted

	On OpenBSD 3.2 (on that machine) MySQL works OK.

>How-To-Repeat:

	# cd /usr/ports/databases/mysql && make install
	# /usr/local/bin/safe_mysqld &

	Wait few hours (generate some load) - mysql will restart itself.

>Fix:

	None known.

>Release-Note:
Received on Sun Apr 27 18:20:20 2003