search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.05k stars 983 forks source link

main.cpp:1494:my_terminate(): [ERROR] ProxySQL crashed due to exception when run proxysql image #4718

Closed csuyangpeng closed 1 month ago

csuyangpeng commented 1 month ago

Run proxysql official docker image pulled from docker hub: 

root@aa6b3fa10fa2:/# proxysql --version
2024-10-15 09:15:00 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
ProxySQL version 2.7.1-16-g2726c27, codename Truls

root@aa6b3fa10fa2:/# proxysql -f --idle-threads -D /var/lib/proxysql
2024-10-15 09:14:43 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
2024-10-15 09:14:43 [INFO] Using config file /etc/proxysql.cnf
2024-10-15 09:14:43 [INFO] Current RLIMIT_NOFILE: 1048576
2024-10-15 09:14:43 [INFO] Using OpenSSL version: OpenSSL 3.3.1 4 Jun 2024
2024-10-15 09:14:43 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-10-15 09:14:43 [INFO] ProxySQL version 2.7.1-16-g2726c27
2024-10-15 09:14:43 [INFO] Detected OS: Linux aa6b3fa10fa2 5.15.0-122-generic #132-Ubuntu SMP Thu Aug 29 13:45:52 UTC 2024 x86_64
2024-10-15 09:14:43 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
2024-10-15 09:14:43 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-10-15 09:14:43 [INFO] Loaded built-in SQLite3
2024-10-15 09:14:43 main.cpp:1494:my_terminate(): [ERROR] ProxySQL crashed due to exception
BACKTRACE ------------
proxysql(_Z12my_terminatev+0x82) [0x55dc4f7ac81f]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e1a) [0x7f9031c6de1a]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85) [0x7f9031c6de85]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8) [0x7f9031c6e0d8]
/lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85) [0x7f9031c655e6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd458d) [0x7f9031c9958d]
proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b) [0x55dc4f80bc5b]
proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7) [0x55dc4f7aa4e0]
proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34) [0x55dc4f7ab8a9]
proxysql(main+0x2a1a) [0x55dc4f7b1e34]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a) [0x7f903190a24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7f903190a305]
proxysql(_start+0x21) [0x55dc4f7a8201]
----------------------
Error: signal 6:
proxysql(_Z13crash_handleri+0x2a)[0x55dc4f7d24ea]
/lib/x86_64-linux-gnu/libc.so.6(+0x3c050)[0x7f903191f050]
/lib/x86_64-linux-gnu/libc.so.6(+0x8ae3c)[0x7f903196de3c]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x12)[0x7f903191efb2]
/lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f9031909472]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0x9d4cb)[0x7f9031c624cb]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85)[0x7f9031c6de85]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8)[0x7f9031c6e0d8]
/lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85)[0x7f9031c655e6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd458d)[0x7f9031c9958d]
proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b)[0x55dc4f80bc5b]
proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7)[0x55dc4f7aa4e0]
proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34)[0x55dc4f7ab8a9]
proxysql(main+0x2a1a)[0x55dc4f7b1e34]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f903190a24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f903190a305]
proxysql(_start+0x21)[0x55dc4f7a8201]
 ---- proxysql(_Z13crash_handleri+0x2a) [0x55dc4f7d24ea] : crash_handler(int)
 ---- /lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85) [0x7f9031c655e6] : std::__throw_system_error(int)
 ---- proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b) [0x55dc4f80bc5b] : MySQL_HostGroups_Manager::init()
 ---- proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7) [0x55dc4f7aa4e0] : ProxySQL_Main_init_main_modules()
 ---- proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34) [0x55dc4f7ab8a9] : ProxySQL_Main_init_phase2___not_started(bootstrap_info_t const&)
To report a crashing bug visit: https://github.com/sysown/proxysql/issues
For support visit: https://proxysql.com/services/support/
Aborted (core dumped)
renecannao commented 1 month ago

Hi @csuyangpeng . Are you manually starting proxysql on a docker container already running proxysql?

csuyangpeng commented 1 month ago

@renecannao No, the container exit because of crash. So i run container with command bash, and try manually starting proxysql. I try two ubuntu servers. Only crash on this server when run docker proxysql. I do the job follow https://hub.docker.com/r/proxysql/proxysql

mirostauder commented 1 month ago

can not reproduce... please provide more details.

# cat /etc/os-release 
PRETTY_NAME="Debian GNU/Linux 12 (bookworm)"
NAME="Debian GNU/Linux"
VERSION_ID="12"
VERSION="12 (bookworm)"
VERSION_CODENAME=bookworm
ID=debian
HOME_URL="https://www.debian.org/"
SUPPORT_URL="https://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"
# docker version
Client: Docker Engine - Community
 Version:           27.3.1
 API version:       1.47
 Go version:        go1.22.7
 Git commit:        ce12230
 Built:             Fri Sep 20 11:41:11 2024
 OS/Arch:           linux/amd64
 Context:           default

Server: Docker Engine - Community
 Engine:
  Version:          27.3.1
  API version:      1.47 (minimum version 1.24)
  Go version:       go1.22.7
  Git commit:       41ca978
  Built:            Fri Sep 20 11:41:11 2024
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.7.22
  GitCommit:        7f7fdf5fed64eb6a7caf99b3e12efcf9d60e311c
 runc:
  Version:          1.1.14
  GitCommit:        v1.1.14-0-g2c9f560
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
# docker run proxysql/proxysql:latest
Unable to find image 'proxysql/proxysql:latest' locally
latest: Pulling from proxysql/proxysql
8cd46d290033: Already exists 
4f4fb700ef54: Already exists 
ca6eaf6fa960: Already exists 
d18c49a246b3: Already exists 
0720b83d038b: Already exists 
98d7c37fa144: Already exists 
4e3c1e1bf7e3: Already exists 
Digest: sha256:cd866337812d98b9df83abeae9f51728f7cd5b1cdd97e788a1200452d9b7e075
Status: Downloaded newer image for proxysql/proxysql:latest
2024-10-15 09:43:06 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
2024-10-15 09:43:06 [INFO] Using config file /etc/proxysql.cnf
2024-10-15 09:43:06 [INFO] Current RLIMIT_NOFILE: 1048576
2024-10-15 09:43:06 [INFO] Using OpenSSL version: OpenSSL 3.3.1 4 Jun 2024
2024-10-15 09:43:06 [INFO] No SSL keys/certificates found in datadir (/var/lib/proxysql). Generating new keys/certificates.
2024-10-15 09:43:07 [INFO] ProxySQL version 2.7.1-16-g2726c27
2024-10-15 09:43:07 [INFO] Detected OS: Linux 0241ae9b753b 6.11.2-x64v3-xanmod1 #0~20241004.g1ebee3e SMP PREEMPT_DYNAMIC Fri Oct  4 19:20:47 UTC x86_64
2024-10-15 09:43:07 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
2024-10-15 09:43:07 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-10-15 09:43:07 [INFO] Loaded built-in SQLite3
Standard ProxySQL MySQL Logger rev. 2.5.0421 -- MySQL_Logger.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:43:07 [INFO] Using UUID: 49fbd28f-fb68-431f-b7f9-d60e360aaf8b , randomly generated. Writing it to database
2024-10-15 09:43:07 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0x6442989A35CF9604', with epoch '1728985387'
2024-10-15 09:43:07 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xC9357E865B8739A0', with epoch '1728985387'
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:43:07 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Sep 20 15:51:19 2024
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:43:07 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0x0000000000000000', with epoch '1728985387'
2024-10-15 09:43:07 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-10-15 09:43:07 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-10-15 09:43:07 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-10-15 09:43:07 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-10-15 09:43:07 [INFO] New mysql_group_replication_hostgroups table
2024-10-15 09:43:07 [INFO] New mysql_galera_hostgroups table
2024-10-15 09:43:07 [INFO] New mysql_aws_aurora_hostgroups table
2024-10-15 09:43:07 [INFO] New mysql_hostgroup_attributes table
2024-10-15 09:43:07 [INFO] New mysql_servers_ssl_params table
2024-10-15 09:43:07 [INFO] Checksum for table mysql_servers_v2 is 0x0000000000000000
2024-10-15 09:43:07 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x0000000000000000'
2024-10-15 09:43:07 [INFO] Checksum for table mysql_servers is 0x0000000000000000
2024-10-15 09:43:07 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-10-15 09:43:07 [INFO] Computed checksum for 'LOAD PROXYSQL SERVERS TO RUNTIME' was '0x0000000000000000', with epoch '1728985387'
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:43:07 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x0000000000000000', with epoch '1728985387'
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Sep 20 15:51:19 2024
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:43:07 [INFO] For information about products and services visit: https://proxysql.com/
2024-10-15 09:43:07 [INFO] For online documentation visit: https://proxysql.com/documentation/
2024-10-15 09:43:07 [INFO] For support visit: https://proxysql.com/services/support/
2024-10-15 09:43:07 [INFO] For consultancy visit: https://proxysql.com/services/consulting/
2024-10-15 09:43:12 [INFO] Latest ProxySQL version available: 2.7.1-16-g2726c27
csuyangpeng commented 1 month ago 
sder@k8s-node1:~/cluster$ cat /etc/os-release
PRETTY_NAME="Ubuntu 22.04.4 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.4 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=jammy
sder@k8s-node1:~/cluster$ docker version
Client: Docker Engine - Community
 Version:           20.10.7
 API version:       1.41
 Go version:        go1.13.15
 Git commit:        f0df350
 Built:             Wed Jun  2 11:56:40 2021
 OS/Arch:           linux/amd64
 Context:           default
 Experimental:      true

Server: Docker Engine - Community
 Engine:
  Version:          20.10.7
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.13.15
  Git commit:       b0f5bc3
  Built:            Wed Jun  2 11:54:48 2021
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.4.8
  GitCommit:        7eba5930496d9bbe375fdf71603e610ad737d2b2
 runc:
  Version:          1.0.0
  GitCommit:        v1.0.0-0-g84113ee
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
sder@k8s-node1:~/cluster$ docker run proxysql/proxysql:latest
2024-10-15 09:54:28 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
2024-10-15 09:54:28 [INFO] Using config file /etc/proxysql.cnf
2024-10-15 09:54:28 [INFO] Current RLIMIT_NOFILE: 1048576
2024-10-15 09:54:28 [INFO] Using OpenSSL version: OpenSSL 3.3.1 4 Jun 2024
2024-10-15 09:54:28 [INFO] No SSL keys/certificates found in datadir (/var/lib/proxysql). Generating new keys/certificates.
2024-10-15 09:54:29 [INFO] ProxySQL version 2.7.1-16-g2726c27
2024-10-15 09:54:29 [INFO] Detected OS: Linux 7ca17cdd6907 5.15.0-122-generic #132-Ubuntu SMP Thu Aug 29 13:45:52 UTC 2024 x86_64
2024-10-15 09:54:29 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
2024-10-15 09:54:29 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-10-15 09:54:29 [INFO] Loaded built-in SQLite3
2024-10-15 09:54:29 main.cpp:1494:my_terminate(): [ERROR] ProxySQL crashed due to exception
BACKTRACE ------------
proxysql(_Z12my_terminatev+0x82) [0x55af2d2c581f]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e1a) [0x7f2796c4de1a]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85) [0x7f2796c4de85]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8) [0x7f2796c4e0d8]
/lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85) [0x7f2796c455e6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd458d) [0x7f2796c7958d]
proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b) [0x55af2d324c5b]
proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7) [0x55af2d2c34e0]
proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34) [0x55af2d2c48a9]
proxysql(main+0x2a1a) [0x55af2d2cae34]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a) [0x7f27968ea24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7f27968ea305]
proxysql(_start+0x21) [0x55af2d2c1201]
----------------------
Error: signal 6:
proxysql(_Z13crash_handleri+0x2a)[0x55af2d2eb4ea]
/lib/x86_64-linux-gnu/libc.so.6(+0x3c050)[0x7f27968ff050]
/lib/x86_64-linux-gnu/libc.so.6(+0x8ae3c)[0x7f279694de3c]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x12)[0x7f27968fefb2]
/lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f27968e9472]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0x9d4cb)[0x7f2796c424cb]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85)[0x7f2796c4de85]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8)[0x7f2796c4e0d8]
/lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85)[0x7f2796c455e6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd458d)[0x7f2796c7958d]
proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b)[0x55af2d324c5b]
proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7)[0x55af2d2c34e0]
proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34)[0x55af2d2c48a9]
proxysql(main+0x2a1a)[0x55af2d2cae34]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f27968ea24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f27968ea305]
proxysql(_start+0x21)[0x55af2d2c1201]
 ---- proxysql(_Z13crash_handleri+0x2a) [0x55af2d2eb4ea] : crash_handler(int)
 ---- /lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85) [0x7f2796c455e6] : std::__throw_system_error(int)
 ---- proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b) [0x55af2d324c5b] : MySQL_HostGroups_Manager::init()
 ---- proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7) [0x55af2d2c34e0] : ProxySQL_Main_init_main_modules()
 ---- proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34) [0x55af2d2c48a9] : ProxySQL_Main_init_phase2___not_started(bootstrap_info_t const&)
To report a crashing bug visit: https://github.com/sysown/proxysql/issues
For support visit: https://proxysql.com/services/support/
Error: signal 11:
proxysql(_Z13crash_handleri+0x2a)[0x55af2d2eb4ea]
/lib/x86_64-linux-gnu/libc.so.6(+0x3c050)[0x7f27968ff050]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x170)[0x7f27968e950f]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0x9d4cb)[0x7f2796c424cb]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85)[0x7f2796c4de85]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8)[0x7f2796c4e0d8]
/lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85)[0x7f2796c455e6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd458d)[0x7f2796c7958d]
proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b)[0x55af2d324c5b]
proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7)[0x55af2d2c34e0]
proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34)[0x55af2d2c48a9]
proxysql(main+0x2a1a)[0x55af2d2cae34]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f27968ea24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f27968ea305]
proxysql(_start+0x21)[0x55af2d2c1201]
 ---- proxysql(_Z13crash_handleri+0x2a) [0x55af2d2eb4ea] : crash_handler(int)
 ---- /lib/x86_64-linux-gnu/libstdc++.so.6(_ZSt20__throw_system_errori+0x85) [0x7f2796c455e6] : std::__throw_system_error(int)
 ---- proxysql(_ZN24MySQL_HostGroups_Manager4initEv+0x5b) [0x55af2d324c5b] : MySQL_HostGroups_Manager::init()
 ---- proxysql(_Z31ProxySQL_Main_init_main_modulesv+0xd7) [0x55af2d2c34e0] : ProxySQL_Main_init_main_modules()
 ---- proxysql(_Z39ProxySQL_Main_init_phase2___not_startedRK16bootstrap_info_t+0x34) [0x55af2d2c48a9] : ProxySQL_Main_init_phase2___not_started(bootstrap_info_t const&)
To report a crashing bug visit: https://github.com/sysown/proxysql/issues
For support visit: https://proxysql.com/services/support/
csuyangpeng commented 1 month ago

@mirostauder Yes, I do this on three ubuntu 22.04. This is another ubuntu log. I have do the basic check and cannot find the reason. Any other information need?

sder@k8s-181:~/cluster$ cat /etc/os-release
PRETTY_NAME="Ubuntu 22.04.4 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.4 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=jammy
sder@k8s-181:~/cluster$ docker version
Client: Docker Engine - Community
 Version:           24.0.2
 API version:       1.43
 Go version:        go1.20.4
 Git commit:        cb74dfc
 Built:             Thu May 25 21:52:13 2023
 OS/Arch:           linux/amd64
 Context:           default

Server: Docker Engine - Community
 Engine:
  Version:          24.0.2
  API version:      1.43 (minimum version 1.12)
  Go version:       go1.20.4
  Git commit:       659604f
  Built:            Thu May 25 21:52:13 2023
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.6.21
  GitCommit:        3dce8eb055cbb6872793272b4f20ed16117344f8
 runc:
  Version:          1.1.7
  GitCommit:        v1.1.7-0-g860f061
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
sder@k8s-181:~/cluster$ docker run proxysql/proxysql:latest
2024-10-15 09:58:33 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
2024-10-15 09:58:33 [INFO] Using config file /etc/proxysql.cnf
2024-10-15 09:58:33 [INFO] Current RLIMIT_NOFILE: 1048576
2024-10-15 09:58:33 [INFO] Using OpenSSL version: OpenSSL 3.3.1 4 Jun 2024
2024-10-15 09:58:33 [INFO] No SSL keys/certificates found in datadir (/var/lib/proxysql). Generating new keys/certificates.
2024-10-15 09:58:33 [INFO] ProxySQL version 2.7.1-16-g2726c27
2024-10-15 09:58:33 [INFO] Detected OS: Linux 0805ad3133fe 5.15.0-122-generic #132-Ubuntu SMP Thu Aug 29 13:45:52 UTC 2024 x86_64
2024-10-15 09:58:33 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
2024-10-15 09:58:33 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-10-15 09:58:33 [INFO] Loaded built-in SQLite3
Standard ProxySQL MySQL Logger rev. 2.5.0421 -- MySQL_Logger.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:58:34 [INFO] Using UUID: 10f3f7d0-0ced-4f83-a014-2960b42717c0 , randomly generated. Writing it to database
2024-10-15 09:58:34 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0x6442989A35CF9604', with epoch '1728986314'
2024-10-15 09:58:34 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xC9357E865B8739A0', with epoch '1728986314'
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:58:34 [INFO] ProxySQL SHA1 checksum: b707c29266a569f8cf279e1448dbeed31d980e96
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Sep 20 15:51:19 2024
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:58:34 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0x0000000000000000', with epoch '1728986314'
2024-10-15 09:58:34 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-10-15 09:58:34 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-10-15 09:58:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-10-15 09:58:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-10-15 09:58:34 [INFO] New mysql_group_replication_hostgroups table
2024-10-15 09:58:34 [INFO] New mysql_galera_hostgroups table
2024-10-15 09:58:34 [INFO] New mysql_aws_aurora_hostgroups table
2024-10-15 09:58:34 [INFO] New mysql_hostgroup_attributes table
2024-10-15 09:58:34 [INFO] New mysql_servers_ssl_params table
2024-10-15 09:58:34 [INFO] Checksum for table mysql_servers_v2 is 0x0000000000000000
2024-10-15 09:58:34 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x0000000000000000'
2024-10-15 09:58:34 [INFO] Checksum for table mysql_servers is 0x0000000000000000
2024-10-15 09:58:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 3ms
2024-10-15 09:58:34 [INFO] Computed checksum for 'LOAD PROXYSQL SERVERS TO RUNTIME' was '0x0000000000000000', with epoch '1728986314'
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:58:34 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x0000000000000000', with epoch '1728986314'
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Sep 20 15:51:19 2024
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Fri Sep 20 15:51:19 2024
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Sep 20 15:51:19 2024
2024-10-15 09:58:34 [INFO] For information about products and services visit: https://proxysql.com/
2024-10-15 09:58:34 [INFO] For online documentation visit: https://proxysql.com/documentation/
2024-10-15 09:58:34 [INFO] For support visit: https://proxysql.com/services/support/
2024-10-15 09:58:34 [INFO] For consultancy visit: https://proxysql.com/services/consulting/
2024-10-15 09:58:38 [INFO] Latest ProxySQL version available: 2.7.1-16-g2726c27
mirostauder commented 1 month ago

This is not a ProxySQL bug, please make sure your environment is up-to-date. I see a very old version of docker engine on the machine where it crashes... Version: 20.10.7

csuyangpeng commented 1 month ago

@mirostauder Fix my problem after upgrade docker. Thanks