Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8574

Running RESET MASTER TO n with too big n breaks binary logging

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1.6
        • Fix Version/s: 10.1
        • Component/s: Replication
        • Labels:
          None

          Description

          MariaDB [test]> show binary logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000001 |       312 |
+------------------+-----------+
1 row in set (0.00 sec)

MariaDB [test]> reset master to 2147483647;
Query OK, 0 rows affected (0.36 sec)

MariaDB [test]> show binary logs;
+----------------------+-----------+
| Log_name             | File_size |
+----------------------+-----------+
| mysql-bin.2147483647 |       316 |
+----------------------+-----------+
1 row in set (0.00 sec)

# So far, so good...

          MariaDB [test]> reset master to 2147483648;
ERROR 1098 (HY000): Can't generate a unique log-filename mysql-bin.(1-999)

MariaDB [test]> show binary logs;
Empty set (0.00 sec)

MariaDB [test]> reset master to 1;
ERROR 1373 (HY000): Target log not found in binlog index
MariaDB [test]> reset master;
ERROR 1373 (HY000): Target log not found in binlog index
MariaDB [test]> create table t1 (i int);
ERROR 3 (HY000): Error writing file 'UNOPENED' (Errcode: 9 "Bad file descriptor")

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-8469 Add RESET MASTER TO x to allow specification of binlog file nr

                • Major - Major loss of function.
                • Closed

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      monty Michael Widenius
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: