Scheduler out of database connections right after start

Infos:

  • Used Zammad version: 6
  • Used Zammad installation type: docker-compose
  • Operating system: Debian
  • Browser + version: n/a

Expected behavior:

  • Scheduler starts up and works correctly

Actual behavior:

zammad-scheduler-1  | starting background services...
zammad-scheduler-1  | I, [2024-05-25T08:09:10.792825 #1]  INFO -- : ActionCable is using the redis instance at redis://zammad-redis:6379.
zammad-scheduler-1  | I, [2024-05-25T08:09:10.827871#1-6180]  INFO -- : Using memcached as Rails cache store.
zammad-scheduler-1  | I, [2024-05-25T08:09:10.832425#1-6180]  INFO -- : Using the Redis back end for Zammad's web socket session store.
zammad-scheduler-1  | I, [2024-05-25T08:09:19.552104#1-6180]  INFO -- : Cleanup of left over locked delayed jobs 2024-05-25 08:09:19 UTC started.
zammad-scheduler-1  | I, [2024-05-25T08:09:19.552500#1-149020]  INFO -- : ProcessScheduledJobs running...
zammad-scheduler-1  | I, [2024-05-25T08:09:19.709131#1-6180]  INFO -- : Cleanup of left over locked delayed jobs 2024-05-25 08:09:19 UTC finished.
zammad-scheduler-1  | I, [2024-05-25T08:09:19.709315#1-6180]  INFO -- : Cleanup of left over import jobs 2024-05-25 08:09:19 UTC started.
zammad-scheduler-1  | I, [2024-05-25T08:09:19.719658#1-6180]  INFO -- : Cleanup of left over import jobs 2024-05-25 08:09:19 UTC finished.
zammad-scheduler-1  | I, [2024-05-25T08:09:19.822986#1-149080]  INFO -- : execute Ticket.process_pending (try_count 0)...
zammad-scheduler-1  | I, [2024-05-25T08:09:19.876100#1-149080]  INFO -- : ended Ticket.process_pending took: 0.199662434 seconds.
zammad-scheduler-1  | I, [2024-05-25T08:09:20.681238#1-149380]  INFO -- : execute Channel.stream (try_count 0)...
zammad-scheduler-1  | I, [2024-05-25T08:09:21.760854#1-149420]  INFO -- : execute ImportJob.start_registered (try_count 0)...
zammad-scheduler-1  | I, [2024-05-25T08:09:21.785452#1-149420]  INFO -- : ended ImportJob.start_registered took: 0.108235259 seconds.
zammad-scheduler-1  | I, [2024-05-25T08:09:22.682448#1-149480]  INFO -- : execute Sessions.jobs (try_count 0)...
zammad-scheduler-1  | E, [2024-05-25T08:09:28.681041#1-150320] ERROR -- : execute Ticket.process_auto_unassign (try_count 0) exited with error #<ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use> in: 5.000403256 seconds.
zammad-scheduler-1  | E, [2024-05-25T08:09:29.678914#1-150360] ERROR -- : execute ExternalCredential::Exchange.refresh_token (try_count 0) exited with error #<ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use> in: 5.000364595 seconds.
zammad-scheduler-1  | E, [2024-05-25T08:09:30.679601#1-150380] ERROR -- : execute Channel.fetch (try_count 0) exited with error #<ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use> in: 5.000393453 seconds.
zammad-scheduler-1  | E, [2024-05-25T08:09:31.680074#1-150400] ERROR -- : execute SessionTimeoutJob.perform_now (try_count 0) exited with error #<ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use> in: 5.000399147 seconds.

The ActiveRecord error messages continue, seemingly never recovering.

This install has been running for about 9 months.

Steps to reproduce the behavior:

  • no idea

Closing as duplicate of