<div dir="ltr">Hey thanks the issue was that the columns where not in the missed calls table.<div><br></div><div>Best Regards,</div><div>Ethan Brooks</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 10, 2015 at 2:53 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
hmm, quite interesting, if works for everything but 5xx. Does it
happen for each 5xx, or just from time to time?<br>
<br>
Can you enable query log in mysql and see what query is sent to the
server?<br>
<br>
Also, in case you record missed calls, be sure you have the columns
in missed_calls table.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 10/04/15 02:05, Ethan Brooks wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">I am seeing a very strange error saying
that time_attr is an unknown column and the insert is failing.
What is strange is that it is in the acc table and is being
populated for all successful calls. It seem to only happen for
5xx unsuccessful calls and the INVITE is not recorded. 4xx
response are recorded.
<div><br>
</div>
<div><b>config</b></div>
<div>modparam("acc", "time_mode", 1);<br>
</div>
<div>
<div>modparam("acc", "failed_transaction_flag", 3)</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><b>syslog</b></div>
<div>
<div>
<div>
<div>Apr 9 20:40:52 a-deploy-callprocessing3
/usr/sbin/kamailio[9732]: ERROR: db_mysql
[km_dbase.c:123]: db_mysql_submit_query(): driver error
on query: Unknown column 'time_attr' in 'field list'</div>
<div>Apr 9 20:40:52 a-deploy-callprocessing3
/usr/sbin/kamailio[9732]: ERROR: <core>
[db_query.c:235]: db_do_insert_cmd(): error while
submitting query</div>
<div>Apr 9 20:40:52 a-deploy-callprocessing3
/usr/sbin/kamailio[9732]: ERROR: acc [acc.c:504]:
acc_db_request(): failed to insert into database</div>
</div>
</div>
<div><br>
</div>
<div><b>Database Fields:</b></div>
<div>
<div> `time_attr` int(11) DEFAULT NULL,</div>
<div> `time_exten` int(11) DEFAULT NULL,</div>
</div>
<div><br>
</div>
<div><b>kamailio -v</b></div>
<div>
<div>version: kamailio 4.2.3 (x86_64/linux)</div>
<div>flags: STATS: Off, USE_TCP, USE_TLS, TLS_HOOKS,
USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK,
SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, DBG_F_MALLOC,
USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE,
USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST,
HAVE_RESOLV_RES</div>
<div>ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT
PKG_SIZE 8MB</div>
<div>poll method support: poll, epoll_lt, epoll_et,
sigio_rt, select.</div>
<div>id: unknown</div>
<div>compiled on 12:08:27 Feb 16 2015 with gcc 4.9.1</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</font></span></div>
</blockquote></div><br></div>