Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5278

[PS 5.6] PAM plugin tests fail on CentOS when tokubackup is active

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None

      Description

      When running PAM bats tests they cause a server to hang. After running the following command to check PAM status:

      mysql -N -s -utest_pam -ptest1234 -e "SELECT * FROM test_pam_table;" test_pam
      Warning: Using a password on the command line interface can be insecure.
      

      server starts another mysql instance:

      [root@centos6 ~]# ps auxww| grep mysql
      root     11899  0.1  0.1  11436  1564 pts/2    S    14:09   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centos6.pid
      mysql    12103  5.4 52.2 1193808 533328 pts/2  Sl   14:09   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos6.pid --socket=/var/lib/mysql/mysql.sock
      root     12140  0.0  0.0 103320   888 pts/2    S+   14:09   0:00 grep mysql
      ...
      Running the command
      ...
      [root@centos6 ~]# ps auxww| grep mysql
      root     11899  0.0  0.1  11436  1564 pts/2    S    14:09   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centos6.pid
      mysql    12103  0.5 52.4 1202476 534796 pts/2  Sl   14:09   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos6.pid --socket=/var/lib/mysql/mysql.sock
      root     12146  0.0  0.3 157000  3664 pts/1    S+   14:11   0:00 mysql -N -s -utest_pam -px xxxxxx -e SELECT * FROM test_pam_table; test_pam
      mysql    12148  0.0 51.5 1202476 525700 pts/2  S    14:11   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos6.pid --socket=/var/lib/mysql/mysql.sock
      root     12150  0.0  0.0 103320   884 pts/2    S+   14:11   0:00 grep mysql
      

      I can't reproduce the issue with packages currently in main repos, or Debian/Ubuntu packages.

      List of installed packages:

      Percona-Server-server-56-5.6.42-rel84.2.el6.x86_64
      Percona-Server-test-56-5.6.42-rel84.2.el6.x86_64
      Percona-Server-devel-56-5.6.42-rel84.2.el6.x86_64
      percona-toolkit-3.0.12-1.el6.x86_64
      percona-xtrabackup-2.3.10-1.el6.x86_64
      percona-xtrabackup-debuginfo-2.3.10-1.el6.x86_64
      percona-release-0.1-6.noarch
      Percona-Server-shared-56-5.6.42-rel84.2.el6.x86_64
      Percona-Server-tokudb-56-5.6.42-rel84.2.el6.x86_64
      Percona-Server-56-debuginfo-5.6.42-rel84.2.el6.x86_64
      percona-xtrabackup-test-2.3.10-1.el6.x86_64
      Percona-Server-client-56-5.6.42-rel84.2.el6.x86_64
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 6 hours, 15 minutes
                  1d 6h 15m