ProxySQL 3.0.0 crashes when connecting from Metabase or DBeaver

[saadbelgi]

ProxySQL version: 3.0.0-alpha
OS version: Ubuntu 22.04 running inside Docker container
Docker version: 24.0.2

I am running ProxySQL 3.0.0-alpha inside a docker container to proxy connections to a Postgres DB running on version 13.5. When I connect using psql command line client (v14.17) or pgAdmin (v8.14), it connects successfully and works as expected.

When connecting using DBeaver Postgres client (v25.0.0) or Metabase Postgres client (v0.43.5), server crashes with the following error:

proxysql: ../include/PgSQL_Connection.h:253: int PgSQL_Conn_Param::get_param_name(const char*): Assertion `key != -1' failed.
Error: signal 6:
proxysql(_Z13crash_handleri+0x40)[0x5edf55988840]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7c5672e8b520]
/lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x12c)[0x7c5672edf9fc]
/lib/x86_64-linux-gnu/libc.so.6(raise+0x16)[0x7c5672e8b476]
/lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7c5672e717f3]
/lib/x86_64-linux-gnu/libc.so.6(+0x2871b)[0x7c5672e7171b]
/lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7c5672e82e96]
proxysql(_ZN14PgSQL_Protocol20load_conn_parametersEP9pgsql_hdrb+0x1af)[0x5edf55b9936f]
proxysql(_ZN14PgSQL_Protocol22process_startup_packetEPhjRb+0xa0)[0x5edf55b9ac60]
proxysql(_ZN13PgSQL_Session59handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKEEP10_PtrSize_tPb+0x201)[0x5edf55bc6cd1]
proxysql(_ZN13PgSQL_Session20get_pkts_from_clientERbR10_PtrSize_t+0x361)[0x5edf55bc7c31]
proxysql(_ZN13PgSQL_Session7handlerEv+0xd4)[0x5edf55bc9104]
proxysql(_ZN12PgSQL_Thread20process_all_sessionsEv+0x3d6)[0x5edf55bac926]
proxysql(_ZN12PgSQL_Thread3runEv+0x416)[0x5edf55bacfd6]
proxysql(_Z24pgsql_worker_thread_funcPv+0xf1)[0x5edf5595a808]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7c5672eddac3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7c5672f6ea04]
---- proxysql(_Z13crash_handleri+0x40) [0x5edf55988840] : crash_handler(int)
---- proxysql(_ZN14PgSQL_Protocol20load_conn_parametersEP9pgsql_hdrb+0x1af) [0x5edf55b9936f] : PgSQL_Protocol::load_conn_parameters(pgsql_hdr*, bool)
---- proxysql(_ZN14PgSQL_Protocol22process_startup_packetEPhjRb+0xa0) [0x5edf55b9ac60] : PgSQL_Protocol::process_startup_packet(unsigned char*, unsigned int, bool&)
---- proxysql(_ZN13PgSQL_Session59handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKEEP10_PtrSize_tPb+0x201) [0x5edf55bc6cd1] : PgSQL_Session::handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(_PtrSize_t*, bool*)
---- proxysql(_ZN13PgSQL_Session20get_pkts_from_clientERbR10_PtrSize_t+0x361) [0x5edf55bc7c31] : PgSQL_Session::get_pkts_from_client(bool&, _PtrSize_t&)
---- proxysql(_ZN13PgSQL_Session7handlerEv+0xd4) [0x5edf55bc9104] : PgSQL_Session::handler()
---- proxysql(_ZN12PgSQL_Thread20process_all_sessionsEv+0x3d6) [0x5edf55bac926] : PgSQL_Thread::process_all_sessions()
---- proxysql(_ZN12PgSQL_Thread3runEv+0x416) [0x5edf55bacfd6] : PgSQL_Thread::run()
---- proxysql(_Z24pgsql_worker_thread_funcPv+0xf1) [0x5edf5595a808] : pgsql_worker_thread_func(void*)
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+0x40)[0x5edf55988840]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7c5672e8b520]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x178)[0x7c5672e71898]
/lib/x86_64-linux-gnu/libc.so.6(+0x2871b)[0x7c5672e7171b]
/lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7c5672e82e96]
proxysql(_ZN14PgSQL_Protocol20load_conn_parametersEP9pgsql_hdrb+0x1af)[0x5edf55b9936f]
proxysql(_ZN14PgSQL_Protocol22process_startup_packetEPhjRb+0xa0)[0x5edf55b9ac60]
proxysql(_ZN13PgSQL_Session59handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKEEP10_PtrSize_tPb+0x201)[0x5edf55bc6cd1]
proxysql(_ZN13PgSQL_Session20get_pkts_from_clientERbR10_PtrSize_t+0x361)[0x5edf55bc7c31]
proxysql(_ZN13PgSQL_Session7handlerEv+0xd4)[0x5edf55bc9104]
proxysql(_ZN12PgSQL_Thread20process_all_sessionsEv+0x3d6)[0x5edf55bac926]
proxysql(_ZN12PgSQL_Thread3runEv+0x416)[0x5edf55bacfd6]
proxysql(_Z24pgsql_worker_thread_funcPv+0xf1)[0x5edf5595a808]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7c5672eddac3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7c5672f6ea04]
---- proxysql(_Z13crash_handleri+0x40) [0x5edf55988840] : crash_handler(int)
---- proxysql(_ZN14PgSQL_Protocol20load_conn_parametersEP9pgsql_hdrb+0x1af) [0x5edf55b9936f] : PgSQL_Protocol::load_conn_parameters(pgsql_hdr*, bool)
---- proxysql(_ZN14PgSQL_Protocol22process_startup_packetEPhjRb+0xa0) [0x5edf55b9ac60] : PgSQL_Protocol::process_startup_packet(unsigned char*, unsigned int, bool&)
---- proxysql(_ZN13PgSQL_Session59handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKEEP10_PtrSize_tPb+0x201) [0x5edf55bc6cd1] : PgSQL_Session::handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(_PtrSize_t*, bool*)
---- proxysql(_ZN13PgSQL_Session20get_pkts_from_clientERbR10_PtrSize_t+0x361) [0x5edf55bc7c31] : PgSQL_Session::get_pkts_from_client(bool&, _PtrSize_t&)
---- proxysql(_ZN13PgSQL_Session7handlerEv+0xd4) [0x5edf55bc9104] : PgSQL_Session::handler()
---- proxysql(_ZN12PgSQL_Thread20process_all_sessionsEv+0x3d6) [0x5edf55bac926] : PgSQL_Thread::process_all_sessions()
---- proxysql(_ZN12PgSQL_Thread3runEv+0x416) [0x5edf55bacfd6] : PgSQL_Thread::run()
---- proxysql(_Z24pgsql_worker_thread_funcPv+0xf1) [0x5edf5595a808] : pgsql_worker_thread_func(void*)
To report a crashing bug visit: https://github.com/sysown/proxysql/issues
For support visit: https://proxysql.com/services/support/

Steps to reproduce:

1. Add a Postgres DB connection in ProxySQL v3.0.0
2. Connect to this DB via ProxySQL using DBeaver or Metabase

Since this a crashing bug:

• The package used to install ProxySQL: v3.0.0-alpha/proxysql_3.0.0-ubuntu22_amd64.deb
• The compressed proxysql binary (compressed using tar -czvf proxysql_binary.tar.gz <proxysql_binary>): proxysql_binary.tar.gz
• The compressed core dump: proxysql_core_dump.tar.gz