- bin/octo-diff on the right machine does show some changes (belvedere)
```
$ bin/octocatalog-diff --octocatalog-diff-args --no-truncate-details --to staging belvedere
*** Running octocatalog-diff on host belvedere.internal.softwareheritage.org
I, [2021-09-03T09:46:40.723238 #25175] INFO -- : Catalogs compiled for belvedere.internal.softwareheritage.org
I, [2021-09-03T09:46:41.737144 #25175] INFO -- : Diffs computed for belvedere.internal.softwareheritage.org
diff origin/production/belvedere.internal.softwareheritage.org current/belvedere.internal.softwareheritage.org
*******************************************
File[/etc/prometheus-sql-exporter/swh-scheduler.yml] =>
parameters =>
content =>
@@ -194,2 +194,26 @@
values:
- sum
+
+- name: swh_scheduler_metrics
+ scope: database
+ cluster: secondary
+ database: ^softwareheritage-scheduler$
+ interval: '4h'
+ help: "Software Heritage Scheduler Metrics"
+ query: |
+ select l.name||':'||l.instance_name as lister_name, sm.visit_type, sm.last_update,
+ sm.origins_known, sm.origins_enabled, sm.origins_never_visited,
+ sm.origins_with_pending_changes
+ from scheduler_metrics sm
+ inner join listers l on sm.lister_id=l.id
+ order by lister_name
+ labels:
+ - lister_name
+ - visit_type
+ - last_update
+ - origins_known
+ - origins_enabled
+ - origins_never_visited
+ - origins_with_pending_changes
+ values:
+ - sum
*******************************************
*** End octocatalog-diff on belvedere.internal.softwareheritage.org
```
- currently trying to troubleshoot it through vagrant vms.
Well, currently i cannot.
- belvedere's db is not fully puppetized for production. So the prometheus-sql-exporter cannot run [1]
- That configuration is only running for production and not staging
[1]
```
root@belvedere:~# systemctl status prometheus-sql-exporter
● prometheus-sql-exporter.service - Prometheus exporter for sql metrics
Loaded: loaded (/lib/systemd/system/prometheus-sql-exporter.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/prometheus-sql-exporter.service.d
└─restart.conf, update_config.conf
Active: inactive (dead)
Condition: start condition failed at Fri 2021-09-03 07:58:10 UTC; 14min ago
└─ ConditionPathExistsGlob=/etc/postgresql/*/*/postgresql.conf was not met
Docs: https://github.com/credativ/sql_exporter
Sep 03 07:48:38 belvedere systemd[1]: Condition check resulted in Prometheus exporter for sql metrics being skipped.
Sep 03 07:49:42 belvedere systemd[1]: Condition check resulted in Prometheus exporter for sql metrics being skipped.
Sep 03 07:52:58 belvedere systemd[1]: Condition check resulted in Prometheus exporter for sql metrics being skipped.
Sep 03 07:58:10 belvedere systemd[1]: Condition check resulted in Prometheus exporter for sql metrics being skipped.
```