[Users] Duplicate Entry Error

[Bogdan-Andrei Iancu]

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
>>>
>>> 
>>>
>>>      
>>>
>
>  
>