mysql crash in dd::upgrade_57::do_pre_checks_and_initialize_dd()

[Hans-Dominik]

2021-12-03T23:00:08.754677Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 1624586
2021-12-03T23:00:08.763921Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
23:00:14 UTC - mysqld got signal 8 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x560d033cf230
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f18710bbd20 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x560cfe1d8011]
/usr/sbin/mysqld(handle_fatal_signal+0x31b) [0x560cfd07bb7b]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7f187e18c3c0]
/usr/sbin/mysqld(trx_assign_rseg_durable(trx_t*)+0x226) [0x560cfe4ba946]
/usr/sbin/mysqld(+0x25c289e) [0x560cfe4c389e]
/usr/sbin/mysqld(dict_stats_evict_tablespaces()+0x54) [0x560cfe609be4]
/usr/sbin/mysqld(+0x23b838e) [0x560cfe2b938e]
/usr/sbin/mysqld(dd::bootstrap::DDSE_dict_init(THD*, dict_init_mode_t, unsigned int)+0x9e) [0x560cfdf5c89e]
/usr/sbin/mysqld(dd::upgrade_57::do_pre_checks_and_initialize_dd(THD*)+0x3fc) [0x560cfe1ab1ec]
/usr/sbin/mysqld(+0x1240456) [0x560cfd141456]
/usr/sbin/mysqld(+0x2885bc9) [0x560cfe786bc9]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7f187e180609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f187d8c5293]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 1
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

### Original Report ###
just updating regularily with do-release-upgrade

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.27-0ubuntu0.20.04.1
ProcVersionSignature: Ubuntu 5.4.0-91.102-generic 5.4.151
Uname: Linux 5.4.0-91-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.21
Architecture: amd64
CasperMD5CheckResult: skip
Date: Sat Dec 4 10:17:14 2021
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ntkonto', 'wikidb', 'ca-key.pem', 'server-key.pem', 'debian-5.7.flag', 'undo_002', 'da', 'WG@002dBiblio', 'horde2', 'nconf', 'mysql_dd_upgrade_info', 'undo_1_trunc.log', 'mysqld_safe.pid', 'server-cert.pem', 's9y_tk', 'ib_logfile1', 'darkman', 'webmoviedb', 'ca.pem', 'ib_logfile0', 'auto.cnf', 'netjuke', 'mysql_upgrade_info', 'horde', '#innodb_temp', 'undo_2_trunc.log', 'cpg', 'ib_buffer_pool', 'performance_schema', 'client-key.pem', 'diak', 'binlog.index', 'client-cert.pem', 'gallery2', 'pydio', 'ibtmp1', 'ibdata1', 'intranet', 'phpmyadmin', 'sys', '#ib_16384_1.dblwr', 'debian-5.6.flag', 'buerowg', 'public_key.pem', 'mysql', '#ib_16384_0.dblwr', 'ocb', 'private_key.pem', 'wikidb_hdm']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-91-generic root=UUID=0b33cf7f-bfbb-4b24-a021-f56d07d8b804 ro
Python3Details: /usr/bin/python3.8, Python 3.8.10, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4
RelatedPackageVersions:
 dpkg 1.19.7ubuntu3
 apt 2.0.6
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.27-0ubuntu0.20.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: Upgraded to focal on 2021-12-04 (0 days ago)

[Bryce Harrington (bryce)]

Your mysql error log shows the server had been segfaulting repeatedly.
The stack trace looks similar to this upstream bug:

https://bugs.mysql.com/bug.php?id=95404

That bug report has steps to reproduce the crash and a suggestion for fixing it, but the bug report remains open so presumably the issue is still unresolved.