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

Galera SST tests fail on Debian sid and focal: all SST method tests fail i.e. mariabackup, mysqldump and rsync

Details

    Attachments

      1. mysqld.1.err
        241 kB
      2. mysqld.2.err
        287 kB
      3. mysqld-local.1.err
        28 kB
      4. mysqld-local.2.err
        13 kB
      5. screenshot-1.png
        screenshot-1.png
        34 kB
      6. stdout-local.log
        2 kB
      7. xtrabackup_galera_info
        0.0 kB

      Activity

        Is this somehow related to https://jira.mariadb.org/browse/MDEV-21140 that was "fixed" but not sure if fix was confirmed.

        jplindst Jan Lindström (Inactive) added a comment - Is this somehow related to https://jira.mariadb.org/browse/MDEV-21140 that was "fixed" but not sure if fix was confirmed.

        jplindst Why do you ask instead of checking it yourself?

        vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular 
        fs.protected_regular = 2
         
        vagrant@ubuntu-focal:~$ sudo rm -f /tmp/xx
        vagrant@ubuntu-focal:~$ sudo touch /tmp/xx
        vagrant@ubuntu-focal:~$ sudo chmod 600 /tmp/xx
        vagrant@ubuntu-focal:~$ sudo chown $USER /tmp/xx
        vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx"
        sh: 1: cannot create /tmp/xx: Permission denied
         
        vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular=0
        fs.protected_regular = 0
        vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx"
         
        vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular=1
        fs.protected_regular = 1
        vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx"
        sh: 1: cannot create /tmp/xx: Permission denied
        

        Can you jplindst please proceed and fix this everywhere in Galera? What Alexander did in MDEV-21140 was most likely not the only place where this is needed.

        otto Otto Kekäläinen added a comment - jplindst Why do you ask instead of checking it yourself? vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular fs.protected_regular = 2   vagrant@ubuntu-focal:~$ sudo rm -f /tmp/xx vagrant@ubuntu-focal:~$ sudo touch /tmp/xx vagrant@ubuntu-focal:~$ sudo chmod 600 /tmp/xx vagrant@ubuntu-focal:~$ sudo chown $USER /tmp/xx vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx" sh: 1: cannot create /tmp/xx: Permission denied   vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular=0 fs.protected_regular = 0 vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx"   vagrant@ubuntu-focal:~$ sudo sysctl fs.protected_regular=1 fs.protected_regular = 1 vagrant@ubuntu-focal:~$ sudo sh -c "echo 1 > /tmp/xx" sh: 1: cannot create /tmp/xx: Permission denied Can you jplindst please proceed and fix this everywhere in Galera? What Alexander did in MDEV-21140 was most likely not the only place where this is needed.

        Tentative fix in https://github.com/MariaDB/server/pull/1510. I am doing this only for 10.5 and only for this one chown scenario in order to not get stalled with fixing the bugs I actually have assigned on my name and which I indend to have closed by the end of the month. Buildbot greenness is holy for me. I don't understand how anybody can develop without having CI that confirms all the time that no testable regressions exist... I at least can't.

        I leave it to Seppo or Jan to fix this properly.

        otto Otto Kekäläinen added a comment - Tentative fix in https://github.com/MariaDB/server/pull/1510 . I am doing this only for 10.5 and only for this one chown scenario in order to not get stalled with fixing the bugs I actually have assigned on my name and which I indend to have closed by the end of the month. Buildbot greenness is holy for me. I don't understand how anybody can develop without having CI that confirms all the time that no testable regressions exist... I at least can't. I leave it to Seppo or Jan to fix this properly.

        Alternative PR targetting 10.2 branch as requested by jplindst: https://github.com/MariaDB/server/pull/1511

        otto Otto Kekäläinen added a comment - Alternative PR targetting 10.2 branch as requested by jplindst : https://github.com/MariaDB/server/pull/1511

        I merged otto’s 10.2 change to 10.3, and it does work there. I see that jplindst separately pushed a change to 10.5 without waiting for a merge.

        marko Marko Mäkelä added a comment - I merged otto ’s 10.2 change to 10.3, and it does work there. I see that jplindst separately pushed a change to 10.5 without waiting for a merge.

        People

          jplindst Jan Lindström (Inactive)
          jplindst Jan Lindström (Inactive)
          Votes:
          1 Vote for this issue
          Watchers:
          7 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.