[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