New subject: In acc for 5xx calls result in "Unknown column 'time_attr' in 'field list'"

9 Apr 2015

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