enterprise-support team mailing list archive

[Bryce Harrington <1953218@xxxxxxxxxxxxxxxxxx>]

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.

** Description changed:

+ 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
+  [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
+  [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
+  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)

** Summary changed:

- 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
+ mysql crash in dd::upgrade_57::do_pre_checks_and_initialize_dd()

** Bug watch added: MySQL Bug System #95404
   http://bugs.mysql.com/bug.php?id=95404

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=95404
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1953218

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1953218/+subscriptions