Opened 7 years ago
Closed 7 years ago
#25107 closed defect (bug) (fixed)
Deleting files from Media Library when MySQL database locked
Reported by: |
|
Owned by: |
|
---|---|---|---|
Milestone: | 3.8 | Priority: | normal |
Severity: | major | Version: | 3.6 |
Component: | Media | Keywords: | has-patch commit |
Focuses: | Cc: |
Description (last modified by )
While permamently deleting files uploaded to a post, I incidentally had set in the mysql config "innodb_force_recovery = 1" and therefore, as it is my understanding, the database was protected against any changes.
Files were, however, permamently deleted from the filesystem but kept in the databased and show in the media library, naturally without the associated image files.
Attachments (2)
Change History (11)
#3
@
7 years ago
- Description modified (diff)
- Resolution invalid deleted
- Status changed from closed to reopened
#5
@
7 years ago
- Milestone changed from Awaiting Review to 3.7
- Owner set to nacin
- Status changed from reopened to accepted
#6
@
7 years ago
- Keywords commit added
We're ultimately not doing everything inside of an atomic transaction. So I think I prefer something like 25107.diff that specifically waits to see if the primary delete query is successful.
#7
@
7 years ago
An issue with 25107.diff could be, that deleting metadata works, but the primary delete query fails. This results in a post without any meta, like for image sizes, which means, that image_get_intermediate_size()
will fail and the image files can't be deleted.
#25108 was marked as a duplicate.