Debian 8.11.1, 9.13.0, 10.10.0, 11.0.0 compatibility

[pospelov-v]

Testing was performed considering commits:

• Add updating apt cache and installing gnupg2
• Install python-is-python3 on Ubuntu/Debian if /usr/bin/python does not exists
• Add installing percona-xtrabackup-24 if percona-xtrabackup is not available

OS images:

• test-debian8
• test-debian9
• test-debian10
• test-debian11

Settings (default):

mysql_version_major: "5"
mysql_version_minor: "6"

Errors:

TASK [ansible-percona : Install percona packages and dependencies on Ubuntu (Percona version < 8)] *************************
fatal: [test-debian11]: FAILED! => {"changed": false, "msg": "No package matching 'percona-server-server-5.6' is available"}
changed: [test-debian10]
changed: [test-debian9]
changed: [test-debian8]

Fixed:

TASK [ansible-percona : Install percona-xtrabackup on Ubuntu (Percona version < 8)] *********************************
fatal: [test-debian10]: FAILED! => {"changed": false, "msg": "No package matching 'percona-xtrabackup' is available"}
...ignoring
changed: [test-debian9]
changed: [test-debian8]

TASK [ansible-percona : Install percona-xtrabackup-24 on Ubuntu (Percona version < 8)] ******************************
skipping: [test-debian8]
skipping: [test-debian9]
changed: [test-debian10]

Results:

PLAY RECAP *******************************************************************************************************
test-debian10              : ok=23   changed=14   unreachable=0    failed=0    skipped=26   rescued=0    ignored=2
test-debian11              : ok=12   changed=6    unreachable=0    failed=1    skipped=7    rescued=0    ignored=1
test-debian8               : ok=22   changed=13   unreachable=0    failed=0    skipped=27   rescued=0    ignored=1
test-debian9               : ok=22   changed=14   unreachable=0    failed=0    skipped=27   rescued=0    ignored=1

Installation on test-debian11 failed.

Settings:

mysql_version_major: "8"
mysql_version_minor: "0"

Errors:

TASK [ansible-percona : Install percona packages and dependencies on Ubuntu (Percona version >= 8)] *****************************************************************************************************************************************
fatal: [test-debian8]: FAILED! => {
  "cache_update_time": 1635334459,
  "cache_updated": false,
  "changed": false,
  "msg": "'/usr/bin/apt-get -y -o \"Dpkg::Options::=--force-confdef\" -o \"Dpkg::Options::=--force-confold\"      install 'percona-server-server=8.0*' 'percona-server-client=8.0*' 'percona-toolkit' 'percona-xtrabackup-80'' failed: E: Sub-process /usr/bin/dpkg returned an error code (1)\n",
  "rc": 100,
  "stderr": "E: Sub-process /usr/bin/dpkg returned an error code (1)\n",
  "stderr_lines": [
    "E: Sub-process /usr/bin/dpkg returned an error code (1)"
  ],
  "stdout": "...",
  "stdout_lines": [
    "...",
    "Setting up percona-server-server (8.0.13-4-1.jessie) ...",
    "dpkg: error processing package percona-server-server (--configure):",
    " subprocess installed post-installation script returned error exit status 1",
    "Setting up libdbi-perl (1.631-3+b1) ...",
    "Setting up libdbd-mysql-perl (4.028-2+deb8u2) ...",
    "Setting up libfile-fcntllock-perl (0.22-1+b1) ...",
    "Setting up libterm-readkey-perl (2.32-1+b1) ...",
    "Setting up percona-toolkit (3.2.0-1.jessie) ...",
    "Setting up rsync (3.1.1-3+deb8u2) ...",
    "Setting up libev4 (1:4.15-3) ...",
    "Setting up percona-xtrabackup-80 (8.0.4-1.jessie) ...",
    "Processing triggers for libc-bin (2.19-18+deb8u10) ...",
    "Processing triggers for systemd (215-17+deb8u13) ...",
    "Errors were encountered while processing:",
    " percona-server-server"
  ]
}
changed: [test-debian11]
changed: [test-debian9]
changed: [test-debian10]

Results:

PLAY RECAP *******************************************************************************************************
test-debian10              : ok=24   changed=14   unreachable=0    failed=0    skipped=25   rescued=0    ignored=1
test-debian11              : ok=25   changed=15   unreachable=0    failed=0    skipped=24   rescued=0    ignored=1
test-debian8               : ok=14   changed=6    unreachable=0    failed=1    skipped=9    rescued=0    ignored=1
test-debian9               : ok=24   changed=14   unreachable=0    failed=0    skipped=25   rescued=0    ignored=1

Installation on test-debian8 failed. The crux of the problem here is that python-mysqldb or python3-mysqldb must be installed after mysql-server.