webui backend showing stat output for deletion

[justinclift]

Just noticed several instances of this showing up in the webui's backend log file.

Note that the user and database name have been replaced for privacy.

May 03 03:22:37 dbhub.io webui[190641]: 2023/05/03 03:22:37 [DELETE] 'webUI' removed Minio database object 'USERNAME/DATABASE', using bucket 'live-cua8zty58i' and id 'kuaya8'
May 03 03:22:37 dbhub.io webui[190641]: 2023/05/03 03:22:37 stat /home/dbhub/.dbhub/live_databases/USERNAME/DATABASE/live.sqlite: no such file or directory

The stat output there is making me wonder if perhaps we have the deletion running in the wrong order, or perhaps the verification of the deletion is going wrong.

So, I'm not sure there's anything wrong here than possibly over-logging, but we should look into it just in case.

[justinclift]

The error message seems to be coming from here:

dbhub.io/live/main.go

Line 440 in b542dc1

log.Println(err)

I've just committed a workaround, but will leave this open for now, so I can look into it more properly later.

[justinclift]

Hmmm, this is still showing up in our backend logs occasionally.

One possibility popped into mind... maybe it's something to do with a foreign key constraint stopping the deletion from occurring. eg missing CASCADE or similar

Something along these lines would fit the behaviour we're seeing.