I'm having a problem with 3CX's postgresql database. I have been fetching phonecalls from the database on a nightly basis for several months now, for reporting purposes. However, recently the database has stopped recording call history entries when the duration is greater than 0 and it only saves a handful of recordings where the duration is greater than 0. Additionally, the timestamps are 4 days in the past.
Finally, the CallHistoryService process is continually maxing out one of the CPUs and I am unable to restart the service - it hangs at "stopping" via the Services status tab.
Our dataset is quite old. We field several hundred calls per day and we have calls going back to 2012.
Has anyone seen similar problems with the Call History Service? Any fixes or solutions?
CallHistoryService.log file snippet:
Finally, the CallHistoryService process is continually maxing out one of the CPUs and I am unable to restart the service - it hangs at "stopping" via the Services status tab.
Our dataset is quite old. We field several hundred calls per day and we have calls going back to 2012.
Has anyone seen similar problems with the Call History Service? Any fixes or solutions?
CallHistoryService.log file snippet:
Code:
2015/06/30 06:57:33.717|0008|Info(03)| select max(idcallhistory3) from callhistory3;
2015/06/30 06:57:33.719|0008|Info(03)| insert into callhistory3 (idcallhistory3, callid, duration, starttime,answertime,endtime, from_no, to_no, group_no, line_no, caller_display_name, is_answ, is_fail, is_compl, is_fromoutside, CallerID, DialedNumber, lastCallerID, lastDialedNumber, mediaType, rate, totalcost, billprefix, BillRateName, GrpAnswDetail, recfile, callchain)values (15805225,'00000BE562579C70_102750','00:00:00','2015/6/26 8:48:45 PM',null,'2015/6/26 8:48:45 PM','5038','8491','5038','','NBS Rollover:',False,False,True,False,'12128871134','8491','12128871134','8491',1,0,0,'','','-1','',E';5038;12128871134;8491;' );
2015/06/30 06:57:33.728|0008|Info(03)| insert into CallDetails (IdCallHistory2, DetailNum, ParentDetailNum, Dest_num, StartTime,Dur, AnswerTime, Status, Is_Compl, SpecDstType, is_tooutside, dest_dn, OtherParty,BillPrefix, BillRateName, BillRate, BillCost) values (15805225,1,0,'8491','2015/6/26 8:48:45 PM','00:00:00.2060000',null,5,True,0,False,'8491','5038','','','0','0' );
2015/06/30 06:57:33.734|0008|Info(03)| select * from myphone_parsecall(15805225, interval '0 minutes')
2015/06/30 06:57:39.844|0008|Info(03)| select max(idcallhistory3) from callhistory3;
2015/06/30 06:57:39.845|0008|Info(03)| insert into callhistory3 (idcallhistory3, callid, duration, starttime,answertime,endtime, from_no, to_no, group_no, line_no, caller_display_name, is_answ, is_fail, is_compl, is_fromoutside, CallerID, DialedNumber, lastCallerID, lastDialedNumber, mediaType, rate, totalcost, billprefix, BillRateName, GrpAnswDetail, recfile, callchain)values (15805226,'00000BE562579E12_102751','00:00:00','2015/6/26 8:48:45 PM',null,'2015/6/26 8:48:45 PM','5038','8522','5038','','NBS Rollover:',False,False,True,False,'12128871134','8522','12128871134','8522',1,0,0,'','','-1','',E';5038;12128871134;8522;' );
