Workflows Missing in Community Edition

Questions
1

We are running a self-hosted community edition on a digital ocean droplet that we setup with a one-click installer from their marketplace.

On two occasions, all workflows from non-admin users were moved from the user over to the admin account such that upon login - individual users saw no workflows and the admin user had all workflows.

The first time this happened was when we followed digital ocean / N8N update procedures. The second time this happened was yesterday. No updates were done.

I’m curious if this has happened to others and, if so, how they solved this issue.

We’re running v 1.18.1

Community self hosted through digital ocean droplet with 2 GB Memory / 2 Intel vCPUs / 90 GB Disk / SFO2 - n8n 1.110.1 on Ubuntu 24.04.

2

This sounds like a database permission issue where workflows are being incorrectly reassigned. Here’s what to check:

- Verify database user permissions (ensure non-admin users have proper read/write access)

- Check the `workflow_entity` table in your database for incorrect owner assignments

- Consider backing up workflows and reinstalling with proper permissions

For immediate help, you might want to check the n8n logs for any permission-related errors during the times this occurred.