[SR-Users] In acc for 5xx calls result in "Unknown column 'time_attr' in 'field list'"

[Daniel-Constantin Mierla]

Hello,

hmm, quite interesting, if works for everything but 5xx. Does it happen
for each 5xx, or just from time to time?

Can you enable query log in mysql and see what query is sent to the server?

Also, in case you record missed calls, be sure you have the columns in
missed_calls table.

Cheers,
Daniel

On 10/04/15 02:05, Ethan Brooks wrote:
> 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.
>
> *config*
> modparam("acc", "time_mode", 1);
> modparam("acc", "failed_transaction_flag", 3)
>
>
> *syslog*
> 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'
> 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
> 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
>
> *Database Fields:*
>   `time_attr` int(11) DEFAULT NULL,
>   `time_exten` int(11) DEFAULT NULL,
>
> *kamailio -v*
> version: kamailio 4.2.3 (x86_64/linux)
> 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
> ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
> MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
> poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
> id: unknown
> compiled on 12:08:27 Feb 16 2015 with gcc 4.9.1
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150410/391d457b/attachment.html>