[MDEV-17140] DB restarted due to InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2 Created: 2018-09-05  Updated: 2018-10-04  Resolved: 2018-10-04

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.2.17
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Syed Tausiff Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Linux version 3.10.0-514.10.2.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-11) (GCC) ) #1 SMP Fri Mar 3 00:04:05 UTC 2017


Issue Links:
PartOf
is part of MDEV-16554 InnoDB: Assertion failure in file mar... Closed

 Description   

DB got restarted due to bug and looking for permanent fix for this issue
I am suspecting this issue since we did not run mysql_upgrade after db upgrade

DB Version

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1241
Server version: 10.2.17-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Sep 01 23:46:04 ks-s302.alx.local mysqld[13374]: 2018-09-01 23:46:04 139883731261184 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql
Sep 01 23:46:04 ks-s302.alx.local mysqld[13374]: 2018-09-01 23:46:04 139883731261184 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: 2018-09-01 23:46:06 0x7f393854d700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: We intentionally generate a memory trap.
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: If you get repeated assertion failures or crashes, even
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: immediately after the mysqld startup, there may be
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: corruption in the InnoDB tablespace. Please refer to
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: InnoDB: about forcing recovery.
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: 180901 23:46:06 [ERROR] mysqld got signal 6 ;
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: This could be because you hit a bug. It is also possible that this binary
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: or one of the libraries it was linked against is corrupt, improperly built,
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: or misconfigured. This error can also be caused by malfunctioning hardware.
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: We will try our best to scrape up some info that will hopefully help
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: diagnose the problem, but since we have already crashed,
Sep 01 23:46:06 ks-s302.alx.local mysqld[13374]: something is definitely wrong and this may fail.



 Comments   
Comment by Elena Stepanova [ 2018-09-06 ]

You upgraded an instance, didn't run mysql_upgrade, observed a problem – it doesn't seem particularly surprising. For starters, do run mysql_upgrade.
If the problem persists, please attach the full error log, the part that you've copy-pasted is meaningless, we can't conclude anything from it.

Comment by Syed Tausiff [ 2018-09-06 ]

Hi Elena,

Thanks for your reply. I will run mysql_upgrade and If we face the issue again I will send the full error log to you for the follow up.

Syed

Generated at Thu Feb 08 08:34:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.