ProxySQL 2.0.10 crash Watchdog: 1 threads missed a heartbeat

[Walter9495]

ProxySQL 2.0.10 got crasheddue to Watchdog missed a heartbeat

ProxySQL version 2.0.10-27-g5b31997
OS Version: Ubuntu 16.04.6

ProxySQL error log:

2022-09-01 03:41:32 main.cpp:1819:main(): [ERROR] Watchdog: 1 threads missed a heartbeat
2022-09-01 03:41:35 main.cpp:1819:main(): [ERROR] Watchdog: 1 threads missed a heartbeat
2022-09-01 03:41:41 main.cpp:1819:main(): [ERROR] Watchdog: 1 threads missed a heartbeat
2022-09-01 03:41:43 main.cpp:1538:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
2022-09-01 03:41:43 [INFO] ProxySQL version 2.0.10-27-g5b31997
2022-09-01 03:41:43 [INFO] ProxySQL SHA1 checksum: a9d97b741a0eb29deca65410a4e82319d1b4f2ce
2022-09-01 03:41:43 [INFO] Angel process started ProxySQL process 8190
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
2022-09-01 03:41:43 [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
2022-09-01 03:41:43 [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

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 18292]
[New LWP 18293]
[New LWP 18294]
[New LWP 18296]
[New LWP 18297]
[New LWP 18295]
[New LWP 18298]
[New LWP 18299]
[New LWP 18307]
[New LWP 18300]
[New LWP 18301]
[New LWP 18315]
[New LWP 18318]
[New LWP 18329]
[New LWP 18330]
[New LWP 18331]
[New LWP 18332]
[New LWP 18340]
[New LWP 18341]
[New LWP 26358]
[New LWP 18320]
[New LWP 18322]
[New LWP 18317]
[New LWP 18319]
[New LWP 18310]
[New LWP 18311]
[New LWP 18305]
[New LWP 18314]
[New LWP 18321]
[New LWP 18316]
[New LWP 18309]
[New LWP 18308]
[New LWP 18304]
[New LWP 18306]
[New LWP 18302]
[New LWP 18303]
[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 SIGABRT, Aborted.
#0  0x00007f524cc11438 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
54 ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
[Current thread is 1 (Thread 0x7f524e3b5400 (LWP 18292))]
(gdb) bt
#0  0x00007f524cc11438 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#1  0x00007f524cc1303a in __GI_abort () at abort.c:89
#2  0x00007f524cc09be7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0xa678e0 "0", file=file@entry=0x977f56 "main.cpp", line=line@entry=1825,
    function=function@entry=0x9792e0 <main::__PRETTY_FUNCTION__> "int main(int, const char**)") at assert.c:92
#3  0x00007f524cc09c92 in __GI___assert_fail (assertion=assertion@entry=0xa678e0 "0", file=file@entry=0x977f56 "main.cpp", line=line@entry=1825, function=function@entry=0x9792e0 <main::__PRETTY_FUNCTION__> "int main(int, const char**)")
    at assert.c:101
#4  0x00000000004a60ac in main (argc=<optimized out>, argv=<optimized out>) at main.cpp:1825
(gdb) bt full
#0  0x00007f524cc11438 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
        resultvar = 0
        pid = 18292
        selftid = 18292
#1  0x00007f524cc1303a in __GI_abort () at abort.c:89
        save_stage = 2
        act = {__sigaction_handler = {sa_handler = 0x4, sa_sigaction = 0x4}, sa_mask = {__val = {140720787299728, 10, 140720787299040, 8589934593, 0, 0, 0, 21474836480, 139991453174976, 140720787299192, 140720787298992, 139991453188944,
              139991453202592, 1, 139991453188944, 10909920}}, sa_flags = 1825, sa_restorer = 0x9792e0 <main::__PRETTY_FUNCTION__>}
        sigs = {__val = {32, 0 <repeats 15 times>}}
#2  0x00007f524cc09be7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0xa678e0 "0", file=file@entry=0x977f56 "main.cpp", line=line@entry=1825,
    function=function@entry=0x9792e0 <main::__PRETTY_FUNCTION__> "int main(int, const char**)") at assert.c:92
        str = 0x7f5249500850 "proxysql: main.cpp:1825: int main(int, const char**): Assertion `0' failed.\n"
        total = 4096
#3  0x00007f524cc09c92 in __GI___assert_fail (assertion=assertion@entry=0xa678e0 "0", file=file@entry=0x977f56 "main.cpp", line=line@entry=1825, function=function@entry=0x9792e0 <main::__PRETTY_FUNCTION__> "int main(int, const char**)")
    at assert.c:101
No locals.
#4  0x00000000004a60ac in main (argc=<optimized out>, argv=<optimized out>) at main.cpp:1825
        atomic_curtime = <optimized out>
        poll_timeout = <optimized out>
        threads_missing_heartbeat = <optimized out>
        i = <optimized out>
        missed_heartbeats = 10
        previous_time = 11581804874966
        inner_loops = 0
        nlimit = {rlim_cur = 102400, rlim_max = 1048576}
        __func__ = "main"
        __PRETTY_FUNCTION__ = "int main(int, const char**)"

[JavierJF]

Hi, sorry but this issue doesn't follow the issue template, it's from a really old ProxySQL version, and doesn't provide a coredump, which is required for crashing issues (the pasted information is just a backtrace under GDB), I'm closing the issue. If you have a crash to report from a more recent ProxySQL version, please make sure to follow the issue template.

Thank you.