Issue Feature Closed

#58764Add more File Abstraction Layer reports

Marc Bastian Heinrichs 05/13/14, 14:40 updated 01/06/23, 12:49

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

  1. Mathias Schreiber changed target version 11/12/15, 17:15

  2. Susanne Moog changed tracker Task Feature 03/03/19, 14:00

  3. Christian Kuhn commented and changed status New Closed 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