compile failure with patch BSD/OS 4.1

>Description:
compile failure, see self-explantory patch
>How-To-Repeat:
compile on a BSD/OS 4.1 system. Newer versions untested.
>Fix:
patch:

--- mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
+++ mysys/my_semaphore.c Tue Jul 30 01:59:02 2002
@@ -23,6 +23,9 @@
#include

#if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
+#include
+
+extern int errno;

int sem_init(sem_t * sem, int pshared, uint value)
{

>Submitter-Id:
>Originator: Melvyn Sopacua
>Organization:

>MySQL support: none
>Synopsis: compile failure
>Severity: serious
>Priority: medium
>Category: mysqld
>Class: sw-bug
>Release: mysql-4.0.2-alpha (first_try_BSDi_41)
>Server: /mysql/bin/mysqladmin Ver 8.35 Distrib 4.0.2-alpha, for pc-bsdi4.1 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.0.2-alpha
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /mysql/tmp/mysql.sock
Uptime: 54 sec

Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.019
>Environment:

System: BSD/OS bsdi.nyvlem.mine.nu 4.1 BSDI BSD/OS 4.1 Kernel #0: Wed Oct 24 20:47:39 CEST 2001 root@bsdi.nyvlem.mine.nu:/usr/src/sys/compile/cvs2 i386


Some paths: /perl/bin/perl /home/mdev/local/bin/make /home/mdev/local/bin/gmake /home/mdev/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /home/mdev/local/lib/gcc-lib/i386-pc-bsdi4.1/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='/home/mdev/local/bin/gcc' CFLAGS='-O0 -mcpu=pentium -fno-strength-reduce' CXX='/home/mdev/local/bin/g++' CXXFLAGS='-O0 -mcpu=pentium -fno-rtti -fno-exceptions -felide-constructors -fno-strength-reduce' LDFLAGS='-ldmalloc'
LIBC:
-r--r--r-- 1 bin bin 1620654 Jul 28 2000 /usr/lib/libc.a
-r--r--r-- 1 bin bin 8561 Nov 22 1999 /usr/lib/libc.except
Configure command: ./configure --prefix=/mysql --enable-assembler --mandir=/home/mdev/local/man --disable-largefile --with-gnu-ld --with-unix-socket-path=/mysql/tmp/mysql.sock --with-mysql-user=mysql --without-debug --with-comment=first_try_BSDi_41 --without-docs --without-bench --with-extra-charsets=none --without-isam --without-innodb --with-pthread LDFLAGS=-ldmalloc 'CFLAGS=-O0 -mcpu=pentium -fno-strength-reduce' CXX=/home/mdev/local/bin/g++ CC=/home/mdev/local/bin/gcc 'CXXFLAGS=-O0 -mcpu=pentium -fno-rtti -fno-exceptions -felide-constructors -fno-strength-reduce'


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

Re: compile failure with patch BSD/OS 4.1

mdev@nyvlem.mine.nu writes:
> >Description:
> compile failure, see self-explantory patch
> >How-To-Repeat:
> compile on a BSD/OS 4.1 system. Newer versions untested.
> >Fix:
> patch:
>
> --- mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
> +++ mysys/my_semaphore.c Tue Jul 30 01:59:02 2002
> @@ -23,6 +23,9 @@
> #include
>
> #if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
> +#include
> +
> +extern int errno;
>
> int sem_init(sem_t * sem, int pshared, uint value)
> {
>

Hi!

Thank you for your patch, but I truly do not think that this would be
ideal location for the include path.

Please, would you be so kind to check whether including semaphore.h
on BSDi includes errno.h ...

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


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

Re: compile failure with patch BSD/OS 4.1

On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:

[...]
SM>>> > --- mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
SM>>> > +++ mysys/my_semaphore.c Tue Jul 30 01:59:02 2002
SM>>> > @@ -23,6 +23,9 @@
SM>>> > #include
SM>>> >
SM>>> > #if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
SM>>> > +#include
SM>>> > +
SM>>> > +extern int errno;
SM>>> >
SM>>> > int sem_init(sem_t * sem, int pshared, uint value)
SM>>> > {
SM>>> >
SM>>>
SM>>> Hi!
SM>>>
SM>>> Thank you for your patch, but I truly do not think that this would be
SM>>> ideal location for the include path.

I agree :-).

SM>>>
SM>>> Please, would you be so kind to check whether including semaphore.h
SM>>> on BSDi includes errno.h ...

Hmm, I don't see why that would help, given the preprocessor statement
before that line:
!defined(HAVE_SEMAPHORE_H)

I've tracked it a bit better, but since this is a fairly slow system,
it'll be a while since I can give your results on it. It also needs to
autoconf and stuff, so...

A new patch is below, but on the other hand, looking at all the functions
defined in that file, I don't see them available in any header on my
system. Nor on a BSDI 4.2 system for that matter.
The sys/semaphore.h header only defines a struct:
#include

typedef struct semaphore {
u_short spins; /* times to spin before blocking
*/
u_short want; /* want flag */
u_char lock; /* lock */
} sem_t;

#ifndef KERNEL
__BEGIN_DECLS
int sem_lock __P((sem_t *));
int sem_wakeup __P((sem_t *));
__END_DECLS
#endif


Regardless - here's the patch I'm trying out now.

--- ./include/my_semaphore.h.dist Mon Jul 1 13:16:44 2002
+++ ./include/my_semaphore.h Tue Jul 30 16:25:05 2002
@@ -35,6 +35,8 @@

#ifdef HAVE_SEMAPHORE_H
#include
+#elif HAVE_SYS_SEMAPHORE_H
+#include
#else

#ifdef __WIN__
--- ./mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
+++ ./mysys/my_semaphore.c Tue Jul 30 16:20:54 2002
@@ -22,7 +22,12 @@
#include
#include

-#if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
+#if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H && !defined HAVE_SYS_SEMAPHORE_H)
+/* don't know if this is the right place
+#include
+
+extern int errno;
+*/

int sem_init(sem_t * sem, int pshared, uint value)
{
--- ./configure.in.dist Mon Jul 1 13:16:15 2002
+++ ./configure.in Tue Jul 30 16:19:01 2002
@@ -1529,7 +1529,7 @@
AC_CHECK_HEADERS(varargs.h stdarg.h dirent.h locale.h ndir.h sys/dir.h \
sys/file.h sys/ndir.h sys/ptem.h sys/pte.h sys/select.h sys/stream.h \
sys/mman.h curses.h termcap.h termio.h termbits.h asm/termbits.h grp.h \
-paths.h semaphore.h)
+paths.h semaphore.h sys/semaphore.h)

# Already-done: strcasecmp
AC_CHECK_FUNCS(lstat putenv select setenv setlocale strcoll tcgetattr)


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

Re: compile failure with patch BSD/OS 4.1

Melvyn Sopacua writes:
> On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:
>
> [...]
> SM>>> > --- mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
> SM>>> > +++ mysys/my_semaphore.c Tue Jul 30 01:59:02 2002
> SM>>> > @@ -23,6 +23,9 @@
> SM>>> > #include
> SM>>> >
> SM>>> > #if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
> SM>>> > +#include
> SM>>> > +
> SM>>> > +extern int errno;
> SM>>> >
> SM>>> > int sem_init(sem_t * sem, int pshared, uint value)
> SM>>> > {
> SM>>> >
> SM>>>
> SM>>> Hi!
> SM>>>
> SM>>> Thank you for your patch, but I truly do not think that this would be
> SM>>> ideal location for the include path.
>
> I agree :-).
>
> SM>>>
> SM>>> Please, would you be so kind to check whether including semaphore.h
> SM>>> on BSDi includes errno.h ...
>

Hi!

Please let me know if this change in my_semaphore.h would work on your
BSDI:


......

#ifdef HAVE_SEMAPHORE_H
#include
#else
#ifdef _BSDI_VERSION
#include
#include
#else
#ifdef __WIN__
typedef HANDLE sem_t;
#else
typedef struct {
pthread_mutex_t mutex;
pthread_cond_t cond;
uint count;
} sem_t;
#endif
#endif
......



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


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

Re: compile failure with patch BSD/OS 4.1

On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:

SM>>> Date: Tue, 30 Jul 2002 18:10:04 +0300
SM>>> From: Sinisa Milivojevic
SM>>> To: mdev@nyvlem.mine.nu
SM>>> Cc: bugs@lists.mysql.com
SM>>> Subject: Re: compile failure with patch BSD/OS 4.1
SM>>>
SM>>> Melvyn Sopacua writes:
SM>>> > On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:
SM>>> >
SM>>> > [...]
SM>>> > SM>>> > --- mysys/my_semaphore.c.dist Mon Jul 1 13:16:53 2002
SM>>> > SM>>> > +++ mysys/my_semaphore.c Tue Jul 30 01:59:02 2002
SM>>> > SM>>> > @@ -23,6 +23,9 @@
SM>>> > SM>>> > #include
SM>>> > SM>>> >
SM>>> > SM>>> > #if !defined(__WIN__) && !defined(HAVE_SEMAPHORE_H)
SM>>> > SM>>> > +#include
SM>>> > SM>>> > +
SM>>> > SM>>> > +extern int errno;
SM>>> > SM>>> >
SM>>> > SM>>> > int sem_init(sem_t * sem, int pshared, uint value)
SM>>> > SM>>> > {
SM>>> > SM>>> >
SM>>> > SM>>>
SM>>> > SM>>> Hi!
SM>>> > SM>>>
SM>>> > SM>>> Thank you for your patch, but I truly do not think that this would be
SM>>> > SM>>> ideal location for the include path.
SM>>> >
SM>>> > I agree :-).
SM>>> >
SM>>> > SM>>>
SM>>> > SM>>> Please, would you be so kind to check whether including semaphore.h
SM>>> > SM>>> on BSDi includes errno.h ...
SM>>> >
SM>>>
SM>>> Hi!
SM>>>
SM>>> Please let me know if this change in my_semaphore.h would work on your
SM>>> BSDI:
SM>>>
SM>>>
SM>>> .....
SM>>>
SM>>> #ifdef HAVE_SEMAPHORE_H
SM>>> #include
SM>>> #else
SM>>> #ifdef _BSDI_VERSION
SM>>> #include
SM>>> #include
SM>>> #else
SM>>> #ifdef __WIN__
SM>>> typedef HANDLE sem_t;
SM>>> #else
SM>>> typedef struct {
SM>>> pthread_mutex_t mutex;
SM>>> pthread_cond_t cond;
SM>>> uint count;
SM>>> } sem_t;
SM>>> #endif
SM>>> #endif

Alright, I'll do that, because the autotools rebuilding is given me
headache as I have a libtool/automake 1.5 or libtool/automake 1.6
combination the first with autoconf 2.52 and the second with 2.53 so I
first need to set up YAAM (yet another autotools mix).

Anyhow - that's a whole different issue.

I'll let you know, as soon as I know.


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

Re: compile failure with patch BSD/OS 4.1

On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:

SM>>> Hi!
SM>>>
SM>>> Please let me know if this change in my_semaphore.h would work on your
SM>>> BSDI:
SM>>>
SM>>>
SM>>> .....
SM>>>
SM>>> #ifdef HAVE_SEMAPHORE_H
SM>>> #include
SM>>> #else
SM>>> #ifdef _BSDI_VERSION
SM>>> #include
SM>>> #include
SM>>> #else
SM>>> #ifdef __WIN__
SM>>> typedef HANDLE sem_t;
SM>>> #else
SM>>> typedef struct {
SM>>> pthread_mutex_t mutex;
SM>>> pthread_cond_t cond;
SM>>> uint count;
SM>>> } sem_t;
SM>>> #endif
SM>>> #endif
SM>>> .....
SM>>>

No dice, but that's because BSDI_VERSION is not defined. I've used
__BSD__, but if you want to be bsdi specific, __bsdi__ is always
a fair choice.

What remains is conflicting types:
/home/mdev/local/bin/gcc -DDEFAULT_BASEDIR=\"/mysql\"
-DDATADIR="\"/mysql/var\""
-DDEFAULT_CHARSET_HOME="\"/mysql\""
-DDATADIR="\"/mysql/var\""
-DSHAREDIR="\"/mysql/share/mysql\""
-DHAVE_CONFIG_H -I./../include -I../include -I.. -I. -O3 -DDBUG_OFF -O0
-mcpu=pentium -fno-strength-reduce -D__BSD__ -DHAVE_BROKEN_REALPATH -c
my_semaphore.c
In file included from my_semaphore.c:23:
.../include/my_semaphore.h:61: conflicting types for `sem_t'
/usr/include/sys/semaphore.h:53: previous declaration of `sem_t'
make[2]: *** [my_semaphore.o] Error 1
make[2]: Leaving directory `/home/mdev/_src/mysql-4.0.2-alpha/mysys'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/mdev/_src/mysql-4.0.2-alpha'
make: *** [all-recursive-am] Error 2

Which to choose is beyond my knowledge. A simple undef of sem_t would do
it of course, but that would defeat the whole purpose of include
sys/semaphore.h - so you decide :-)


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

Re: compile failure with patch BSD/OS 4.1

Melvyn Sopacua writes:
> On Tue, 30 Jul 2002, Sinisa Milivojevic wrote:
>
> No dice, but that's because BSDI_VERSION is not defined. I've used
> __BSD__, but if you want to be bsdi specific, __bsdi__ is always
> a fair choice.
>
> What remains is conflicting types:
> /home/mdev/local/bin/gcc -DDEFAULT_BASEDIR=\"/mysql\"
> -DDATADIR="\"/mysql/var\""
> -DDEFAULT_CHARSET_HOME="\"/mysql\""
> -DDATADIR="\"/mysql/var\""
> -DSHAREDIR="\"/mysql/share/mysql\""
> -DHAVE_CONFIG_H -I./../include -I../include -I.. -I. -O3 -DDBUG_OFF -O0
> -mcpu=pentium -fno-strength-reduce -D__BSD__ -DHAVE_BROKEN_REALPATH -c
> my_semaphore.c
> In file included from my_semaphore.c:23:
> ../include/my_semaphore.h:61: conflicting types for `sem_t'
> /usr/include/sys/semaphore.h:53: previous declaration of `sem_t'
> make[2]: *** [my_semaphore.o] Error 1
> make[2]: Leaving directory `/home/mdev/_src/mysql-4.0.2-alpha/mysys'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/home/mdev/_src/mysql-4.0.2-alpha'
> make: *** [all-recursive-am] Error 2
>

OK, then please try this :

......

#ifdef HAVE_SEMAPHORE_H
#include
#else
#ifdef __bsdi__
#include
#else
#ifdef __WIN__
typedef HANDLE sem_t;
#else
typedef struct {
pthread_mutex_t mutex;
pthread_cond_t cond;
uint count;
} sem_t;
#endif
#endif
......


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


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:

SM>>> OK, then please try this :
SM>>>
SM>>> .....
SM>>>
SM>>> #ifdef HAVE_SEMAPHORE_H
SM>>> #include
SM>>> #else
SM>>> #ifdef __bsdi__
SM>>> #include
SM>>> #else
SM>>> #ifdef __WIN__
SM>>> typedef HANDLE sem_t;
SM>>> #else
SM>>> typedef struct {
SM>>> pthread_mutex_t mutex;
SM>>> pthread_cond_t cond;
SM>>> uint count;
SM>>> } sem_t;
SM>>> #endif
SM>>> #endif

Yes. That's compiling nicely.
Do you know of anything I should test, that it's not only compiling but
also working correctly?
Then let me know.


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

Re: compile failure with patch BSD/OS 4.1

Melvyn Sopacua writes:
> On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
>
> Yes. That's compiling nicely.
> Do you know of anything I should test, that it's not only compiling but
> also working correctly?
> Then let me know.
>


Just run:

make test

and let me know if it passes tests, so that I can push a change ...

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


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:

SM>>> > Yes. That's compiling nicely.
SM>>> > Do you know of anything I should test, that it's not only compiling but
SM>>> > also working correctly?
SM>>> > Then let me know.
SM>>> >
SM>>>
SM>>>
SM>>> Just run:
SM>>>
SM>>> make test
SM>>>
SM>>> and let me know if it passes tests, so that I can push a change ...

Grr..
Starting Tests

TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------ ------------
alias .... .... .... [ fail ]

time: illegal option -- p

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon


I'll install GNU time for the occasion.


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

Re: compile failure with patch BSD/OS 4.1

Melvyn Sopacua writes:
> On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
>
> I'll install GNU time for the occasion.
>

Please.

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


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:

SM>>> Date: Wed, 31 Jul 2002 18:28:45 +0300
SM>>> From: Sinisa Milivojevic
SM>>> To: mdev@nyvlem.mine.nu
SM>>> Cc: bugs@lists.mysql.com
SM>>> Subject: Re: compile failure with patch BSD/OS 4.1
SM>>>
SM>>> Melvyn Sopacua writes:
SM>>> > On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
SM>>> >
SM>>> > I'll install GNU time for the occasion.
SM>>> >
SM>>>

Argh - the tester is really linux oriented I'm afraid. I've already made a
few adjustments and it's not finishing, but I don't think it's related to
this particular change in the source but to the tester. I'll see if I can
fix up the scripts, to be more portable. But for now I get stuck on this:
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables
--basedir=. --datadir=./var/master-data --skip-innodb --skip-b
db --language=../sql/share/english/
020731 19:01:49 ../sql/mysqld: Shutdown Complete

Installing Slave Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables
--basedir=. --datadir=./var/slave-data --skip-innodb --skip-bd
b --language=../sql/share/english/
020731 19:01:49 ../sql/mysqld: Shutdown Complete

rm: var/slave1-data/: Is a directory
rm: var/slave2-data/: Is a directory
Manager disabled, skipping manager start.
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------ ------------
alias 0.03 0.05 0.23 [ pass ]
alter_table 0.04 0.04 1.09 [ pass ]
analyse 0.03 0.04 0.16 [ pass ]
auto_increment 0.05 0.04 0.44 [ pass ]
backup 0.03 0.05 0.53 [ pass ]
bdb-crash .... .... .... [ skipped ]
bdb-deadlock .... .... .... [ skipped ]
bdb .... .... .... [ skipped ]
bench_count_distinct 0.05 0.08 0.51 [ pass ]
bigint 0.02 0.05 0.40 [ pass ]
binary 0.04 0.03 0.22 [ pass ]
bulk_replace 0.02 0.05 0.12 [ pass ]
case 0.03 0.05 0.14 [ pass ]
check 2.51 1.08 32.18 [ pass ]
comments 0.02 0.04 0.08 [ pass ]
compare 0.02 0.04 0.12 [ pass ]
count_distinct 0.04 0.04 0.36 [ pass ]
count_distinct2 2.46 0.93 22.85 [ pass ]
ERROR: /home/mdev/_src/mysql-4.0.2-alpha/mysql-test/var/run/master. pid was
not created in 400 seconds; Aborting
*** Error code 1

I'll let you know, when I have the time to investigate this more.


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 31 Jul 2002, Melvyn Sopacua wrote:

MS>>> Date: Wed, 31 Jul 2002 19:37:02 +0200 (CEST)
MS>>> From: Melvyn Sopacua
MS>>> To: Sinisa Milivojevic
MS>>> Cc: bugs@lists.mysql.com
MS>>> Subject: Re: compile failure with patch BSD/OS 4.1
MS>>>
MS>>> On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
MS>>>
MS>>> SM>>> Date: Wed, 31 Jul 2002 18:28:45 +0300
MS>>> SM>>> From: Sinisa Milivojevic
MS>>> SM>>> To: mdev@nyvlem.mine.nu
MS>>> SM>>> Cc: bugs@lists.mysql.com
MS>>> SM>>> Subject: Re: compile failure with patch BSD/OS 4.1
MS>>> SM>>>
MS>>> SM>>> Melvyn Sopacua writes:
MS>>> SM>>> > On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
MS>>> SM>>> >
MS>>> SM>>> > I'll install GNU time for the occasion.
MS>>> SM>>> >
MS>>> SM>>>
MS>>>
MS>>> Argh - the tester is really linux oriented I'm afraid. I've already made a
MS>>> few adjustments and it's not finishing, but I don't think it's related to
MS>>> this particular change in the source but to the tester. I'll see if I can
MS>>> fix up the scripts, to be more portable. But for now I get stuck on this:

Just for the record:
Some tests fire up a second master. However - not on an alternate port and
thus clashing, which is why the script doesn't continue. Is this a
test-script bug, or is this actually a mysqld bug?

To be more specific:
I added the port option in:
$ cat t/count_distinct2-master.opt
--set-variable=max_heap_table_size=16384 --port=39230

and then that test passed with glory. Without it - the wait_for_master
waits 30 seconds and then aborts the test, and the error log showing the
can't bind on that port "do you have an alternate runing" message.


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

Re: compile failure with patch BSD/OS 4.1

Melvyn Sopacua writes:
> On Wed, 31 Jul 2002, Melvyn Sopacua wrote:
>
>
> Just for the record:
> Some tests fire up a second master. However - not on an alternate port and
> thus clashing, which is why the script doesn't continue. Is this a
> test-script bug, or is this actually a mysqld bug?
>
> To be more specific:
> I added the port option in:
> $ cat t/count_distinct2-master.opt
> --set-variable=max_heap_table_size=16384 --port=39230
>
> and then that test passed with glory. Without it - the wait_for_master
> waits 30 seconds and then aborts the test, and the error log showing the
> can't bind on that port "do you have an alternate runing" message.
>


Thank you for your contribution.

This seems to be a solution for some systems.

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


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

Re: compile failure with patch BSD/OS 4.1

On Thu, 1 Aug 2002, Sinisa Milivojevic wrote:

SM>>>> To be more specific:
SM>>>> I added the port option in:
SM>>>> $ cat t/count_distinct2-master.opt
SM>>>> --set-variable=max_heap_table_size=16384 --port=39230
SM>>>>
SM>>>> and then that test passed with glory. Without it - the wait_for_master
SM>>>> waits 30 seconds and then aborts the test, and the error log showing the
SM>>>> can't bind on that port "do you have an alternate runing" message.
SM>>>>
SM>>>
SM>>>
SM>>>Thank you for your contribution.
SM>>>
SM>>>This seems to be a solution for some systems.

Actually - it's a workaround, as the original master never shuts down. The
same happens when I use mysqladmin shutdown in the real environment and
the daemon is chrooted. When I chroot the command it shuts down. However -
how this relates to the testkit seems illogical as chrooting doesn't
apply.


Here's how the chroot is setup:
mdev@bsdi /
$ ls -al /mysql
lrwxr-xr-x 1 root wheel 18 Aug 4 13:34 /mysql -> chroot/mysql-4.0

mdev@bsdi /chroot
$ ls -al mysql
lrwxr-xr-x 1 root wheel 11 Aug 4 13:34 mysql -> mysql-4.0.2

The BSDI notes say something about symlinking databases and REAL_PATH, but
that's not the case here and symlinking isn't an issue in the testkit as
far as I can tell.

I really can't find anything else off-balance. Should I file a seperate
bug report for this one, or do you have some pointers where to look.

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

On Tuesday 06 August 2002 00:48, Melvyn Sopacua wrote:
> On Thu, 1 Aug 2002, Sinisa Milivojevic wrote:
>
> SM>>>> To be more specific:
> SM>>>> I added the port option in:
> SM>>>> $ cat t/count_distinct2-master.opt
> SM>>>> --set-variable=3Dmax_heap_table_size=3D16384 --port=3D39230
> SM>>>>
> SM>>>> and then that test passed with glory. Without it - the
> wait_for_master SM>>>> waits 30 seconds and then aborts the test, and t=
he
> error log showing the SM>>>> can't bind on that port "do you have an
> alternate runing" message. SM>>>>
> SM>>>
> SM>>>
> SM>>>Thank you for your contribution.
> SM>>>
> SM>>>This seems to be a solution for some systems.
>
> Actually - it's a workaround, as the original master never shuts down. =
The
> same happens when I use mysqladmin shutdown in the real environment and
> the daemon is chrooted. When I chroot the command it shuts down. Howeve=
r -
> how this relates to the testkit seems illogical as chrooting doesn't
> apply.
>

Oh. Really this probably happens because you have pid file left ocasional=
ly
the same path, but not chrooted

mysqladmin shutdown waits for pid file to be removed as indication of=20
successful shutdown. And so if one is left and it is not going to be remo=
ved this
will take a long time to wait. Timeout exists but as I remember it is 1 h=
our.




--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


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

Re: compile failure with patch BSD/OS 4.1

Hi!

>>>>> "Melvyn" == Melvyn Sopacua writes:


Melvyn> Actually - it's a workaround, as the original master never shuts down. The
Melvyn> same happens when I use mysqladmin shutdown in the real environment and
Melvyn> the daemon is chrooted. When I chroot the command it shuts down. However -
Melvyn> how this relates to the testkit seems illogical as chrooting doesn't
Melvyn> apply.

Have you checked if the logs files in var/logs offers any clues for
the shutdown problem ?

One way to find out what is going wrong is to configure MySQL with
--debug and then one script as follows:

cd mysql-test
mysql-test-run --local --debug t/alias.test

If the mysql server doesn't shut down and log files doesn't include a
clue for why this is happeing, you can upload all files in the var/log
directory to ftp://support.mysql.com/pub/mysql/secret so that we can
have a look at what's going wrong.



Melvyn> The BSDI notes say something about symlinking databases and REAL_PATH, but
Melvyn> that's not the case here and symlinking isn't an issue in the testkit as
Melvyn> far as I can tell.

I don't think that REAL_PATH has anything to do with this problem.

Melvyn> I really can't find anything else off-balance. Should I file a seperate
Melvyn> bug report for this one, or do you have some pointers where to look.

See above.

The thing to find out is if the mysqladmin uses the right socket file
to take down MySQL and if the mysqld server gets the shutdown
command/signal.

Regards,
Monty

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

Re: compile failure with patch BSD/OS 4.1

Hi!

>>>>> "Melvyn" == Melvyn Sopacua writes:

Melvyn> On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
SM> OK, then please try this :
SM>
SM> .....
SM>
SM> #ifdef HAVE_SEMAPHORE_H
SM> #include
SM> #else
SM> #ifdef __bsdi__
SM> #include
SM> #else
SM> #ifdef __WIN__
SM> typedef HANDLE sem_t;
SM> #else
SM> typedef struct {
SM> pthread_mutex_t mutex;
SM> pthread_cond_t cond;
SM> uint count;
SM> } sem_t;
SM> #endif
SM> #endif

Melvyn> Yes. That's compiling nicely.
Melvyn> Do you know of anything I should test, that it's not only compiling but
Melvyn> also working correctly?
Melvyn> Then let me know.

First, the original error was probably because my_semaphore.c didn't
contain an #include directive. (I have now fixed this in
4.0.3)

The above patch is quite strange as the main thing it does is disables
our definition of sem_t, but my_semaphore.cc still will use it's own
version of the semaphore code (which is not a good idea).

I have now reverted this patch until I understand what is going on.

Melvyn, is it possible to get a temporary access to your server to
check this out ?

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com


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

Re: compile failure with patch BSD/OS 4.1

On Tuesday 06 August 2002 08:53, Peter Zaitsev wrote:
> On Tuesday 06 August 2002 00:48, Melvyn Sopacua wrote:
> > On Thu, 1 Aug 2002, Sinisa Milivojevic wrote:
> >
> > SM>>>> To be more specific:
> > SM>>>> I added the port option in:
> > SM>>>> $ cat t/count_distinct2-master.opt
> > SM>>>> --set-variable=3Dmax_heap_table_size=3D16384 --port=3D39230
> > SM>>>>
> > SM>>>> and then that test passed with glory. Without it - the
> > wait_for_master SM>>>> waits 30 seconds and then aborts the test, and=
the
> > error log showing the SM>>>> can't bind on that port "do you have an
> > alternate runing" message. SM>>>>
> > SM>>>
> > SM>>>
> > SM>>>Thank you for your contribution.
> > SM>>>
> > SM>>>This seems to be a solution for some systems.
> >
> > Actually - it's a workaround, as the original master never shuts down=

> > The same happens when I use mysqladmin shutdown in the real environme=
nt
> > and the daemon is chrooted. When I chroot the command it shuts down.
> > However - how this relates to the testkit seems illogical as chrootin=
g
> > doesn't apply.
>
> Oh. Really this probably happens because you have pid file left ocasion=
ally
> the same path, but not chrooted

Yes - the error is indeed referering to the a "waiting for pidfile". But =
since=20
the __directories__ are symlinks there are not 2 pidfiles. Just one.

> mysqladmin shutdown waits for pid file to be removed as indication of
> successful shutdown. And so if one is left and it is not going to be
> removed this will take a long time to wait. Timeout exists but as I
> remember it is 1 hour.

Yes correct - I remember waiting that out once on an AIX system and it's =
1=20
hour (the reason for this shutdown delay was totally different though and=
=20
unrelated).

--=20
Best regards,

IDG.nl
Melvyn Sopacua
WebMaster

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

Re: compile failure with patch BSD/OS 4.1

On Tuesday 06 August 2002 12:45, Melvyn Sopacua wrote:

> >
> > Oh. Really this probably happens because you have pid file left
> > ocasionally the same path, but not chrooted
>
> Yes - the error is indeed referering to the a "waiting for pidfile". Bu=
t
> since the __directories__ are symlinks there are not 2 pidfiles. Just o=
ne.

OK. Could you please check this file is actually removed during MySQL shu=
tdown=20

Also it is importand which problem is it. Do you have mysqld process not=20
exiting (you can check this with ps) or it is just mysqladmin hanging ?




--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


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

Re: compile failure with patch BSD/OS 4.1

On Tue, 6 Aug 2002, Peter Zaitsev wrote:

PZ>>>On Tuesday 06 August 2002 12:45, Melvyn Sopacua wrote:
PZ>>>
PZ>>>> >
PZ>>>> > Oh. Really this probably happens because you have pid file left
PZ>>>> > ocasionally the same path, but not chrooted
PZ>>>>
PZ>>>> Yes - the error is indeed referering to the a "waiting for pidfile". But
PZ>>>> since the __directories__ are symlinks there are not 2 pidfiles. Just one.
PZ>>>
PZ>>>OK. Could you please check this file is actually removed during MySQL shutdown
PZ>>>
PZ>>>Also it is importand which problem is it. Do you have mysqld process not
PZ>>>exiting (you can check this with ps) or it is just mysqladmin hanging ?
PZ>>>

[root@bsdi] ~
# mysqladmin shutdown
^CWarning; Aborted waiting on pid file:
'/mysql/var/bsdi.nyvlem.mine.nu.pid' after 13 seconds
[root@bsdi] ~
# ls -al /mysql
lrwxr-xr-x 1 root wheel 18 Aug 4 13:34 /mysql -> chroot/mysql-4.0.2
[root@bsdi] ~
# top

[..]
15873 root 10 0 232K 532K sleep 0:00 0.00% 0.00% mysqld_safe
15893 mysql 2 4 3252K 3400K sleep 16:59 0.00% 0.00% mysqld

[root@bsdi] ~
# tail /mysql/var/bsdi.nyvlem.mine.nu.err
020730 15:06:52 mysqld ended

020730 15:10:02 mysqld started
/mysql/libexec/mysqld: ready for connections
020804 11:10:09 /mysql/libexec/mysqld: Normal shutdown

020804 13:35:56 mysqld started
/mysql/libexec/mysqld: ready for connections
020806 11:32:32 /mysql/libexec/mysqld: Normal shutdown

[root@bsdi] ~
# chroot /chroot /mysql/bin/mysqladmin shutdown
/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
[root@bsdi] ~
# ps auwwx | grep mysql | grep -v grep | wc -l
0

[root@bsdi] ~
# tail /mysql/var/bsdi.nyvlem.mine.nu.err
020804 11:10:09 /mysql/libexec/mysqld: Normal shutdown

020804 13:35:56 mysqld started
/mysql/libexec/mysqld: ready for connections
020806 11:32:32 /mysql/libexec/mysqld: Normal shutdown

020806 11:33:43 /mysql/libexec/mysqld: Shutdown Complete

020806 11:33:43 mysqld ended


--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

Michael Widenius writes:
>
> Hi!
>
>
> The above patch is quite strange as the main thing it does is disables
> our definition of sem_t, but my_semaphore.cc still will use it's own
> version of the semaphore code (which is not a good idea).
>
> I have now reverted this patch until I understand what is going on.
>
> Melvyn, is it possible to get a temporary access to your server to
> check this out ?
>
> Regards,
> Monty
>

My final patch also just adds :

#elif defined(__bsdi__)
#include
....

in my_semaphore.h.

Nothing else.

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


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

Re: compile failure with patch BSD/OS 4.1

> # top
>
> [..]
> 15873 root 10 0 232K 532K sleep 0:00 0.00% 0.00% mysqld_s=
afe
> 15893 mysql 2 4 3252K 3400K sleep 16:59 0.00% 0.00% mysqld
>

According to this mysqld just waits for something does not consuming any=
CPU.
You may also check it does not actively flush to the disk table cache by =
running
iostat/vmstat.

In any case the best understanding from what is happening may come from t=
he following steps:

- Compile MySQL with debugging information and frame pointers (it is not =
required to compile=20
it with full debug)
- Run it and repeat shutdown problem
- Connect with GDB to mysqld process and provide back trace for threads =
you have
this will help us to understand what is happening.

> [root@bsdi] ~
> # chroot /chroot /mysql/bin/mysqladmin shutdown
> /mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Lost connection to MySQL server during query'
> [root@bsdi] ~
> # ps auwwx | grep mysql | grep -v grep | wc -l
> 0

Are you saying running CHROOT "mysqladmin shutdown" works ?
after you issued normal shutdown.

You may also wish to try to run second shutdown without chroot to see
if it will work. I do not see the reason how mysqladmin shutdown convers=
ation with
server may depend on if it is running CHROOTed or not in case socket/pid=
file directoryes
are symlinked to be the same.=20


--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 7 Aug 2002, Peter Zaitsev wrote:

PZ>>>> [root@bsdi] ~
PZ>>>> # ps auwwx | grep mysql | grep -v grep | wc -l
PZ>>>> 0
PZ>>>
PZ>>>Are you saying running CHROOT "mysqladmin shutdown" works ?
PZ>>>after you issued normal shutdown.

Yes.

PZ>>>You may also wish to try to run second shutdown without chroot to see
PZ>>>if it will work.

Good call, that works also.
I'll do a debugging build later on.

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

On Wednesday 07 August 2002 13:06, Melvyn Sopacua wrote:
> On Wed, 7 Aug 2002, Peter Zaitsev wrote:
>
> PZ>>>> [root@bsdi] ~
> PZ>>>> # ps auwwx | grep mysql | grep -v grep | wc -l
> PZ>>>> 0
> PZ>>>
> PZ>>>Are you saying running CHROOT "mysqladmin shutdown" works ?
> PZ>>>after you issued normal shutdown.
>
> Yes.

So at least you have work around for the problem like calling shutdown tw=
ice.

So it looks like this should be some threading related problem - mysqld =
continues
to wait for conections and exits only then it is able to accept connectio=
n.

Which threads library are you using ?



--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


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

Re: compile failure with patch BSD/OS 4.1

On Wed, 7 Aug 2002, Peter Zaitsev wrote:

PZ>>>Date: Wed, 7 Aug 2002 13:53:57 +0400
PZ>>>From: Peter Zaitsev
PZ>>>To: Melvyn Sopacua
PZ>>>Cc: bugs@lists.mysql.com
PZ>>>Subject: Re: compile failure with patch BSD/OS 4.1
PZ>>>
PZ>>>On Wednesday 07 August 2002 13:06, Melvyn Sopacua wrote:
PZ>>>> On Wed, 7 Aug 2002, Peter Zaitsev wrote:
PZ>>>>
PZ>>>> PZ>>>> [root@bsdi] ~
PZ>>>> PZ>>>> # ps auwwx | grep mysql | grep -v grep | wc -l
PZ>>>> PZ>>>> 0
PZ>>>> PZ>>>
PZ>>>> PZ>>>Are you saying running CHROOT "mysqladmin shutdown" works ?
PZ>>>> PZ>>>after you issued normal shutdown.
PZ>>>>
PZ>>>> Yes.
PZ>>>
PZ>>>So at least you have work around for the problem like calling shutdown twice.
PZ>>>
PZ>>>So it looks like this should be some threading related problem - mysqld continues
PZ>>>to wait for conections and exits only then it is able to accept connection.
PZ>>>
PZ>>>Which threads library are you using ?

$ ldd /mysql/libexec/mysqld
libdmalloc.so => /weblib/local/lib/libdmalloc.so (0x481c6000)
libdl.so => /shlib/libdl.so (0x4820f000)
libpthread.so.14 => /weblib/local/lib/libpthread.so.14
(0x48213000)
libz.so.1 => /weblib/local/lib/libz.so.1 (0x4822e000)
libm.so => /shlib/libm.so.0.0 (0x4823e000)
libc.so.1 => /shlib/libc.so.1 (0x48250000)
libgcc.so.1 => /shlib/libgcc.so.1 (0x48318000)

Which is pth 1.4.0, pthread compat.

That dmalloc is in there, since there was no way to get that outof pthread
that I've found, allthough pth-config does not reflect that:
$ /weblib/local/bin/pth-config --libs
-lpth

From previous experiences I didn't try the other thread related
possibilities since that didn't work at all.

Full configure:

CC=/home/mdev/local/bin/gcc \
CFLAGS='-O0 -mcpu=pentium -fno-strength-reduce' \
CXX=/home/mdev/local/bin/g++ \
CXXFLAGS='-O0 -mcpu=pentium -fno-rtti -fno-exceptions -felide-constructors -fno-strength-reduce' \
LDFLAGS='-ldmalloc' \
../configure \
--prefix=/mysql \
--enable-assembler \
--mandir=/home/mdev/local/man \
--disable-largefile \
--with-gnu-ld \
--with-unix-socket-path=/mysql/tmp/mysql.sock \
--with-mysql-user=mysql \
--without-debug \
--with-comment=first_try_BSDi_41 \
--without-docs \
--without-bench \
--with-extra-charsets=none \
--without-isam \
--without-innodb \
--with-pthread


I'll let you know what the debug build shows.

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

On Wednesday 07 August 2002 16:12, Melvyn Sopacua wrote:

> PZ>>>Which threads library are you using ?
>
> $ ldd /mysql/libexec/mysqld
> libdmalloc.so =3D> /weblib/local/lib/libdmalloc.so (0x481c6000)
> libdl.so =3D> /shlib/libdl.so (0x4820f000)
> libpthread.so.14 =3D> /weblib/local/lib/libpthread.so.14
> (0x48213000)
> libz.so.1 =3D> /weblib/local/lib/libz.so.1 (0x4822e000)
> libm.so =3D> /shlib/libm.so.0.0 (0x4823e000)
> libc.so.1 =3D> /shlib/libc.so.1 (0x48250000)
> libgcc.so.1 =3D> /shlib/libgcc.so.1 (0x48318000)
>
> Which is pth 1.4.0, pthread compat.

OK. These are UserLevel pthreads as I know which may produce=20
some sort of strange effects. For example in this case it is likely=20
some system call is not really unblocked which leads to thread only
be terminated when it is complete.

>
> That dmalloc is in there, since there was no way to get that outof pthr=
ead
> that I've found, allthough pth-config does not reflect that:
> $ /weblib/local/bin/pth-config --libs
> -lpth

That's strange. You have dmalloc in. Do not you have access to=20
compiled pth to check if this is expected ?

>
> From previous experiences I didn't try the other thread related
> possibilities since that didn't work at all.
>
>
> I'll let you know what the debug build shows.

OK. Thanks.=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


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

Re: compile failure with patch BSD/OS 4.1

On Thu, 8 Aug 2002, Peter Zaitsev wrote:

PZ>>>OK. These are UserLevel pthreads as I know which may produce
PZ>>>some sort of strange effects. For example in this case it is likely
PZ>>>some system call is not really unblocked which leads to thread only
PZ>>>be terminated when it is complete.
PZ>>>
PZ>>>>
PZ>>>> That dmalloc is in there, since there was no way to get that outof pthread
PZ>>>> that I've found, allthough pth-config does not reflect that:
PZ>>>> $ /weblib/local/bin/pth-config --libs
PZ>>>> -lpth
PZ>>>
PZ>>>That's strange. You have dmalloc in. Do not you have access to
PZ>>>compiled pth to check if this is expected ?

The only undefined symbols, relating to dmalloc, are the _leap functions:
$ nm /weblib/local/lib/libdmalloc.so | grep ' T ' | while read LINE; do
SYMBOL=`echo ${LINE} | awk '{print $3}'`; nm
/weblib/local/lib/libpthread.so | grep "$SYMBOL" | grep ' U ' ; done
U _calloc_leap
U _free_leap
U _malloc_leap
U _calloc_leap
U _free_leap
U _malloc_leap

I'll recompile pth, with version 1.4.1 this time, then see about a debug
build.

If you're interested, I've made a ktrace of the whole shutdown process.
Let me know if you want me to upload it.

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

On Thu, 8 Aug 2002, Peter Zaitsev wrote:

PZ>>>Well. Really what I really need is back trace from GDB connected to the process during the hang

Here we go:
Attaching to program `/mysql/libexec/mysqld', process 4342
Reading symbols from /shlib/libdl.so...done.
Reading symbols from /weblib/local/lib/libpthread.so.14...done.
Reading symbols from /usr/lib/libz.so.1...done.
Reading symbols from /shlib/libm.so.0.0...done.
Reading symbols from /shlib/libc.so.1...done.
Reading symbols from /shlib/libgcc.so.1...done.
Reading symbols from /shlib/ld-bsdi.so...done.
0x4824b575 in _syscall_sys_select ()
(gdb) bt
#0 0x4824b575 in _syscall_sys_select ()
#1 0x48202a56 in __pth_sched_eventmanager ()
#2 0x48202297 in __pth_scheduler ()
#3 0x482037b8 in pth_spawn_trampoline ()
#4 0x48201975 in pth_mctx_set_bootstrap ()
#5 0x482018ea in pth_mctx_set_trampoline ()
#6
#7 0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) continue
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) bt
#0 0x482d57b6 in _syscall_sys_sigsuspend ()
#1 0x4820179e in __pth_mctx_set ()
#2 0x48203a1b in pth_spawn ()
#3 0x481ff04e in pthread_create ()
#4 0x8080b44 in create_new_thread (thd=0x8285000) at mysqld.cc:2389
#5 0x808128b in handle_connections_sockets (arg=0x0) at mysqld.cc:2618
#6 0x80803af in main (argc=15, argv=0x8213340) at mysqld.cc:2142
#7 0x804c7d7 in __start ()
(gdb) continue
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) bt
#0 0x482d57b6 in _syscall_sys_sigsuspend ()
#1 0x4820179e in __pth_mctx_set ()
#2 0x48203a1b in pth_spawn ()
#3 0x481ff04e in pthread_create ()
#4 0x8080b44 in create_new_thread (thd=0x8285000) at mysqld.cc:2389
#5 0x808128b in handle_connections_sockets (arg=0x0) at mysqld.cc:2618
#6 0x80803af in main (argc=15, argv=0x8213340) at mysqld.cc:2142
#7 0x804c7d7 in __start ()
(gdb) continue
Continuing.

Program received signal SIGPIPE, Broken pipe.
0x482d56f5 in _syscall_sys_sigprocmask ()
(gdb) bt
#0 0x482d56f5 in _syscall_sys_sigprocmask ()
#1 0x48202a13 in __pth_sched_eventmanager ()
#2 0x48202297 in __pth_scheduler ()
#3 0x482037b8 in pth_spawn_trampoline ()
#4 0x48201975 in pth_mctx_set_bootstrap ()
#5 0x482018ea in pth_mctx_set_trampoline ()
#6
#7 0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) continue
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) bt
#0 0x482d57b6 in _syscall_sys_sigsuspend ()
#1 0x4820179e in __pth_mctx_set ()
#2 0x48203a1b in pth_spawn ()
#3 0x481ff04e in pthread_create ()
#4 0x807f66a in signal_hand (arg=0x0) at mysqld.cc:1564
#5 0x482037b8 in pth_spawn_trampoline ()
#6 0x48201975 in pth_mctx_set_bootstrap ()
#7 0x482018ea in pth_mctx_set_trampoline ()
#8
#9 0x482d57b6 in _syscall_sys_sigsuspend ()
#10 0x6d2f016a in ?? ()
Error accessing memory address 0x5: Cannot allocate memory.
(gdb) continue
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) bt
#0 0x482d57b6 in _syscall_sys_sigsuspend ()
#1 0x4820179e in __pth_mctx_set ()
#2 0x48203a1b in pth_spawn ()
#3 0x481ff04e in pthread_create ()
#4 0x807f66a in signal_hand (arg=0x0) at mysqld.cc:1564
#5 0x482037b8 in pth_spawn_trampoline ()
#6 0x48201975 in pth_mctx_set_bootstrap ()
#7 0x482018ea in pth_mctx_set_trampoline ()
#8
#9 0x482d57b6 in _syscall_sys_sigsuspend ()
#10 0x6d2f016a in ?? ()
Error accessing memory address 0x5: Cannot allocate memory.
(gdb) continue
Continuing.

>>>> At this point I stopped mysqladmin and re-issued the shutdown
command. <<<<<<


Program received signal SIGUSR1, User defined signal 1.
0x482d56f5 in _syscall_sys_sigprocmask ()
(gdb) bt
#0 0x482d56f5 in _syscall_sys_sigprocmask ()
#1 0x4826a300 in siglongjmp ()
#2 0x482037b8 in pth_spawn_trampoline ()
#3 0x48201975 in pth_mctx_set_bootstrap ()
#4 0x482018ea in pth_mctx_set_trampoline ()
#5
#6 0x482d57b6 in _syscall_sys_sigsuspend ()
(gdb) continue
Continuing.

Program exited normally.
(gdb)


--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

Hi!

Sorry for the late responce but I have been on vacation and I am still
catching up with my emails..

>>>>> "Melvyn" == Melvyn Sopacua writes:

Melvyn> On Thu, 8 Aug 2002, Peter Zaitsev wrote:
PZ> Well. Really what I really need is back trace from GDB connected to the process during the hang

Melvyn> Here we go:



Melvyn> Program received signal SIGUSR1, User defined signal 1.
Melvyn> 0x482d57b6 in _syscall_sys_sigsuspend ()
Melvyn> (gdb) bt
Melvyn> #0 0x482d57b6 in _syscall_sys_sigsuspend ()
Melvyn> #1 0x4820179e in __pth_mctx_set ()
Melvyn> #2 0x48203a1b in pth_spawn ()
Melvyn> #3 0x481ff04e in pthread_create ()
Melvyn> #4 0x8080b44 in create_new_thread (thd=0x8285000) at mysqld.cc:2389
Melvyn> #5 0x808128b in handle_connections_sockets (arg=0x0) at mysqld.cc:2618
Melvyn> #6 0x80803af in main (argc=15, argv=0x8213340) at mysqld.cc:2142
Melvyn> #7 0x804c7d7 in __start ()
Melvyn> (gdb) continue
Melvyn> Continuing.



Melvyn> Program received signal SIGPIPE, Broken pipe.
Melvyn> 0x482d56f5 in _syscall_sys_sigprocmask ()
Melvyn> (gdb) bt
Melvyn> #0 0x482d56f5 in _syscall_sys_sigprocmask ()
Melvyn> #1 0x48202a13 in __pth_sched_eventmanager ()
Melvyn> #2 0x48202297 in __pth_scheduler ()
Melvyn> #3 0x482037b8 in pth_spawn_trampoline ()
Melvyn> #4 0x48201975 in pth_mctx_set_bootstrap ()
Melvyn> #5 0x482018ea in pth_mctx_set_trampoline ()
Melvyn> #6
Melvyn> #7 0x482d57b6 in _syscall_sys_sigsuspend ()
Melvyn> (gdb) continue
Melvyn> Continuing.

SIGUSR1 and SIGPIPE is signals that you should ignore in gdb as these
are used internally by MySQL and the thread library.

To fix this, create a .gdbinit file, in the directory you are
when debugging MySQL, with the current content:

set print sevenbit off
handle SIGUSR1 nostop noprint
handle SIGUSR2 nostop noprint
handle SIGWAITING nostop noprint
handle SIGLWP nostop noprint
handle SIGPIPE nostop
handle SIGALRM nostop
handle SIGHUP nostop
handle SIGTERM nostop noprint

This will tell gdb to ignore the above signals.

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com



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

Re: compile failure with patch BSD/OS 4.1

Hi,

On Sat, 17 Aug 2002, Michael Widenius wrote:

MW>>>Sorry for the late responce but I have been on vacation and I am still
MW>>>catching up with my emails..

No worries.
This part of the bug has been resolved with help of Peter Zaitsev, in
private mail, to not clutter the list.

The solution is to *not* use pth in pthread compat mode. Then everything
works well.
The bug has been reported to the pth-bug list.

Thanx for the .gdbinit instructions, I'll put them in.

As for the original bug - the semaphore/errno problem, you wanted to
investigate further and I have mailed relevant details to you directly.
Take your time though - including errno.h, removing pth/pthread fixed all
problems I can see and it's running.

The test-suite, really needs a brush up though, so I'm unable to report
any specifics in that area (which may or may not reveal that the different
semaphore implementations are resulting in a bug).

Some things I've encountered:

-- GNU time required, but no test-mechanism and time is
called as 'time', so even if GNU time is prefered in the PATH, the shell
built-in takes precedence (BSD time gives the same information, just on 1
line, rather than 3)

-- no skip-mechanism when latin1_de is not installed and it's only
installed with --with-charsets=all (additionally the available charsets
are missing in the configure --help output)

-- rm uses trailing slashes (will give errors on BSD's)

-- when installed, assumption of mysqld being in ../bin/ is wrong and file
r/have_bdb.require is missing

Is this work in progress for the 4.0 release cycle, or would you
appreciate any compatibility patches now?

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

Hi!

>>>>> "Melvyn" == Melvyn Sopacua writes:

Melvyn> Hi,
Melvyn> On Sat, 17 Aug 2002, Michael Widenius wrote:

MW> Sorry for the late responce but I have been on vacation and I am still
MW> catching up with my emails..

Melvyn> No worries.
Melvyn> This part of the bug has been resolved with help of Peter Zaitsev, in
Melvyn> private mail, to not clutter the list.

Good to hear!



Melvyn> The test-suite, really needs a brush up though, so I'm unable to report
Melvyn> any specifics in that area (which may or may not reveal that the different
Melvyn> semaphore implementations are resulting in a bug).

In the long run we plan to rewrite mysql-test-run to C to avoid
problems with a lot of different shells and commands.

But for now we have just to patch mysql-test-run to work reasonable
well with all OS.

Melvyn> Some things I've encountered:

Melvyn> -- GNU time required, but no test-mechanism and time is
Melvyn> called as 'time', so even if GNU time is prefered in the PATH, the shell
Melvyn> built-in takes precedence (BSD time gives the same information, just on 1
Melvyn> line, rather than 3)

I have done a temporary fix for this by searching after 'time' in the PATH.

Melvyn> -- no skip-mechanism when latin1_de is not installed and it's only
Melvyn> installed with --with-charsets=all (additionally the available charsets
Melvyn> are missing in the configure --help output)

This will be fixed in MySQL 4.1. For MySQL 4.0 this is a bit hard to
fix :(

I tried to fix configure --help but was not able to get a variable
printed in the help text :(
(Need to learn more about autoconf to be able to do this).

Melvyn> -- rm uses trailing slashes (will give errors on BSD's)

Found one case where this was used (fixed)

Melvyn> -- when installed, assumption of mysqld being in ../bin/ is wrong and file
Melvyn> r/have_bdb.require is missing

I have now fixed the mysqld is first searched for in libexec.

In which distribution is have_bdb.require missing ?
(I just checked and it's included in the MySQL 4.0.3 source distribution)

Melvyn> Is this work in progress for the 4.0 release cycle, or would you
Melvyn> appreciate any compatibility patches now?

Yes, the above are bugs that should be fixed in the 4.0 tree.
Any help you can give is welcome...

Regards,
Monty

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

Re: compile failure with patch BSD/OS 4.1

Hi Michael,

On Sun, 18 Aug 2002, Michael Widenius wrote:

[...]

MW>>>Melvyn> The test-suite, really needs a brush up though, so I'm unable to report
MW>>>Melvyn> any specifics in that area (which may or may not reveal that the different
MW>>>Melvyn> semaphore implementations are resulting in a bug).
MW>>>
MW>>>In the long run we plan to rewrite mysql-test-run to C to avoid
MW>>>problems with a lot of different shells and commands.

Good choice.

MW>>>But for now we have just to patch mysql-test-run to work reasonable
MW>>>well with all OS.

OK.

MW>>>Melvyn> Some things I've encountered:
MW>>>
MW>>>Melvyn> -- GNU time required, but no test-mechanism and time is
MW>>>Melvyn> called as 'time', so even if GNU time is prefered in the PATH, the shell
MW>>>Melvyn> built-in takes precedence (BSD time gives the same information, just on 1
MW>>>Melvyn> line, rather than 3)
MW>>>
MW>>>I have done a temporary fix for this by searching after 'time' in the PATH.

By default, /usr/bin/time takes precedence in a path. I think it make it
easier on everybody if existence of variable GNUTIME=/path/to/time is
available in the environment.

MW>>>
MW>>>Melvyn> -- no skip-mechanism when latin1_de is not installed and it's only
MW>>>Melvyn> installed with --with-charsets=all (additionally the available charsets
MW>>>Melvyn> are missing in the configure --help output)
MW>>>
MW>>>This will be fixed in MySQL 4.1. For MySQL 4.0 this is a bit hard to
MW>>>fix :(

Yeah, I see the problem.
Would be nice if something like this would work:
CREATE TABLE vars
SHOW VARIABLES LIKE 'character_sets';
SELECT COUNT(1) FROM vars WHERE Value LIKE '% latin1_de %';

Or:
SHOW VARIABLES LIKE 'character_sets' VALUE LIKE '% latin1_de %';

The latter prefered, not only for this test, but in general, to automate
some scripting.

MW>>>I tried to fix configure --help but was not able to get a variable
MW>>>printed in the help text :(
MW>>>(Need to learn more about autoconf to be able to do this).

Hmm, tried this and I agree - it's not that easy, because it's expecting
text.

MW>>>Melvyn> -- rm uses trailing slashes (will give errors on BSD's)
MW>>>
MW>>>Found one case where this was used (fixed)

I got 2 warnings, but indeed, one spot.

MW>>>Melvyn> -- when installed, assumption of mysqld being in ../bin/ is wrong and file
MW>>>Melvyn> r/have_bdb.require is missing
MW>>>
MW>>>I have now fixed the mysqld is first searched for in libexec.

OK.

MW>>>In which distribution is have_bdb.require missing ?
MW>>>(I just checked and it's included in the MySQL 4.0.3 source distribution)

4.0.3 isn't released, so it's 4.0.2, but the file is there, just not after
make install, which is fixed by the following patch, to be applied in
$(top_source_dir)/mysql-test and should be self-explanatory:

--- Makefile.am.dist Mon Jul 1 13:16:52 2002
+++ Makefile.am Sun Aug 18 16:36:24 2002
@@ -42,6 +42,7 @@
$(INSTALL_DATA) $(srcdir)/t/*.test $(DESTDIR)$(testdir)/t
$(INSTALL_DATA) $(srcdir)/t/*.opt $(DESTDIR)$(testdir)/t
$(INSTALL_DATA) $(srcdir)/r/*.result $(DESTDIR)$(testdir)/r
+ $(INSTALL_DATA) $(srcdir)/r/*.require $(DESTDIR)$(testdir)/r
$(INSTALL_DATA) $(srcdir)/include/*.inc $(DESTDIR)$(testdir)/include
$(INSTALL_DATA) $(srcdir)/std_data/*.dat $(DESTDIR)$(testdir)/std_data

--- Makefile.in.dist Mon Jul 1 14:16:41 2002
+++ Makefile.in Sun Aug 18 16:37:49 2002
@@ -341,6 +341,7 @@
$(INSTALL_DATA) $(srcdir)/t/*.test $(DESTDIR)$(testdir)/t
$(INSTALL_DATA) $(srcdir)/t/*.opt $(DESTDIR)$(testdir)/t
$(INSTALL_DATA) $(srcdir)/r/*.result $(DESTDIR)$(testdir)/r
+ $(INSTALL_DATA) $(srcdir)/r/*.require $(DESTDIR)$(testdir)/r
$(INSTALL_DATA) $(srcdir)/include/*.inc $(DESTDIR)$(testdir)/include
$(INSTALL_DATA) $(srcdir)/std_data/*.dat $(DESTDIR)$(testdir)/std_data


MW>>>Melvyn> Is this work in progress for the 4.0 release cycle, or would you
MW>>>Melvyn> appreciate any compatibility patches now?
MW>>>
MW>>>Yes, the above are bugs that should be fixed in the 4.0 tree.
MW>>>Any help you can give is welcome...

With respect to the latin1_de test, I think it should either be removed as
it will interfere with any setup not specifying --with-extra-charsets=all,
or latin1_de should be installed, but to do this, just to make the test
suite work, is a bit overkill.

Ideally, the test should be kept at an alternate place, and configure
should figure out, whether it should be copied (and removed by make clean)
when latin1_de is in the configured charsets.

Or - the mysql-test-run script itself should accept the option
--skip-test=name[[,name],...]
which would be the long-term fix, even when moving to C this is usefull.

--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.


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

Re: compile failure with patch BSD/OS 4.1

Hi!

>>>>> "Melvyn" == Melvyn Sopacua writes:

Melvyn> Hi Michael,
Melvyn> On Sun, 18 Aug 2002, Michael Widenius wrote:

MW> Melvyn> -- GNU time required, but no test-mechanism and time is
MW> Melvyn> called as 'time', so even if GNU time is prefered in the PATH, the shell
MW> Melvyn> built-in takes precedence (BSD time gives the same information, just on 1
MW> Melvyn> line, rather than 3)
MW>
MW> I have done a temporary fix for this by searching after 'time' in the PATH.

Melvyn> By default, /usr/bin/time takes precedence in a path. I think it make it
Melvyn> easier on everybody if existence of variable GNUTIME=/path/to/time is
Melvyn> available in the environment.

For running the test, its as easy to set the PATH as setting GNUTIME.

MW> Melvyn> -- no skip-mechanism when latin1_de is not installed and it's only
MW> Melvyn> installed with --with-charsets=all (additionally the available charsets
MW> Melvyn> are missing in the configure --help output)
MW>
MW> This will be fixed in MySQL 4.1. For MySQL 4.0 this is a bit hard to
MW> fix :(

Melvyn> Yeah, I see the problem.

Melvyn> Would be nice if something like this would work:
Melvyn> CREATE TABLE vars
Melvyn> SHOW VARIABLES LIKE 'character_sets';
Melvyn> SELECT COUNT(1) FROM vars WHERE Value LIKE '% latin1_de %';

Melvyn> Or:
Melvyn> SHOW VARIABLES LIKE 'character_sets' VALUE LIKE '% latin1_de %';

Melvyn> The latter prefered, not only for this test, but in general, to automate
Melvyn> some scripting.

I think this is already solved in 4.1 where we can change character
sets no the fly.

In 5.0 (late this year) we plan to add support for WHERE clause,
ORDER BY etc on SHOW, which will solve the other problem..

Melvyn> 4.0.3 isn't released, so it's 4.0.2, but the file is there, just not after
Melvyn> make install, which is fixed by the following patch, to be applied in
Melvyn> $(top_source_dir)/mysql-test and should be self-explanatory:

Melvyn> --- Makefile.am.dist Mon Jul 1 13:16:52 2002
Melvyn> +++ Makefile.am Sun Aug 18 16:36:24 2002
Melvyn> @@ -42,6 +42,7 @@
Melvyn> $(INSTALL_DATA) $(srcdir)/t/*.test $(DESTDIR)$(testdir)/t
Melvyn> $(INSTALL_DATA) $(srcdir)/t/*.opt $(DESTDIR)$(testdir)/t
Melvyn> $(INSTALL_DATA) $(srcdir)/r/*.result $(DESTDIR)$(testdir)/r
Melvyn> + $(INSTALL_DATA) $(srcdir)/r/*.require $(DESTDIR)$(testdir)/r
Melvyn> $(INSTALL_DATA) $(srcdir)/include/*.inc $(DESTDIR)$(testdir)/include
Melvyn> $(INSTALL_DATA) $(srcdir)/std_data/*.dat $(DESTDIR)$(testdir)/std_data

Applied. Thanks!



Melvyn> With respect to the latin1_de test, I think it should either be removed as
Melvyn> it will interfere with any setup not specifying --with-extra-charsets=all,
Melvyn> or latin1_de should be installed, but to do this, just to make the test
Melvyn> suite work, is a bit overkill.

On the other hand, as one can easily go around this with --force, I
don't know if this is that critical to fix until 4.1

Melvyn> Ideally, the test should be kept at an alternate place, and configure
Melvyn> should figure out, whether it should be copied (and removed by make clean)
Melvyn> when latin1_de is in the configured charsets.

Melvyn> Or - the mysql-test-run script itself should accept the option
Melvyn> --skip-test=name[[,name],...]
Melvyn> which would be the long-term fix, even when moving to C this is usefull.

This is also a nice idea. Shall look into fixing this in the near future.

Regards,
Monty

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

Re: compile failure with patch BSD/OS 4.1

On Tue, 6 Aug 2002, Michael Widenius wrote:

MW>>>Date: Tue, 6 Aug 2002 11:12:38 +0300
MW>>>From: Michael Widenius
MW>>>To: Melvyn Sopacua
MW>>>Cc: Sinisa Milivojevic , bugs@lists.mysql.com
MW>>>Subject: Re: compile failure with patch BSD/OS 4.1
MW>>>
MW>>>
MW>>>Hi!
MW>>>
MW>>>>>>>> "Melvyn" == Melvyn Sopacua writes:
MW>>>
MW>>>Melvyn> On Wed, 31 Jul 2002, Sinisa Milivojevic wrote:
MW>>>SM> OK, then please try this :
MW>>>SM>
MW>>>SM> .....
MW>>>SM>
MW>>>SM> #ifdef HAVE_SEMAPHORE_H
MW>>>SM> #include
MW>>>SM> #else
MW>>>SM> #ifdef __bsdi__
MW>>>SM> #include
MW>>>SM> #else
MW>>>SM> #ifdef __WIN__
MW>>>SM> typedef HANDLE sem_t;
MW>>>SM> #else
MW>>>SM> typedef struct {
MW>>>SM> pthread_mutex_t mutex;
MW>>>SM> pthread_cond_t cond;
MW>>>SM> uint count;
MW>>>SM> } sem_t;
MW>>>SM> #endif
MW>>>SM> #endif
MW>>>
MW>>>Melvyn> Yes. That's compiling nicely.
MW>>>Melvyn> Do you know of anything I should test, that it's not only compiling but
MW>>>Melvyn> also working correctly?
MW>>>Melvyn> Then let me know.
MW>>>
MW>>>First, the original error was probably because my_semaphore.c didn't
MW>>>contain an #include directive. (I have now fixed this in
MW>>>4.0.3)

Correct - that's actually all that was needed.

MW>>>
MW>>>The above patch is quite strange as the main thing it does is disables
MW>>>our definition of sem_t, but my_semaphore.cc still will use it's own
MW>>>version of the semaphore code (which is not a good idea).

Agreed. Especially since struct sem_t is not in , but
.

MW>>>
MW>>>I have now reverted this patch until I understand what is going on.
MW>>>

The combination/revert/semi-patch in 4.0.3 resulted in a non working
source.

MW>>>Melvyn, is it possible to get a temporary access to your server to
MW>>>check this out ?

I have sent details regarding that. If you need me to send them again, let
me know, but I'll sum it up here (also applies to BSD/OS 4.2):

* Semaphore functions are in sys/sem.h and sys/semaphore.h
* There's a ocmment in the sys/semaphore.h header, that explains the
differences in implementation:
/*
* XXX NOTE: We expect to switch to a POSIX-style mutex interface shortly.
*/

* The current sem_t struct is defined as:

typedef struct semaphore {
u_short spins; /* times to spin before blocking
*/
u_short want; /* want flag */
u_char lock; /* lock */
} sem_t;


* The only sem_ functions defined in sys/semaphore.h are:
int sem_lock __P((sem_t *));
int sem_wakeup __P((sem_t *));

Hope this helps.


--
Best regards,

Melvyn Sopacua
Phone: no thanx, have one.
Fax: didn't that die already?
Mobile: see phone
Email: see 'From:' header - duh!
Website: have that too.



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