Proxysql: ProxySQL Crashed: Querying from stats_mysql_errors table

[eightnoteight]

[x] A clear description of your issue

When I tried to query from the stats_mysql_errors table, the proxysql crashed.

[x] The version of OS and ProxySQL details
OS Details

$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 9.8 (stretch)
Release:    9.8
Codename:   stretch

ProxySQL Version:

2019-03-26 09:25:43 [INFO] ProxySQL version 2.0.2-1-g533442f4

It's a 3 node proxysql cluster
Installation Mechanism
sudo apt install proxysql

[ ] Every step to reproduce the issue
since this happened on our production, and the behaviour repeated when tried to query again on the same table after the restart. it's hard for me to include the steps to achieve this state but it's happening with this simple query

select * from stats.stats_mysql_errors limit 10;

[x] The error log

proxysql: ProxySQL_Admin.cpp:6068: void ProxySQL_Admin::stats___mysql_errors(bool): Assertion `rc==SQLITE_OK' failed.
Error: signal 6:
/usr/bin/proxysql(_Z13crash_handleri+0x1a)[0x55e6e828322a]
/lib/x86_64-linux-gnu/libc.so.6(+0x33060)[0x7fc8e0199060]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7fc8e0198fff]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fc8e019a42a]
/lib/x86_64-linux-gnu/libc.so.6(+0x2be67)[0x7fc8e0191e67]
/lib/x86_64-linux-gnu/libc.so.6(+0x2bf12)[0x7fc8e0191f12]
/usr/bin/proxysql(_ZN14ProxySQL_Admin20stats___mysql_errorsEb+0x53e)[0x55e6e82eb25e]
/usr/bin/proxysql(_ZN14ProxySQL_Admin24GenericRefreshStatisticsEPKcjb+0x773)[0x55e6e82fa7b3]
/usr/bin/proxysql(_Z21admin_session_handlerP13MySQL_SessionPvP10_PtrSize_t+0x14c)[0x55e6e8305f9c]
/usr/bin/proxysql(_ZN13MySQL_Session7handlerEv+0x159c)[0x55e6e82cec1c]
/usr/bin/proxysql(_Z11child_mysqlPv+0x251)[0x55e6e82e2ec1]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x74a4)[0x7fc8e13cf4a4]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc8e024ed0f]
2019-03-26 09:25:43 main.cpp:1371:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
2019-03-26 09:25:43 [INFO] ProxySQL version 2.0.2-1-g533442f4

[ ] If it is a crashing bug, please check here: https://github.com/sysown/proxysql/wiki/How-to-report-a-crash-bug

• current error log is too big to be attached here(3GB), if you can plz mention the number of days of error logs needed, I'll attach
• core dump: I'm not sure how I can instruct proxysql to generate core dump on crash

Please let me know if any other details are needed to resolve this.

Thanks

[hmphu]

It's also happened to me. I'm using:

OS: Amazon Linux AMI 2018.03
ProxySQL: ProxySQL version 2.0.3-29-g00f26d5, codename Truls

Proxysql.log

proxysql: ProxySQL_Admin.cpp:6070: void ProxySQL_Admin::stats___mysql_errors(bool): Assertion `rc==0' failed. Error: signal 6: proxysql(_Z13crash_handleri+0x1a)[0x48ff6a] /lib64/libc.so.6(+0x362f0)[0x7feebaff32f0] /lib64/libc.so.6(gsignal+0x37)[0x7feebaff3277] /lib64/libc.so.6(abort+0x148)[0x7feebaff4968] /lib64/libc.so.6(+0x2f096)[0x7feebafec096] /lib64/libc.so.6(+0x2f142)[0x7feebafec142] proxysql(_ZN14ProxySQL_Admin20stats___mysql_errorsEb+0x563)[0x4f9c33] proxysql(_ZN14ProxySQL_Admin24GenericRefreshStatisticsEPKcjb+0x8ac)[0x5097ec] proxysql(_Z21admin_session_handlerP13MySQL_SessionPvP10_PtrSize_t+0x134)[0x515734] proxysql(_ZN13MySQL_Session7handlerEv+0x192a)[0x4de43a] proxysql(_Z11child_mysqlPv+0x251)[0x4f1ff1] /lib64/libpthread.so.0(+0x7de5)[0x7feebc250de5] /lib64/libc.so.6(clone+0x6d)[0x7feebb0baf1d] 2019-04-01 07:00:55 main.cpp:1371:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!

[renecannao]

Thank you for the report.
Can you please provide several lines from error log before the assertion, or even better the full error log? The cause of a problem is often not in the last error message.
This is why we require "The error log" and not "the last error message".
Thanks

[sneils]

I'm having the same problem. There are actually no other errors before this one in the log (at least in my case).

OS: Ubuntu 18.04.2 LTS (Bionic Beaver)
ProxySQL version: ProxySQL version 2.0.3-28-g39a0c9c5, codename Truls

Query ran:

select * from stats_mysql_errors;

Only error in the log:

proxysql: ProxySQL_Admin.cpp:6070: void ProxySQL_Admin::stats___mysql_errors(bool): Assertion `rc==SQLITE_OK' failed.

[renecannao]

Fixed in 2.0.4