Hello,
I currently have ejabberd installed using with ODBC enabled. It's connected to Google Cloud SQL (GCSQL) but I don't think the fact I'm using GCSQL is the root of my problems.
Here's what's happening:
The system seems to be working fine, and suddenly (I'm sure there's a reason but I don't know yet) I receive the following error messages on my log:
2014-10-27 00:00:18.088 [error] <0.31800.0>@ejabberd_odbc:log:580 p1_mysql_conn: p1_mysql_recv: socket was closed {<0.31801.0>,normal}
2014-10-27 00:02:22.852 [error] <0.31903.0>@ejabberd_odbc:log:580 p1_mysql_conn: p1_mysql_recv: socket was closed {<0.31904.0>,normal}
2014-10-27 00:02:29.194 [error] <0.31902.0> gen_fsm <0.31902.0> in state session_established terminated with reason: closed
2014-10-27 00:02:29.194 [error] <0.31903.0>@ejabberd_odbc:log:580 p1_mysql_conn: Received close signal, exiting.
2014-10-27 00:02:29.194 [error] <0.31902.0> CRASH REPORT Process <0.31902.0> with 0 neighbours exited with reason: closed in p1_fsm:terminate/8 line 759
2014-10-27 00:02:29.194 [error] <0.344.0> Supervisor 'ejabberd_odbc_sup_versapp.co' had child 4 started with ejabberd_odbc:start_link(<<"[my host here...]">>, 30000) at <0.31902.0> exit with reason closed in context child_terminated
2014-10-27 00:02:29.340 [error] <0.31919.0>@ejabberd_odbc:log:580 p1_mysql_conn: p1_mysql_recv: socket was closed {<0.31920.0>,normal}
2014-10-27 00:02:29.369 [error] <0.31918.0> gen_fsm <0.31918.0> in state session_established terminated with reason: closed
2014-10-27 00:02:29.369 [error] <0.31918.0> CRASH REPORT Process <0.31918.0> with 0 neighbours exited with reason: closed in p1_fsm:terminate/8 line 759
2014-10-27 00:02:29.369 [error] <0.31919.0>@ejabberd_odbc:log:580 p1_mysql_conn: Received close signal, exiting.
2014-10-27 00:02:29.370 [error] <0.344.0> Supervisor 'ejabberd_odbc_sup_versapp.co' had child 9 started with ejabberd_odbc:start_link(<<"[my host here....]">>, 30000) at <0.31918.0> exit with reason closed in context child_terminated
2014-10-27 00:02:29.594 [error] <0.31850.0>@ejabberd_odbc:log:580 p1_mysql_conn: p1_mysql_recv: socket was closed {<0.31851.0>,normal}
Then users can't connect to ejabberd for a while. After trying to reconnect multiple times, users are finally able to. It's like all connections with the MySQL server drop and then reopen. But why are they dropping?
Have you guys experienced a similar problem?
Thank you so much for your time! I hope this helps others out there with the same problem.
Thanks again!
Sincerely,
Will
My ejabberd have met the same
My ejabberd have met the same problem,I can only restart it to deal with it.
And my ejabberd version is 14.07.