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

wsrep_sst_rsync crashes when log-bin is set but log-bin-index is not.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.30
    • 10.4, 10.5, 10.6
    • None
    • None

    Description

      After having upgraded several systems from MariaDB 10.2.x to MariaDB 10.3.30 we ran into the situation that a full SST does not work, this is in the donor logs:

      2021-08-10 10:23:53 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 5740707)
      2021-08-10 10:23:53 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.220.200.61:4444/rsync_sst' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --gtid 'fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707' --gtid-domain-id '0' --binlog 'galera' --mysqld-args --wsrep_start_position=fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707'
      2021-08-10 10:23:53 2 [Note] WSREP: sst_donor_thread signaled with 0
      2021-08-10 10:23:54 0 [Note] WSREP: Flushing tables for SST...
      2021-08-10 10:23:54 0 [Note] WSREP: Provider paused at fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707 (83)
      2021-08-10 10:23:54 0 [Note] WSREP: Tables flushed.
      tail: cannot open 'mysql-bin.index' for reading: No such file or directory
      2021-08-10 10:23:54 0 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '10.220.200.61:4444/rsync_sst' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --gtid 'fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707' --gtid-domain-id '0' --binlog 'galera' --mysqld-args --wsrep_start_position=fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707
      2021-08-10 10:23:54 0 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '10.220.200.61:4444/rsync_sst' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --gtid 'fcd85f
      39-ec71-11eb-8b1b-3fa7ede6267b:5740707' --gtid-domain-id '0' --binlog 'galera' --mysqld-args --wsrep_start_position=fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707: 1 (Operation not permitted)
      2021-08-10 10:23:54 0 [Note] WSREP: resuming provider at 83
      2021-08-10 10:23:54 0 [Note] WSREP: Provider resumed.
      2021-08-10 10:23:54 0 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '10.220.200.61:4444/rsync_sst' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --gtid 'fcd85f39-ec71-1
      1eb-8b1b-3fa7ede6267b:5740707' --gtid-domain-id '0' --binlog 'galera' --mysqld-args --wsrep_start_position=fcd85f39-ec71-11eb-8b1b-3fa7ede6267b:5740707
      2021-08-10 10:23:54 0 [Warning] WSREP: 0.0 (tb-test-zabbix-db-el): State transfer to 1.0 (tb-test-zabbix-db-wp) failed: -1 (Operation not permitted)
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            rolf.fokkens Rolf Fokkens
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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