<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>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?</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 01.02.21 10:27, M Arqum CH wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CACm_yeFtT44OerUeKnh9JisJNbKkTWft4SB84PLQN6AozV1m6Q@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello Everyone, <br>
<br>
can anyone suggest about share issue?
<div><br>
</div>
<div>Waiting for reply.</div>
<div><br>
</div>
<div>Thanks </div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jan 28, 2021 at 7:01
PM M Arqum CH <<a href="mailto:marqumch@gmail.com"
moz-do-not-send="true">marqumch@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>Hello Members,<br>
<br>
</div>
<div>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. </div>
<div><br>
</div>
<div>Please guide me on what I should do to find and fix the
issue. </div>
<div><br>
</div>
<div>Kamailio Installed version :</div>
<div>kamailio -v<br>
version: kamailio 5.4.1 (x86_64/linux) 2ca223<br>
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<br>
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB<br>
poll method support: poll, epoll_lt, epoll_et, sigio_rt,
select.<br>
id: 2ca223 <br>
compiled on 12:51:24 Sep 21 2020 with gcc 6.3.0<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>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<br>
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<br>
Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]:
DEBUG: acc [acc_logic.c:446]: should_acc_reply(): acc is
on<br>
<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]:
ERROR: acc [acc_cdr.c:267]: db_write_cdr(): failed to
insert into database<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 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<br>
Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]:
ERROR: acc [acc_cdr.c:682]: cdr_on_end_confirmed(): failed
to write cdr!<br>
Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103637]:
DEBUG: tm [t_reply.c:1758]: cleanup_uac_timers(): RETR/FR
timers reset<br>
Jan 28 13:38:29 /root/mykamailio/sbin/kamailio[103682]:
DEBUG: tm [timer.c:634]: wait_handler(): finished
transaction: 0x7fe29727ba88
(p:0x7fe294d27288/n:0x7fe294d27288)<br>
</div>
<div><br>
</div>
-- <br>
<div dir="ltr">Regards
<div>M Arqum</div>
</div>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Regards
<div>M Arqum</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</body>
</html>