[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