We are using Ejabberd 17.04 with Mysql databse.
We are facing a recurring issue in which all the Ejabberd commands end as failure and after an interval of an hour or so all the commands start executing successfully.
Upon checking the log file, we have found the following logs.
@ejabberd_sql:check_error:1091 SQL query 'Q105780715' at {sql_queries,150} failed: <<"Failed sending data on socket : closed">>
2017-06-28 04:54:12.738 [info] <0.8912.0>@ejabberd_sql:log:925 Closing connection #Port<0.25194>: ok
2017-06-28 04:54:12.738 [error] <0.8911.0> gen_fsm <0.8911.0> in state session_established terminated with reason: closed
2017-06-28 04:54:12.738 [error] <0.8911.0> CRASH REPORT Process <0.8911.0> with 0 neighbours exited with reason: closed in p1_fsm:terminate/8 line 760
2017-06-28 04:54:12.739 [error] <0.374.0> Supervisor 'ejabberd_sql_sup_xmpp2.livecare.ca' had child 7 started with ejabberd_sql:start_link(<<"xmpp2.livecare.ca">>, 30000) at <0.8911.0> exit with reason closed in context child_terminated
