Wed Aug 16 100314 CST 2023 jobserver critical Error creating jobcontroller database disk image is malformeddatabase disk image is malformed while executing$my_dbh eval DELETE FROM taskdata WHERE t

The error message suggests that there is a problem with the database disk image. Specifically, it mentions that the database disk image is malformed. This error occurs while trying to create a jobcontroller.

The error occurs in the following line of code:

$my_dbh eval "DELETE FROM taskdata WHERE task IN (SELECT id FROM task WHERE status = 'finished')"

It seems that there is an issue with the SQL query being executed. It is trying to delete records from the "taskdata" table where the corresponding task has a status of "finished". However, the database disk image is malformed, causing this operation to fail.

The error is then propagated to other parts of the code, resulting in the error message you provided.

To resolve this issue, you will need to repair the database disk image. This can be done using appropriate database management tools or by restoring from a backup if available. Once the database is repaired, the jobcontroller should be able to be created successfully