Flows list is empty after upgrade, but webhooks/runs still work (self-hosted on Coolify)

Hi! I’m running Activepieces self-hosted on Coolify and after an upgrade my instance is in a weird state:

  • The Flows page shows No flows found.
  • On the left sidebar I still see the correct folder + flow counters (e.g. “All flows 29”, “allsign events 5”, etc.).
  • My existing flows still run correctly: when I hit my webhooks / events, the automations execute and I can see new entries in the Runs tab.

So the flows definitely exist in the database, but the list endpoint / UI is not showing them.

What I changed

  1. I updated my Activepieces service in Coolify and it pulled a newer image.
  2. The Postgres container started failing with this error:

in 18+, these Docker images are configured to store database data in a format which is compatible with “pg_ctlcluster”…
Counter to that, there appears to be PostgreSQL data in: /var/lib/postgresql/data
This looks like the classic Postgres 18 + existing data dir problem (data was originally created on an older Postgres).

  1. To fix that I:
  • Pinned Postgres to a specific version (for now I’m using postgres:17, so it can read the existing data dir again).
  • For Activepieces I set an explicit tag instead of latest, e.g.:
ghcr.io/activepieces/activepieces:0.72.4
  1. After that, the stack comes up fine, Postgres is healthy, Activepieces starts, webhooks work and runs are created.

But now the Flows list is empty, even though the folders and run history clearly “know” the flows are there.

Current symptoms

  • Flows sidebar shows the correct number of flows per folder.
  • Main table in Flows tab always shows “No flows found”.
  • Existing webhooks still point to valid flows and run successfully.
  • The issue started right after the image / Postgres version changes above.
    I will share my browser console with current errors:

Questions

  1. Is this a known issue when:
  • upgrading Activepieces and Postgres, and then
  • pinning tags (possibly after migrations already ran)?
  1. Is there any recommended combination of image tags (Activepieces + Postgres) for an existing database created on older versions?
  2. Is there any manual migration / repair step I can run to make the flows list work again without losing my existing flows?
  3. As a last resort, is there a documented way to export flows from the database (given that they still run) and re-import them into a clean instance?

Any guidance would be really appreciated – my automation stack depends 100% on this instance, so I’d like to fix it properly without losing data.

Hi @binaryme

The issue seems in listing flows endpoint, the data is there.

Consider upgrading to activepieces versions · activepieces · GitHub

I think it includes the fix, we will do offical release soon.

@abuaboud I’m having the same issue after upgrading - 0 flows or anything displayed in UI but existing webhook is triggering as it should.

Upgrading to the 0.73.0-rc.1 didn’t fix issue.