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

Binlog truncated in the middle of event; consider out of disk space on master

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.1.36, 10.2.17
    • 10.2.19, 10.1.38
    • Replication

    Description

      Experts,
      After applying latest MariaDB patches on Replication master and Replication Slave, we are facing a strange issue.
      Once per nearly 3 hours (random time) replication process at slave stopped with following errors

      2018-09-04 6:33:28 140064771901184 [ERROR] Error reading packet from server: binlog truncated in the middle of event; consider out of disk space on master; the first event 'XXXXX-bin.000727' at 431628288, the last event read from 'XXXXX-bin.000728' at 399111340, the last byte read from 'XXXXX-bin.000728' at 399111359. (server_errno=1236)

      2018-09-04 6:33:28 140064771901184 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'XXXXX-bin.000727' at 431628288, the last event read from 'XXXXX-bin.000728' at 399111340, the last byte read from 'XXXXX-bin.000728' at 399111359.', Internal MariaDB error code: 1236

      This issue resolves when i submit command "stop slave; start slave;" .
      This is something weird and strange because let's assume if problem persists on master replication server how it gone away by "stop slave; start slave;" simple command.

      That make me uncomfortable and unconvinced.
      thanks
      Devang

      Attachments

        1. SLAVE10-Variables.txt
          312 kB
        2. SLAVE10-Status.txt
          28 kB
        3. SLAVE10.log
          4.99 MB
        4. mysqld-slave10.log
          71 kB
        5. mysqld-master14.log
          95 kB
        6. MDEV-17133.png
          MDEV-17133.png
          21 kB
        7. MASTER14-Variables.txt
          466 kB
        8. MASTER14-Status.txt
          28 kB
        9. MASTER14-Processes.txt
          11 kB
        10. MASTER14-Log.txt
          39 kB
        11. MASTER14-bin.000761.zip.013
          1.66 MB
        12. MASTER14-bin.000761.zip.013
          1.66 MB
        13. MASTER14-bin.000761.zip.012
          10.00 MB
        14. MASTER14-bin.000761.zip.012
          10.00 MB
        15. MASTER14-bin.000761.zip.011
          10.00 MB
        16. MASTER14-bin.000761.zip.011
          10.00 MB
        17. MASTER14-bin.000761.zip.010
          10.00 MB
        18. MASTER14-bin.000761.zip.010
          10.00 MB
        19. MASTER14-bin.000761.zip.009
          10.00 MB
        20. MASTER14-bin.000761.zip.009
          10.00 MB
        21. MASTER14-bin.000761.zip.008
          10.00 MB
        22. MASTER14-bin.000761.zip.008
          10.00 MB
        23. MASTER14-bin.000761.zip.007
          10.00 MB
        24. MASTER14-bin.000761.zip.007
          10.00 MB
        25. MASTER14-bin.000761.zip.006
          10.00 MB
        26. MASTER14-bin.000761.zip.006
          10.00 MB
        27. MASTER14-bin.000761.zip.005
          10.00 MB
        28. MASTER14-bin.000761.zip.005
          10.00 MB
        29. MASTER14-bin.000761.zip.004
          10.00 MB
        30. MASTER14-bin.000761.zip.004
          10.00 MB
        31. MASTER14-bin.000761.zip.003
          10.00 MB
        32. MASTER14-bin.000761.zip.003
          10.00 MB
        33. MASTER14-bin.000761.zip.002
          10.00 MB
        34. MASTER14-bin.000761.zip.002
          10.00 MB
        35. MASTER14-bin.000761.zip.001
          10.00 MB
        36. MASTER14-bin.000761.zip.001
          10.00 MB
        37. MASTER14-bin.000712.1033405612.19_bytes.dump
          0.0 kB
        38. MASTER14.log
          4.99 MB
        39. 712.sql
          2 kB

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              devang_modi Devang
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.