On Thu, 3 Oct 2019 10:27:01 +0200 Thomas Plant <thomas@plant.systems> wrote:
Hello,
we have a client VM with MariaDB 10.4.8 which crashes always on the same query (it's in the log). Can someone help me to debug the problem, or is it already known problem? Server ist a CentOS 7 patched up to date and MariaDB 10.4.8 from the MariaDB repositories.
Log contains the following:
191003 9:43:19 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
See this ^, https://jira.mariadb.org/ Include EXPLAIN EXTENDED {query} So with for email_template_id` = 11 as a comparison point too (output might be different). for table users, email_templates and users_email: SHOW CREATE TABLE {tablename} SHOW INDEXES FROM {tablename} This information will still be useful even if you've reverted to 10.3