Hello, there should be other log error messages if the db insert fails. Are you sure you did copy&paste of all logs messages printed by kamailio in such case?
Cheers, Daniel On 01.02.21 10:27, M Arqum CH wrote: > 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] > <mailto:[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 -- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
