[ejabberd] ejabberd_odbc, mysql connection dropped

Jean-Manuel Da Silva dasilvj at gmail.com
Mon Jul 27 17:18:46 MSD 2009


Hi,

I've came last night on the ejabberd chatroom, but no one got a response
for me and said to me to post on that mailing list.

So, here come my problem:
Every 7 hours approximately, my five ejabberd processes receive an unknown
signal and drop their connections to MySQL. So users can't connect anymore
(I use an external auth and a MySQL database). At this moment, with an
"ejabberdctl status", I can see that my ejabberd still running...
but no one can get an auth. I have to restart him to get him working back.

I really don't know what to do about this... so...
Is there anyone who have already got the same issue,
or someone with an idea about this ?

Some specs:
- ejabberd 2.0.5
- mysql module, r952 (fresh compiled from SVN).
  As you can see on the repository log, the r951 look very interesting:

------------------------------------------------------------------------
r923 | jsautret | 2009-03-18 18:12:01 +0100 (Wed, 18 Mar 2009) | 2 lines

* mysql/src/mysql_conn.erl: set "unknown signal" debug message to error.



- Here traces from my ejabberd.log file:

=ERROR REPORT==== 2009-07-20 18:06:09 ===
E(<0.278.0>:ejabberd_odbc:351) : mysql_conn: Received unknown signal,
exiting : {mysql_recv,

    <0.279.0>,

    closed,

    normal}

=INFO REPORT==== 2009-07-20 18:06:09 ===
I(<0.278.0>:ejabberd_odbc:349) : Closing connection #Port<0.398>: ok


=ERROR REPORT==== 2009-07-20 18:06:09 ===
** Generic server <0.277.0> terminating
** Last message in was {'DOWN',#Ref<0.0.0.8794>,process,<0.278.0>,normal}
** When Server state == {state,<0.278.0>,mysql}
** Reason for termination ==
** connection_dropped

=ERROR REPORT==== 2009-07-20 18:06:09 ===
E(<0.272.0>:ejabberd_odbc:351) : mysql_conn: Received unknown signal,
exiting : {mysql_recv,

    <0.273.0>,

    closed,

    normal}

=INFO REPORT==== 2009-07-20 18:06:09 ===
I(<0.272.0>:ejabberd_odbc:349) : Closing connection #Port<0.396>: ok


=ERROR REPORT==== 2009-07-20 18:06:09 ===
** Generic server <0.271.0> terminating
** Last message in was {'DOWN',#Ref<0.0.0.8784>,process,<0.272.0>,normal}
** When Server state == {state,<0.272.0>,mysql}
** Reason for termination ==
** connection_dropped




Thanks for you help.
[Sorry for my english, I hope that this mail still readable] :>
--
J. Da Silva
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20090727/26846514/attachment.html>


More information about the ejabberd mailing list