Crashed report

[jkklee]

ENV: centos 7 proxysql 1.4.4-139-ga51b040
This is the error log, I'm not sure if the last [WARNING] is the direct cause of this crash.

2018-01-09 18:08:25 MySQL_Session.cpp:2874:handler(): [WARNING] Error during query on (1,192.168.1.38,3306): 1267, Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
Error: signal 11:
proxysql(_Z13crash_handleri+0x1a)[0x44baba]
/lib64/libc.so.6(+0x35250)[0x7fab0aecf250]
/lib64/libstdc++.so.6(_ZSt28_Rb_tree_rebalance_for_erasePSt18_Rb_tree_node_baseRS_+0xc0)[0x7fab0b7e86e0]
proxysql(_ZN22MySQL_STMT_Manager_v1416ref_count_clientEmib+0x159)[0x4c5329]
proxysql(_ZN21MySQL_STMTs_local_v1412client_closeEj+0x7f)[0x4c589f]
proxysql(_ZN13MySQL_Session7handlerEv+0x993)[0x487313]
proxysql(_ZN12MySQL_Thread20process_all_sessionsEv+0x29c)[0x47030c]
proxysql(_ZN12MySQL_Thread3runEv+0xd66)[0x478f06]
proxysql(_Z24mysql_worker_thread_funcPv+0x6c)[0x449afc]
/lib64/libpthread.so.0(+0x7dc5)[0x7fab0c6fcdc5]
/lib64/libc.so.6(clone+0x6d)[0x7fab0af9176d]
2018-01-09 18:08:57 main.cpp:913:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
2018-01-09 18:08:57 [INFO] Angel process started ProxySQL process 133240
Standard ProxySQL Cluster rev. 0.1.0702 -- ProxySQL_Cluster.cpp -- Wed Dec 20 12:28:37 2017
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Wed Dec 20 12:28:37 2017

[jkklee]

I think I can confirm the reason of crash, Proxysql crashed the second time after

MySQL_Session.cpp:2874:handler(): [WARNING] Error during query on (1,192.168.1.38,3306): 1267, Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

but not immediately after this, the interval is a few seconds as I see.

[renecannao]

Hi. Probably is the same as bug #1307 .
Can you try to compile 1.4.5 from source? Or I can provide a package.
Thank you

[jkklee]

sorry for the late reply，I will try tomorrow. It's better if you can give me a package😀

[renecannao]

proxysql-1.4.5-1-centos7.x86_64.rpm.gz
Preview of ProxySQL 1.4.5 for CentOS 7 is attached.
Thanks.

[jkklee]

@renecannao It's ok now!

[renecannao]

1.4.5 is out.
Thanks

[jkklee]

I updated to v1.4.5-19-g3b9e408, but it still crashed at sometime, the attachments is the crash log that filtered by tail -6000 /var/lib/proxysql/proxysql.log | grep -A 13 "signal" > /tmp/proxysql_crash.log
proxysql_crash.log

[jkklee]

@renecannao I can provide more detail information if you need, thanks.

[renecannao]

Hi @jkklee , this is probably a different bug.

Using addr2line, the most common crash seems on:

/opt/proxysql/lib/MySQL_PreparedStatement.cpp:415
/opt/proxysql/lib/MySQL_PreparedStatement.cpp:557
/opt/proxysql/lib/MySQL_PreparedStatement.cpp:699
/opt/proxysql/lib/MySQL_Session.cpp:2597

This seems a different bug:

Error: signal 11:
proxysql(_Z13crash_handleri+0x1a)[0x44baca]
/lib64/libc.so.6(+0x35250)[0x7fe3cc732250]
proxysql(mysql_change_user_start+0x3a)[0x608d5a]
proxysql(_ZN16MySQL_Connection17change_user_startEv+0x6f)[0x55178f]
proxysql(_ZN16MySQL_Connection7handlerEs+0xb50)[0x552900]
proxysql(_ZN16MySQL_Connection17async_change_userEs+0x41)[0x5532b1]
proxysql(_ZN13MySQL_Session43handler_again___status_CHANGING_USER_SERVEREPi+0xb61)[0x486301]
proxysql(_ZN13MySQL_Session7handlerEv+0x1206)[0x487bd6]
proxysql(_ZN12MySQL_Thread20process_all_sessionsEv+0x29c)[0x47030c]
proxysql(_ZN12MySQL_Thread3runEv+0xd76)[0x478f56]
proxysql(_Z24mysql_worker_thread_funcPv+0x6c)[0x449afc]
/lib64/libpthread.so.0(+0x7dc5)[0x7fe3cdf5fdc5]
/lib64/libc.so.6(clone+0x6d)[0x7fe3cc7f476d]

Do you have the core dump for this one?

[jkklee]

I'v sent core file to you email(rene.cannao gmail)

[renecannao]

Received, thanks.
From a quick look the backtrace seems correct.
Maybe the other bug is corrupting memory. Let me fix that one first.

[jkklee]

@renecannao Thanks very much!

[jkklee]

@renecannao dose the crash will be fix soon?