Wow. Sounds like there is a problem there. Not one I have seen though. I guess you need to find out why there is more than 1 call with the same call id.
On Tue, Jun 5, 2012 at 6:37 AM, Henry Dogger <[email protected]> wrote: > 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]> 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] > List Archive: http://list.sipfoundry.org/archive/sipx-users/**** > > ** ** > > LAN/Telephony/Security and Control Systems Helpdesk:**** > > Telephone: 434.984.8426**** > > sip: [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/ > -- ~~~~~~~~~~~~~~~~~~ Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.465.6833 ~~~~~~~~~~~~~~~~~~ Linked-In Profile: http://www.linkedin.com/pub/tony-graziano/14/4a6/7a4 Ask about our Internet Fax services! ~~~~~~~~~~~~~~~~~~ -- LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [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/
