Appsignal error [https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10](https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10)

### Analysis

In our cloud infrastructure, seeding fails for aws-de-vips5 in unexpected ways: in the non-tenant schema, for some reasons, there are no workflows in the database. When seeding happens, it tries to add the default workflows necessary for demo projects. When doing it looks up some reference it has not created and fails.

For aws-de-trials2, it seems to happen on tenants for the same Begin of the insertionreason: one of the tenant does not have any workflows defined. That's how it happened: 3 new statuses were created (because they have ids 15, 16, and 17), and then all previous statuses got deleted. As a side effect, it deleted all workflows which depended on the deleted statuses. They probably didn't figure out that workflows were needed to be able to use OpenProject correctly.End of the insertion Begin of the deletion reason. Investigation in progress.End of the deletion

### Steps to reproduce

Begin of the insertion2 ways to reproduce it. The second one is more reproducable.

End of the insertion 1. for aws-de-vips5

1. Seed a first time

2. Manually delete all workflows from database

3. Seed a second time => failure

2. for aws-de-trials2

1. Begin of the insertionDelete all demo projects so that you have no projects

2. Create 1 new work package status that you set as default

3. Delete all other work package statuses (that's why it was necessary to delete all projects: to delete the work packages which depended on these statuses)

1. Now all workflows have been deleted

4. Seed => failureEnd of the insertion Begin of the deletion investigation in progressEnd of the deletion


### What is the buggy behavior?

* seeding should never fail


### What is the expected behavior?

1. Either fix the seeding for this particular case

2. Or disable seeding for non-tenant schema (public schema) to fix vips5 seeding


### **Logs**

See AppSignal errors:

* on **aws-de-trials2**: [https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/879](https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/879)

* on **aws-de-vips5**: [https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10](https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10)


Occured during deployment of 16.1.1 on 2025-06-26. Other shards did not report any errors.

Sample from vips5 [https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10/samples/681379ae55b0b20ed3735994-733312623961102186817509330201](https://appsignal.com/openproject-gmbh/sites/681379ae55b0b20ed3735994/exceptions/incidents/10/samples/681379ae55b0b20ed3735994-733312623961102186817509330201)

**Backtrace**

```text
app/seeders/source/seed_data.rb:67 Source::SeedData#find_reference
app/seeders/source/seed_data.rb:72 block in Source::SeedData#find_references
app/seeders/source/seed_data.rb:72 Array#map
app/seeders/source/seed_data.rb:72 Source::SeedData#find_references
app/seeders/basic_data/workflow_seeder.rb:68 block in BasicData::WorkflowSeeder#workflows
app/seeders/basic_data/workflow_seeder.rb:66 Array#map
app/seeders/basic_data/workflow_seeder.rb:66 BasicData::WorkflowSeeder#workflows
app/seeders/basic_data/workflow_seeder.rb:51 BasicData::WorkflowSeeder#seed_workflows
app/seeders/basic_data/workflow_seeder.rb:40 BasicData::WorkflowSeeder#seed_data!
app/seeders/seeder.rb:57 block in Seeder#seed!
app/models/journal/notification_configuration.rb:43 Journal::NotificationConfiguration.with
app/seeders/seeder.rb:99 Seeder#without_notifications
app/seeders/seeder.rb:56 Seeder#seed!
app/seeders/composite_seeder.rb:42 block in CompositeSeeder#seed_with
app/seeders/composite_seeder.rb:40 Array#each
app/seeders/composite_seeder.rb:40 CompositeSeeder#seed_with
app/seeders/composite_seeder.rb:30 block in CompositeSeeder#seed_data!
app/seeders/composite_seeder.rb:29 CompositeSeeder#seed_data!
app/seeders/seeder.rb:57 block in Seeder#seed!
app/models/journal/notification_configuration.rb:43 Journal::NotificationConfiguration.with
app/seeders/seeder.rb:99 Seeder#without_notifications
app/seeders/seeder.rb:56 Seeder#seed!
app/seeders/root_seeder.rb:133 RootSeeder#seed_basic_data
modules/bim/lib/open_project/bim/patches/root_seeder_patch.rb:12 OpenProject::Bim::Patches::RootSeederPatch::InstanceMethods#seed_basic_data
app/seeders/root_seeder.rb:71 RootSeeder#do_seed!
app/seeders/root_seeder.rb:63 block (3 levels) in RootSeeder#seed_data!
app/seeders/root_seeder.rb:62 block (2 levels) in RootSeeder#seed_data!
```

Note that this error occurred previously in other forms, and were fixed in #62582 (of which <mention class="mention" data-id="63826" data-type="work_package" data-text="#63826">#63826</mention> is a duplicate) and #64711.

### Environment information

**OpenProject installation type**

* Hosted cloud edition


**OpenProject version**

Upgrade from 16.1.0 to 16.1.1