Hello all,
I was check up 4.0.3 (from the Development Source Tree), bug still exist.
>>Description:
aor> I use replication circle (A->B, B->A) with 3.23.51 - all ok.
aor> But I got problem, when upgrade both my servers to 4.0.2.
aor> Mysqld create 30 new bin-log files every second at both servers:
aor> -----------------------------------
aor> [www2:/opt/mysql-dev/var]:1303# ls -1 www2-bin.* | wc -l
aor> 2268
aor> [www2:/opt/mysql-dev/var]:1306# l www2-bin.00*
aor> -rw-rw---- 1 mysql mysql 137 Aug 12 16:31 www2-bin.001
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.002
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.003
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.004
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.005
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.006
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.007
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.008
aor> -rw-rw---- 1 mysql mysql 62 Aug 12 16:31 www2-bin.009
aor> [www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001
aor> # at 4
aor> #020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0.
aor> 2-alpha-log created 020812 16:29:30
aor> # at 79
aor> #020812 16:31:13 server id 2 log_pos 79 Rotate to www2-bin.002 pos: 4
aor> # at 118
aor> #020812 16:31:13 server id 1 log_pos 118 Stop
aor> [www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002
aor> # at 4
aor> #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4
aor> # at 43
aor> #020812 16:31:13 server id 1 log_pos 43 Stop
aor> [www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003
aor> # at 4
aor> #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4
aor> # at 43
aor> #020812 16:31:13 server id 1 log_pos 43 Stop
aor> [www2:/opt/mysql-dev/var]:1308#
aor> --------------------------------------------------------------
aor> and so on.
aor> 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:
aor> System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown
aor> Architecture: i686
aor> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
aor> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
aor> gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85)
aor> Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
aor> LIBC:
aor> lrwxrwxrwx 1 root root 11 Nov 25 2000 /lib/libc.so.6 ->
libc-2.2.so
aor> -rwxr-xr-x 1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so
aor> -rw-r--r-- 1 root root 24498288 Jan 11 2001 /usr/lib/libc.a
aor> -rw-r--r-- 1 root root 178 Jan 11 2001 /usr/lib/libc.so
aor> configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared
--prefix=/opt/mysql-dev --with-charset=cp1251
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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