>Description:
I use replication circle (A->B, B->A) with 3.23.51 - all ok.
But I got problem, when upgrade both my servers to 4.0.2.
Mysqld create 30 new bin-log files every second at both servers:
-----------------------------------
[www2:/opt/mysql-dev/var]:1303# ls -1 www2-bin.* | wc -l
2268
[www2:/opt/mysql-dev/var]:1306# l www2-bin.00*
-rw-rw---- 1 mysql mysql 137 Aug 12 16:31 www2-bin.001
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.002
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.003
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.004
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.005
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.006
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.007
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.008
-rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.009
[www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001
# at 4
#020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0.
2-alpha-log created 020812 16:29:30
# at 79
#020812 16:31:13 server id 2 log_pos 79 Rotate to www2-bin.002 pos: 4
# at 118
#020812 16:31:13 server id 1 log_pos 118 Stop
[www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002
# at 4
#020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4
# at 43
#020812 16:31:13 server id 1 log_pos 43 Stop
[www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003
# at 4
#020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4
# at 43
#020812 16:31:13 server id 1 log_pos 43 Stop
[www2:/opt/mysql-dev/var]:1308#
--------------------------------------------------------------
and so on.
Will be fixed this error in 4.0.3?
>How-To-Repeat:
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Artem Ryabov
>Organization:
>MySQL support: none
>Synopsis: too many bin-log files
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.2-alpha (Source distribution)
>Environment:
System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Nov 25 2000 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x 1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so
-rw-r--r-- 1 root root 24498288 Jan 11 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 11 2001 /usr/lib/libc.so
configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared
--prefix=/opt/mysql-dev --with-charset=cp1251
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php