Problem: project restore fails

[steadfasterX]

Issue

when restoring a project it aborts with error:

Request failed with status code 400

the journal states:

Jan 06 09:56:20 ansible semaphore[110926]: time="2025-01-06T09:56:20Z" level=error msg="error at templates[0]: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`semaphore`.`project__template_vault`, CONSTRAINT `project__template_vault_ibfk_3` FOREIGN KEY (`vault_key_id`) REFERENCES `access_key` (`id`) ON DELETE CASCADE)"

Jan 06 09:56:20 ansible semaphore[110926]: goroutine 49 [running]:
Jan 06 09:56:20 ansible semaphore[110926]: runtime/debug.Stack()
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/runtime/debug/stack.go:26 +0x5e
Jan 06 09:56:20 ansible semaphore[110926]: runtime/debug.PrintStack()
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/runtime/debug/stack.go:18 +0x13
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api/helpers.WriteError({0x1b159a8, 0xc000544000}, {0x1b0f1e0, 0xc00020ae90})
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/helpers/helpers.go:122 +0x212
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api/projects.Restore({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/projects/backup_restore.go:70 +0x433
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0x1b159a8?, {0x1b159a8?, 0xc000544000?}, 0x0?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api.authentication.func1({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/auth.go:177 +0x57
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0xc9ca60?, {0x1b159a8?, 0xc000544000?}, 0xc?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api.JSONMiddleware.func1({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/router.go:45 +0xf6
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0xbe0400?, {0x1b159a8?, 0xc000544000?}, 0x7c144c?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api.StoreMiddleware.func1.1()
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/router.go:36 +0x28
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/db.StoreSession({0x1b26840, 0xc0000727f0}, {0xc000406270, 0xc}, 0xc0001717e0)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/db/Store.go:572 +0x5f
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api.StoreMiddleware.func1({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/api/router.go:35 +0x114
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0xc000414640?, {0x1b159a8?, 0xc000544000?}, 0xcb8b20?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/cli/cmd.runService.func1.1({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/cli/cmd/root.go:94 +0xea
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0x0?, {0x1b159a8?, 0xc000544000?}, 0x410665?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/api.Route.CORSMethodMiddleware.func1.1({0x1b159a8, 0xc000544000}, 0xc000414640)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/mux/middleware.go:51 +0x89
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0xc0004143c0?, {0x1b159a8?, 0xc000544000?}, 0x70?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/gorilla/mux.(*Router).ServeHTTP(0xc00029c300, {0x1b159a8, 0xc000544000}, 0xc000414140)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/mux/mux.go:212 +0x1e2
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/cli/cmd.runService.ProxyHeaders.func3({0x1b159a8, 0xc000544000}, 0xc000414140)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/handlers/proxy_headers.go:59 +0x143
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0xc0002a8095?, {0x1b159a8?, 0xc000544000?}, 0x1?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: github.com/semaphoreui/semaphore/cli/cmd.runService.cropTrailingSlashMiddleware.func5({0x1b159a8, 0xc000544000}, 0xc000414140)
Jan 06 09:56:20 ansible semaphore[110926]:         /home/runner/work/semaphore/semaphore/cli/cmd/server.go:27 +0xbd
Jan 06 09:56:20 ansible semaphore[110926]: net/http.HandlerFunc.ServeHTTP(0x410665?, {0x1b159a8?, 0xc000544000?}, 0xc000544001?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2220 +0x29
Jan 06 09:56:20 ansible semaphore[110926]: net/http.serverHandler.ServeHTTP({0x1b128c8?}, {0x1b159a8?, 0xc000544000?}, 0x6?)
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:3210 +0x8e
Jan 06 09:56:20 ansible semaphore[110926]: net/http.(*conn).serve(0xc000528000, {0x1b17990, 0xc0002b8150})
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:2092 +0x5d0
Jan 06 09:56:20 ansible semaphore[110926]: created by net/http.(*Server).Serve in goroutine 1
Jan 06 09:56:20 ansible semaphore[110926]:         /opt/hostedtoolcache/go/1.23.4/x64/src/net/http/server.go:3360 +0x485

the project was backed up with semaphore version 2.12.0-beta3-f5746b2-1736110750 and the restore attempt was made on the exact same version.

Impact

Web-Frontend (what users interact with), Database

Installation method

Binary

Database

MySQL

Browser

Chrome

Semaphore Version

2.12.0-beta3-f5746b2-1736110750

Ansible Version

No response

Logs & errors

Manual installation - system information

Alma Linux 9

Configuration

No response

Additional information

No response