ProxySQL crash 1.4.10 / seems to be query result related

[Reiner030]

same server as in #1648

Both errors "started" crashing this week after using proxySQL 1.4.10 since last week:

2018-08-10 15:31:14 status installed proxysql:amd64 1.4.10

before there were no such crashes (recognized) on this server so I have to downgrade to 1.4.9...

This time reason:

Error: signal 11:
proxysql(_Z13crash_handleri+0x1a)[0x44a61a]
/lib/x86_64-linux-gnu/libc.so.6(+0x350e0)[0x7fde9678a0e0]
proxysql[0x572e33]
proxysql[0x578d32]
proxysql[0x5acb48]
proxysql[0x5ad41c]
proxysql(unpack_fields+0x1a8)[0x617008]
proxysql(mthd_my_read_query_result+0x1b0)[0x617e90]
proxysql[0x61d3ff]
proxysql(my_context_spawn+0x41)[0x61c891]
2018-08-15 14:25:13 main.cpp:910:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
2018-08-15 14:25:13 [INFO] Angel process started ProxySQL process 18832
Standard ProxySQL Cluster rev. 0.1.0702 -- ProxySQL_Cluster.cpp -- Tue Aug  7 12:46:14 2018
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Tue Aug  7 12:46:14 2018
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Tue Aug  7 12:46:14 2018
Standard ProxySQL Admin rev. 0.2.0902 -- ProxySQL_Admin.cpp -- Tue Aug  7 12:46:14 2018
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Tue Aug  7 12:46:14 2018
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Tue Aug  7 12:46:14 2018

core file mailed to @renecannao

[renecannao]

Hi @Reiner030 . No core dump received yet.
Can you also send an extract from the error log before the crash?
Thanks

[Reiner030]

I hope they arrived in meantime - if not I would try send/share them with my google account but it could take some time / they could be filtered out because of size:

# ls -lh /var/lib/proxysql/core*
-rw------- 1 root root 24M Aug 15 09:45 /var/lib/proxysql/core-2018-08-15-09.45.gz
-rw------- 1 root root 16M Aug 15 14:25 /var/lib/proxysql/core-2018-08-15-14.25.gz

I added the full proxysql log of today in email of this issue and the variables like requested in issue #1600 after 2nd crash:

SHOW MYSQL VARIABLES;
SELECT * FROM stats.stats_mysql_global ORDER BY Variable_Name;
SELECT * FROM mysql_query_rules;
SELECT * FROM monitor.mysql_server_ping_log LIMIT 30;
SELECT * FROM mysql_servers;
SELECT * FROM stats_mysql_connection_pool;
SELECT * FROM stats_mysql_query_digest WHERE digest_text LIKE '%timeout%';