2021-11-05 11:03:04.120385+01:00 [error] <0.30995.46>@ejabberd_sql:check_error/2:1237 SQL query 'delete from archive where timestamp < 1636106525119628 and server_host='wh-ejabberd-9.vianova.it'' failed: <<"quer
y timed out">>
2021-11-05 11:03:04.120749+01:00 [error] <0.31004.46>@ejabberd_sql:log/3:1082 p1_mysql_conn: p1_mysql_recv: received close

2021-11-05 11:03:04.120715+01:00 [error] <0.30995.46>@ejabberd_sql:check_error/2:1230 SQL query 'Q90282885' at {mod_mam_sql,80} failed: <<"query timed out">>
2021-11-05 11:03:04.121127+01:00 [error] <0.30995.46> ** State machine 'ejabberd_sql_wh-ejabberd-9.vianova.it_9' terminating
** Last message in was {'$gen_sync_event',
                           {<0.20938.52>,#Ref<0.2366414176.2647654401.19313>},
                           {sql_cmd,
                               {sql_query,
                                   {sql_query,<<"Q90282885">>,
                                       #Fun<mod_mam_sql.24.73493614>,
                                       #Fun<mod_mam_sql.25.73493614>,
                                       #Fun<mod_mam_sql.26.73493614>,
                                       {mod_mam_sql,80}}},
                               -576396018030}}
** When State == session_established
**      Data  == {state,<0.31004.46>,mysql,undefined,
                        <<"wh-ejabberd-9.vianova.it">>,
                        {{[],[]},0,unlimited},
                        undefined}
** Reason for termination =
** timeout

2021-11-05 11:03:04.120865+01:00 [error] <0.31004.46>@ejabberd_sql:log/3:1082 p1_mysql_conn: Connection closed, exiting.
2021-11-05 11:03:04.122148+01:00 [info] <0.31004.46>@ejabberd_sql:log/3:1081 Closing connection {gen_tcp,#Port<0.1016691>}: ok

2021-11-05 11:03:04.122501+01:00 [error] <0.30995.46>@proc_lib:crash_report/4:525 CRASH REPORT:
  crasher:
    initial call: ejabberd_sql:init/1
    pid: <0.30995.46>
    registered_name: 'ejabberd_sql_wh-ejabberd-9.vianova.it_9'
    exception exit: timeout
      in function  p1_fsm:terminate/8 (p1_fsm.erl, line 760)
    ancestors: ['ejabberd_sql_sup_wh-ejabberd-9.vianova.it',ejabberd_db_sup,
                  ejabberd_sup,<0.120.0>]
    message_queue_len: 3
    messages: [{'$gen_sync_event',
                      {<0.20960.52>,#Ref<0.2366414176.2647654401.62983>},
                      {sql_cmd,{sql_query,[<<"SELECT 1;">>]},-576395989170}},
                  {fetch_result,#Ref<0.2366414176.2647654401.19314>,
                      <0.31004.46>,
                      {error,
                          {p1_mysql_result,[],[],0,
                              "p1_mysql_recv: socket was closed"}}},
                  {'EXIT',<0.31004.46>,normal}]
    links: [<0.360.0>,<0.358.0>]
    dictionary: [{ejabberd_sql_nesting_level,0},
                  {'$internal_queue_len',0},
                  {ejabberd_sql_state,
                      {state,<0.31004.46>,mysql,undefined,
                          <<"wh-ejabberd-9.vianova.it">>,
                          {{[],[]},0,unlimited},
                          undefined}}]
    trap_exit: true
    status: running
    heap_size: 6772
    stack_size: 28
    reductions: 136630970
  neighbours:

2021-11-05 11:03:04.127786+01:00 [error] <0.20960.52>@ejabberd_sql:keep_alive/2:160 Keep alive query failed, closing connection: {error,timeout}
2021-11-05 11:03:04.127727+01:00 [error] <0.358.0>@supervisor:do_restart/3:719 SUPERVISOR REPORT:
    supervisor: {local,'ejabberd_sql_sup_wh-ejabberd-9.vianova.it'}
    errorContext: child_terminated
    reason: timeout
    offender: [{pid,<0.30995.46>},
               {id,9},
               {mfargs,{ejabberd_sql,start_link,
                                     [<<"wh-ejabberd-9.vianova.it">>,9]}},
               {restart_type,transient},
               {shutdown,2000},
               {child_type,worker}]