Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4658

Post reboot binlog router entered stuck state

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 22.08.4
    • 2.5.26, 6.4.8, 22.08.7, 23.02.3
    • binlogrouter
    • None
    • ubuntu, on prem vm
      2 mxs with keepalived, 2 local regular async, 1 off site skysql DR replication with binlog router

    Description

      After scheduled OS patching the following happened with a binlog router.

      DB server reported
      [Warning] Aborted connection 207574 to db: 'unconnected' user: 'maxscale' host: '10.90.194.37' (Got an error writing communication packets)

      maxscale was erroring with
      2023-06-28 15:13:14 error : (Replication-Proxy); Error received during replication from '10.90.194.79:3306': Could not open /var/lib/maxscale/binlogs//mariadb-bin.000049 for STOP_EVENT addition

      Slave status was stuck in slave_io = connecting or timed out.

      The binlog on maxscale was not malformed but just the header message.

      Resolution was deleting all files in /var/lib/maxscale/binlog then turning service back on. This then properly repulled the bins and resumed operating properly.

      The standby maxscale node did not suffer this problem

      Attachments

        Issue Links

          Activity

            People

              nantti Niclas Antti
              bbancroft Bryan Bancroft (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.