[debian-mysql] dbconfig autopkgtests fail: Plugin caching_sha2_password could not be loaded: /usr/lib/aarch64-linux-gnu/mariadb19/plugin/caching_sha2_password.so

Sun Aug 23 11:18:47 BST 2020

Hello!

I uploaded mariadb-10.3 1:10.3.24-1 to Debian unstable yesterday and
autopkgtests for dbconfig started to fail. Seems they are also failing
after the recent mysql-8.0 upload.

The log at https://ci.debian.net/data/autopkgtest/testing/amd64/d/dbconfig-common/6770952/log.gz
is very long and hard to decipher. Searching for typical strings such
as "error" yields too many results.

Paul, could you please help by interpreting the log for us?

https://ci.debian.net/data/autopkgtest/testing/amd64/d/dbconfig-common/6770952/log.gz
https://ci.debian.net/data/autopkgtest/testing/amd64/d/dbconfig-common/6747576/log.gz
https://ci.debian.net/data/autopkgtest/testing/arm64/d/dbconfig-common/6771128/log.gz

I can see this but I don't understand the context. This file has never
even been packaged in mariadb-10.3 in Debian.

***
failed: Plugin caching_sha2_password could not be loaded:
/usr/lib/aarch64-linux-gnu/mariadb19/plugin/caching_sha2_password.so:
cannot open shared object file: No such file or directory at
/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql
line 18
***

More

Creating config file /etc/db-test-mysql-perl/debian-db.pm with new version
dbc_read_package_config() .
dbc_detect_installed_dbtype() mysql.
_dbc_detect_installed_dbtype() mysql.
dbc_get_admin_pass() .
debconf (developer): <-- FGET db-test-mysql-perl/mysql/admin-pass seen
debconf (developer): --> 0 true
debconf (developer): <-- GET db-test-mysql-perl/mysql/admin-pass
debconf (developer): --> 0 CeMTqG9yU2jVBNow
_dbc_detect_installed_dbtype() mysql.
checking privileges on database dbtestmysqlperl for
db-test-mysql-pe at localhost: user creation needed.
granting access to database dbtestmysqlperl for
db-test-mysql-pe at localhost: success.
verifying access for db-test-mysql-pe at localhost: success.
_dbc_detect_installed_dbtype() mysql.
creating database dbtestmysqlperl: success.
verifying database dbtestmysqlperl exists: success.
populating database via scriptfile...  DBI
connect('database=dbtestmysqlperl;host=localhost','db-test-mysql-pe',...)
failed: Plugin caching_sha2_password could not be loaded:
/usr/lib/aarch64-linux-gnu/mariadb19/plugin/caching_sha2_password.so:
cannot open shared object file: No such file or directory at
/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql
line 18.
Can't call method "do" on an undefined value at
/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql
line 21.
error encountered populating database:
/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql
exited with non-zero status
If the script logged anything about what went wrong,
 it can be found in /var/log/apt/term.log.
debconf (developer): <-- SUBST db-test-mysql-perl/install-error error
/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql
exited with non-zero status\nIf the script logged anything about what
went wrong,\n it can be found in /var/log/apt/term.log.
debconf (developer): --> 0
debconf (developer): <-- FSET db-test-mysql-perl/install-error seen false
debconf (developer): --> 0 false
debconf (developer): <-- INPUT critical db-test-mysql-perl/install-error
debconf (developer): --> 0 question will be asked
debconf (developer): <-- GO
Configuring db-test-mysql-perl
------------------------------

An error occurred while installing the database:

/usr/share/dbconfig-common/scripts/db-test-mysql-perl/install/mysql exited with
non-zero status\nIf the script logged anything about what went wrong,\n it can
be found in /var/log/apt/term.log. . Your options are:
 * abort - Causes the operation to fail; you will need to downgrade,
   reinstall, reconfigure this package, or otherwise manually intervene
   to continue using it. This will usually also impact your ability to
   install other packages until the installation failure is resolved.
 * retry - Prompts once more with all the configuration questions
   (including ones you may have missed due to the debconf priority
   setting) and makes another attempt at performing the operation.
 * retry (skip questions) - Immediately attempts the operation again,
   skipping all questions. This is normally useful only if you have
   solved the underlying problem since the time the error occurred.
 * ignore - Continues the operation ignoring dbconfig-common errors.
   This will usually leave this package without a functional database.

  1. abort  2. retry  3. retry (skip questions)  4. ignore
Next step for database installation:
Use of uninitialized value $_[1] in join or string at
/usr/share/perl5/Debconf/DbDriver/Stack.pm line 111.
debconf (developer): --> 0 ok
debconf (developer): <-- GET db-test-mysql-perl/install-error
debconf (developer): --> 0 abort
debconf (developer): <-- FSET db-test-mysql-perl/database-type seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/dbconfig-install seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/dbconfig-upgrade seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/dbconfig-remove seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/dbconfig-reinstall seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/password-confirm seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/app-password-confirm seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/purge seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/upgrade-backup seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET
db-test-mysql-perl/passwords-do-not-match seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/install-error seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/upgrade-error seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/remove-error seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET
db-test-mysql-perl/internal/reconfiguring seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/internal/skip-preseed
seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET
db-test-mysql-perl/missing-db-package-error seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/mysql/authplugin seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/mysql/method seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/remote/host seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/remote/newhost seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/mysql/app-pass seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/mysql/admin-user seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/mysql/admin-pass seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/remote/port seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/db/dbname seen false
debconf (developer): --> 0 false
debconf (developer): <-- FSET db-test-mysql-perl/db/app-user seen false
debconf (developer): --> 0 false
dbconfig-common: db-test-mysql-perl configure: aborted.
dbc_postinst_cleanup() .
dbc_forget_dbadmin_password() .
dbconfig-common: flushing administrative password
debconf (developer): <-- RESET db-test-mysql-perl/mysql/admin-pass
debconf (developer): --> 0
debconf (developer): <-- FSET db-test-mysql-perl/mysql/admin-pass seen false
debconf (developer): --> 0 false
debconf (developer): <-- RESET db-test-mysql-perl/password-confirm
debconf (developer): --> 0
debconf (developer): <-- FSET db-test-mysql-perl/password-confirm seen false
debconf (developer): --> 0 false
dbc_forget_app_password() .
debconf (developer): <-- RESET db-test-mysql-perl/mysql/app-pass
debconf (developer): --> 0
debconf (developer): <-- FSET db-test-mysql-perl/mysql/app-pass seen false
debconf (developer): --> 0 false
debconf (developer): <-- RESET db-test-mysql-perl/app-password-confirm
debconf (developer): --> 0
debconf (developer): <-- FSET db-test-mysql-perl/app-password-confirm seen false
debconf (developer): --> 0 false
debconf (developer): <-- RESET db-test-mysql-perl/internal/skip-preseed
debconf (developer): --> 0
debconf (developer): <-- RESET db-test-mysql-perl/internal/reconfiguring
debconf (developer): --> 0
Use of uninitialized value $val in substitution (s///) at
/usr/share/perl5/Debconf/Format/822.pm line 83, <GEN5> line 56.
Use of uninitialized value $val in concatenation (.) or string at
/usr/share/perl5/Debconf/Format/822.pm line 84, <GEN5> line 56.
dpkg: error processing package db-test-mysql-perl (--install):
 installed db-test-mysql-perl package post-installation script
subprocess returned error exit status 1
Errors were encountered while processing:
 db-test-mysql-perl
autopkgtest [21:31:26]: test install-examples: -----------------------]
install-examples     FAIL non-zero exit status 1
autopkgtest [21:31:26]: test install-examples:  - - - - - - - - - -
results - - - - - - - - - -
autopkgtest [21:31:26]: test install-examples: preparing testbed