Re: [SR-Users] [sr-dev] FOSDEM 2017

[Nuno Reis]

Hi guys.

Last minute subscribe for +6 people.


Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS

| www.wavecom.pt ** *






On Wed, Feb 1, 2017 at 10:48 PM, Ludovic Gasc  wrote:

> Hi,
>
> It's clearly a good idea, I'm in, if possible.
>
> Have a nice week.
>
> --
> Ludovic Gasc (GMLudo)
> Lead Developer Architect at ALLOcloud
> https://be.linkedin.com/in/ludovicgasc
>
> 2017-02-01 16:59 GMT+01:00 Daniel-Constantin Mierla :
>
>> Some updates:
>>
>>  - the reservation was increased to 25 seats, accommodating everyone that
>> showed interest today.
>>
>>  - there is a little flexibility that few more people can be accommodated
>> on spot, but it is better to announce your intention as soon as possible,
>> because if there are too many, the space might not be enough.
>>
>> For those that were there last year, it is the same place, nearby Fosdem
>> location. I will send a dedicated email to provide more details.
>>
>> Many thanks to Torrey taking care again this year of everything regarding
>> the reservation!
>>
>> Cheers,
>> Daniel
>>
>> On 01/02/2017 10:51, Daniel-Constantin Mierla wrote:
>>
>> As far as I know, Torrey already made the reservation. Monday evening I
>> estimated 20 participants given the feedback on the mailing lists or
>> directly to me. There were few seats extra, but they filled meanwhile.
>>
>> If there are new participants from this moment on, I think that we have
>> to increase the number of seats.
>>
>> Also, given the high number of participants, we will have a special menu
>> with a limited list of choices (like last year) -- more details to be
>> published soon.
>>
>> Cheers,
>> Daniel
>>
>> On 01/02/2017 10:41, Daniel Pocock wrote:
>>
>>
>> Adding the Free-RTC mailing list - anybody else want to join the dinner
>> that is being proposed for Saturday night at FOSDEM?
>>
>> Have any details been confirmed?  Is there a deadline or maximum number
>> of people?
>>
>>
>> On 20/01/17 10:38, Alexandr Dubovikov wrote:
>>
>> Hi Daniel,
>>
>> IMHO we can do like last year. It was good organized.
>>
>> Wbr,
>> Alexandr
>>
>> On 20 January 2017 at 11:00, Daniel-Constantin Mierla 
>> wrote:
>>
>>> Hello,
>>>
>>> another edition of FOSDEM is approaching, about 2 weeks left:
>>>
>>>   - https://fosdem.org/2017/
>>>
>>> Couple of devs and many Kamailio friends will be around.
>>>
>>> Like past year, there is a Realtime Communications devroom, this edition
>>> on Sunday. Very interesting presentation for our ecosystem: Olle giving
>>> a presentation about IPv4/IPv6, Inaki introducing its SFU media server
>>> project, Jose talking about JsSIP, Daniel debating about fundraising
>>> FreeRTC, Lorenzo with Janus SIP-WebRTC gateway, the other Lorenzo with
>>> Homer Sipcature, Saul with Jitsi, Dan with cgrates, Matt with Asterisk,
>>> Giovanni with FreeSwitch... Schedule at:
>>>
>>>   - https://fosdem.org/2017/schedule/track/real_time_communications/
>>>
>>> On Sunday morning, part of Lua devroom, I will present about using Lua
>>> for building RTC services with Kamailio:
>>>
>>>   - https://fosdem.org/2017/schedule/track/lua/
>>>   - https://fosdem.org/2017/schedule/event/luartcserviceskamailio/
>>>
>>> During the past editions we organized a dinner on Saturday evening.
>>> Shall we attempt to do it again in advance this year? Or should we do it
>>> on spot based on the weather and mood at the end of Saturday?
>>>
>>> Cheers,
>>> Daniel
>>>
>>> --
>>> Daniel-Constantin Mierla
>>> www.twitter.com/miconda -- www.linkedin.com/in/miconda
>>> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) -
>>> www.asipto.com
>>> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
>>>
>>>
>>> ___
>>> sr-dev mailing list
>>> sr-...@lists.sip-router.org
>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>>>
>>
>>
>>
>> ___
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
>> listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>>
>> --
>> Daniel-Constantin Mierlawww.twitter.com/miconda -- 
>> www.linkedin.com/in/miconda
>> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - 
>> www.asipto.com
>> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
>>
>>
>> --
>> Daniel-Constantin Mierlawww.twitter.com/miconda -- 
>> www.linkedin.com/in/miconda
>> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - 
>> www.asipto.com
>> Kamailio World Conference - May 

Re: [SR-Users] [sr-dev] Fosdem 2016

[Nuno Reis]

Hi Daniel.

José Ferreira and I from Wavecom will be there from Friday to Sunday. You
can count with us for dinner and social event.
See you there.

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS

| www.wavecom.pt ** *






On Wed, Jan 6, 2016 at 8:16 AM, Daniel-Constantin Mierla 
wrote:

> Hello,
>
> ok, let's see how many we are going to be and then decide how to do it
> (if we are not a large group, we can just go in the city center and walk
> around for a place).
>
> Cheers,
> Daniel
>
> On 06/01/16 02:30, Alexandr Dubovikov wrote:
> > Hello Daniel,
> >
> > I will be there, plus Lorenzo and Torsen. Make a small event on
> > Saturday will be very cool, but not at Beer Mania :-)
> >
> > Wbr,
> > Alexandr
> >
> > On 05.01.2016 20:06, Daniel-Constantin Mierla wrote:
> >> Hello,
> >>
> >> anyone going to Fosdem?
> >>
> >> If no unexpected weather conditions messing the transport system, I am
> >> going to be there. It would be good to know who else we can meet there.
> >>
> >> If there are enough people interested, we can try organizing a social
> >> event (dinner/drinks) on Saturday evening. Last year we did it together
> >> with Jitsi team, but they are not coming this year. Perhaps there are
> >> other folks around the RTC dev room we can ask.
> >>
> >> On the other hand, it is harder to find a place if it is a large group,
> >> even harder to put all together if there are different
> >> groups/coordinators. Also, it is not easy to discuss withing a large
> >> group, as typically for a dinner we were seated to tables. Therefore
> >> organizing for a smaller group just for Kamailio friends could be a good
> >> alternative. Let's see first the number of participant and the level of
> >> interest for various options.
> >>
> >> This being an announcement, was crossposted to few mailing lists, but as
> >> most of the people are on sr-users, I think it would be good to reply
> >> and follow up on this discussion only there.
> >>
> >> Cheers,
> >> Daniel
> >>
> >
> >
> > ___
> > sr-dev mailing list
> > sr-...@lists.sip-router.org
> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
> --
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Book: SIP Routing With Kamailio - http://www.asipto.com
> http://miconda.eu
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] CRITICAL log on kamailio startup

[Nuno Reis]

Hi Daniel.

Thanks for answering me.
I took a look on the loadmodule lines again as you suggested and found out
I was indeed having a dependency situation which is now fixed. All OK now.
Thanks again.

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
<http://maps.google.com/maps/ms?msa=0=202333747613191340808.0004b4b227a6144f0df88>
| www.wavecom.pt <http://www.wavecom.pt/>** <http://www.wavecom.pt/>*

<http://www.wavecom.pt/>
<http://www.wavecom.pt/pt/>



On Mon, Aug 24, 2015 at 1:14 PM, Daniel-Constantin Mierla <mico...@gmail.com
> wrote:

> Hello,
>
> are you loading any module using dialog before it?
>
> You can paste your loadmodule lines here if you are not sure which one
> depends on dialog.
>
> Cheers,
> Daniel
>
>
> On 24/08/15 13:20, Nuno Reis wrote:
>
> Good morning.
> Has anyone seen this too?
> Looking forward to hear from you.
>
> BR,
>
> --
>
> *Nuno Miguel Reis* | *Unified Communication** Systems*
> M. +351 913907481 | nr...@wavecom.pt
> WAVECOM-Soluções Rádio, S.A.
> Cacia Park | Rua do Progresso, Lote 15
> 3800-639 AVEIRO | Portugal
> T. +351 309 700 225 | F. +351 234 919 191
> *GPS
> <http://maps.google.com/maps/ms?msa=0=202333747613191340808.0004b4b227a6144f0df88>
> | www.wavecom.pt <http://www.wavecom.pt/>** <http://www.wavecom.pt/>*
>
> <http://www.wavecom.pt/>
> <http://www.wavecom.pt/pt/>
>
>
>
> On Fri, Aug 14, 2015 at 1:41 AM, Nuno Reis <nr...@wavecom.pt> wrote:
>
>> Hi guys.
>>
>> I've noticed this CRITICAL log line on kamailio startup:
>>
>> CRITICAL: dialog [dlg_cb.c:137]: register_dlgcb(): DLGCB_CREATED type
>> registered after shutdown!?!
>>
>>
>> This line started to show up after upgrade from 4.2.x to 4.3 and now to
>> 4.3.1.
>> Everything seems to be working fine and a really don't see any harm
>> anywhere.
>> Could you please comment on this?
>>
>> Cheers,
>>
>> --
>>
>> *Nuno Miguel Reis* | *Unified Communication** Systems*
>> M. +351 913907481 | nr...@wavecom.pt
>> WAVECOM-Soluções Rádio, S.A.
>> Cacia Park | Rua do Progresso, Lote 15
>> 3800-639 AVEIRO | Portugal
>> T. +351 309 700 225 | F. +351 234 919 191
>> *GPS
>> <http://maps.google.com/maps/ms?msa=0=202333747613191340808.0004b4b227a6144f0df88>
>> | www.wavecom.pt <http://www.wavecom.pt/>** <http://www.wavecom.pt/>*
>>
>> <http://www.wavecom.pt/>
>> <http://www.wavecom.pt/pt/>
>>
>>
>>
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
> listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - 
> http://www.linkedin.com/in/miconda
> Book: SIP Routing With Kamailio - http://www.asipto.com
>
>
> ___
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] CRITICAL log on kamailio startup

[Nuno Reis]

Good morning.
Has anyone seen this too?
Looking forward to hear from you.

BR,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

http://www.wavecom.pt/
http://www.wavecom.pt/pt/



On Fri, Aug 14, 2015 at 1:41 AM, Nuno Reis nr...@wavecom.pt wrote:

 Hi guys.

 I've noticed this CRITICAL log line on kamailio startup:

 CRITICAL: dialog [dlg_cb.c:137]: register_dlgcb(): DLGCB_CREATED type
 registered after shutdown!?!


 This line started to show up after upgrade from 4.2.x to 4.3 and now to
 4.3.1.
 Everything seems to be working fine and a really don't see any harm
 anywhere.
 Could you please comment on this?

 Cheers,

 --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
 WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 http://www.wavecom.pt/
 http://www.wavecom.pt/pt/



___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Just to be clear. The memory is in Kilobytes (kB).

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Wed, Feb 11, 2015 at 3:26 AM, Nuno Reis nr...@wavecom.pt wrote:

 Hi Daniel.
 Thank you for your suggestion and feedback on this.
 I've tried that already and here's what I've found after 15h on a running
 kamailio:

 All records in pua and presentity DB tables are gone by the end of the
 day, so the expire time seems to be working.
 I still see system memory growing and not being released again.
 You can find attached (tar.gz) various dumps of pkgstats and shmem usage.
 The number after the 'underscore' in file names corresponds to system
 memory allocation in kamailio at the various timestamps. The earlier
 timestamp corresponds to minute 1.
 So I started with 638632kb system mem allocation and I'm now
 with 1086548kb being used after 15 hours.

 I'll continue to investigate the issue but if you have any other
 suggestions on how to tackle this, I'm of course available to test those.
 Looking forward to hear from you.

 Best Regards,

 --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
 WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



 On Mon, Feb 9, 2015 at 5:05 PM, Daniel-Constantin Mierla 
 mico...@gmail.com wrote:

  Hello,

 can you check the expires column in presentity table. The issue might be
 accumulation of too many dialog-info documents, due to large expires
 interval, taken from the default lifetime of the dialog. You can change
 that with:

   -
 http://kamailio.org/docs/modules/4.2.x/modules/pua_dialoginfo.html#idp2576952

 Cheers,
 Daniel


 On 30/01/15 16:43, Nuno Reis wrote:

 Hi Daniel.

  Thanks for answering me back. I'll follow the exact procedures from
 here: http://www.kamailio.org/wiki/tutorials/troubleshooting/memory and
 will let you know about my exact finding soon.

  Cheers,

  --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
  WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



 On Fri, Jan 30, 2015 at 5:23 AM, Daniel-Constantin Mierla 
 mico...@gmail.com wrote:

 Hello,

  which memory is increasing? shared or private memory? or is system
 memory?

  Cheers,
 Daniel

 On Fri, Jan 30, 2015 at 4:24 AM, Nuno Reis nr...@wavecom.pt wrote:

 Hi Juha and all.

  I understand that and that is what the RFC says. It seems pua module
 does that right. Although something is clearly not right in my production
 environment because kamailio memory consumption still grows pretty fast.
 Kamailio memory usage starts in ~500MB and after ~24H kamailio is using
 ~3GB. If I disable kamailio from listening on the localhost(127.0.0.1)
 where pua is generating the SIP Publishes kamailio just keeps around the
 ~500MB all the time.
 This is a small production environment with 70 extensions with Yealink
 phones.
 Any ideas on how to chase down this memory leak? Should I open a git
 issue for this one?



  --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
  WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



   On Wed, Jan 21, 2015 at 8:45 PM, Juha Heinanen j...@tutpro.com wrote:

 Nuno Reis writes:

  Here my publisher is Kamailio itself. Can

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hi Daniel.
Thank you for your suggestion and feedback on this.
I've tried that already and here's what I've found after 15h on a running
kamailio:

All records in pua and presentity DB tables are gone by the end of the day,
so the expire time seems to be working.
I still see system memory growing and not being released again.
You can find attached (tar.gz) various dumps of pkgstats and shmem usage.
The number after the 'underscore' in file names corresponds to system
memory allocation in kamailio at the various timestamps. The earlier
timestamp corresponds to minute 1.
So I started with 638632kb system mem allocation and I'm now with 1086548kb
being used after 15 hours.

I'll continue to investigate the issue but if you have any other
suggestions on how to tackle this, I'm of course available to test those.
Looking forward to hear from you.

Best Regards,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Mon, Feb 9, 2015 at 5:05 PM, Daniel-Constantin Mierla mico...@gmail.com
wrote:

  Hello,

 can you check the expires column in presentity table. The issue might be
 accumulation of too many dialog-info documents, due to large expires
 interval, taken from the default lifetime of the dialog. You can change
 that with:

   -
 http://kamailio.org/docs/modules/4.2.x/modules/pua_dialoginfo.html#idp2576952

 Cheers,
 Daniel


 On 30/01/15 16:43, Nuno Reis wrote:

 Hi Daniel.

  Thanks for answering me back. I'll follow the exact procedures from
 here: http://www.kamailio.org/wiki/tutorials/troubleshooting/memory and
 will let you know about my exact finding soon.

  Cheers,

  --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
  WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



 On Fri, Jan 30, 2015 at 5:23 AM, Daniel-Constantin Mierla 
 mico...@gmail.com wrote:

 Hello,

  which memory is increasing? shared or private memory? or is system
 memory?

  Cheers,
 Daniel

 On Fri, Jan 30, 2015 at 4:24 AM, Nuno Reis nr...@wavecom.pt wrote:

 Hi Juha and all.

  I understand that and that is what the RFC says. It seems pua module
 does that right. Although something is clearly not right in my production
 environment because kamailio memory consumption still grows pretty fast.
 Kamailio memory usage starts in ~500MB and after ~24H kamailio is using
 ~3GB. If I disable kamailio from listening on the localhost(127.0.0.1)
 where pua is generating the SIP Publishes kamailio just keeps around the
 ~500MB all the time.
 This is a small production environment with 70 extensions with Yealink
 phones.
 Any ideas on how to chase down this memory leak? Should I open a git
 issue for this one?



  --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
  WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



   On Wed, Jan 21, 2015 at 8:45 PM, Juha Heinanen j...@tutpro.com wrote:

 Nuno Reis writes:

  Here my publisher is Kamailio itself. Can someone elaborate a bit
 more on
  this issue and maybe we can get to bottom of it?

 when your application issues initial publish request, it does so without
 SIP-If-Match header.  200 ok from presence server then contains an etag
 in SIP-ETag header. when your application refreshes the publish, it must
 place this etag in SIP-If-Match header to prevent presence server from
 creating a new publication.

 for subscribes, your application must place in re-subscribe the
 same event header id param as the previous one had in order for the
 presence server to know that subscribe was not a new subscription.

 -- juha





   --
  Daniel-Constantin Mierla - http://www.asipto.com
 http://twitter.com

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hi Daniel.

Thanks for answering me back. I'll follow the exact procedures from here:
http://www.kamailio.org/wiki/tutorials/troubleshooting/memory and will let
you know about my exact finding soon.

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Fri, Jan 30, 2015 at 5:23 AM, Daniel-Constantin Mierla mico...@gmail.com
 wrote:

 Hello,

 which memory is increasing? shared or private memory? or is system memory?

 Cheers,
 Daniel

 On Fri, Jan 30, 2015 at 4:24 AM, Nuno Reis nr...@wavecom.pt wrote:

 Hi Juha and all.

 I understand that and that is what the RFC says. It seems pua module does
 that right. Although something is clearly not right in my production
 environment because kamailio memory consumption still grows pretty fast.
 Kamailio memory usage starts in ~500MB and after ~24H kamailio is using
 ~3GB. If I disable kamailio from listening on the localhost(127.0.0.1)
 where pua is generating the SIP Publishes kamailio just keeps around the
 ~500MB all the time.
 This is a small production environment with 70 extensions with Yealink
 phones.
 Any ideas on how to chase down this memory leak? Should I open a git
 issue for this one?



 --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
 WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



 On Wed, Jan 21, 2015 at 8:45 PM, Juha Heinanen j...@tutpro.com wrote:

 Nuno Reis writes:

  Here my publisher is Kamailio itself. Can someone elaborate a bit more
 on
  this issue and maybe we can get to bottom of it?

 when your application issues initial publish request, it does so without
 SIP-If-Match header.  200 ok from presence server then contains an etag
 in SIP-ETag header. when your application refreshes the publish, it must
 place this etag in SIP-If-Match header to prevent presence server from
 creating a new publication.

 for subscribes, your application must place in re-subscribe the
 same event header id param as the previous one had in order for the
 presence server to know that subscribe was not a new subscription.

 -- juha





 --
 Daniel-Constantin Mierla - http://www.asipto.com
 http://twitter.com/#!/miconda - http://www.linkedin.com/in/micond
 http://www.linkedin.com/in/miconda

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hi Juha and all.

I understand that and that is what the RFC says. It seems pua module does
that right. Although something is clearly not right in my production
environment because kamailio memory consumption still grows pretty fast.
Kamailio memory usage starts in ~500MB and after ~24H kamailio is using
~3GB. If I disable kamailio from listening on the localhost(127.0.0.1)
where pua is generating the SIP Publishes kamailio just keeps around the
~500MB all the time.
This is a small production environment with 70 extensions with Yealink
phones.
Any ideas on how to chase down this memory leak? Should I open a git issue
for this one?



--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Wed, Jan 21, 2015 at 8:45 PM, Juha Heinanen j...@tutpro.com wrote:

 Nuno Reis writes:

  Here my publisher is Kamailio itself. Can someone elaborate a bit more on
  this issue and maybe we can get to bottom of it?

 when your application issues initial publish request, it does so without
 SIP-If-Match header.  200 ok from presence server then contains an etag
 in SIP-ETag header. when your application refreshes the publish, it must
 place this etag in SIP-If-Match header to prevent presence server from
 creating a new publication.

 for subscribes, your application must place in re-subscribe the
 same event header id param as the previous one had in order for the
 presence server to know that subscribe was not a new subscription.

 -- juha

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hello all.

Just want to tell you that the problem remains even after the patch Daniel
add to the latest 4.2.
I've sent another email yesterday (partially quoted bellow) to the mailing
list which was already answered by Juha Heinanen in cc regarding an odd
behavior (seems odd to me) i'm seeing.

I've been testing presence module for a while and I do notice that
 presentity table grows endlessly over time.
 Each time a call is made a new record is added in presentity with a
 different etag.
 In documentation, namely developers guide we can read this:

 int etag_not_new;
   /*
*  0 - the standard mechanism (allocating new etag
   for each Publish)
*  1 - allocating an etag only
   for an initial Publish
   */

 How can I tell the presence module in kamailio config to work using the
 second form of the above?


I have a small production environment with ~70 extensions and in less than
24H (~20H), the presentity table grew from 0 to about ~2000 records, pua
table grew to about ~850 records and kamailio memory usage grew from 600MB
to 2GB on a 4G Linux server.
Yesterday Juha said and I'll quote:

presence module does not do anything with calls.  it handles publish and
 subscriber requests and generates notifies.

 when publish is handled, it is the job of the publisher to place correct
 etag in subsequent refresh publish requests.

 -- juha


Here my publisher is Kamailio itself. Can someone elaborate a bit more on
this issue and maybe we can get to bottom of it?
Thanks.

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Thu, Jan 15, 2015 at 4:56 PM, Daniel-Constantin Mierla mico...@gmail.com
 wrote:

  Hello,

 I applied the patch, with some adjustments. Now in master, to be
 backported to stable branches soon.

 Cheers,
 Daniel


 On 13/01/15 20:16, Nuno Reis wrote:

 Hi Kristian and Daniel.

  Kristian, hhanks for you feedback and patch.
 I'll try your patch here and will let you know the outcome soon.
 Thanks again guys.

  Cheers,

  --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
  WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



 On Tue, Jan 13, 2015 at 10:00 AM, Daniel-Constantin Mierla 
 mico...@gmail.com wrote:

  Hello,

 thanks for the details and patch. I will try to look at later today.

 Cheers,
 Daniel


 On 13/01/15 08:35, Kristian F. Høgh wrote:

  Hi,



 I've been hunting a memory error in publish handling the last couple of
 days.

 The error is on our old but good 3.1.x presence server.

 Using memory debug, I located the memory leak in modules/presence/hash.c,
 function insert_phtable, line 492 (in trunk):

 p= (pres_entry_t*)shm_malloc(size);



 As far I can see there are two errors when deleting publish htable entries

 1. When calling delete_phtable pres.event-type is used instead of
 pres.event-evp-type



 2. When creating publish hashtable, p-publ_count is not set. (defaults
 to 0)

 In delete_phtable, the following code is present

 p-publ_count--;

 if(p-publ_count== 0)

 p-publ_count is probably decremented to -1 (unless the user have two
 active dialogs)



 I attach a patch, which I would carefully test in a test environment :-)



 Regards,

 Kristian Høgh

 Uni-tel





 On Monday 12 January 2015 15:39:27 Nuno Reis wrote:

  Hello all.

 

  I'm consistently watching a memory increase in kamailio when dealing
 with

  PRESENCE events, namely SIP PUBLISH events. The system eventually hangs

  running out of memory.

  This behavior is seen at least in kamailio 4.1 and 4.2. I'm currently
 using

  the latest stable 4.2.2.

  If I disable the SIP PUBLISH handling in kamailio i don't observe the
 issue

  anymore but as a side effect I don't have presence (name BLFs) also.

  What do you think can be the right approach here? Should I open an
 issue in

  github for this? Should I run kamailio under valgrind for some time? Are

  there any other possible debug hints here?

  Please find attached a code snippet with the presence related parts I'm

  using

Re: [SR-Users] How to make presence module allocating an etag only for an initial Publish??

[Nuno Reis]

Hi Juha.
Thanks for answering me back.
In my particular case my publisher is Kamailio itself.
You can see a code snippet for my presence configs (attached) in my
kamailio config file.
I'm using pua to generate SIP PUBLISH messages on 127.0.0.1 and probably
that isn't the best approach, but I don't have other.
Any suggestions?

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Tue, Jan 20, 2015 at 7:37 PM, Juha Heinanen j...@tutpro.com wrote:

 Nuno Reis writes:

  I've been testing presence module for a while and I do notice that
  presentity table grows endlessly over time.
  Each time a call is made a new record is added in presentity with a
  different etag.

 presence module does not do anything with calls.  it handles publish and
 subscriber requests and generates notifies.

 when publish is handled, it is the job of the publisher to place correct
 etag in subsequent refresh publish requests.

 -- juha



presence.cfg
Description: Binary data
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] How to make presence module allocating an etag only for an initial Publish??

[Nuno Reis]

Hello all.

I've been testing presence module for a while and I do notice that
presentity table grows endlessly over time.
Each time a call is made a new record is added in presentity with a
different etag.
In documentation, namely developers guide we can read this:

int etag_not_new;
/*
 *  0 - the standard mechanism (allocating new etag
for each Publish)
 *  1 - allocating an etag only
for an initial Publish
*/

How can I tell the presence module in kamailio config to work using the
second form of the above?


Looking forward to hear from you.


BR,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hi Kristian and Daniel.

Kristian, hhanks for you feedback and patch.
I'll try your patch here and will let you know the outcome soon.
Thanks again guys.

Cheers,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php



On Tue, Jan 13, 2015 at 10:00 AM, Daniel-Constantin Mierla 
mico...@gmail.com wrote:

  Hello,

 thanks for the details and patch. I will try to look at later today.

 Cheers,
 Daniel


 On 13/01/15 08:35, Kristian F. Høgh wrote:

 Hi,



 I've been hunting a memory error in publish handling the last couple of
 days.

 The error is on our old but good 3.1.x presence server.

 Using memory debug, I located the memory leak in modules/presence/hash.c,
 function insert_phtable, line 492 (in trunk):

 p= (pres_entry_t*)shm_malloc(size);



 As far I can see there are two errors when deleting publish htable entries

 1. When calling delete_phtable pres.event-type is used instead of
 pres.event-evp-type



 2. When creating publish hashtable, p-publ_count is not set. (defaults to
 0)

 In delete_phtable, the following code is present

 p-publ_count--;

 if(p-publ_count== 0)

 p-publ_count is probably decremented to -1 (unless the user have two
 active dialogs)



 I attach a patch, which I would carefully test in a test environment :-)



 Regards,

 Kristian Høgh

 Uni-tel





 On Monday 12 January 2015 15:39:27 Nuno Reis wrote:

  Hello all.

 

  I'm consistently watching a memory increase in kamailio when dealing with

  PRESENCE events, namely SIP PUBLISH events. The system eventually hangs

  running out of memory.

  This behavior is seen at least in kamailio 4.1 and 4.2. I'm currently
 using

  the latest stable 4.2.2.

  If I disable the SIP PUBLISH handling in kamailio i don't observe the
 issue

  anymore but as a side effect I don't have presence (name BLFs) also.

  What do you think can be the right approach here? Should I open an issue
 in

  github for this? Should I run kamailio under valgrind for some time? Are

  there any other possible debug hints here?

  Please find attached a code snippet with the presence related parts I'm

  using right now.

  Looking forward to hear from you.

 

  Best Regards,

 

  --

 

  *Nuno Miguel Reis* | *Unified Communication** Systems*

  M. +351 913907481 | nr...@wavecom.pt

  WAVECOM-Soluções Rádio, S.A.

  Cacia Park | Rua do Progresso, Lote 15

  3800-639 AVEIRO | Portugal

  T. +351 309 700 225 | F. +351 234 919 191

  *GPS

 
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88

  | www.wavecom.pt http://www.wavecom.pt/ http://www.wavecom.pt/**
 http://www.wavecom.pt/ http://www.wavecom.pt/*

 

  [image: Description: Description: WavecomSignature]

  http://www.wavecom.pt/pt/wavecom/premios.php
 http://www.wavecom.pt/pt/wavecom/premios.php

 

  [image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php
 http://www.wavecom.pt/pt/mail_eventos.php




 ___
 SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
 listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


 --
 Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - 
 http://www.linkedin.com/in/miconda


 ___
 SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
 sr-users@lists.sip-router.org
 http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] Possible memory leak dealing with presence in kamailio

[Nuno Reis]

Hello all.

I'm consistently watching a memory increase in kamailio when dealing with
PRESENCE events, namely SIP PUBLISH events. The system eventually hangs
running out of memory.
This behavior is seen at least in kamailio 4.1 and 4.2. I'm currently using
the latest stable 4.2.2.
If I disable the SIP PUBLISH handling in kamailio i don't observe the issue
anymore but as a side effect I don't have presence (name BLFs) also.
What do you think can be the right approach here? Should I open an issue in
github for this? Should I run kamailio under valgrind for some time? Are
there any other possible debug hints here?
Please find attached a code snippet with the presence related parts I'm
using right now.
Looking forward to hear from you.

Best Regards,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php


presence.cfg
Description: Binary data
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] FS#439 - CRASH: segmentation fault after INVITE

[Nuno Reis]

Hi.
I've just opened a bug report FS#439 on a segmentation fault after an
invite to a uknown DNS domain.
It is reproducible and is happening in kamailio 4.1.3 (642428c)
Please let me know if anything else is needed.

Thanks.

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[SR-Users] DB ERROR using presence status persistence

[Nuno Reis]

Hi guys.

I've setup presence management in kamailio and i'm currently persisting the
presence info in a postgres DB.
I'm having a recurring issue on DB key violations, here's a log error
output on that:

Jun  3 15:09:46 144227  ERROR: pua_dialoginfo [pua_dialoginfo.c:264]:
__dialog_sendpublish(): bad reply or missing CONTACT hdr
Jun  3 15:10:01 723993  ERROR: presence [presentity.c:807]:
update_presentity(): No E_Tag match a.1401768964.671509.1990.6
Jun  3 15:10:06 242334  WARNING: db_postgres [km_dbase.c:235]:
db_postgres_submit_query(): postgres result check failed with code 7
(PGRES_FATAL_ERROR)
Jun  3 15:10:06 242370  WARNING: db_postgres [km_dbase.c:239]:
db_postgres_submit_query(): postgres query command failed, connection
status 0, error [ERROR:  duplicate key value violates unique constraint
pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
Jun  3 15:10:06 243415  WARNING: db_postgres [km_dbase.c:235]:
db_postgres_submit_query(): postgres result check failed with code 7
(PGRES_FATAL_ERROR)
Jun  3 15:10:06 243449  WARNING: db_postgres [km_dbase.c:239]:
db_postgres_submit_query(): postgres query command failed, connection
status 0, error [ERROR:  duplicate key value violates unique constraint
pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
Jun  3 15:10:06 244458  WARNING: db_postgres [km_dbase.c:235]:
db_postgres_submit_query(): postgres result check failed with code 7
(PGRES_FATAL_ERROR)
Jun  3 15:10:06 244487  WARNING: db_postgres [km_dbase.c:239]:
db_postgres_submit_query(): postgres query command failed, connection
status 0, error [ERROR:  duplicate key value violates unique constraint
pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
Jun  3 15:10:06 244504  ERROR: db_postgres [km_dbase.c:247]:
db_postgres_submit_query(): 0x7f21476b1910 PQsendQuery Error: ERROR:
duplicate key value violates unique constraint pua_pua_idx#012DETAIL:
Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , )
already exists.#012 Query: update kamailio.pua set
expires=1401807715,cseq=0,etag='a.1401768964.671497.1902.6',desired_expires=1401811600,version=2
where pres_uri='sip:2...@freguesiadearroios.govoice.pt' AND
pres_id='dialog_publish.440163220-35219...@bjc.bgi.b.bai' AND flag=1024 AND
event=32
Jun  3 15:10:06 244521  ERROR: core [db_query.c:337]: db_do_update():
error while submitting query
Jun  3 15:10:06 244548  ERROR: db_postgres [km_dbase.c:537]:
db_postgres_store_result(): invalid query, execution aborted
Jun  3 15:10:06 244560  ERROR: db_postgres [km_dbase.c:538]:
db_postgres_store_result(): driver error: PGRES_FATAL_ERROR, ERROR:
duplicate key value violates unique constraint pua_pua_idx#012DETAIL:
Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , )
already exists.#012
Jun  3 15:10:06 244584  WARNING: db_postgres [km_dbase.c:647]:
db_postgres_update(): unexpected result returned
Jun  3 15:10:06 244591  ERROR: pua [pua.c:1076]: db_update(): while
updating in database


I've read the module documentation, but there isn't much documentation on
it and i'm basically guessing and trying here.
Can someone tell me what am i doing wrong or maybe what should a try to be
able to persist the presence status in a postgres database.
I know that i could use in memory persistence or other  type of DB, but i
really want to know if i can use a normal postgres DB for presence
persistence and what could be used to avoid key violations.

Looking forward to hear from you.
Best Regards,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php
___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Re: [SR-Users] DB ERROR using presence status persistence

[Nuno Reis]

Could this be a bug in pua?

Using kamailio 4.1.3 (642428c)

Looking forward to hear from you.

BR,

--

*Nuno Miguel Reis* | *Unified Communication** Systems*
M. +351 913907481 | nr...@wavecom.pt
WAVECOM-Soluções Rádio, S.A.
Cacia Park | Rua do Progresso, Lote 15
3800-639 AVEIRO | Portugal
T. +351 309 700 225 | F. +351 234 919 191
*GPS
http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
| www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

[image: Description: Description: WavecomSignature]
http://www.wavecom.pt/pt/wavecom/premios.php

[image: Publicity] http://www.wavecom.pt/pt/mail_eventos.php




On Tue, Jun 3, 2014 at 3:23 PM, Nuno Reis nr...@wavecom.pt wrote:

 Hi guys.

 I've setup presence management in kamailio and i'm currently persisting
 the presence info in a postgres DB.
 I'm having a recurring issue on DB key violations, here's a log error
 output on that:

 Jun  3 15:09:46 144227  ERROR: pua_dialoginfo [pua_dialoginfo.c:264]:
 __dialog_sendpublish(): bad reply or missing CONTACT hdr
 Jun  3 15:10:01 723993  ERROR: presence [presentity.c:807]:
 update_presentity(): No E_Tag match a.1401768964.671509.1990.6
 Jun  3 15:10:06 242334  WARNING: db_postgres [km_dbase.c:235]:
 db_postgres_submit_query(): postgres result check failed with code 7
 (PGRES_FATAL_ERROR)
 Jun  3 15:10:06 242370  WARNING: db_postgres [km_dbase.c:239]:
 db_postgres_submit_query(): postgres query command failed, connection
 status 0, error [ERROR:  duplicate key value violates unique constraint
 pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
 from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
 Jun  3 15:10:06 243415  WARNING: db_postgres [km_dbase.c:235]:
 db_postgres_submit_query(): postgres result check failed with code 7
 (PGRES_FATAL_ERROR)
 Jun  3 15:10:06 243449  WARNING: db_postgres [km_dbase.c:239]:
 db_postgres_submit_query(): postgres query command failed, connection
 status 0, error [ERROR:  duplicate key value violates unique constraint
 pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
 from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
 Jun  3 15:10:06 244458  WARNING: db_postgres [km_dbase.c:235]:
 db_postgres_submit_query(): postgres result check failed with code 7
 (PGRES_FATAL_ERROR)
 Jun  3 15:10:06 244487  WARNING: db_postgres [km_dbase.c:239]:
 db_postgres_submit_query(): postgres query command failed, connection
 status 0, error [ERROR:  duplicate key value violates unique constraint
 pua_pua_idx#012DETAIL:  Key (etag, tuple_id, call_id,
 from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012]
 Jun  3 15:10:06 244504  ERROR: db_postgres [km_dbase.c:247]:
 db_postgres_submit_query(): 0x7f21476b1910 PQsendQuery Error: ERROR:
 duplicate key value violates unique constraint pua_pua_idx#012DETAIL:
 Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , )
 already exists.#012 Query: update kamailio.pua set
 expires=1401807715,cseq=0,etag='a.1401768964.671497.1902.6',desired_expires=1401811600,version=2
 where pres_uri='sip:2...@freguesiadearroios.govoice.pt' AND
 pres_id='dialog_publish.440163220-35219...@bjc.bgi.b.bai' AND flag=1024
 AND event=32
 Jun  3 15:10:06 244521  ERROR: core [db_query.c:337]: db_do_update():
 error while submitting query
 Jun  3 15:10:06 244548  ERROR: db_postgres [km_dbase.c:537]:
 db_postgres_store_result(): invalid query, execution aborted
 Jun  3 15:10:06 244560  ERROR: db_postgres [km_dbase.c:538]:
 db_postgres_store_result(): driver error: PGRES_FATAL_ERROR, ERROR:
 duplicate key value violates unique constraint pua_pua_idx#012DETAIL:
 Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , )
 already exists.#012
 Jun  3 15:10:06 244584  WARNING: db_postgres [km_dbase.c:647]:
 db_postgres_update(): unexpected result returned
 Jun  3 15:10:06 244591  ERROR: pua [pua.c:1076]: db_update(): while
 updating in database


 I've read the module documentation, but there isn't much documentation on
 it and i'm basically guessing and trying here.
 Can someone tell me what am i doing wrong or maybe what should a try to be
 able to persist the presence status in a postgres database.
 I know that i could use in memory persistence or other  type of DB, but i
 really want to know if i can use a normal postgres DB for presence
 persistence and what could be used to avoid key violations.

 Looking forward to hear from you.
 Best Regards,

 --

 *Nuno Miguel Reis* | *Unified Communication** Systems*
 M. +351 913907481 | nr...@wavecom.pt
 WAVECOM-Soluções Rádio, S.A.
 Cacia Park | Rua do Progresso, Lote 15
 3800-639 AVEIRO | Portugal
 T. +351 309 700 225 | F. +351 234 919 191
 *GPS
 http://maps.google.com/maps/ms?msa=0msid=202333747613191340808.0004b4b227a6144f0df88
 | www.wavecom.pt http://www.wavecom.pt/** http://www.wavecom.pt/*

 [image: Description: Description: WavecomSignature]
 http://www.wavecom.pt/pt/wavecom/premios.php

 [image: Publicity] http