No no remote connections or users logged in to run reports. Restarted call resolver using sipxproc, but still the errors keep being logged.
I also checked the postgres log, which reports: ERROR: duplicate key violates unique constraint "cdrs_call_id_unique" ERROR: duplicate key violates unique constraint "cdrs_call_id_unique" ERROR: duplicate key violates unique constraint "cdrs_call_id_unique" It is completely filled with these lines... From: [email protected] [mailto:[email protected]] On Behalf Of Tony Graziano Sent: dinsdag 5 juni 2012 11:49 To: Discussion list for users of sipXecs software Subject: Re: [sipx-users] loss of connection to database Are you using anything to connect to postgres remotely to collect cdr records? Are there any users logged in tying to run cdr reports or view Dr records? If you restart service for cdr (call resolver) does the message continue? On Jun 5, 2012 5:23 AM, "Henry Dogger" <[email protected]<mailto:[email protected]>> wrote: Hi all, I posted a question about this a while ago, but no clear answer has come out of it. Now using sipXecs 4.4 latest release, where I get errors: "2012-06-05T09:21:13.754020Z":515:CDR:ERR:server.domain.local:main:00000000:cdr:"Loss of connection to database #<struct DatabaseUrl database=\"SIPXCDR\", port=5433, host=\"localhost\", adapter=\"postgresql\", username=\"postgres\"> - retrying to connect after sleep" It reports about this every 10 seconds, also the process ruby is slowly eating all the cpu time and memory.... Any ideas what this could be? All services are running fine, have restarted sipX and servers multiple times, and also CDR functions are working, but keep getting slower and slower... Kind regards, Henry Dogger Telecats BV _______________________________________________ sipx-users mailing list [email protected]<mailto:[email protected]> List Archive: http://list.sipfoundry.org/archive/sipx-users/ LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected]<mailto:[email protected]> Helpdesk Customers: http://myhelp.myitdepartment.net Blog: http://blog.myitdepartment.net
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
