did you try to reindex? not sure if that will help the cdr database....
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/ > -- Michael Picher, Director of Technical Services eZuce, Inc. 300 Brickstone Square**** Suite 201**** Andover, MA. 01810 O.978-296-1005 X2015 M.207-956-0262 @mpicher <http://twitter.com/mpicher> linkedin <http://www.linkedin.com/profile/view?id=35504760&trk=tab_pro> www.ezuce.com ------------------------------------------------------------------------------------------------------------ There are 10 kinds of people in the world, those who understand binary and those who don't.
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
