[OpenSIPS-Devel] [ opensips-Bugs-2431561 ] Crash at start due to presence module

Fri Dec 19 00:25:31 CET 2008

Bugs item #2431561, was opened at 2008-12-15 20:20
Message generated for change (Comment added) made by ibc_sf
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2431561&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Iñaki Baz (ibc_sf)
Assigned to: Anca Vamanu (anca_vamanu)
Summary: Crash at start due to presence module

Initial Comment:
I've a OpenSIPS just acting as a presence server. Presence related tables (MySQL) are emptied before I run OpenSIPS.

OpenSIPS starts and I run a SIP client which sends some PUBLISH and SUBSCRIBE.

After it OpenSIPS crashes. It occurs very often when doing the above scenario.

I attach the log (devel 4) and the output of "gdb bt" and "gdb bt full" from the coredump file.

PD: Note also that there are several ERROR about "db_mysql", but that is part of other bug.

----------------------------------------------------------------------

>Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-19 00:25

Message:
ok, then the only explanation is that yesterday in the night I fixed the
code asleep XD

----------------------------------------------------------------------

Comment By: Dan (dan_pascu)
Date: 2008-12-19 00:09

Message:
Also, for the record, the fix in rev 5060 and 5061 was for a crash in the
dialog module when it tried to load more than 128 dialogs at startup with a
db driver that supports FETCH mode.

----------------------------------------------------------------------

Comment By: Dan (dan_pascu)
Date: 2008-12-19 00:03

Message:
It was NOT fixed by my commit. I made a joke on the list, which was taken
seriously. Jus tfor the record rev5060 & 5061 have nothing to do with
this...

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-18 23:57

Message:
The issue seems to be fixed thanks to Dan commit (rev TRUNK 5060):

http://opensips.svn.sourceforge.net/viewvc/opensips?view=rev&revision=5060

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-18 22:35

Message:
Hi Anca, I'm realy surprised!

Yesterday I upgraded to trunk rev 5062 (before the commit about notify.c
you mean, that is rev 5066).
Since yesterday I've not got the ERROR:db_mysql anymore!
I don't see more commits those days related to presence modules (maybe
db_mysql related)?

I've done exactly the same as other days and I've changeg absolutelly
nothing in my system (MySQL and so), just upgraded to rev 5062.

It seems that the issue is solved but I don't know "where" :)

----------------------------------------------------------------------

Comment By: Anca Vamanu (anca_vamanu)
Date: 2008-12-18 13:29

Message:
Hi,

Dan has discovered a buffer overflow bug that I introduced recently in
presence. Maybe it is related to the crash that you got.
Can you please update and test again?

regards,
Anca

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-16 18:04

Message:
I'm trying now MySQL server in Debian Lenny:

  mysql-server-5.0   5.0.51a-18

and the same error occurs all the time.

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-16 16:40

Message:
Hi Anca, this is my MySQL version running on Debian Etch 64 bits:

  ii  libmysqlclient15-dev              5.0.32-7etch8
  ii  libmysqlclient15off               5.0.32-7etch8
  ii  mysql-common                      5.0.32-7etch8
  ii  mysql-server-5.0                  5.0.32-7etch6

Do you know which versions are working without this issue? I would like to
try them. Anyway I expect that lot of people are using Debian Etch with
Debian MySQL package.

PD: I also wonder why just thepresence module process gest this MySQL
error and no other modules which also access to MySQL (as usrloc,
registrar, pua, dialog...), could be any reason for it? Of course it's the
same database for all.

Thanks.

----------------------------------------------------------------------

Comment By: Anca Vamanu (anca_vamanu)
Date: 2008-12-16 13:45

Message:
Hi Inaki,

PD: Note also that there are several ERROR about "db_mysql", but that is
part of other bug.

This is in fact very much related, because the crash occures when
accessing the data retreived from a database query.
I am thinking that your issue is related to the version of mysql that you
use - since it does not happen for others. 

regards,
Anca

----------------------------------------------------------------------

Comment By: Anca Vamanu (anca_vamanu)
Date: 2008-12-16 13:45

Message:
Hi Inaki,

PD: Note also that there are several ERROR about "db_mysql", but that is
part of other bug.

This is in fact very much related, because the crash occures when
accessing the data retreived from a database query.
I am thinking that your issue is related to the version of mysql that you
use - since it does not happen for others. 

regards,
Anca

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-12-15 20:20

Message:
File Added: opensips_presence_crash_startup_COREDUMP_gdb

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2431561&group_id=232389