diff options
author | Gibheer <gibheer+git@zero-knowledge.org> | 2019-08-12 14:49:53 +0200 |
---|---|---|
committer | Gibheer <gibheer+git@zero-knowledge.org> | 2019-08-12 14:49:53 +0200 |
commit | e2b479c34fcee4c41009fc9e8fe869831fbd494f (patch) | |
tree | 465ba149ff5e25e853e4dd5d758298a7fd97d59a /cmd/monwork | |
parent | 88b50033d0e9808a4657ff56835c6dacc77cd433 (diff) |
support new checker api
With this, it is now possible to support multiple check instances and
balance the load.
Diffstat (limited to 'cmd/monwork')
-rw-r--r-- | cmd/monwork/main.go | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/cmd/monwork/main.go b/cmd/monwork/main.go index 81bc347..4271213 100644 --- a/cmd/monwork/main.go +++ b/cmd/monwork/main.go @@ -226,13 +226,13 @@ var ( where c.last_refresh < c.updated or c.last_refresh is null limit 1 for update of c skip locked;` - SQLRefreshActiveCheck = `insert into active_checks(check_id, cmdline, intval, enabled, msg, mapping_id) -select c.id, $2, c.intval, c.enabled, case when ac.msg is null then '' else ac.msg end, case when c.mapping_id is not null then c.mapping_id when n.mapping_id is not null then n.mapping_id else 1 end + SQLRefreshActiveCheck = `insert into active_checks(check_id, cmdline, intval, enabled, msg, mapping_id, checker_id) +select c.id, $2, c.intval, c.enabled, case when ac.msg is null then '' else ac.msg end, case when c.mapping_id is not null then c.mapping_id when n.mapping_id is not null then n.mapping_id else 1 end, c.checker_id from checks c left join active_checks ac on c.id = ac.check_id left join nodes n on c.node_id = n.id where c.id = $1 on conflict(check_id) -do update set cmdline = $2, intval = excluded.intval, enabled = excluded.enabled, mapping_id = excluded.mapping_id;` +do update set cmdline = $2, intval = excluded.intval, enabled = excluded.enabled, mapping_id = excluded.mapping_id, checker_id = excluded.checker_id;` SQLUpdateLastRefresh = `update checks set last_refresh = now() where id = $1;` ) |