Problem: Deleting a Scheduled Task Template Breaks Schedules

[NolanWelser]

Issue

Deleting a task template that has a schedule in the "Schedules" tab causes the schedules tab to break and only display a white screen. Backing up the project, deleting all schedules, and restoring resolves the issue. It is unclear if this prevents schedules from running or only affects the web view.

Impact

Service (scheduled tasks, alerts)

Installation method

Binary

Database

BoltDB

Browser

Chrome

Semaphore Version

2.12.14-685c726-1739570559

Ansible Version

Logs & errors

Apr 07 09:30:05  bash[1453]: time="2025-04-07T09:30:05-04:00" level=error msg="error at schedules[8]: template does not exist in templates[].name"
Apr 07 09:30:05  bash[1453]: time="2025-04-07T09:30:05-04:00" level=error msg="error at schedules[8]: template does not exist in templates[].name"
Apr 07 09:30:05  bash[1453]: goroutine 258 [running]:
Apr 07 09:30:05  bash[1453]: runtime/debug.Stack()
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/runtime/debug/stack.go:26 +0x5e
Apr 07 09:30:05  bash[1453]: runtime/debug.PrintStack()
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/runtime/debug/stack.go:18 +0x13
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api/helpers.WriteError({0x1b31928, 0xc0001975e0}, {0x1b2b080, 0xc000334c40})
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/helpers/helpers.go:122 +0x212
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api/projects.Restore({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/projects/backup_restore.go:70 +0x433
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0x1b31928?, {0x1b31928?, 0xc0001975e0?}, 0x0?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api.authentication.func1({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/auth.go:246 +0x57
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0xcb29e0?, {0x1b31928?, 0xc0001975e0?}, 0xc?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api.JSONMiddleware.func1({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/router.go:45 +0xf6
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0x0?, {0x1b31928?, 0xc0001975e0?}, 0x0?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api.StoreMiddleware.func1.1()
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/router.go:36 +0x28
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/db.StoreSession({0x1b432e0, 0xc0001c7808}, {0xc0008b4ad0, 0xc}, 0xc000a137e0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/db/Store.go:576 +0x5f
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api.StoreMiddleware.func1({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/api/router.go:35 +0x114
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0xc00027dcc0?, {0x1b31928?, 0xc0001975e0?}, 0xcce5e0?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/cli/cmd.runService.func1.1({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/cli/cmd/root.go:94 +0xea
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0x0?, {0x1b31928?, 0xc0001975e0?}, 0x410525?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/api.Route.CORSMethodMiddleware.func1.1({0x1b31928, 0xc0001975e0}, 0xc00027dcc0)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/mux/middleware.go:51 +0x89
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0xc0008d3b80?, {0x1b31928?, 0xc0001975e0?}, 0x70?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/gorilla/mux.(*Router).ServeHTTP(0xc000238780, {0x1b31928, 0xc0001975e0}, 0xc0008d3400)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/mux/mux.go:212 +0x1e2
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/cli/cmd.runService.ProxyHeaders.func3({0x1b31928, 0xc0001975e0}, 0xc0008d3400)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/vendor/github.com/gorilla/handlers/proxy_headers.go:59 +0x143
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0xc00090aab5?, {0x1b31928?, 0xc0001975e0?}, 0x1?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: github.com/semaphoreui/semaphore/cli/cmd.runService.cropTrailingSlashMiddleware.func5({0x1b31928, 0xc0001975e0}, 0xc0008d3400)
Apr 07 09:30:05  bash[1453]:         /home/runner/work/semaphore/semaphore/cli/cmd/server.go:27 +0xbd
Apr 07 09:30:05  bash[1453]: net/http.HandlerFunc.ServeHTTP(0x410525?, {0x1b31928?, 0xc0001975e0?}, 0xc000197501?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2220 +0x29
Apr 07 09:30:05  bash[1453]: net/http.serverHandler.ServeHTTP({0x1b2e808?}, {0x1b31928?, 0xc0001975e0?}, 0x6?)
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:3210 +0x8e
Apr 07 09:30:05  bash[1453]: net/http.(*conn).serve(0xc000a98000, {0x1b33910, 0xc000607830})
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:2092 +0x5d0
Apr 07 09:30:05  bash[1453]: created by net/http.(*Server).Serve in goroutine 1
Apr 07 09:30:05  bash[1453]:         /opt/hostedtoolcache/go/1.23.6/x64/src/net/http/server.go:3360 +0x485
Apr 07 09:31:43  bash[1453]: time="2025-04-07T09:31:43-04:00" level=error msg="no rows in result set" error="Bad request. Cannot get task from database"

Manual installation - system information

Linux 6.8.0-57-generic #59-Ubuntu SMP PREEMPT_DYNAMIC Sat Mar 15 17:40:59 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

Configuration

No response

Additional information

No response

[fiftin]

Fixed. Available in 2.14.0-rc1