From 2ddc837b4b182736f3a79503f9823bfe5c5688d9 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 1 Dec 2021 17:56:03 -0800 Subject: file_meta cleanup update --- extra/cleanups/file_meta.md | 75 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 75 insertions(+) (limited to 'extra') diff --git a/extra/cleanups/file_meta.md b/extra/cleanups/file_meta.md index d99e821e..d10d0e0f 100644 --- a/extra/cleanups/file_meta.md +++ b/extra/cleanups/file_meta.md @@ -150,3 +150,78 @@ TODO: add manual `finish()` calls on sinks in tool `run` function | parallel -j8 --round-robin --pipe -q ./fatcat_import.py --editgroup-description-override 'backfill of full file-level metadata for early-imported papers' file-meta - # Counter({'total': 1000, 'update': 481, 'skip-existing-complete': 415, 'skip-no-match': 104, 'skip': 0, 'insert': 0, 'exists': 0}) +## 2021-11-29 Update + + zcat ../2021-11-25/file_export.json.gz \ + | rg -v '"sha256":' \ + | pv -l \ + | gzip \ + > files_missing_sha256.json.gz + # 356k 0:11:13 [ 529 /s] + +As a side note, almost all the missing entities are at the "start" of the +export file, not the "end". Presumably because they were imported early on? + + head result_cdx.json | ./pdfextract_tool.py -j1 extract-json - + +The `pdfextract_tool.py` already does Kafka publishing, which is great. Should +be much faster than GROBID worker; we can do the GROBID re-processing later. + +Use new sandcrawler CDX lookup/fetch script to find exact CDX rows: + + # in sandcrawler/python folder + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.json.gz \ + | parallel -j6 --round-robin --pipe --linebuffer pipenv run python -m scripts.fetch_cdx_sha1hex - \ + | pv -l \ + | gzip \ + > /schnell/fatcat_cleanups/file_meta/files_missing_sha256.fetched.json.gz + # 356k 2:17:27 [43.2 /s] + + # stats + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.fetched.json.gz \ + | jq .status -r \ + | sort \ + | uniq -c + + 15477 fail-not-found + 5 skip-no-urls + 314291 success-api + 26723 success-db + + # extract all CDX rows for processing + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.fetched.json.gz \ + | rg '"success' \ + | jq .cdx_rows[] -c \ + | pv -l \ + | shuf \ + | gzip \ + > /schnell/fatcat_cleanups/file_meta/files_missing_sha256.cdx_rows.json.gz + # 354k 0:00:17 [19.7k/s] + + export TMPDIR=/fast/tmp/ + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.cdx_rows.json.gz \ + | parallel -j16 --round-robin --pipe --linebuffer pipenv run ./pdfextract_tool.py -j1 extract-json - \ + | pv -l \ + | gzip \ + > /schnell/fatcat_cleanups/file_meta/files_missing_sha256.pdf_extract.json.gz + # 354k 2:45:35 [35.7 /s] + + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.pdf_extract.json.gz | jq .status -r | sort | uniq -c | sort -nr + + 299226 success + 44297 parse-error + 8986 error-wayback + 1819 not-pdf + 518 text-too-large + 1 empty-blob + + zcat /schnell/fatcat_cleanups/file_meta/files_missing_sha256.pdf_extract.json.gz \ + | jq .file_meta -c \ + | rg -v ^null \ + | pv -l \ + | pigz \ + > /schnell/fatcat_cleanups/file_meta/files_missing_sha256.file_meta.json.gz + # 345k 0:08:21 [ 689 /s] + +Holding off on actually importing, because metadata dumps are happening on +fatcat prod database server. -- cgit v1.2.3