[SR-Users] Acc module unable to insert cdr in mysql server

[M Arqum CH]

Hello Everyone,

can anyone suggest about share issue?

Waiting for reply.

Thanks

On Thu, Jan 28, 2021 at 7:01 PM M Arqum CH <marqumch at gmail.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210201/e63e65d2/attachment.htm>