ProxySQL restarting every 1 minute

[bambooHouse]

• [Description] I'm trying to use ProxySQL with IPv6, then i found ProxySQL restarting every 1 minute, and i check my configurtion , "mysql-monitor_enabled" is false
• [ProxySQL version ] 2.0.8-67-g877cab1
• [ OS version] CentOS Linux release 7.9.2009
• [ steps]
  UPDATE global_variables SET variable_value='0.0.0.0:6033;[::]:6033' WHERE variable_name='mysql-interfaces';
  UPDATE global_variables SET variable_value='0.0.0.0:6032;[::]:6032' WHERE variable_name='admin-mysql_ifaces';
  SAVE MYSQL VARIABLES TO DISK;
  SAVE ADMIN VARIABLES TO DISK;
  PROXYSQL RESTART;
• [error log]
  Error: signal 11:
  /usr/bin/proxysql(_Z13crash_handleri+0x1a)[0x4ad56a]
  /lib64/libc.so.6(+0x36400)[0x7fca5b399400]
  /usr/bin/proxysql[0x7e99aa]
  /usr/bin/proxysql[0x54ab42]
  /lib64/libpthread.so.0(+0x7ea5)[0x7fca5c57aea5]
  /lib64/libc.so.6(clone+0x6d)[0x7fca5b46198d]
  2022-11-29 19:42:11 main.cpp:1396:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!
  2022-11-29 19:42:11 [INFO] ProxySQL version 2.0.8-67-g877cab1
  2022-11-29 19:42:11 [INFO] ProxySQL SHA1 checksum: b47a9f01a56158c4d5e64fada92750a94137844f
  2022-11-29 19:42:11 [INFO] Angel process started ProxySQL process 7265

[bambooHouse]

also, i got many core dump file, they are all > 100m , when i use gdb -c [core dump file], i got result like this :

GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-120.el7
Copyright (C) 2013 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-redhat-linux-gnu".
For bug reporting instructions, please see:
http://www.gnu.org/software/gdb/bugs/.
[New LWP 10001]
[New LWP 10004]
[New LWP 9998]
[New LWP 10002]
[New LWP 10003]
[New LWP 10005]
[New LWP 10009]
[New LWP 10007]
[New LWP 9999]
[New LWP 10000]
[New LWP 10006]
Missing separate debuginfo for the main executable file
Try: yum --enablerepo='debug' install /usr/lib/debug/.build-id/2d/4d471e7b2a379d29feab54ea0171487ed759e0
Core was generated by `/usr/bin/proxysql -c /etc/proxysql.cnf --clickhouse-server'.
Program terminated with signal 11, Segmentation fault.
#0 0x00000000007e99aa in ?? ()

[bambooHouse]

GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-120.el7
Copyright (C) 2013 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-redhat-linux-gnu".
For bug reporting instructions, please see:
http://www.gnu.org/software/gdb/bugs/...
Reading symbols from /usr/bin/proxysql...done.
[New LWP 17147]
[New LWP 17157]
[New LWP 17151]
[New LWP 17150]
[New LWP 17148]
[New LWP 17159]
[New LWP 17143]
[New LWP 17144]
[New LWP 17273]
[New LWP 17142]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/usr/bin/proxysql -c /etc/proxysql.cnf'.
Program terminated with signal 11, Segmentation fault.
#0 atomic_load_p (mo=atomic_memory_order_relaxed, a=0x0) at include/jemalloc/internal/atomic.h:62
62 include/jemalloc/internal/atomic.h: 没有那个文件或目录.
Missing separate debuginfos, use: debuginfo-install proxysql-2.0.8-1.x86_64
(gdb) bt
#0 atomic_load_p (mo=atomic_memory_order_relaxed, a=0x0) at include/jemalloc/internal/atomic.h:62
#1 rtree_leaf_elm_bits_read (tsdn=, rtree=, dependent=true, elm=0x0) at include/jemalloc/internal/rtree.h:175
#2 rtree_szind_slab_read (r_slab=, r_szind=, dependent=true, key=17951355467682807808, rtree_ctx=0x7ff8fbd7da80, rtree=, tsdn=0x7ff8fbd7da50)
at include/jemalloc/internal/rtree.h:500
#3 ifree (slow_path=false, tcache=0x7ff8fbd7dc40, ptr=0xf92006b000000000, tsd=0x7ff8fbd7da50) at src/jemalloc.c:2490
#4 je_free_default (ptr=0xf92006b000000000) at src/jemalloc.c:2710
#5 0x000000000054ab42 in ~SQLite3_column (this=0x7ff8fe02c351, __in_chrg=) at ../include/sqlite3db.h:115
#6 ~SQLite3_result (this=0x7ff8f9201000, __in_chrg=) at ../include/sqlite3db.h:202
#7 admin_main_loop (arg=0x7ff8fe05e1a0) at ProxySQL_Admin.cpp:3928
#8 0x00007ff8ff7b9ea5 in start_thread () from /lib64/libpthread.so.0
#9 0x00007ff8fe6a098d in clone () from /lib64/libc.so.6

[rahim-kanji]

Hi @bambooHouse,

After trying your reproduction steps we couldn't easily reproduce the issue with a recent ProxySQL version.

In order to investigate further we require the data that is specified in the issue template, since this is crashing bug, this would be:
- [ ] The full ProxySQL error log (default location: /var/lib/proxysql/proxysql.log)
And:
- [ ] The package used to install ProxySQL
- [ ] The compressed proxysql binary
- [ ] The compressed core dump (Note: if you're worried it may contain sensitive data, please contact us for information on sharing it securely: https://proxysql.com/contact-us/)