PetschStudios/KanbanGit
3
0
Fork 0
Code Issues Pull Requests 2 Actions Packages Projects Releases 24 Wiki Activity

Fix KAN-64 project deletion on MariaDB #176

Merged
Twyco merged 1 commits from fix/KAN-64-project-delete-response into main 2026-10-02 10:17:20 +00:00
Conversation 0 Commits 1 Files Changed 2
+4
Twyco commented 2026-10-01 20:45:45 +00:00
Owner
Copy Link
Copy Source

Problem

Deleting a project with ticket statuses returns HTTP 500 on MariaDB. The project delete cascades through board columns and statuses at the same time, causing a foreign key violation. The desktop app then displays its generic server response error.

Fix

Delete the project's ticket statuses within the existing transaction before deleting the project. The database can then cascade the remaining project data without conflicting with the status-to-board-column relation.

Verification

  • Reproduced the production SQLSTATE 23000 error with the existing project deletion test against an isolated local MariaDB 11.4 database before the fix.
  • ProjectControllerTest: 27 tests passed on MariaDB and 27 tests passed with the default SQLite configuration.
  • ProjectApiTest delete case: passed on MariaDB.
  • Pint and git diff checks passed.

No production project deletion or production database write was performed.

## Problem Deleting a project with ticket statuses returns HTTP 500 on MariaDB. The project delete cascades through board columns and statuses at the same time, causing a foreign key violation. The desktop app then displays its generic server response error. ## Fix Delete the project's ticket statuses within the existing transaction before deleting the project. The database can then cascade the remaining project data without conflicting with the status-to-board-column relation. ## Verification - Reproduced the production SQLSTATE 23000 error with the existing project deletion test against an isolated local MariaDB 11.4 database before the fix. - ProjectControllerTest: 27 tests passed on MariaDB and 27 tests passed with the default SQLite configuration. - ProjectApiTest delete case: passed on MariaDB. - Pint and git diff checks passed. No production project deletion or production database write was performed.
Twyco added 1 commit 2026-10-01 20:45:46 +00:00
Fix project deletion with linked ticket statuses on MariaDB
CI/CD / preconditions (pull_request) Successful in 2s
Details
CI/CD / test_and_check_app (pull_request) Successful in 6m5s
Details
CI/CD / Publish immutable image (pull_request) Skipped
Details
cc83ff2af8
Twyco merged commit ba12e65e81 into main 2026-10-02 10:17:20 +00:00
Twyco deleted branch fix/KAN-64-project-delete-response 2026-10-02 10:17:20 +00:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
Eric Twyco flux-image-automation (Flux Image Automation)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: PetschStudios/KanbanGit#176