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

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