[Spce-user] Duplicate entries in SQL on register
Walter Klomp
walter at myrepublic.com.sg
Sun Jun 12 23:52:50 EDT 2016
Hi,
Running CE 3.8.5:
For some reason when there is a network break (some anomality happened) - we have quite a few issues with registrations, after a REGISTER attempt we see the following:
Jun 13 11:47:46 sipwise proxy[5793]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplicate entry 'uloc-5757d4f1-16a1-a7aa6' for key 'ruid_idx'
--
Jun 13 11:47:48 sipwise proxy[5795]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplicate entry 'uloc-5757d4ed-16a6-55496' for key 'ruid_idx'
--
Jun 13 11:47:49 sipwise proxy[5798]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplicate entry 'uloc-5757d4f1-16a1-59aa6' for key 'ruid_idx'
--
Jun 13 11:47:49 sipwise proxy[5800]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplicate entry 'uloc-5757d4ed-16a7-51696' for key ‘ruid_idx'
It seems the registrations can’t be entered in the database. Can it be fixed so that if this happens it clears the old entry before inserting the new one ?
More information about the Spce-user
mailing list