Re: Shutting down one server, creates a new logfile every few seconds

Melvyn Sopacua writes:
> On Monday 19 August 2002 21:34, Michael Widenius wrote:
>
> It is not fixed in 4.0.3.
>
> Monty - if you need access to these systems, just let me know where to send
> the details. It will have to be SSH, preferably SSH2 protocol.
>
> I tried doing this with a testcase, but couldn't reproduce it, I think it
> needs actual network network traffic.
>
> Here's our situation:
>
> Machine 'hanneke', ip-addresses:
> 192.168.100.121
> 192.168.101.121
> master_host 192.168.101.120
> master_user: replicate
> master_port: 3406
>
> Config:
> log-bin = /data/sql/logs/rep_log
>
> Machine 'femke', ip-addresses:
> 192.168.100.120
> 192.168.101.120
> master_host: 192.168.101.121
> master_user: replicate
> master_port: 3406
>
> Config:
> log-bin = /data/mdev/sql/logs/rep_log
>
> They both have different passwords. Both get queries from the webservers at
> the 192.168.100 interface and replicate at 192.168.101 interface, so the
> traffice doesn't bite.
>
> Grants:
> GRANT SELECT, FILE, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES,
> REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'replicate'@'192.168.101.121'
> IDENTIFIED BY 'scrambled';
>
> And vice versa.
>
> How-To-Repeat:
> Setup the above configuration, preferably at an AIX 4.3.3 system as I haven't
> tested another OS.
>
> Then start them both up without skip-slave-start and voila.
>
> How-To-Resolve:
> Issue SLAVE STOP on one of them and hope, that the master is already skipped
> ahead. Then issue:
> CHANGE MASTER TO MASTER_LOG_FILE='rep_log.5086', MASTER_LOG_POS=4;
> SLAVE START;
>
> Remarks:
> The 'skip-locking' setting has no effect on this issue.
>
> --
> Best regards,
>
> IDG.nl
> Melvyn Sopacua
> WebMaster
>

Yes, we know it is not fixed in 4.0.3.

We have just managed to make a proper test case, so it will be fixed
in the near future.

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

Re: Shutting down one server, creates a new logfile every few seconds

On Monday 09 September 2002 20:50, Sinisa Milivojevic wrote:

> Yes, we know it is not fixed in 4.0.3.
>
> We have just managed to make a proper test case, so it will be fixed
> in the near future.

Could you send me the testcase, because I'd like to test snapshots as soo=
n as=20
you announce them to be fixed.

By the way - what's the status of 'mysqldeveloper.com'. Are those officia=
l=20
snapshots?

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

Re: Shutting down one server, creates a new logfile every few seconds

README: http://www.mysqldeveloper.com/snapshots/

THIS IS AN UNOFFICIAL "SNAPSHOT" RELEASE. THIS IS THE SAME RELEASE YOU
WOULD END UP WITH IF YOU HAD USED THE BitKeeper (bk) SOURCE MANAGEMENT
TOOL TO RETRIEVE THE DATA FROM THE work.mysql.com SERVER.

THIS REALLY WILL MOST LIKELY CONTAIN BUGS AND OTHER ISSUES.
WE DO NOT RECOMMEND YOU RUN THIS ON A PRODUCTION SERVER. PLEASE REPORT
ISSUES, FIXES, PATCHES, ETC. TO THE MySQL INTERNALS MAILING LIST AT:

internals@lists.mysql.com


GOOD LUCK.




Melvyn Sopacua wrote:
>
> On Monday 09 September 2002 20:50, Sinisa Milivojevic wrote:
>
> > Yes, we know it is not fixed in 4.0.3.
> >
> > We have just managed to make a proper test case, so it will be fixed
> > in the near future.
>
> Could you send me the testcase, because I'd like to test snapshots as soon as
> you announce them to be fixed.
>
> By the way - what's the status of 'mysqldeveloper.com'. Are those official
> snapshots?
>
> --
> 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-thread12511@lists.mysql.com
> To unsubscribe, e-mail

--
Colin Faber
(303) 736-5160
fpsn.net, Inc.

* Black holes are where God divided by zero. *

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

Re: Shutting down one server, creates a new logfile every few seconds

On Monday 09 September 2002 23:01, Melvyn Sopacua wrote:
> On Monday 09 September 2002 20:50, Sinisa Milivojevic wrote:
> > Yes, we know it is not fixed in 4.0.3.
> >
> > We have just managed to make a proper test case, so it will be fixed
> > in the near future.
>
> Could you send me the testcase, because I'd like to test snapshots as s=
oon
> as you announce them to be fixed.

The test is in the repositiry now. So you may just get the recent pull fr=
om
our BK tree to get the test.

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

Re: Shutting down one server, creates a new logfile every few seconds

On Wed, 18 Sep 2002, Peter Zaitsev wrote:

PZ>>> On Monday 09 September 2002 23:01, Melvyn Sopacua wrote:
PZ>>> > On Monday 09 September 2002 20:50, Sinisa Milivojevic wrote:
PZ>>> > > Yes, we know it is not fixed in 4.0.3.
PZ>>> > >
PZ>>> > > We have just managed to make a proper test case, so it will be fixed
PZ>>> > > in the near future.
PZ>>> >
PZ>>> > Could you send me the testcase, because I'd like to test snapshots as soon
PZ>>> > as you announce them to be fixed.
PZ>>>
PZ>>> The test is in the repositiry now. So you may just get the recent pull from
PZ>>> our BK tree to get the test.

Is the manual at:
http://www.mysql.com/doc/en/Installing_source_tree.html

up to date?
I did a bk pull, but I can't get it to configure correctly because of Berkely DB
configure not being there.

I added AC_CONFIG_SUBDIRS(bdb/dist innobase) to configure.in but that didn't help.

autoconf 2.52 and automake 1.4-p6.

Last parts of configure:
checking "can netinet files be included"... "yes"
checking for ORBit... ./configure[14075]: orbit-config: not found
../configure[14076]: orbit-config: not found
../configure[14077]: orbit-config: not found
found!
checking if we should build MySQLFS... no
checking for OpenSSL... checking "character sets"... default: latin1; compiled in: latin1
checking for BerkeleyDB... searching...
Compiling Berekeley DB in 'bdb'
checking for Innodb... Not using Innodb
CONFIGURING FOR BERKELEY DB
checking for a BSD compatible install... ../.././bdb/dist/../../install-sh -c
checking build system type... rs6000-ibm-aix4.3.3.0
checking host system type... rs6000-ibm-aix4.3.3.0
checking if building in the top-level directory... no
.../.././bdb/dist/configure[1156]: AM_VERSION_SET: not found
.../.././bdb/dist/configure[1158]: AM_OPTIONS_SET: not found
checking for cc... gcc -pipe -mcpu=power -Wa,-many
checking for gcc... (cached) gcc -pipe -mcpu=power -Wa,-many
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for executable suffix...
checking for object suffix... o
checking whether we are using the GNU C compiler... yes
checking whether gcc -pipe -mcpu=power -Wa,-many accepts -g... yes
.../.././bdb/dist/configure[3068]: AM_TCL_LOAD: not found
checking for pthread_create in -lpthread... yes
checking whether byte ordering is bigendian... yes
checking for gcc -pipe -mcpu=power -Wa,-many option to accept ANSI C... none needed
checking for an ANSI C-conforming const... yes
checking how to run the C preprocessor... gcc -pipe -mcpu=power -Wa,-many -E
checking whether stat file-mode macros are broken... no
checking whether time.h and sys/time.h may both be included... yes
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... no
checking for unistd.h... yes
checking for struct stat.st_blksize... yes
checking for mode_t... yes
checking for off_t... yes
checking for pid_t... yes
checking for size_t... yes
.../.././bdb/dist/configure[4206]: AM_SHORTHAND_TYPES: not found
checking for dirent.h that defines DIR... yes
checking for opendir in -ldir... no
checking for sys/select.h... yes
checking for sys/time.h... yes
.../.././bdb/dist/configure[4469]: AM_DEFINE_MUTEXES: not found
checking for getcwd... yes
checking for getopt... yes
checking for memcmp... yes
checking for memcpy... yes
checking for memmove... yes
checking for raise... yes
checking for snprintf... yes
checking for strcasecmp... yes
checking for strerror... yes
checking for vsnprintf... yes
checking for getuid... yes
checking for pstat_getdynamic... no
checking for sysconf... yes
checking for sched_yield... yes
checking for strtoul... yes
checking for yield... yes
checking for pread... yes
checking for pwrite... yes
checking for fcntl/F_SETFD... yes
checking for qsort... yes
checking for select... yes
checking for int type sprintf return value... yes
checking for mlock... yes
checking for munlock... yes
checking for mmap... yes
checking for munmap... yes
checking for shmget... yes
.../.././bdb/dist/configure[5339]: AM_PROGRAMS_SET: not found
configure: creating ./config.status
config.status: creating Makefile
config.status: creating include.tcl
config.status: error: cannot find input file: ../test/include.tcl
configure: error: could not configure Berkeley DB

Before my addition it ended as:

checking "can netinet files be included"... "yes"
checking for ORBit... ./configure[14073]: orbit-config: not found
../configure[14074]: orbit-config: not found
../configure[14075]: orbit-config: not found
found!
checking if we should build MySQLFS... no
checking for OpenSSL... checking "character sets"... default: latin1; compiled in: latin1
checking for BerkeleyDB... searching...
Compiling Berekeley DB in 'bdb'
checking for Innodb... Not using Innodb
CONFIGURING FOR BERKELEY DB
sh: ../.././bdb/dist/configure: not found
configure: error: could not configure Berkeley DB

Configure script:

#!/bin/sh

CC="gcc -pipe -mcpu=power -Wa,-many" \
CXX="gcc -pipe -mcpu=power -Wa,-many" \
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" \
../configure \
--prefix=/home/mdev/local/mysql \
--localstatedir=/home/mdev/local/mysql/var \
--disable-shared \
--with-raid \
--with-unix-socket-path=/home/mdev/local/mysql/tmp/mysql.soc k \
--with-mysqld-user=mdev \
--with-mysqld-ldflags=-Wl,-bbigtoc \
--with-debug \
--with-comment="AIX 4.3.3 statically linked, Snapshot build, 4.0.4" \
--without-bench \
--with-charset=latin1 \
--with-extra-charsets=none \
--with-tcp-port=3506 \
--without-isam \
--with-berkeley-db \
--without-extra-tools \
--without-innodb





--
Best regards,

Melvyn Sopacua
WebMaster IDG.nl
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
If it applies, where it applies - this email is a personal
contribution and does not reflect the views of my employer
IDG.nl.
\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\



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

Problem with compuling the new tree

On Sunday 22 September 2002 02:25, Melvyn Sopacua wrote:

>
> Is the manual at:
> http://www.mysql.com/doc/en/Installing_source_tree.html
>
> up to date?

Well. It should. At least we did not get any bug reports from other users=
yet.

> I did a bk pull, but I can't get it to configure correctly because of
> Berkely DB configure not being there.
>
> I added AC_CONFIG_SUBDIRS(bdb/dist innobase) to configure.in but that
> didn't help.
>
> autoconf 2.52 and automake 1.4-p6.

Really I should say I have no Idea why it does not work for you.
I just checked the tree on Linux and Build with BDB was successful,
while this sort of bugs should not be platform specific.

It is possible there is some platform specific issue which we will fix du=
ring
release cycle for 4.0.4

Also it is possible some files are not properly checked from you bk tree.

You may try to run bk -r edit in order to get complete tree ready for bu=
ild.=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-thread12586@lists.mysql.com
To unsubscribe, e-mail

Problem with compuling the new tree

Hi!

>>>>> "Peter" == Peter Zaitsev writes:

Peter> On Sunday 22 September 2002 02:25, Melvyn Sopacua wrote:



>> I did a bk pull, but I can't get it to configure correctly because of
>> Berkely DB configure not being there.
>> I added AC_CONFIG_SUBDIRS(bdb/dist innobase) to configure.in but that
>> didn't help.
>>
>> autoconf 2.52 and automake 1.4-p6.

Peter> Really I should say I have no Idea why it does not work for you.
Peter> I just checked the tree on Linux and Build with BDB was successful,
Peter> while this sort of bugs should not be platform specific.

Peter> It is possible there is some platform specific issue which we will fix during
Peter> release cycle for 4.0.4

In my environment I always build with the
BUILD/compile-pentium-debug-max script, which builds MySQL with InnoDB
and BDB. I have hot have any problem with bulding BDB for any 4.0 bk
tree.

Note that this script does the following:

((/my/mysql-4.0)) BUILD/compile-pentium-debug-max --print
gmake -k clean || true
/bin/rm -f */.deps/*.P config.cache innobase/config.cache bdb/build_unix/config.cache

aclocal && autoheader && aclocal && automake && autoconf
(cd bdb/dist && sh s_all)
(cd innobase && aclocal && autoheader && aclocal && automake && autoconf)
if [ -d gemini ]
then
(cd gemini && aclocal && autoheader && aclocal && automake && autoconf)
fi

CFLAGS="-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -O1" CXX="gcc" CXXFLAGS="-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -O1" CXXLDFLAGS="" ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-debug --with-berkeley-db --with-innodb --with-embedded-server --with-openssl --enable-local-infile

gmake -j 4

-----------

In other words, we do build configure independently for each sub dir.

Can you try one of the scripts in the BUILD directory and see if this
solves this problem for you...

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

Re: Problem with compuling the new tree

Hi,

At 20:50 26-9-2002, Michael Widenius wrote:

[..]

>In my environment I always build with the
>BUILD/compile-pentium-debug-max script, which builds MySQL with InnoDB
>and BDB. I have hot have any problem with bulding BDB for any 4.0 bk
>tree.
>
>Note that this script does the following:
>
>((/my/mysql-4.0)) BUILD/compile-pentium-debug-max --print
>gmake -k clean || true
>/bin/rm -f */.deps/*.P config.cache innobase/config.cache
>bdb/build_unix/config.cache
>
>aclocal && autoheader && aclocal && automake && autoconf
>(cd bdb/dist && sh s_all)

This sh_all (sh_config and sh_symlink mainly) script gives me some errors.
Something with 'sort' and missing files in docs_src.
These are minor.

However - 'include.tcl' isn't built and the final config.status fails on that.
I'll see if I can work them out.

Additionally I've added --add-missing to the automake flags.

'reconf.sh' script I'm using now:
#!/bin/sh

AUTOMAKE_FLAGS='--add-missing'
gmake -k clean || true
/bin/rm -f */.deps/*.P config.cache innobase/config.cache
bdb/build_unix/config.cache
/bin/rm -rf configure config.h.in config.log missing mkinstalldirs libtool
..libs autom4te.cache
aclocal
autoheader
autoconf
automake ${AUTOMAKE_OPTS}
(cd bdb/dist && sh s_all)
(cd innobase && aclocal && autoheader && aclocal && automake
${AUTOMAKE_FLAGS} && autoconf)
if [ -d gemini ]
then
(cd gemini && aclocal && autoheader && aclocal && automake
${AUTOMAKE_FLAGS} && autoconf)
fi

I'm removing 'missing' and 'mkinstalldirs' so I can see that the correct
version of automake
is being used as I'm using the 'autotools wrappers' from Cygwin, tuned for
my environment.

I'll send patches for whatever I can come up with.

Current errors:
$ cat bdb/dist/s_all.errs
s_symlink[3]: ../docs_src/api_cxx: not found.
s_symlink[3]: ../docs_src/api_cxx: not found.
s_symlink[3]: ../docs_src/api_cxx: not found.
s_symlink[3]: ../docs_src/api_java: not found.
s_symlink[3]: ../docs_src/api_java: not found.
s_symlink[3]: ../docs_src/api_java: not found.
s_symlink[3]: ../docs_src/api_java: not found.
s_symlink[3]: ../docs_src/api_tcl: not found.
s_symlink[3]: ../docs_src/ref/am: not found.
s_symlink[3]: ../docs_src/ref/am_conf: not found.
s_symlink[3]: ../docs_src/ref/arch: not found.
s_symlink[3]: ../docs_src/ref/build_unix: not found.
s_symlink[3]: ../docs_src/ref/build_vxworks: not found.
s_symlink[3]: ../docs_src/ref/build_win: not found.
s_symlink[3]: ../docs_src/ref/cam: not found.
s_symlink[3]: ../docs_src/ref/debug: not found.
s_symlink[3]: ../docs_src/ref/distrib: not found.
s_symlink[3]: ../docs_src/ref/dumpload: not found.
s_symlink[3]: ../docs_src/ref/env: not found.
s_symlink[3]: ../docs_src/ref/install: not found.
s_symlink[3]: ../docs_src/ref/intro: not found.
s_symlink[3]: ../docs_src/ref/java: not found.
s_symlink[3]: ../docs_src/ref/lock: not found.
s_symlink[3]: ../docs_src/ref/log: not found.
s_symlink[3]: ../docs_src/ref/mp: not found.
s_symlink[3]: ../docs_src/ref/perl: not found.
s_symlink[3]: ../docs_src/ref/program: not found.
s_symlink[3]: ../docs_src/ref/refs: not found.
s_symlink[3]: ../docs_src/ref/rpc: not found.
s_symlink[3]: ../docs_src/ref/sendmail: not found.
s_symlink[3]: ../docs_src/ref/simple_tut: not found.
s_symlink[3]: ../docs_src/ref/tcl: not found.
s_symlink[3]: ../docs_src/ref/test: not found.
s_symlink[3]: ../docs_src/ref/transapp: not found.
s_symlink[3]: ../docs_src/ref/txn: not found.
s_symlink[3]: ../docs_src/ref/upgrade.2.0: not found.
s_symlink[3]: ../docs_src/ref/upgrade.3.0: not found.
s_symlink[3]: ../docs_src/ref/upgrade.3.1: not found.
s_symlink[3]: ../docs_src/ref/upgrade.3.2: not found.
s_symlink[3]: ../docs_src/ref/xa: not found.
chmod: config.guess: A file or directory in the path name does not exist.
chmod: config.sub: A file or directory in the path name does not exist.
chmod: install-sh: A file or directory in the path name does not exist.
s_readme[6]: RELEASE: not found.
Usage: sort [-Abcdfimnru] [-T Directory] [-t Character] [-o File]
[-y[Kilobytes]] [-z Recordsize] [-k Keydefinition]...
[[+Position1][-Position2]]... [File]...
s_rpc[50]: rpcgen: not found.
s_rpc[51]: rpcgen: not found.
s_rpc[52]: rpcgen: not found.
s_rpc[53]: rpcgen: not found.
s_win32[8]: RELEASE: not found.
s_win32_dsp[6]: RELEASE: not found.
s_vxworks[8]: RELEASE: not found.
s_java[8]: RELEASE: not found.
s_tcl[8]: RELEASE: not found.


Best regards,
Melvyn Sopacua
WebMaster IDG.nl
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
If it applies, where it applies - this email is a personal
contribution and does not reflect the views of my employer
IDG.nl.
\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\


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