Skip to content
This repository has been archived by the owner on Apr 12, 2021. It is now read-only.

Sat5 + Sat6: check for database inconsistencies #28

Open
jhutar opened this issue Nov 3, 2016 · 0 comments
Open

Sat5 + Sat6: check for database inconsistencies #28

jhutar opened this issue Nov 3, 2016 · 0 comments

Comments

@jhutar
Copy link
Collaborator

jhutar commented Nov 3, 2016

Check for data in tables that refers to parent data that doesn't exist:

Satellite 5:
    select * from rhnchannelerrata where channel_id not in (select id from rhnchannel)
    select * from rhnchannelerrata where errata_id not in (select id from rhnerrata) 

There are probably many similar things to look for in Satellite 6

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant