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

Daniel-Constantin Mierla miconda at gmail.com
Mon Feb 1 13:40:29 CET 2021


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 <marqumch at gmail.com
> <mailto: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
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210201/9d93363c/attachment.htm>


More information about the sr-users mailing list