Re: [SR-Users] event on table location Duplicate entry for key 'ruid_idx'

2015-01-14 Thread Daniel-Constantin Mierla
Would be interesting to discover the issue that got here. server_id can help in the future, but the chance of getting overlapping unique ids is very low even with it. That's why I asked for 'kamctl ps' to see if there are PIDs overlapping on the two systems. Then it is also the start time that matt

Re: [SR-Users] event on table location Duplicate entry for key 'ruid_idx'

2015-01-13 Thread Sergey Okhapkin
Add server_id=N to kamailio.cfg on both servers, where N is an integer with unique value. userloc module will use server_id value to create unique between servers ruid. On Tuesday 13 January 2015 10:53:28 Daniel-Constantin Mierla wrote: > Hello, > > On 12/01/15 22:54, Yuriy Gorlichenko wrote: >

Re: [SR-Users] event on table location Duplicate entry for key 'ruid_idx'

2015-01-13 Thread Daniel-Constantin Mierla
Hello, On 12/01/15 22:54, Yuriy Gorlichenko wrote: > Hello. We use 2 kamailio servers cluster and we have porblems with > db. Database failed pecause of error: > > Could not execute Write_rows_v1 event on table production.location; > Duplicate entry 'uloc-54aae947-86d-a67' for key 'ruid_idx', >

[SR-Users] event on table location Duplicate entry for key 'ruid_idx'

2015-01-12 Thread Yuriy Gorlichenko
Hello. We use 2 kamailio servers cluster and we have porblems with db. Database failed pecause of error: Could not execute Write_rows_v1 event on table production.location; Duplicate entry 'uloc-54aae947-86d-a67' for key 'ruid_idx', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the even