aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dump_reingest_quarterly.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-04-09 13:03:18 -0700
committerBryan Newbold <bnewbold@archive.org>2021-04-09 13:03:18 -0700
commitdd4e8bcd6dbe0aaa141b94c851a47963bb49563a (patch)
tree72ab1676a12683caf63cd1676b1592f98fa5ec28 /sql/dump_reingest_quarterly.sql
parente40d7ddf0c091426e8c61cc1a5be5f15bd052c10 (diff)
downloadsandcrawler-dd4e8bcd6dbe0aaa141b94c851a47963bb49563a.tar.gz
sandcrawler-dd4e8bcd6dbe0aaa141b94c851a47963bb49563a.zip
sql: update periodic retry/reingest scripts
Diffstat (limited to 'sql/dump_reingest_quarterly.sql')
-rw-r--r--sql/dump_reingest_quarterly.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/dump_reingest_quarterly.sql b/sql/dump_reingest_quarterly.sql
index 303824b..066df9f 100644
--- a/sql/dump_reingest_quarterly.sql
+++ b/sql/dump_reingest_quarterly.sql
@@ -10,6 +10,10 @@ COPY (
AND ingest_file_result.status like 'spn2-%'
AND ingest_file_result.status != 'spn2-error:invalid-url-syntax'
AND ingest_file_result.status != 'spn2-error:filesize-limit'
+ AND ingest_file_result.status != 'spn2-error:not-found'
+ AND ingest_file_result.status != 'spn2-error:blocked-url'
+ AND ingest_file_result.status != 'spn2-error:too-many-redirects'
+ AND ingest_file_result.status != 'spn2-error:network-authentication-required'
AND ingest_file_result.status != 'spn2-wayback-error'
) TO '/grande/snapshots/reingest_quarterly_spn2-error_current.rows.json';