Dashboard/Reports stuck since Sept 11 – no stats jobs after upgrade (CE, Ubuntu 22.04)

Technical assistance
1

Infos:

  • Used Zammad version: 6.5.2 (package)
  • Used Zammad installation type: DEB package (on-prem)
  • Operating system: Ubuntu 22.04.4 LTS
  • Browser + version: Chrome / Edge (latest)

Expected behavior:

  • Dashboard/Reports should aggregate tickets until the current date.
  • stats jobs should be visible in Delayed Job queue and processed by the worker.

Actual behavior:

  • Ticket overviews show correct current tickets (e.g. created today).
  • Dashboard/Reports freeze at September 11, 2025.
  • In Delayed Job queue, there are only "default" and "scheduler" queues – no stats jobs.
  • Worker logs show no stats activity.

Steps to reproduce the behavior:

  1. Upgrade system (Ubuntu & Zammad) – PostgreSQL was stopped during upgrade, apt install failed initially.
  2. Restarted PostgreSQL and fixed installation with apt --fix-broken install.
  3. Web UI showed missing assets (application.css not present) → fixed by:
sudo zammad run rake assets:precompile
sudo systemctl restart zammad zammad-web zammad-worker
  1. Zammad web UI now loads fine, tickets are working.
  2. Dashboard/Reports remain frozen at Sept 11.
  3. Tried:
sudo zammad run rails r "StatsStore.delete_all"
sudo systemctl restart zammad-worker
sudo zammad run rails r "puts Delayed::Job.group(:queue).count"

→ Output only shows {"default"=>..., "scheduler"=>...}
7. Suspected migrations not fully applied → planning to run:

cd /opt/zammad
sudo -u zammad bundle exec rake db:migrate
2

Did you rebuild the searchindex?

sudo zammad run rake zammad:searchindex:rebuild