enterprise-support team mailing list archive

[Sveta Smirnova <sveta@xxxxxxxxxxxxx>]

Public bug reported:

Currently relay-log.info file should have at most 7 lines, but if run
test from upstream bug #25713 (http://bugs.mysql.com/bug.php?id=25713)
it is possible to get relay-log.info with more lines.

How to repeat.

Follow instructions from http://bugs.mysql.com/bug.php?id=25713:

1. Start replication
2. On master create a procedure:

mysql> \d |
mysql> create procedure p1()
    -> BEGIN
    ->    DECLARE id INT;
    ->    set id=0;
    ->    while id<1000000 do
    ->       INSERT INTO test.tt VALUES (id);
    ->       set id=id+1;
    ->    end while;
    -> END
    -> |
Query OK, 0 rows affected (0.00 sec)

3. Run procedure few times:

call p1();

4. Create bash file:

#!/bin/bash

while [ 1 ]
do
cat /PATH/TO/ps-5.6/mysql-test/var/mysqld.2/data/relay-log.info |awk 'begin{line=0}{line++}{if(line==4)print;if(line==5) print}'
sleep 1
done

5. Run bash file

6. I don't see described corruption of line 4 as in original bug, but
relay-log.info occasionally has 10 lines:

mysql> \! cat var/mysqld.2/data/relay-log.info
7
./slave-relay-bin.000007
69814314
master-bin.000009
69814150
0
0
1
0
1
mysql> \! cat var/mysqld.2/data/relay-log.info | wc -l
10


Having that relay-log.info can have extra lines there is possibility it can be corrupted in worst way. Customer saw it corrupted binary log file name and position.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: New

** Affects: percona-server/5.1
     Importance: Undecided
         Status: New

** Affects: percona-server/5.5
     Importance: Undecided
         Status: New

** Affects: percona-server/5.6
     Importance: Undecided
         Status: New


** Tags: i56136

** Bug watch added: MySQL Bug System #25713
   http://bugs.mysql.com/bug.php?id=25713

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=25713
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1470273

Title:
  Extra lines in relay-log.info

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1470273/+subscriptions