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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
Douglas Garstang