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

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