#58764Add more File Abstraction Layer reports
Description
To check the integrity of the sys_file index, other reports are usefull:
- report, if for records the missing status is missing (files are deleted – index not up-to-date)
- report, if pids of sys_file_reference records are fitting to pids of related records
- report, if sys_file_reference records pointing to lost sys_file records
- report, if sys_file contains duplicates on combined identifier (storage, identifier)
- report, if sys_file contains duplicates for the same file in different storages
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
History 3
-
Mathias Schreiber changed target version 11/12/15, 17:15
-
Susanne Moog changed tracker
TaskFeature 03/03/19, 14:00 -
Christian Kuhn commented and changed status
NewClosed 01/06/23, 12:49
Closing here for now:
Dealing with db inconsistencies may or may not be a core topic, but it’s at least a pretty complex one.
ext:dbdoctor tries to find various such inconsistencies to fix them. I guess that’s the way to go for now: https://github.com/lolli42/dbdoctor