aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/dump_reingest_quarterly.sql1
-rw-r--r--sql/dump_reingest_weekly.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/dump_reingest_quarterly.sql b/sql/dump_reingest_quarterly.sql
index 5e8d412..972e9fe 100644
--- a/sql/dump_reingest_quarterly.sql
+++ b/sql/dump_reingest_quarterly.sql
@@ -14,6 +14,7 @@ COPY (
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-error:unknown'
) TO '/srv/sandcrawler/tasks/reingest_quarterly_spn2-error_current.rows.json';
COPY (
diff --git a/sql/dump_reingest_weekly.sql b/sql/dump_reingest_weekly.sql
index 15465f3..e7cd553 100644
--- a/sql/dump_reingest_weekly.sql
+++ b/sql/dump_reingest_weekly.sql
@@ -14,6 +14,7 @@ COPY (
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-error:unknown'
) TO '/srv/sandcrawler/tasks/reingest_weekly_spn2-error_current.rows.json';
COPY (