itpanda2024 created an issue (kamailio/kamailio#4467)
<!--
Kamailio Project uses GitHub Issues only for bugs in the code or feature
requests. Please use this template only for bug reports.
If you have questions about using Kamailio or related to its configuration
file, ask on sr-users mailing list:
*
https://lists.kamailio.org/mailman3/postorius/lists/sr-users.lists.kamailio.org/
If you have questions about developing extensions to Kamailio or its existing C
code, ask on sr-dev mailing list:
*
https://lists.kamailio.org/mailman3/postorius/lists/sr-dev.lists.kamailio.org/
Please try to fill this template as much as possible for any issue. It helps
the developers to troubleshoot the issue.
Note that an issue report may be closed automatically after about 2 months
if there is no interest from developers or community users on pursuing it, being
considered expired. In such case, it can be reopened by writing a comment that
includes
the token `/notexpired`. About two weeks before considered expired, the issue is
marked with the label `stale`, trying to notify the submitter and everyone else
that might be interested in it. To remove the label `stale`, write a comment
that
includes the token `/notstale`. Also, any comment postpone the `expire`
timeline,
being considered that there is interest in pursuing the issue.
If there is no content to be filled in a section, the entire section can be
removed.
You can delete the comments from the template sections when filling.
You can delete next line and everything above before submitting (it is a
comment).
-->
### Description
<!--
We use db_cluster module with configuration below :
loadmodule "db_mysql.so"
modparam("db_mysql", "timeout_interval", 2)
loadmodule "db_cluster.so"
modparam("db_mysql", "timeout_interval", 2)
modparam("db_cluster",
"connection","cfig_db1=>mysql://kamailio:kamailiorw@localhost/kamailio")
modparam("db_cluster",
"connection","cfig_db2=>mysql://kamailio_user:[email protected]/kamailio")
modparam("db_cluster", "cluster", "cfig_db=>cfig_db1=9s8r;cfig_db2=9s8r")
modparam("db_cluster", "inactive_interval", 180)
modparam("db_cluster", "max_query_length", 5)
But we stop db1 . Kamailio fail ,not change to connect db2 and kamailio
service stoped.
-->
### Troubleshooting
#### Reproduction
<!--
Nov 11 09:43:56 kam-02 kamailio[249517]: 391(249517) INFO: db_cluster
[db_cluster_mod.c:192]: dbcl_rpc_list_connections(): read connection [cfig_db2]
Nov 11 09:43:56 kam-02 kamailio[249517]: 391(249517) INFO: db_cluster
[db_cluster_mod.c:192]: dbcl_rpc_list_connections(): read connection [cfig_db1]
Nov 11 09:44:12 kam-02 kamailio[249509]: 387(249509) ERROR: db_mysql
[km_dbase.c:129]: db_mysql_submit_query_impl(): driver error on query: Can't
connect to local server through socket '/var/lib/mysql/mysql.sock' (2) (2002)
Nov 11 09:44:12 kam-02 kamailio[249509]: 387(249509) ERROR: <core>
[db_query.c:335]: db_do_delete(): error while submitting query
Nov 11 09:44:12 kam-02 kernel: kamailio[249509]: segfault at 0 ip
00007f02cb456312 sp 00007fff12a9a3f0 error 4 in
db_cluster.so[12312,7f02cb446000+2f000] likely on CPU 3 (core 0, socket 6)
Nov 11 09:44:12 kam-02 kernel: Code: 84 89 c7 e8 c0 fd fe ff 48 8b 4d a0 8b 45
c0 48 63 f0 8b 45 c4 48 63 d0 48 89 d0 48 c1 e0 03 48 29 d0 48 01 f0 48 8b 44
c1 18 <4c> 8b 38 48 8b 4d a0 8b 45 c0 48 63 f0 8b 45 c4 48 63 d0 48 89 d0
Nov 11 09:44:12 kam-02 systemd-coredump[249541]: Process 249509 (kamailio) of
user 993 terminated abnormally with signal 11/SEGV, processing...
Nov 11 09:44:12 kam-02 systemd[1]: Started [email protected]
- Process Core Dump (PID 249541/UID 0).
Nov 11 09:44:13 kam-02 systemd-coredump[249542]: Process 249509 (kamailio) of
user 993 dumped core.#012#012Module libuuid.so.1 from rpm
util-linux-2.40.2-10.el10.x86_64#012Module libpcre2-8.so.0 from rpm
pcre2-10.44-1.0.1.el10.3.x86_64#012Module libcrypt.so.2 from rpm
libxcrypt-4.4.36-10.el10.x86_64#012Module libselinux.so.1 from rpm
libselinux-3.8-2.el10_0.x86_64#012Module libbrotlicommon.so.1 from rpm
brotli-1.1.0-6.el10.x86_64#012Module libsasl2.so.3 from rpm
cyrus-sasl-2.1.28-27.el10.x86_64#012Module libevent-2.1.so.7 from rpm
libevent-2.1.12-16.el10.x86_64#012Module libkeyutils.so.1 from rpm
keyutils-1.6.3-5.el10.x86_64#012Module libkrb5support.so.0 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64#012Module libcom_err.so.2 from rpm
e2fsprogs-1.47.1-3.el10.x86_64#012Module libk5crypto.so.3 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64#012Module libkrb5.so.3 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64#012Module libunistring.so.5 from rpm
libunistring-1.1-10.el10.x86_64#012Module libz.so.1 from rpm
zlib-ng-2.2.3-1.el10.x86_64#012Module libbrotlidec.so.1 from rpm
brotli-1.1.0-6.el10.x86_64#012Module libgssapi_krb5.so.2 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64#012Module libcrypto.so.3 from rpm
openssl-3.2.2-16.0.1.el10_0.4.x86_64#012Module libssl.so.3 from rpm
openssl-3.2.2-16.0.1.el10_0.4.x86_64#012Module libpsl.so.5 from rpm
libpsl-0.21.5-6.el10.x86_64#012Module libssh.so.4 from rpm
libssh-0.11.1-4.el10_0.x86_64#012Module libidn2.so.0 from rpm
libidn2-2.3.7-3.el10.x86_64#012Module libnghttp2.so.14 from rpm
nghttp2-1.64.0-2.el10.x86_64#012Module libcurl.so.4 from rpm
curl-8.9.1-5.el10.x86_64#012Module libcap.so.2 from rpm
libcap-2.69-7.el10.x86_64#012Module libnss_myhostname.so.2 from rpm
systemd-257-9.0.1.el10_0.1.x86_64#012Stack trace of thread 249509:#012#0
0x00007f02cb456312 db_cluster_delete (db_cluster.so + 0x12312)#012#1
0x00007f02cb3b461d tps_db_clean_branches (topos.so + 0x2e61d)#012#2
0x00007f02cb3cae2f tps_storage_clean (topos.so + 0x44e2f)#012#3
0x00000000006dd64f sr_wtimer_exec (/usr/local/sbin/kamailio + 0x2dd64f)#012#4
0x00000000006dc71d fork_sync_timer (/usr/local/sbin/kamailio + 0x2dc71d)#012#5
0x00000000006dd9c3 sr_wtimer_start (/usr/local/sbin/kamailio + 0x2dd9c3)#012#6
0x000000000042eea0 main_loop (/usr/local/sbin/kamailio + 0x2eea0)#012#7
0x000000000043902c main (/usr/local/sbin/kamailio + 0x3902c)#012#8
0x00007f02f04f230e __libc_start_call_main (libc.so.6 + 0x2a30e)#012#9
0x00007f02f04f23c9 __libc_start_main@@GLIBC_2.34 (libc.so.6 + 0x2a3c9)#012#10
0x000000000041dc65 _start (/usr/local/sbin/kamailio + 0x1dc65)#012ELF object
binary architecture: AMD x86-64
-->
#### Debugging Data
<!--
If you got a core dump, use gdb to extract troubleshooting data - full
backtrace,
local variables and the list of the code at the issue location.
gdb /path/to/kamailio /path/to/corefile
bt full
info locals
list
If you are familiar with gdb, feel free to attach more of what you consider to
be relevant.
Module libuuid.so.1 from rpm util-linux-2.40.2-10.el10.x86_64
Module libpcre2-8.so.0 from rpm pcre2-10.44-1.0.1.el10.3.x86_64
Module libcrypt.so.2 from rpm libxcrypt-4.4.36-10.el10.x86_64
Module libselinux.so.1 from rpm libselinux-3.8-2.el10_0.x86_64
Module libbrotlicommon.so.1 from rpm brotli-1.1.0-6.el10.x86_64
Module libsasl2.so.3 from rpm cyrus-sasl-2.1.28-27.el10.x86_64
Module libevent-2.1.so.7 from rpm libevent-2.1.12-16.el10.x86_64
Module libkeyutils.so.1 from rpm keyutils-1.6.3-5.el10.x86_64
Module libkrb5support.so.0 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64
Module libcom_err.so.2 from rpm e2fsprogs-1.47.1-3.el10.x86_64
Module libk5crypto.so.3 from rpm krb5-1.21.3-8.0.1.el10_0.x86_64
Module libkrb5.so.3 from rpm krb5-1.21.3-8.0.1.el10_0.x86_64
Module libunistring.so.5 from rpm
libunistring-1.1-10.el10.x86_64
Module libz.so.1 from rpm zlib-ng-2.2.3-1.el10.x86_64
Module libbrotlidec.so.1 from rpm brotli-1.1.0-6.el10.x86_64
Module libgssapi_krb5.so.2 from rpm
krb5-1.21.3-8.0.1.el10_0.x86_64
Module libcrypto.so.3 from rpm
openssl-3.2.2-16.0.1.el10_0.4.x86_64
Module libssl.so.3 from rpm openssl-3.2.2-16.0.1.el10_0.4.x86_64
Module libpsl.so.5 from rpm libpsl-0.21.5-6.el10.x86_64
Module libssh.so.4 from rpm libssh-0.11.1-4.el10_0.x86_64
Module libidn2.so.0 from rpm libidn2-2.3.7-3.el10.x86_64
Module libnghttp2.so.14 from rpm nghttp2-1.64.0-2.el10.x86_64
Module libcurl.so.4 from rpm curl-8.9.1-5.el10.x86_64
Module libcap.so.2 from rpm libcap-2.69-7.el10.x86_64
Module libnss_myhostname.so.2 from rpm
systemd-257-9.0.1.el10_0.1.x86_64
Stack trace of thread 250950:
#0 0x00007feac2913312 db_cluster_delete (db_cluster.so +
0x12312)
#1 0x00007feac287161d tps_db_clean_branches (topos.so +
0x2e61d)
#2 0x00007feac2887e2f tps_storage_clean (topos.so + 0x44e2f)
#3 0x00000000006dd64f sr_wtimer_exec (/usr/local/sbin/kamailio
+ 0x2dd64f)
#4 0x00000000006dc71d fork_sync_timer
(/usr/local/sbin/kamailio + 0x2dc71d)
#5 0x00000000006dd9c3 sr_wtimer_start
(/usr/local/sbin/kamailio + 0x2dd9c3)
#6 0x000000000042eea0 main_loop (/usr/local/sbin/kamailio +
0x2eea0)
#7 0x000000000043902c main (/usr/local/sbin/kamailio + 0x3902c)
#8 0x00007feae79ac30e __libc_start_call_main (libc.so.6 +
0x2a30e)
#9 0x00007feae79ac3c9 __libc_start_main@@GLIBC_2.34 (libc.so.6
+ 0x2a3c9)
#10 0x000000000041dc65 _start (/usr/local/sbin/kamailio +
0x1dc65)
ELF object binary architecture: AMD x86-64
-->
```
(paste your debugging data here)
```
#### Log Messages
<!--
Check the syslog file and if there are relevant log messages printed by
Kamailio, add them next, or attach to issue, or provide a link to download them
(e.g., to a pastebin site).
-->
```
(paste your log messages here)
```
#### SIP Traffic
<!--
If the issue is exposed by processing specific SIP messages, grab them with
ngrep or save in a pcap file, then add them next, or attach to issue, or
provide a link to download them (e.g., to a pastebin site).
-->
```
(paste your sip traffic here)
```
### Possible Solutions
<!--
If you found a solution or workaround for the issue, describe it. Ideally,
provide a pull request with a fix.
-->
### Additional Information
* **Kamailio Version** - output of `kamailio -v`
```
(paste your output here)
```
* **Operating System**:
<!--
Details about the operating system, the type: Linux (e.g.,: Debian 8.4, Ubuntu
16.04, CentOS 7.1, ...), MacOS, xBSD, Solaris, ...;
Kernel details (output of `lsb_release -a` and `uname -a`)
-->
```
(paste your output here)
```
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/4467
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/[email protected]>_______________________________________________
Kamailio - Development Mailing List -- [email protected]
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the
sender!
