strange mysql bug, possibly thread related

[Konstantinos Koukopoulos]

On Sat 03 Dec 2005 11:31, Petr Salinger wrote:
> > does anyone have any
> > ideas as to what I should look at or what I should try?
>
> Which combination of kernel/libc is failing ?
>
> libc0.1 2.3-1+kbsd.14 + kfreebsd-image-5.4-1-686 5.4-8
> libc0.1 2.3-1+kbsd.11 + kfreebsd-image-5.4-1-686 5.4-8
> libc0.1 2.3-1+kbsd.11 + kfreebsd-image-5.4-1-686 5.4-7
>

I first noticed the problem when I rebooted some time after the packages were 
automatically upgraded to:
libc0.1 2.3-1+kbsd.14 + kfreebsd-image-5.4-1-686 5.4-8
So this combination is failing for sure.

After reading the changelog for kfreebsd-image-5.4-1 I  saw that there were 
some threading changes in that release so I tried downgrading kfreebsd-image 
to version 5.4-7. I rebooted but this still did not fix the problem. So that 
means that for me also the following combination does not work:
libc0.1 2.3-1+kbsd.14 + kfreebsd-image-5.4-1-686 5.4-7.

Next I downgraded libc to version 2.3-1+kbsd.11 and rebooted. This combination 
is what I currently have running and mysql is working like before.

> Of course kernel have to be running, not only installed.
>

of course.

> Please specify version also of version and package
> of mysql-server - 4.1 or 5.0 ?

The problem appeared while I was running mysql-server-4.1 version 4.1.15-1. 
Before I started experimenting with the kernel and libc packages I tried 
upgrading to mysql-server-5.0 version 5.0.16-1, which is what I have running 
now. I suppose that mysql 4.1 works as well.

Cheers,
Kostas