24 Mar
2006
24 Mar
'06
6:23 a.m.
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@voice-system.ro]
Sent: Thursday, March 23, 2006 11:24 AM
To: Douglas Garstang
Cc: users(a)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@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
>
>
>
>
>