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

Better Error Message Required For Import Failures #7

Open
IgnoredAmbience opened this issue Feb 22, 2019 · 2 comments
Open

Better Error Message Required For Import Failures #7

IgnoredAmbience opened this issue Feb 22, 2019 · 2 comments

Comments

@IgnoredAmbience
Copy link
Owner

Current error messages from a full set of imports:

$ ./bplan.py *.gz
Unable to process 20140116_ReferenceData.gz:
Inconsistent REF counts, expected 1405, got 247
Unable to process 20160126_ReferenceData.gz:
Inconsistent REF counts, expected 1422, got 257
Unable to process Geography_20151213_to_20160514_from_20160126.txt.gz:
Inconsistent REF counts, expected 1422, got 257
Unable to process Geography_20161211_to_20171209_from_20170823.txt.gz:
Inconsistent TLD counts, expected 638, got 629

I suspect this is due to foreign key inconsistencies in the REF table. Need visibility of the sqlite errors.

@IgnoredAmbience
Copy link
Owner Author

This appears to be caused by a discrepancy between the record counts and the PIT record. ☹️

Additionally, foreign key consistency needs to be enabled by the application as a pragma (stupid sqlite):

PRAGMA foreign_keys=ON;

@IgnoredAmbience
Copy link
Owner Author

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