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@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