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

At 15:10 5/29/2002 -0600, Sasha Pachev wrote:


>On Tuesday 28 May 2002 08:29 am, Melvyn Sopacua wrote:
> > >Description:
> > ????????When one of the servers in a replication scheme, where master =
>slave of master,
> > ????????goes down, the servers replicate eachothers 'set logfile' command.
> > ????????This results in a new logfile being created every few seconds and
>tying up server
> > ????????resources.
>
>Thanks for reporting the bug. This is a known problem, and is fixed in 4.0.2.

Nope it is not.

mysql> SHOW BINLOG EVENTS IN 'rep_log.36640';
+---------------+-----+------------+-----------+------------ --+---------------------------------------+
| Log_name | Pos | Event_type | Server_id | Orig_log_pos |
Info |
+---------------+-----+------------+-----------+------------ --+---------------------------------------+
| rep_log.36640 | 4 | Rotate | 3406120 | 4 |
rep_log.36641;pos=4; forced by master |
| rep_log.36640 | 44 | Stop | 3406121 |
44 | |
+---------------+-----+------------+-----------+------------ --+---------------------------------------+
2 rows in set (0.80 sec)

mysql> SELECT VERSION();
+-----------------+
| VERSION() |
+-----------------+
| 4.0.2-alpha-log |
+-----------------+
1 row in set (0.01 sec)

Can you please look into it again?




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