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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
