Autosubmit delete doesn't delete the metadata
Talking with @eferre1 , we discovered some job_data from 2023 that doesn't belong to Eric's user, the current experiment(t0n3) owner.
[eadmin@bsceshub02 as_metadata]$ ll * | grep t0n3
-rw-r--r--. 1 2337 Earth 536K Apr 27 2023 job_data_t0n3_corrupted.db
-rw-r--r--. 1 2337 Earth 1.2M Apr 27 2023 job_data_t0n3.db
-rw-r--r--. 1 2337 Earth 1.2M Apr 27 2023 job_data_t0n3.sql
This results in a crash in the GUI visualization. After moving/create the files to another location the GUI visualization works.
For some reason, I could manually delete the .db one, but not the others, by using the admin user.
I think that what happened is that the autosubmit delete t0n3
was prompted by the original user, which is now 2337, and the next expid got that expid with metadata still belonging to the previous owner. Another possible reason would be this issue #1136 (closed)
Autosubmit deletes should also delete the associated as_metadata. This is using 3.15.X, we need to see if this is also the case on 4.1.X.
I'm tagging @ltenorio, because I don't know if the Postgres branch is generating additional files that need to be included in the autosubmit delete