[debian-mysql] Bug#1035944: mariadb: upgrade issue: mariadb-server-10.5 fails to restart after upgrading mariadb-common

[Otto Kekäläinen]

Hi!

I was able to reproduce this with:

apt install mariadb-plugin-gssapi-server mariadb-plugin-gssapi-client
sed s/bullseye/bookworm/g -i /etc/apt/sources.list
apt update
apt-get upgrade

Upgrade only updates mysql-common and mariadb-common:

$ dpkg -l | grep -e mysql -e maria
ii  libdbd-mariadb-perl                1.21-3
ii  libmariadb3:amd64                  1:10.5.19-0+deb11u2
ii  mariadb-client-10.5                1:10.5.19-0+deb11u2
ii  mariadb-client-core-10.5           1:10.5.19-0+deb11u2
ii  mariadb-common                     1:10.11.2-1
ii  mariadb-plugin-gssapi-client:amd64 1:10.5.19-0+deb11u2
ii  mariadb-plugin-gssapi-server       1:10.5.19-0+deb11u2
iF  mariadb-server-10.5                1:10.5.19-0+deb11u2
ii  mariadb-server-core-10.5           1:10.5.19-0+deb11u2
ii  mysql-common                       5.8+1.1.0



I applied manually the debugging patch I have in
https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/26
on /etc/init.d/mariadb and it resulted in:

$ /etc/init.d/mariadb restart
Stopping MariaDB database server: mariadbd.
Starting MariaDB database server: mariadbd . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . .
230514 01:36:00 mysqld_safe Can't log to error log and syslog at the
same time.  Remove all --log-error configuration options for --syslog
to take effect.
230514 01:36:00 mysqld_safe Logging to '/tmp/tmp.AQ6kA9uzuH.err'.
230514 01:36:00 mysqld_safe Starting mariadbd daemon with databases
from /var/lib/mysql
Running '/etc/init.d/mariadb start' failed with error log:
230514 01:36:00 mysqld_safe Starting mariadbd daemon with databases
from /var/lib/mysql
2023-05-14  1:36:00 0 [Note] Starting MariaDB
10.5.19-MariaDB-0+deb11u2 source revision
f8a85af8ca1c937b8d4f847477bd282f80251cde as process 9189
2023-05-14  1:36:00 0 [Note] InnoDB: Uses event mutexes
2023-05-14  1:36:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-05-14  1:36:00 0 [Note] InnoDB: Number of pools: 1
2023-05-14  1:36:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-05-14  1:36:00 0 [Note] InnoDB: Using Linux native AIO
2023-05-14  1:36:00 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2023-05-14  1:36:00 0 [Note] InnoDB: Completed initialization of buffer pool
2023-05-14  1:36:00 0 [Note] InnoDB: Starting crash recovery from
checkpoint LSN=45127,45127
2023-05-14  1:36:00 0 [Note] InnoDB: 128 rollback segments are active.
2023-05-14  1:36:00 0 [Note] InnoDB: Removed temporary tablespace data
file: "ibtmp1"
2023-05-14  1:36:00 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2023-05-14  1:36:00 0 [Note] InnoDB: Setting file './ibtmp1' size to
12 MB. Physically writing the file full; Please wait ...
2023-05-14  1:36:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-05-14  1:36:00 0 [Note] InnoDB: 10.5.19 started; log sequence
number 45163; transaction id 20
2023-05-14  1:36:00 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2023-05-14  1:36:00 0 [Note] Plugin 'FEEDBACK' is disabled.
230514  1:36:00 [ERROR] mysqld got signal 11 ;
...
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5613bb07516e]
/usr/sbin/mariadbd(handle_fatal_signal+0x485)[0x5613bab6df45]
/lib/x86_64-linux-gnu/libc.so.6(+0x3bf90)[0x7f4b7a2faf90]
/usr/lib/x86_64-linux-gnu/libk5crypto.so.3(krb5_c_random_os_entropy+0x0)[0x7f4b785fcde0]
/usr/lib/x86_64-linux-gnu/libkrb5.so.3(krb5_init_context_profile+0x22f)[0x7f4b7866dcbf]
/usr/lib/mysql/plugin/auth_gssapi.so(_Z11plugin_initv+0x129)[0x7f4b7874e569]
/usr/lib/mysql/plugin/auth_gssapi.so(+0x2330)[0x7f4b7874e330]
/usr/sbin/mariadbd(+0x77b562)[0x5613ba982562]
/usr/sbin/mariadbd(_Z11plugin_initPiPPci+0x887)[0x5613ba9834d7]
/usr/sbin/mariadbd(+0x6a40e6)[0x5613ba8ab0e6]
/usr/sbin/mariadbd(_Z11mysqld_mainiPPc+0x3f4)[0x5613ba8b0dc4]
/lib/x86_64-linux-gnu/libc.so.6(+0x2718a)[0x7f4b7a2e618a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f4b7a2e6245]
/usr/sbin/mariadbd(_start+0x2a)[0x5613ba8a5daa]


I suspect that some of the dependencies on the system (libc?) that
updated causes GSSAPI to crash.