Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Diagnose missing htids #16

Open
moseshll opened this issue Aug 6, 2024 · 0 comments
Open

Diagnose missing htids #16

moseshll opened this issue Aug 6, 2024 · 0 comments

Comments

@moseshll
Copy link
Contributor

moseshll commented Aug 6, 2024

There are about 11k items that are in the rights database but not in hf (and have non-"suppressed" rights). It would be worth running a small sample manually and/or checking any existing logs to determine why these records are missing.

Warning! Slow query!

select concat(r.namespace, ".", r.id) as htid,a.name,r.time from rights_current r inner join attributes a on r.attr=a.id left join hf h on concat(r.namespace, ".", r.id)=h.htid where h.bib_num is null and a.name!='supp'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant