/opt/rt6# sbin/rt-validator --check
Record #26 in Users references a nonexistent record in Groups
id => ‘26’ => Instance
Record #62 in Users references a nonexistent record in Groups
id => ‘62’ => Instance
…
Feels like I am going to have to alter the database directly as shredder is also failing with stuff like:
Shredder has found a dependency that it cannot automatically resolve, so the requested object was not removed. Some plugins do not automatically shred dependent objects for safety, but you may be able to shred the dependent objects directly using other plugins. The documentation for this plugin may have more information. Additional info: Couldn’t find resolver for dependency 'RT::User-…
I have tried to find the “nonexistent record in Groups…” using straight up SQL but no luck so far.
Looking to move to Postgresql from Mariadb, however, before I do this I need to make sure these issues are cleared up.
How do I find these nonexistent reocrds?