was there a restore or anything involved with this system? If there is a dup key it could be removed manually. Finding out how it happened would be a good idea first though.
On Tue, Jun 5, 2012 at 9:24 AM, Michael Picher <[email protected]> wrote: > is it a call-id that is duplicated or is the database key messed up? i > couldn't quite tell from the error... i assumed it was a database key and > not the call-id. > > > On Tue, Jun 5, 2012 at 8:51 AM, Henry Dogger <[email protected]> wrote: > >> Yeah i suppose, but nothing special is done with call-id…**** >> >> ** ** >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *Tony Graziano >> *Sent:* dinsdag 5 juni 2012 14:16 >> >> *To:* Discussion list for users of sipXecs software >> *Subject:* Re: [sipx-users] loss of connection to database**** >> >> ** ** >> >> 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/ >> > > > > -- > 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/ > -- ~~~~~~~~~~~~~~~~~~ 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/
