Hello Everyone, can anyone suggest about share issue?
Waiting for reply. Thanks On Thu, Jan 28, 2021 at 7:01 PM M Arqum CH <[email protected]> wrote: > Hello Members, > > Kamailio acc module is not inserting cdr into MySQL DB, sometimes it works > and sometimes didn't, the number of parameters/values are similar in failed > as well success scenario. I also check with tcpdump for MySQL requests, > unfortunately, Kamailio didn't issue insert query toward DB server, so it > is clear to me that the MySQL server is nothing to do with failed queries. > > Please guide me on what I should do to find and fix the issue. > > Kamailio Installed version : > kamailio -v > version: kamailio 5.4.1 (x86_64/linux) 2ca223 > flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, > DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, > F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, > USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, > HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED > ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, > BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB > poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. > id: 2ca223 > compiled on 12:51:24 Sep 21 2020 with gcc 6.3.0 > > > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_logic.c:691]: tmcb_func(): acc callback called for t(0x7fe29b2a7870) > event type 512, reply code 200 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_logic.c:413]: should_acc_reply(): probing acc state - code: 200 flags: > 0x6 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_logic.c:446]: should_acc_reply(): acc is on > > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 0 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 1 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 2 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 4 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 5 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 6 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 7 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 8 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 9 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 10 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 11 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 12 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 13 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 16 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 17 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 19 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 20 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 22 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 26 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 28 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 29 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 32 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 6, index i 33 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: tm > [t_hooks.c:256]: run_trans_callbacks_internal(): DBG: trans=0x7fe29b2a7870, > callback type 512, id 0 entered > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 0 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 1 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 2 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 3 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 4 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 5 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 8 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 9 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 11 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 12 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 14 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 18 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 20 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 21 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 24 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 25 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: ERROR: acc > [acc_cdr.c:267]: db_write_cdr(): failed to insert into database > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 0 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 1 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 2 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 3 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 4 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 5 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 8 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 9 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 11 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 12 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 14 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 18 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 20 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 21 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 24 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: acc > [acc_extra.h:63]: free_strar_mem(): Freeing memory, type is 2, > message_index 3, index i 25 > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: ERROR: acc > [acc_cdr.c:682]: cdr_on_end_confirmed(): failed to write cdr! > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]: DEBUG: tm > [t_reply.c:1758]: cleanup_uac_timers(): RETR/FR timers reset > Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103682]: DEBUG: tm > [timer.c:634]: wait_handler(): finished transaction: 0x7fe29727ba88 > (p:0x7fe294d27288/n:0x7fe294d27288) > > -- > Regards > M Arqum > -- Regards M Arqum
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
