I have fixed this issue.
I just have replaced sqlite db file sofia_reg_internal.db by same file from other FS and have done flush all regs.
It Looks like this db file was damaged not sure how exactly but replacement fixed this issue.
> Date: Wed, 4 Apr 2012 13:51:02 -0500
> From: anthony.minessale@gmail.com
> To: freeswitch-users@lists.freeswitch.org
> Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database sofia_reg_internal.db
>
> I already advised.
>
> You did the first one and checked your settings.
> Next capture sip traffic
>
> sofia global siptrace on
>
> and look at all the registers for anything anomalous
>
> On Wed, Apr 4, 2012 at 1:26 PM, Yuriy Nasida <nasida@live.ru> wrote:
> > Anthony, thank you for your answer but I think it is not issue with settings
> > of sip devices. Incorrect additional row may be any of my customers. I mean
> > that the additional row do change after ./fs_cli -x "sofia profile
> > internal flush_inbound_reg"
> >
> > Also I have this problem after moving to : FreeSWITCH Version 1.0.head
> > (git-2ec02e5 2012-03-01 13-22-52 -0600) + Centos 6.
> >
> > I really don't understand why i have it just after cleaning of all rows...
> >
> > sqlite> select * from sip_registrations where sip_user=' user2 ';
> > | user2 ||||||||||||||||||||
> >
> > Please advice.
> >
> > Thanks.
> >
> > ________________________________
> > From: nasida@live.ru
> > To: freeswitch-users@lists.freeswitch.org
> > Date: Wed, 4 Apr 2012 21:55:56 +0400
> > Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database
> > sofia_reg_internal.db
> >
> >
> > Update.
> >
> > after ./fs_cli -x "sofia profile internal flush_inbound_reg" I have
> >
> > sqlite> select * from sip_registrations where sip_user=' user2 ';
> > | user2 ||||||||||||||||||||
> >
> > Why?? I must have clear rows!!
> >
> > Next, I will have 2 rows again but with user3 instead of user1...
> >
> > Thanks.
> >
> > ________________________________
> > From: nasida@live.ru
> > To: freeswitch-users@lists.freeswitch.org
> > Date: Wed, 4 Apr 2012 21:20:51 +0400
> > Subject: [Freeswitch-users] incorrect reg rows in sqlite database
> > sofia_reg_internal.db
> >
> > Hello guys.
> >
> > I have issue with incorrect reg rows in sqlite database
> > sofia_reg_internal.db. it looks like that one registrations are crossed with
> > others. so sometimes i have 2 inbound call for 2 different users instead of
> > one. What it can be ? probably it is some bug of new FS version ? Can you
> > give me some advise ?
> >
> > sqlite> select * from sip_registrations where sip_user='user2';
> >
> > 3c73a57f-34be3361@10.0.0.140|user2|69.XX.XX.101|| user1 <sip:user1@10.0.0.140:5060;fs_nat=yes;fs_path=sip%3Auser1%4079.XX.XX.13%3A5060>|Registered(UDP-NAT)|unknown|1377757948|Linksys/SPA2102-5.2.10;000e081d81c1|user1|69.XX.XX.101|internal|sipproviderdedi1.domain.com|79.XX.XX.13|5060|user1|sip2.sipprovider.com|user1|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101
> >
> > 3bb28227-edc8becf@80.XX.XX.131|user2|69.XX.XX.101||user2
> > <sip:user2@80.XX.XX.131:5060>|Registered(UDP)|unknown|1333557925|Linksys/SPA2102-5.2.10;000e081ac13e|user2|69.XX.XX.101|internal|sipproviderdedi1.domain.com|80.XX.XX.131|5060|user2|sip2.sipprovider.com|user2|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101
> >
> >
> > Why I have first row here? When I call for user2 I have two call (for user1
> > an user2) instead of one (for user2).
> > I have separate row for user1...
> >
> > Thanks.
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services: consulting@freeswitch.org
> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> > Communication Server http://www.cudatel.com Official FreeSWITCH Sites
> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
> > FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services: consulting@freeswitch.org
> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> > Communication Server http://www.cudatel.com Official FreeSWITCH Sites
> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
> > FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting@freeswitch.org
> > http://www.freeswitchsolutions.com
> >
> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> > http://www.cudatel.com
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users@lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
>
>
>
> --
> Anthony Minessale II
>
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
> Twitter: http://twitter.com/FreeSWITCH_wire
>
> AIM: anthm
> MSN:anthony_minessale@hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888@conference.freeswitch.org
> googletalk:conf+888@conference.freeswitch.org
> pstn:+19193869900
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting@freeswitch.org
> http://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org