aboutsummaryrefslogtreecommitdiffstats
path: root/sql/reingest_weekly.sh
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2022-04-04 15:27:02 -0700
committerBryan Newbold <bnewbold@archive.org>2022-04-04 15:27:02 -0700
commitc4caeaedc63c2bb2f9bb9f6be6826480aefc9caf (patch)
tree8cbf981a46afc8571ab3cc85f3eab5595afd426b /sql/reingest_weekly.sh
parent51193896a4958025f1bf045b0ba908ab5d4d0553 (diff)
downloadsandcrawler-c4caeaedc63c2bb2f9bb9f6be6826480aefc9caf.tar.gz
sandcrawler-c4caeaedc63c2bb2f9bb9f6be6826480aefc9caf.zip
sql: fix reingest query missing type on LEFT JOIN; wrap in read-only transaction
Diffstat (limited to 'sql/reingest_weekly.sh')
-rwxr-xr-xsql/reingest_weekly.sh2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/reingest_weekly.sh b/sql/reingest_weekly.sh
index 04ce39d..b60bd0e 100755
--- a/sql/reingest_weekly.sh
+++ b/sql/reingest_weekly.sh
@@ -13,7 +13,7 @@ sudo -u sandcrawler pipenv run \
cat /srv/sandcrawler/tasks/reingest_weekly_current.json \
| shuf \
- | head -n60000 \
+ | head -n80000 \
| jq . -c \
| kafkacat -P -b wbgrp-svc263.us.archive.org -t sandcrawler-prod.ingest-file-requests-daily -p -1