Our application creates SQL dynamically to generate reports using PHP drivers. Our application's reporting engine generates SQL via string functions, and then passes that SQL to be run with the mysql class using MySQLi driver with client api version is 5.5.52-MariaDB. Some queries will crash the mysqld executable when run using this method. We have taken the code generated and run it in MySQL Workbench, dbForge Sutdio for MySQL, and directly on the server MySQL client and it will crash the mysqld executable every time. If we modify the query by either formatting it or adding spaces, the query completes and no crash is created. We have changed our code to basically wrap the SQL with another :SELECT * FROM (generated SQL)" and this method works to allow the query to run properly. However, because this is crashing the mysqld, we wanted to start a bug ticket.

We have run the code on our dev server using MariaDB 5.5.53, and on our staging Galera cluster running 10.0.31-galera in every manner possible, but crashes still happen. When it happens on the galera cluster, the mysql-safe restart does not properly restart wsrep services and we have to do a full server restart for that cluster member.

I have uploaded the sql error log from both servers for review (tmo-db.feeneywireless.com.err and fw-end1.feeneywireless.com.err) and the config files (tmo-db.my.cnf and fw-end1.my.cnf). I also included a sample of the SQL that is causing the crash, but there have been other generated SQL that caused the problems.

Our next steps are to update to current version on these servers but would like to do so only if this is a known bug that has been fixed in the 5.5 and 10.0 branches.