From 36d1b1b6a4f3d282a6ecd9ff73ae0d6adbf180b9 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Sun, 29 Jan 2012 14:00:55 +0100 Subject: [PATCH] Need to bring back the lastcrawl table for nagios monitoring --- tools/search/crawler/listcrawler.py | 2 ++ tools/search/sql/schema.sql | 4 ++++ 2 files changed, 6 insertions(+) diff --git a/tools/search/crawler/listcrawler.py b/tools/search/crawler/listcrawler.py index 03621f3a..0fb2054a 100755 --- a/tools/search/crawler/listcrawler.py +++ b/tools/search/crawler/listcrawler.py @@ -32,6 +32,8 @@ def doit(opt): # Update total counts curs.execute("WITH t AS (SELECT list,count(*) AS c FROM messages GROUP BY list) UPDATE lists SET pagecount=t.c FROM t WHERE id=t.list") + # Indicate when we crawled + curs.execute("UPDATE lastcrawl SET lastcrawl=CURRENT_TIMESTAMP") conn.commit() log("Indexed %s messages" % n) diff --git a/tools/search/sql/schema.sql b/tools/search/sql/schema.sql index e88abf5e..0a699f71 100644 --- a/tools/search/sql/schema.sql +++ b/tools/search/sql/schema.sql @@ -43,3 +43,7 @@ CREATE TABLE site_excludes ( ); ALTER TABLE site_excludes ADD CONSTRAINT pk_site_excludes PRIMARY KEY (site,suburlre); +CREATE TABLE lastcrawl ( + lastcrawl timestamptz NOT NULL +); +INSERT INTO lastcrawl VALUES (CURRENT_TIMESTAMP); -- 2.39.5