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)