Problem: After migration (from boltdb) Tasks cannot be run, error 500

Issue

After updating semaphore to 2.18.4 everything works. But we are on BoltDB and want to migrate.

Both migration to SQLite and PostgreSQL result in the same output when migrating, and same error when running tasks.

... No errors before this ... Importing Event 100% Errors: 10 Importing Role 100% Importing TemplateRole 100% Importing IntegrationExtractValue 100% Importing IntegrationAlias 100% Importing TemplateVault 100% Migration finished successfully.

Semaphore starts ok, and I am able to login, but I notice alot of tasks are "Not Launched" and when I try and run a Task I get "Request failed with status code 500" and the error in journalctl below (same error if I try and clone this task and run it 'fresh')

May 27 13:47:51 semaphore-test**** semaphore[5893]: time="2026-05-27T13:47:51+02:00" level=info msg="Task status updated" context=task_logger status=error task_id=178 May 27 13:47:51 semaphore-test***** semaphore[5893]: time="2026-05-27T13:47:51+02:00" level=error msg="Cannot add task" context=AddTask error="no rows in result set" project_id=3 template_id=11 user_id=4

Impact

Ansible (task execution)

Installation method

Package

Database

Postgres

Browser

Chrome

Semaphore Version

2.18.4-7ca373d-1779131064

Ansible Version

Logs & errors

No response

Manual installation - system information

No response

Configuration

No response

Additional information

No response