Reappeared problem with threads on linux

Hi,
I've just compiled current bitkeeper sources (fresh clone)
of 4.0 tree, and I see the following:

How-To-Repeat:

../configure --prefix=/usr/local/mysql --with-extra-charsets=complex
--with-server-suffix= --enable-thread-safe-client --enable-local-infile
--enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O3
-mcpu=pentiumpro ' 'CXXFLAGS=-O3 -mcpu=pentiumpro -felide-constructors
-fno-exceptions -fno-rtti' CXX=gcc LDFLAGS=-static --with-pstack
--without-innodb --without-bdb

# cd mysql-BK20030204
# libexec/mysqld --port=3307 --datadir=/data/mysql2 --socket=/tmp/mysql-socket2 --skip-locking --user=mysql --basedir=/usr/local/mysql
crashing: /proc/29329/exe: Permission denied
BFD load failed..
libexec/mysqld: ready for connections
030204 12:30:46 libexec/mysqld: Normal shutdown
030204 12:30:46 libexec/mysqld: Shutdown Complete

# cd ../mysql-standard-4.0.9-gamma-pc-linux-i686/
# bin/mysqld --port=3307 --datadir=/data/mysql2 --socket=/tmp/mysql-socket2 --skip-locking --user=mysql --basedir=/usr/local/mysql
bin/mysqld: ready for connections


When running under gdb (binary with full debug already), I see:

Starting program: /usr/scratch/mysql-4.0/sql/mysqld --port=3307 --datadir=/data/mysql2 --socket=/tmp/mysql-socket2 --skip-locking --user=mysql --basedir=/usr/local/mysql

Breakpoint 2, 0x081db2a2 in safe_mutex_global_init () at thr_mutex.c:254
254 }
Current language: auto; currently c
(gdb) where
#0 0x081db2a2 in safe_mutex_global_init () at thr_mutex.c:254
#1 0x081c5322 in my_init () at my_init.c:74
#2 0x08088087 in main (argc=7, argv=0xbffffb84) at mysqld.cc:2003
#3 0x081fd315 in __libc_start_main ()
(gdb) s
my_init () at my_init.c:81
81 my_thread_global_init();
(gdb)
crashing: /proc/5806/exe: Permission denied
BFD load failed..
/usr/scratch/mysql-4.0/sql/mysqld: ready for connections


--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585

------------------------------------------------------------ ---------
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 bugs-thread13664@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> Hi,
> I've just compiled current bitkeeper sources (fresh clone)
> of 4.0 tree, and I see the following:
>=20
> How-To-Repeat:
>=20
> ./configure --prefix=3D/usr/local/mysql --with-extra-charsets=3Dcompl=
ex
> --with-server-suffix=3D --enable-thread-safe-client --enable-local-in=
file
> --enable-assembler --with-mysqld-ldflags=3D-all-static
> --with-client-ldflags=3D-all-static --disable-shared 'CFLAGS=3D-O3
> -mcpu=3Dpentiumpro ' 'CXXFLAGS=3D-O3 -mcpu=3Dpentiumpro -felide-const=
ructors
> -fno-exceptions -fno-rtti' CXX=3Dgcc LDFLAGS=3D-static --with-pstack
> --without-innodb --without-bdb
>=20
>=20
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

Can you increase thread_stack to 192K and see if it changes anything ??=


--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13678@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

On Tue, 4 Feb 2003, Sinisa Milivojevic wrote:

> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi,
> > I've just compiled current bitkeeper sources (fresh clone)
> > of 4.0 tree, and I see the following:
> >
> > How-To-Repeat:
> >
> > ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex
> > --with-server-suffix= --enable-thread-safe-client --enable-local-infile
> > --enable-assembler --with-mysqld-ldflags=-all-static
> > --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O3
> > -mcpu=pentiumpro ' 'CXXFLAGS=-O3 -mcpu=pentiumpro -felide-constructors
> > -fno-exceptions -fno-rtti' CXX=gcc LDFLAGS=-static --with-pstack
> > --without-innodb --without-bdb

> Can you increase thread_stack to 192K and see if it changes anything ??

No, it doesn't.

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585

------------------------------------------------------------ ---------
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 bugs-thread13684@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

Hi,

Same problem here with latest bk pull, the load keeps increasing... (at
stopped mysqld when the server load was at more 100)
I stay with 4.0.9 binaries which just works fine.

Regards,
Jocelyn
----- Original Message -----
From: "Martin MOKREJ©"
To:
Sent: Tuesday, February 04, 2003 12:12 PM
Subject: Reappeared problem with threads on linux


> Hi,
> I've just compiled current bitkeeper sources (fresh clone)
> of 4.0 tree, and I see the following:
>
> How-To-Repeat:
>
> ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex
> --with-server-suffix= --enable-thread-safe-client --enable-local-infile
> --enable-assembler --with-mysqld-ldflags=-all-static
> --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O3
> -mcpu=pentiumpro ' 'CXXFLAGS=-O3 -mcpu=pentiumpro -felide-constructors
> -fno-exceptions -fno-rtti' CXX=gcc LDFLAGS=-static --with-pstack
> --without-innodb --without-bdb
>
> # cd mysql-BK20030204
> #
libexec/mysqld --port=3307 --datadir=/data/mysql2 --socket=/tmp/mysql-socket
2 --skip-locking --user=mysql --basedir=/usr/local/mysql
> crashing: /proc/29329/exe: Permission denied
> BFD load failed..
> libexec/mysqld: ready for connections
> 030204 12:30:46 libexec/mysqld: Normal shutdown
> 030204 12:30:46 libexec/mysqld: Shutdown Complete
>
> # cd ../mysql-standard-4.0.9-gamma-pc-linux-i686/
> #
bin/mysqld --port=3307 --datadir=/data/mysql2 --socket=/tmp/mysql-socket2 --
skip-locking --user=mysql --basedir=/usr/local/mysql
> bin/mysqld: ready for connections
>
>
> When running under gdb (binary with full debug already), I see:
>
> Starting program:
/usr/scratch/mysql-4.0/sql/mysqld --port=3307 --datadir=/data/mysql2 --socke
t=/tmp/mysql-socket2 --skip-locking --user=mysql --basedir=/usr/local/mysql
>
> Breakpoint 2, 0x081db2a2 in safe_mutex_global_init () at thr_mutex.c:254
> 254 }
> Current language: auto; currently c
> (gdb) where
> #0 0x081db2a2 in safe_mutex_global_init () at thr_mutex.c:254
> #1 0x081c5322 in my_init () at my_init.c:74
> #2 0x08088087 in main (argc=7, argv=0xbffffb84) at mysqld.cc:2003
> #3 0x081fd315 in __libc_start_main ()
> (gdb) s
> my_init () at my_init.c:81
> 81 my_thread_global_init();
> (gdb)
> crashing: /proc/5806/exe: Permission denied
> BFD load failed..
> /usr/scratch/mysql-4.0/sql/mysqld: ready for connections
>
>
> --
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax: +49-89-3187 3585
>
> ------------------------------------------------------------ ---------
> 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 bugs-thread13664@lists.mysql.com
> To unsubscribe, e-mail
>
>


------------------------------------------------------------ ---------
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 bugs-thread13683@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

Jocelyn Fournier writes:
> Hi,
>
> Same problem here with latest bk pull, the load keeps increasing... (at
> stopped mysqld when the server load was at more 100)
> I stay with 4.0.9 binaries which just works fine.
>
> Regards,
> Jocelyn

This is from the latest 4.0 BK build:

/mnt/work/mysql-4.0/sql/mysqld --port=3307
--datadir=/usr/local/var --socket=/tmp/mysql-socket2 --skip-locking
--skip-innodb --language=/mnt/work/mysql-4.0/sql/share/english/ &
/mnt/work/mysql-4.0/sql/mysqld: ready for connections.
Version: '4.0.10-gamma-debug' socket: '/tmp/mysql-socket2' port: 3307

It is running for 30 minutes now, with load less then 0.1 %.

I have only changed few minor options, which can't influence the
outcome.

You definitely have some problems with your glibc.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13696@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

Hi,

I've no load problem with 4.1 compiled from bk tree.
BTW latest bk tree displays 4.0.11, not 4.0.10 like in your input ??

Regards,
Jocelyn
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc: ;
Sent: Wednesday, February 05, 2003 6:00 PM
Subject: Re: Reappeared problem with threads on linux


> Jocelyn Fournier writes:
> > Hi,
> >
> > Same problem here with latest bk pull, the load keeps increasing... (at
> > stopped mysqld when the server load was at more 100)
> > I stay with 4.0.9 binaries which just works fine.
> >
> > Regards,
> > Jocelyn
>
> This is from the latest 4.0 BK build:
>
> /mnt/work/mysql-4.0/sql/mysqld --port=3307
> --datadir=/usr/local/var --socket=/tmp/mysql-socket2 --skip-locking
> --skip-innodb --language=/mnt/work/mysql-4.0/sql/share/english/ &
> /mnt/work/mysql-4.0/sql/mysqld: ready for connections.
> Version: '4.0.10-gamma-debug' socket: '/tmp/mysql-socket2' port: 3307
>
> It is running for 30 minutes now, with load less then 0.1 %.
>
> I have only changed few minor options, which can't influence the
> outcome.
>
> You definitely have some problems with your glibc.
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
> Join MySQL Users Conference and Expo:
> http://www.mysql.com/events/uc2003/
>
>
How-to-repeat ...

------------------------------------------------------------ ---------
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 bugs-thread13695@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

Jocelyn Fournier writes:
> Hi,
>
> I've no load problem with 4.1 compiled from bk tree.
> BTW latest bk tree displays 4.0.11, not 4.0.10 like in your input ??
>
> Regards,
> Jocelyn

Well, I have yet to push lot's of fixes, when I will pull other stuff,
which will fix my version ....

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13708@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

On Wed, 5 Feb 2003, Sinisa Milivojevic wrote:

Hi,
I have found that ny binaries (static) actually work quite well on our
second linux server. I've checked the libc version reported by mysqlbug(1)
on both machines, and they are same. The only difference was that the
problematic box was running 2.4.20 instead of 2.4.19. But installing
2.4.19 did not actually help. :( Both are SMP kernels, on the server where
in not the problem with threads is also HIGHMEM kernel, lvm. I'll try to
dig more into this.

Does it make sense to check library version, when the binaries are
static? ;)

So what can be the cause?


> Jocelyn Fournier writes:
> > Hi,
> >
> > Same problem here with latest bk pull, the load keeps increasing... (at
> > stopped mysqld when the server load was at more 100)
> > I stay with 4.0.9 binaries which just works fine.
> >
> > Regards,
> > Jocelyn
>
> This is from the latest 4.0 BK build:
>
> /mnt/work/mysql-4.0/sql/mysqld --port=3307
> --datadir=/usr/local/var --socket=/tmp/mysql-socket2 --skip-locking
> --skip-innodb --language=/mnt/work/mysql-4.0/sql/share/english/ &
> /mnt/work/mysql-4.0/sql/mysqld: ready for connections.
> Version: '4.0.10-gamma-debug' socket: '/tmp/mysql-socket2' port: 3307
>
> It is running for 30 minutes now, with load less then 0.1 %.
>
> I have only changed few minor options, which can't influence the
> outcome.
>
> You definitely have some problems with your glibc.
>
>

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585

------------------------------------------------------------ ---------
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 bugs-thread13711@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Wed, 5 Feb 2003, Sinisa Milivojevic wrote:
>=20
> Hi,
> I have found that ny binaries (static) actually work quite well on =
our
> second linux server. I've checked the libc version reported by mysqlb=
ug(1)
> on both machines, and they are same. The only difference was that the=

> problematic box was running 2.4.20 instead of 2.4.19. But installing
> 2.4.19 did not actually help. :( Both are SMP kernels, on the server =
where
> in not the problem with threads is also HIGHMEM kernel, lvm. I'll try=
to
> dig more into this.
>=20
> Does it make sense to check library version, when the binaries are
> static? ;)
>=20
> So what can be the cause?
>=20
>=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20


Static libraries can also be problematic.

It is when you link with fine static libs that you should not have
problems.=20

Which is why we recommend our binaries for Linux.=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13712@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

On Thu, 6 Feb 2003, Sinisa Milivojevic wrote:

> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > On Wed, 5 Feb 2003, Sinisa Milivojevic wrote:
> >
> > Hi,
> > I have found that ny binaries (static) actually work quite well on our
> > second linux server. I've checked the libc version reported by mysqlbug(1)
> > on both machines, and they are same. The only difference was that the
> > problematic box was running 2.4.20 instead of 2.4.19. But installing
> > 2.4.19 did not actually help. :( Both are SMP kernels, on the server where
> > in not the problem with threads is also HIGHMEM kernel, lvm. I'll try to
> > dig more into this.
> >
> > Does it make sense to check library version, when the binaries are
> > static? ;)
> >
> > So what can be the cause?

> Static libraries can also be problematic.

Sure, but should cause problem on both machines.

>
> It is when you link with fine static libs that you should not have
> problems.

But buggy static libs from source box should cause problem on target
machine too! -- but they don't. That's why I'm looking for difference in
kernel. Are the other things to look at?

>
> Which is why we recommend our binaries for Linux.

I'll look if 4.0.11 is already available. ;)
--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585

------------------------------------------------------------ ---------
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 bugs-thread13713@lists.mysql.com
To unsubscribe, e-mail

Re: Reappeared problem with threads on linux

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Thu, 6 Feb 2003, Sinisa Milivojevic wrote:
>=20
>=20
> Sure, but should cause problem on both machines.
>=20

You are forgetting about dynamic part of glibc !!!

Try running nscd, may be that will solve your problems.=20

> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20
>=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13718@lists.mysql.com
To unsubscribe, e-mail