[Users] Duplicate Entry Error

Douglas Garstang dgarstang at oneeighty.com
Thu Mar 23 20:23:47 CET 2006


Maybe the contact is still in the cache for one openser server, when the phone tries to register to another openser server?
How do I disable usrloc caching?

Thank,
Doug

> -----Original Message-----
> From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro]
> Sent: Thursday, March 23, 2006 11:24 AM
> To: Douglas Garstang
> Cc: users at openser.org
> Subject: Re: [Users] Duplicate Entry Error
> 
> 
> Doug,
> 
> there error is from usrloc module - a contact for same user 
> is inserted 
> twice. I guess you are using cached usrloc.
> Even if in theory what you are saying seams right, the practice shows 
> something else - more than one servers trying to add the same 
> contact. 
> Check you configuration and do some network trace to see where the 
> problem is.
> 
> regards,
> bogdan
> 
> Douglas Garstang wrote:
> 
> >Bogdan,
> >
> >Sure... here's everything that appears related... Don't see 
> anything about a module tho
> >
> >Mar 23 10:05:27 artemis openser[11950]: submit_query: 
> Duplicate entry '80014157--sip:80014157 at xxx.187.128.104' for 
> key 'PRIMARY' 
> >Mar 23 10:05:27 artemis openser[11950]: db_insert: Error 
> while submitting query 
> >Mar 23 10:05:27 artemis openser[11950]: 
> db_insert_ucontact(): Error while inserting contact 
> >Mar 23 10:05:27 artemis openser[11950]: wb_timer: Error 
> while inserting contact into database 
> >
> >We have three different OpenSER systems all pointed to a 
> single MySQL database. It may be too late to ask now, but is 
> that supported? Only one OpenSER system should be accepting 
> registrations from a single phone at a time, and therefore 
> only one OpenSER system should be updating the location table 
> for a specific phone at a time. Correct?
> >
> >Doug.
> >
> >  
> >
> >>-----Original Message-----
> >>From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro]
> >>Sent: Thursday, March 23, 2006 4:14 AM
> >>To: Douglas Garstang
> >>Cc: users at openser.org
> >>Subject: Re: [Users] Duplicate Entry Error
> >>
> >>
> >>Hi Doug,
> >>
> >>do you have any previous or next related err messaged - it's 
> >>important 
> >>to find out the module that generates the query and the context.
> >>
> >>regards,
> >>bogdan
> >>
> >>Douglas Garstang wrote:
> >>
> >>    
> >>
> >>>Can someone tell me what this means?
> >>>
> >>>Mar 22 09:54:21 apollo openser[6562]: submit_query: 
> >>>      
> >>>
> >>Duplicate entry '2944053--sip:2944053 at xxx.187.128.81' for key 
> >>'PRIMARY'
> >>    
> >>
> >>>It doesn't look good.
> >>>
> >>>Doug.
> >>>
> >>>_______________________________________________
> >>>Users mailing list
> >>>Users at openser.org
> >>>http://openser.org/cgi-bin/mailman/listinfo/users
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >
> >  
> >
> 
> 




More information about the Users mailing list