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

[Ethan Brooks]

Hey thanks the issue was that the columns where not in the missed calls
table.

Best Regards,
Ethan Brooks

On Fri, Apr 10, 2015 at 2:53 AM, Daniel-Constantin Mierla <miconda at gmail.com
> wrote:

>  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 listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://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/4856ee01/attachment.html>