Joex: SQL Failure after upgrading from 0.32 to 0.34 #1468
Description
Hey,
i think I found another SQL Bug on Version 0.34 (and maybe 0.33). I updated from 0.32 to 0.34 and it seems that its not #1436
2022.03.22 23:38:12:0000 [io-comp...] [ERROR] docspell.store.impl.DoobieMeta - SQL Failure: ExecFailure(INSERT INTO periodic_task (id, enabled, task, group_, args, subject, submitter, priority, worker, marked, timer, nextrun, created, summary) VALUES (?,?,?,?,?, ?,?,?,?, ?,?,?,?,? ),List(Ident(docspell-houskeeping), true, Ident(housekeeping), Ident(docspell-system), {}, Docspell house-keeping, Ident(docspell-system), Low, None, None, CalEvent(List(Vector(Single(Sun))),DateEvent(All,All,All),TimeEvent(List(Vector(Single(0,None))),List(Vector(Single(0,None))),List(Vector(Single(0,None)))),None), Timestamp(2022-03-27T00:00:00Z), Timestamp(2022-03-22T22:38:12.379339298Z), Some(Docspell house-keeping)),21506285 nanoseconds,org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »periodic_task_pkey«
Detail: Schlüssel »(id)=(docspell-houskeeping)« existiert bereits.)
2022.03.22 23:38:12:0000 [io-comp...] [ERROR] docspell.store.impl.DoobieMeta - SQL Failure: ExecFailure(INSERT INTO periodic_task (id, enabled, task, group_, args, subject, submitter, priority, worker, marked, timer, nextrun, created, summary) VALUES (?,?,?,?,?, ?,?,?,?, ?,?,?,?,? ),List(Ident(docspell-update-check), false, Ident(new-release-check), Ident(docspell-system), {}, Docspell Update Check, Ident(docspell-system), Low, None, None, CalEvent(List(Vector(Single(Sun))),DateEvent(All,All,All),TimeEvent(List(Vector(Single(0,None))),List(Vector(Single(0,None))),List(Vector(Single(0,None)))),None), Timestamp(2022-03-27T00:00:00Z), Timestamp(2022-03-22T22:38:12.603191983Z), Some(Docspell Update Check)),1964913 nanoseconds,org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »periodic_task_pkey«
Detail: Schlüssel »(id)=(docspell-update-check)« existiert bereits.)