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

Position of events reported by mysqlbinlog is wrong with encrypted binlogs, SHOW BINLOG EVENTS reports the correct one.

    XMLWordPrintable

    Details

      Description

      Using encrypted binlogs it was impossible to point a Slave to the Master getting error:

      2019-09-09 5:55:23 139739348764416 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event 'mysql-binlog.016054' at 763411303, the last event read from 'mysql-binlog.nnnnn' at xxxxxxx, the last byte read from 'mysql-binlog.nnnnn at yyyyyyy. (server_errno=1236)

      The error message is misleading because it's just due to pointing to a wrong position.

      Using the positions reported by SHOW BINLOG EVENTS worked.

        Attachments

        1. config-sql.txt
          0.7 kB
        2. mysqlbinlog.txt
          4 kB
        3. show_binlog_events.txt
          3 kB

          Activity

            People

            Assignee:
            sachin.setiya.007 Sachin Setiya
            Reporter:
            claudio.nanni Claudio Nanni
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: