maria-discuss team mailing list archive

[Daniel Black <daniel@xxxxxxxxxxxxx>]

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