One of them is expired in my mind and wiating for  "usrloc" "timer_interval" for clearing in DB.  Expired contact will ignore while calling.  Like this
MariaDB [kamailio_dev]> select username, expires, UNIX_TIMESTAMP(expires) - UNIX_TIMESTAMP(now()), user_agent from location where username='000*888';
+----------+---------------------+-------------------------------------------------+--------------------------------+
| username | expires             | UNIX_TIMESTAMP(expires) - UNIX_TIMESTAMP(now()) | user_agent                     |
+----------+---------------------+-------------------------------------------------+--------------------------------+
| 000*888  | 2017-11-17 14:24:55 |                                            1260 | Yealink SIP-T46G 28.81.0.25    |
| 000*888  | 2017-11-17 14:02:02 |                                            -113 | CSipSimpl||errrr               |
| 000*888  | 2017-11-17 14:17:42 |                                             827 | Bria Android 3.9.6 build 99409 |
+----------+---------------------+-------------------------------------------------+--------------------------------+


2017-11-16 21:18 GMT+03:00 Gholamreza Sabery <gr.sabery@gmail.com>:
Dear Daniel,

I can not use db_mode=1 in my setup; but I will try to test it.

Regards


On Thu, Nov 16, 2017 at 9:23 PM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Very busy with the work this week ...

To see if this a limitation of db only mode or not, can you test with db_mode=1?

Cheers,
Daniel


On 16.11.17 16:51, Gholamreza Sabery wrote:
No ideas?

On Wed, Nov 15, 2017 at 3:27 PM, Gholamreza Sabery <gr.sabery@gmail.com> wrote:
Hello Daniel,

I use a value of 3 for db_mode.

On Wed, Nov 15, 2017 at 11:11 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

what is the value of db_mode parameter for usrloc module?

Cheers,
Daniel


On 15.11.17 06:36, Gholamreza Sabery wrote:
I have a Kamailio server that has:

modparam("registrar", "max_contacts", 2)

But recently I noticed some users have more than two records in the location table. For example one of the users has three different records with nearly the same information. The records are as follows. Is this behavior normal? (I am using Kamailio 4XX).

*************************** 1. row ***************************
           id: 171296745
         ruid: uloc-2c69-59db6c73-7ca-132d92
     username: 999999999999
       domain: NULL
      contact: sip:999999999999@5.106.35.18:10362
     received: sip:5.106.35.18:10361
         path: NULL
      expires: 2017-11-14 08:45:50
            q: -1.00
       callid: XpCnmaAhRF
         cseq: 43
last_modified: 2017-11-14 08:44:50
        flags: 0
       cflags: 64
   user_agent: android_1.1.0_samsung_SM-E500H_7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2)
       socket: udp:192.168.103.21:5060
      methods: NULL
     instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269>
       reg_id: 0
    server_id: 11369
connection_id: -1
    keepalive: 1
    partition: 14
*************************** 2. row ***************************
           id: 171296746
         ruid: uloc-2c69-59db6c73-7f2-eb5d92
     username: 999999999999
       domain: NULL
      contact: sip:999999999999@5.106.35.18:10362
     received: sip:5.106.35.18:10361
         path: NULL
      expires: 2017-11-14 08:45:50
            q: -1.00
       callid: BzMKuyJN8C
         cseq: 50
last_modified: 2017-11-14 08:44:50
        flags: 0
       cflags: 64
   user_agent: android_1.1.0_samsung_SM-E500H_7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2)
       socket: udp:192.168.103.21:5060
      methods: NULL
     instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269>
       reg_id: 0
    server_id: 11369
connection_id: -1
    keepalive: 1
    partition: 23
*************************** 3. row ***************************
           id: 171296747
         ruid: uloc-2c69-59db6c73-80f-541d92
     username: 999999999999
       domain: NULL
      contact: sip:999999999999@5.106.35.18:10362
     received: sip:5.106.35.18:10361
         path: NULL
      expires: 2017-11-14 08:45:50
            q: -1.00
       callid: 3p9P4PgZSv
         cseq: 51
last_modified: 2017-11-14 08:44:50
        flags: 0
       cflags: 64
   user_agent: android_1.1.0_samsung_SM-E500H_7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2)
       socket: udp:192.168.103.21:5060
      methods: NULL
     instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269>
       reg_id: 0
    server_id: 11369
connection_id: -1
    keepalive: 1
    partition: 15


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com



-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
Kamailio World Conference - www.kamailioworld.com


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users




--
Savolainen Dmitri