[DRE-maint] Bug#1111134: ruby-mysql2: autpkgtest fails on ERROR: 1356 View 'mysql.user' references invalid table(s) with MariaDB 1:11.8.3-1

[Otto Kekäläinen]

Package: ruby-mysql2

After uploading MariaDB 1:11.8.3-1 I saw the error below in debci at
https://ci.debian.net/packages/r/ruby-mysql2/testing/arm64/63206477/

There was this change in the Debian packaging:
https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/cc276ff741c4d9e840ce59a3127ace132b5586d7


I am not able to correlate this with any new commits at
https://salsa.debian.org/mariadb-team/mariadb-server/-/commits/debian/latest

Please help debug. Thanks!


33s + mysqladmin=/usr/bin/mysqladmin --user=debci
--socket=/tmp/tmp.JCafgKwyvZ/mysql.sock
33s + mysql_install_db --no-defaults --datadir=/tmp/tmp.JCafgKwyvZ
--force --skip-name-resolve --user=debci
33s /usr/bin/mysql_install_db: Deprecated program name. It will be
removed in a future release, use 'mariadb-install-db' instead
33s chown: cannot access
'/usr/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool': Permission
denied
33s Couldn't set an owner to
'/usr/lib/mysql/plugin/auth_pam_tool_dir/auth_pam_tool'.
33s It must be root, the PAM authentication plugin doesn't work otherwise..
33s
33s chown: changing ownership of
'/usr/lib/mysql/plugin/auth_pam_tool_dir': Operation not permitted
33s Cannot change ownership of the
'/usr/lib/mysql/plugin/auth_pam_tool_dir' directory
33s to the 'debci' user. Check that you have the necessary permissions
and try again.
33s
33s Installing MariaDB/MySQL system tables in '/tmp/tmp.JCafgKwyvZ' ...
34s OK
34s
34s To start mariadbd at boot time you have to copy
34s support-files/mariadb.service to the right place for your system
34s
34s
34s Two all-privilege accounts were created.
34s One is root at localhost, it has no password, but you need to
34s be system 'root' user to connect. Use, for example, sudo mariadb
34s The second is debci at localhost, it has no password either, but
34s you need to be the system 'debci' user to connect.
34s After connecting you can set the password, if you would need to be
34s able to connect as any of these users with a password and without sudo
34s
34s See the MariaDB Knowledgebase at https://mariadb.com/kb
34s
34s You can start the MariaDB daemon with:
34s cd '/usr' ; /usr/bin/mariadbd-safe --datadir='/tmp/tmp.JCafgKwyvZ'
34s
34s You can test the MariaDB daemon with mariadb-test-run.pl
34s cd '/usr/share/mariadb/mariadb-test' ; perl mariadb-test-run.pl
34s
34s Please report any problems at https://mariadb.org/jira
34s
34s The latest information about MariaDB is available at https://mariadb.org/.
34s
34s Consider joining MariaDB's strong and vibrant community:
34s https://mariadb.org/get-involved/
34s
34s + cat
34s + MYSQL_PID=2803
34s + echo -n pinging mysqld.
34s pinging mysqld.+ attempts=0
34s + /usr/bin/mysqladmin --user=debci
--socket=/tmp/tmp.JCafgKwyvZ/mysql.sock ping
34s + /usr/sbin/mysqld --no-defaults --user=debci
--socket=/tmp/tmp.JCafgKwyvZ/mysql.sock --datadir=/tmp/tmp.JCafgKwyvZ
--skip-networking --init-file=/tmp/tmp.JCafgKwyvZ/init.sql
34s  /usr/bin/mysqladmin: connect to server at 'localhost' failed
34s error: 'Can't connect to local server through socket
'/tmp/tmp.JCafgKwyvZ/mysql.sock' (2)'
34s Check that mariadbd is running and that the socket:
'/tmp/tmp.JCafgKwyvZ/mysql.sock' exists!
34s + sleep 3
34s 2025-08-14 12:46:36 0 [Note] Starting MariaDB 11.8.3-MariaDB-1
from Debian source revision b565b3e7e041c480fd8013e3beec6b99544d6bf8
server_uid vRdSzt0LYXY+YKwCKWw+/fB5Hcw= as process 2803
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Number of transaction pools: 1
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Using io_uring
34s 2025-08-14 12:46:36 0 [Note] InnoDB:
innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Completed initialization of buffer pool
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Buffered log writes (block
size=512 bytes)
34s 2025-08-14 12:46:36 0 [Note] InnoDB: End of log at LSN=46300
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Opened 3 undo tablespaces
34s 2025-08-14 12:46:36 0 [Note] InnoDB: 128 rollback segments in 3
undo tablespaces are active.
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Setting file './ibtmp1' size
to 12.000MiB. Physically writing the file full; Please wait ...
34s 2025-08-14 12:46:36 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
34s 2025-08-14 12:46:36 0 [Note] InnoDB: log sequence number 46300;
transaction id 14
34s 2025-08-14 12:46:36 0 [Note] Plugin 'FEEDBACK' is disabled.
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Loading buffer pool(s) from
/tmp/tmp.JCafgKwyvZ/ib_buffer_pool
34s 2025-08-14 12:46:36 0 [Note] Plugin 'wsrep-provider' is disabled.
34s 2025-08-14 12:46:36 0 [Note] InnoDB: Buffer pool(s) load completed
at 250814 12:46:36
37s + attempts=1
37s + [ 1 -gt 10 ]
37s + /usr/bin/mysqladmin --user=debci
--socket=/tmp/tmp.JCafgKwyvZ/mysql.sock ping
37s  /usr/bin/mysqladmin: connect to server at 'localhost' failed
37s error: 'Can't connect to local server through socket
'/tmp/tmp.JCafgKwyvZ/mysql.sock' (2)'
37s Check that mariadbd is running and that the socket:
'/tmp/tmp.JCafgKwyvZ/mysql.sock' exists!
37s + sleep 3
37s 2025-08-14 12:46:39 0 [Note] mysqld: Event Scheduler: Loaded 0 events
37s ERROR: 1356 View 'mysql.user' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use
them
37s 2025-08-14 12:46:39 0 [Note] /usr/sbin/mysqld: ready for connections.
37s Version: '11.8.3-MariaDB-1 from Debian' socket:
'/tmp/tmp.JCafgKwyvZ/mysql.sock' port: 0 -- Please help get to 10k
stars at https://github.com/MariaDB/Server
40s + attempts=2
40s + [ 2 -gt 10 ]
40s + /usr/bin/mysqladmin --user=debci
--socket=/tmp/tmp.JCafgKwyvZ/mysql.sock ping
40s mysqld is alive
40s + trap cleanup INT EXIT TERM
40s + ruby3.3 -S rspec
42s <internal:gc>:286: warning: double_heap is deprecated, please use
expand_heap instead