Decoding SQL time outs - Githubissues

licaon-kter commented 2 years ago

Environment

ejabberd version: 6b0fa44386709151bb48ad9284a060888b7c5c54
Erlang version: 23.2.6 / Erlang (SMP,ASYNC_THREADS) (BEAM) emulator version 11.1.8
OS: Debian Bullseye arm64
Installed from: source
Database: Postgresql 11.12

From postgresql.log and ejabberd.log interleaved, those with ejabberd@ejabberd are from postgresql

While the device is not crazy fast I keep seeing time outs in ejabberd.log as if Postgresql has issues keeping up with the queries.

As @weiss recommended in the support room, I've setup log_min_duration_statement to 250ms in Postgresql to have it log any slower ones.

badlop commented 1 year ago

What to do with this issue?

licaon-kter commented 1 year ago

Find out why it "times out" for those SQL queries 'Q????????' I guess as those are marked as errors.

Is my db broken? Are the queries broken? etc