24 Mar
2006
24 Mar
'06
5:24 a.m.
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@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@voice-system.ro]
Sent: Thursday, March 23, 2006 4:14 AM
To: Douglas Garstang
Cc: users(a)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@xxx.187.128.81' for key
'PRIMARY'
>It doesn't look good.
>
>Doug.
>
>_______________________________________________
>Users mailing list
>Users(a)openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>
>
>