ProxySQL 2.0.10 crashing due to signal 11 #3690
Comments
|
Please upgrade |
|
Dear Renecanno, Still proxysql is crashing even after upgraded to the latest version 2.3.2-10-g8cd66cf. OS version - Ubuntu 16.04.6 LTS Proxysql error log : Coredump : |
|
Reopening. Do you have a reproducible test case? |
|
I am now seeing it was a simple |
|
Hi Rene, As requested , I have sent the coredump privately with you .Please check and share your observation |
|
Hello Renecannao, |
|
Hi @kishmu419 and @shan1234567, thanks to the provided coredump we have being able to identify the issue and we are working on a fix. |
|
Sure Javier.
Regards,
G Krishna Kumar
Office Number(Mob) : 6381720944
www.mafiree.com
…On Tue, Nov 30, 2021 at 5:05 PM Javier Jaramago Fernández < ***@***.***> wrote:
Hi @kishmu419 <https://github.com/kishmu419> and @shan1234567
<https://github.com/shan1234567>,
thanks to the provided coredump we have being able to identify the issue
and we are working on a fix.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#3690 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AWNQQXPD4FTAWJQDMZDL37TUOSZG5ANCNFSM5HXOMGTQ>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
|
JavierJF
added a commit
that referenced
this issue
Dec 1, 2021
…#3690 - Provided a new function to partially initialize 'MySQL_ResultSet'. - Replaced 'generate_pkt_row' in favor of 'generate_pkt_row3' for resulset writing.
JavierJF
added a commit
that referenced
this issue
Dec 1, 2021
renecannao
added a commit
that referenced
this issue
Dec 6, 2021
Fixed invalid handling of large packets for Admin - Closes #3690
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ProxySQL 2.0.10 crashed with Signal 11.
ProxySQL version - 2.0.10-27-g5b31997
OS version - Ubuntu 16.04.6 LTS
Proxysql error log :
2021-11-09 13:00:01 MySQL_Thread.cpp:4583:process_all_sessions(): [WARNING] Closing unhealthy client connection 172.33.96.38:27526
Error: signal 11:
proxysql(_Z13crash_handleri+0x2d)[0x4ae7fd]
/lib/x86_64-linux-gnu/libc.so.6(+0x354c0)[0x7f5df8df24c0]
proxysql(_ZN12MySQL_Thread20process_all_sessionsEv+0x599)[0x4f3299]
proxysql(_ZN12MySQL_Thread3runEv+0x16e8)[0x4fb258]
proxysql(_Z24mysql_worker_thread_funcPv+0x7c)[0x4a740c]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f5df9e3b6ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5df8ec44dd]
2021-11-09 13:00:06 main.cpp:1538:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
2021-11-09 13:00:06 [INFO] ProxySQL version 2.0.10-27-g5b31997
2021-11-09 13:00:06 [INFO] ProxySQL SHA1 checksum: a9d97b741a0eb29deca65410a4e82319d1b4f2ce
2021-11-09 13:00:06 [INFO] Angel process started ProxySQL process 6805
Standard ProxySQL MySQL Logger rev. 2.0.0714 -- MySQL_Logger.cpp -- Mon Feb 24 16:38:57 2020
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Mon Feb 24 16:38:57 2020
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Mon Feb 24 16:38:57 2020
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Mon Feb 24 16:38:57 2020
2021-11-09 13:00:06 [INFO] Switching query logging format from 1 to 2
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Mon Feb 24 16:38:57 2020
2021-11-09 13:00:06 [INFO] ProxySQL SHA1 checksum: a9d97b741a0eb29deca65410a4e82319d1b4f2ce
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Mon Feb 24 16:38:57 2020
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Mon Feb 24 16:38:57 2020
2021-11-09 13:00:06 [INFO] Dumping mysql_servers_incoming
Core dump :
GNU gdb (Ubuntu 7.11.1-0ubuntu1~16.5) 7.11.1
Copyright (C) 2016 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
http://www.gnu.org/software/gdb/bugs/.
Find the GDB manual and other documentation resources online at:
http://www.gnu.org/software/gdb/documentation/.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/bin/proxysql...done.
[New LWP 1705]
[New LWP 1694]
[New LWP 1696]
[New LWP 1697]
[New LWP 1700]
[New LWP 1698]
[New LWP 1701]
[New LWP 1699]
[New LWP 1702]
[New LWP 1703]
[New LWP 1711]
[New LWP 1706]
[New LWP 1712]
[New LWP 1713]
[New LWP 1735]
[New LWP 1736]
[New LWP 1704]
[New LWP 1707]
[New LWP 1740]
[New LWP 1709]
[New LWP 1822]
[New LWP 1826]
[New LWP 1858]
[New LWP 1708]
[New LWP 6800]
[New LWP 1741]
[New LWP 1743]
[New LWP 1739]
[New LWP 3490]
[New LWP 1738]
[New LWP 1742]
[New LWP 1859]
[New LWP 1737]
[New LWP 1710]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `proxysql -c /etc/proxysql.cnf -D /var/lib/proxysql'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 MySQL_Thread::process_all_sessions (this=this@entry=0x7f5df0000000) at MySQL_Thread.cpp:4487
4487 MySQL_Thread.cpp: No such file or directory.
[Current thread is 1 (Thread 0x7f5df61eb700 (LWP 1705))]
(gdb) bt full
#0 MySQL_Thread::process_all_sessions (this=this@entry=0x7f5df0000000) at MySQL_Thread.cpp:4487
a = 0
n = 37
total_active_transactions_ = 0
idle_maintenance_thread = false
rc =
func = "process_all_sessions"
#1 0x00000000004fb258 in MySQL_Thread::run (this=this@entry=0x7f5df0000000) at MySQL_Thread.cpp:4327
num_idles =
ttw =
maintenance_interval =
n =
rc =
idle_maintenance_thread =
PRETTY_FUNCTION = "void MySQL_Thread::run()"
func = "run"
#2 0x00000000004a740c in mysql_worker_thread_func (arg=0x7f5df78a2f10) at main.cpp:743
thread_attr = {__size = '\000' <repeats 17 times>, "\020", '\000' <repeats 37 times>, __align = 0}
tmp_stack_size = 8388608
mysql_thread = 0x7f5df78a2f10
worker = 0x7f5df0000000
#3 0x00007f5df9e3b6ba in start_thread (arg=0x7f5df61eb700) at pthread_create.c:333
_res =
pd = 0x7f5df61eb700
now =
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140041537894144, 308842705401010586, 0, 140725267269407, 140041537894848, 140041515671552, -363992290258724454, -364007572692280934}, mask_was_saved = 0}},
priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call =
pagesize_m1 =
sp =
freesize =
PRETTY_FUNCTION = "start_thread"
#4 0x00007f5df8ec44dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
No locals.
(gdb)
#0 MySQL_Thread::process_all_sessions (this=this@entry=0x7f5df0000000) at MySQL_Thread.cpp:4487
a = 0
n = 37
total_active_transactions = 0
idle_maintenance_thread = false
rc =
func = "process_all_sessions"
#1 0x00000000004fb258 in MySQL_Thread::run (this=this@entry=0x7f5df0000000) at MySQL_Thread.cpp:4327
num_idles =
ttw =
maintenance_interval =
n =
rc =
idle_maintenance_thread =
PRETTY_FUNCTION = "void MySQL_Thread::run()"
func = "run"
#2 0x00000000004a740c in mysql_worker_thread_func (arg=0x7f5df78a2f10) at main.cpp:743
thread_attr = {__size = '\000' <repeats 17 times>, "\020", '\000' <repeats 37 times>, __align = 0}
tmp_stack_size = 8388608
mysql_thread = 0x7f5df78a2f10
worker = 0x7f5df0000000
#3 0x00007f5df9e3b6ba in start_thread (arg=0x7f5df61eb700) at pthread_create.c:333
__res =
pd = 0x7f5df61eb700
now =
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140041537894144, 308842705401010586, 0, 140725267269407, 140041537894848, 140041515671552, -363992290258724454, -364007572692280934}, mask_was_saved = 0}},
priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call =
pagesize_m1 =
sp =
freesize =
PRETTY_FUNCTION = "start_thread"
#4 0x00007f5df8ec44dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
No locals.
The text was updated successfully, but these errors were encountered: