wdevs/pgsql-broker
5
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases 3 Wiki Activity

Metrics.. #4

New Issue
Closed
opened 2026-09-18 21:21:34 +00:00 by warkanum · 5 comments
warkanum commented 2026-09-18 21:21:34 +00:00
Owner
Copy Link
Copy Source

We need to add metrics. Prometheus.

How many jobs was done, failed, queued
How many queues/databases etc.
Speed of jobs by group , by name

Also embed a small web server, with port configurable
that serves a small embedded metrics page (Page must be single html, css showing metrics)

We need to add metrics. Prometheus. How many jobs was done, failed, queued How many queues/databases etc. Speed of jobs by group , by name Also embed a small web server, with port configurable that serves a small embedded metrics page (Page must be single html, css showing metrics)
sgcommand commented 2026-09-18 23:03:59 +00:00
Member
Copy Link
Copy Source

Dispatcher assignment — 2026-09-19T01:03:42+02:00\n\n- Forge/repository: Gitea wdevs/pgsql-broker\n- Issue: #4 — Metrics..\n- Classification: non-simple cross-cutting metrics/server implementation requiring design judgment; Ornith excluded.\n- Selected backend: Claude Code CLI, claude-sonnet-4-6 (command/version/auth checks passed; bounded probe returned CLAUDE_DISPATCH_PROBE_OK).\n- Planned worker session: ia-pgsql-broker-4-claude (process pending launch)\n- Worktree: /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics\n- Branch: issue-4-prometheus-metrics (not pushed yet; PR not created)\n- Plan: read issue/docs and existing broker/queue/worker/config lifecycle, implement Prometheus metrics plus configurable embedded single-page metrics server, test/format/build, commit/push, create PR against main, and post delivery evidence.\n- Required skills: cron-model-selection-policy; cron-worker-contract.\n- Taskboard card: t_c7581025 is blocked to suppress duplicate dispatch while this external worker is authoritative.

Dispatcher assignment — 2026-09-19T01:03:42+02:00\n\n- Forge/repository: Gitea wdevs/pgsql-broker\n- Issue: #4 — Metrics..\n- Classification: non-simple cross-cutting metrics/server implementation requiring design judgment; Ornith excluded.\n- Selected backend: Claude Code CLI, claude-sonnet-4-6 (command/version/auth checks passed; bounded probe returned CLAUDE_DISPATCH_PROBE_OK).\n- Planned worker session: ia-pgsql-broker-4-claude (process pending launch)\n- Worktree: /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics\n- Branch: issue-4-prometheus-metrics (not pushed yet; PR not created)\n- Plan: read issue/docs and existing broker/queue/worker/config lifecycle, implement Prometheus metrics plus configurable embedded single-page metrics server, test/format/build, commit/push, create PR against main, and post delivery evidence.\n- Required skills: cron-model-selection-policy; cron-worker-contract.\n- Taskboard card: t_c7581025 is blocked to suppress duplicate dispatch while this external worker is authoritative.
sgcommand commented 2026-09-18 23:04:23 +00:00
Member
Copy Link
Copy Source

Assignment comment formatting correction.

The preceding assignment record is authoritative; this follow-up preserves the exact fields with real Markdown line breaks.

  • Repository: wdevs/pgsql-broker (Gitea)
  • Issue: #4 — Metrics..
  • Assignment timestamp: 2026-09-19T01:03:42+02:00
  • Classification: non-simple cross-cutting metrics/server implementation; design judgment required
  • Backend/model: Claude Code CLI / claude-sonnet-4-6; authenticated bounded probe passed
  • Worker session: ia-pgsql-broker-4-claude (launch follows this comment)
  • Worktree: /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics
  • Branch: issue-4-prometheus-metrics; not pushed yet
  • PR: not created yet
  • Verification plan: inspect issue/docs and existing broker/queue/worker/config lifecycle, implement focused metrics/page server and tests, format/build/test, commit, push, create PR against main, then post exact SHA/PR/verification evidence.
  • Required skills: cron-model-selection-policy; cron-worker-contract
  • Taskboard: t_c7581025 blocked to suppress duplicate dispatch.
Assignment comment formatting correction. The preceding assignment record is authoritative; this follow-up preserves the exact fields with real Markdown line breaks. - Repository: wdevs/pgsql-broker (Gitea) - Issue: #4 — Metrics.. - Assignment timestamp: 2026-09-19T01:03:42+02:00 - Classification: non-simple cross-cutting metrics/server implementation; design judgment required - Backend/model: Claude Code CLI / claude-sonnet-4-6; authenticated bounded probe passed - Worker session: ia-pgsql-broker-4-claude (launch follows this comment) - Worktree: /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics - Branch: issue-4-prometheus-metrics; not pushed yet - PR: not created yet - Verification plan: inspect issue/docs and existing broker/queue/worker/config lifecycle, implement focused metrics/page server and tests, format/build/test, commit, push, create PR against main, then post exact SHA/PR/verification evidence. - Required skills: cron-model-selection-policy; cron-worker-contract - Taskboard: t_c7581025 blocked to suppress duplicate dispatch.
sgcommand commented 2026-09-19 03:02:51 +00:00
Member
Copy Link
Copy Source

Worker backend update — 2026-09-19T05:02Z

Claude Code Sonnet reached max turns before committing or opening a PR. No worker process/tmux remains. Preserved partial changes in worktree /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics on branch issue-4-prometheus-metrics (not pushed; no PR).

Approved fallback: Hermes OpenAI/Codex surface, model gpt-5.6-luna; bounded probe returned CODEX_56_OK. A continuation worker will preserve and review existing changes, finish tests/commit/push/PR, and post exact evidence.

Worker backend update — 2026-09-19T05:02Z Claude Code Sonnet reached max turns before committing or opening a PR. No worker process/tmux remains. Preserved partial changes in worktree /home/hermes/work/issue-agents/wdevs/pgsql-broker/issue-4-prometheus-metrics on branch issue-4-prometheus-metrics (not pushed; no PR). Approved fallback: Hermes OpenAI/Codex surface, model gpt-5.6-luna; bounded probe returned CODEX_56_OK. A continuation worker will preserve and review existing changes, finish tests/commit/push/PR, and post exact evidence.
sgcommand commented 2026-09-19 03:13:35 +00:00
Member
Copy Link
Copy Source

Continuation delivery for issue #4.

Implemented and pushed:

  • PR #6: #6
  • Branch: issue-4-prometheus-metrics
  • Commit: f69cbea49f6a1748e3e0df9077a6f369102cfeb7

The change adds Prometheus counters/histograms for completed, failed, requeued, and job duration by database/group/name; queue depth, queue count, and database count gauges; and a configurable embedded HTTP server exposing /metrics plus an embedded single-page HTML/CSS dashboard.

Verification:

  • GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go test $(go list ./... | grep -v '/tests/integration') — passed
  • GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go vet ./... — passed
  • GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go build ./cmd/broker — passed
  • git diff --check and git diff origin/main...HEAD --check — passed
  • make lint is blocked by the installed golangci-lint v1 rejecting the repository's v2 configuration
  • Full go test ./... reached all package tests but integration tests failed because PostgreSQL at 127.0.0.1:5433 was unavailable

The remote branch was independently verified at the full SHA above. PR CI was in progress when checked.

Continuation delivery for issue #4. Implemented and pushed: - PR #6: https://git.warky.dev/wdevs/pgsql-broker/pulls/6 - Branch: `issue-4-prometheus-metrics` - Commit: `f69cbea49f6a1748e3e0df9077a6f369102cfeb7` The change adds Prometheus counters/histograms for completed, failed, requeued, and job duration by database/group/name; queue depth, queue count, and database count gauges; and a configurable embedded HTTP server exposing `/metrics` plus an embedded single-page HTML/CSS dashboard. Verification: - `GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go test $(go list ./... | grep -v '/tests/integration')` — passed - `GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go vet ./...` — passed - `GOTMPDIR=/home/hermes/.tmp GOCACHE=/home/hermes/.cache/go go build ./cmd/broker` — passed - `git diff --check` and `git diff origin/main...HEAD --check` — passed - `make lint` is blocked by the installed golangci-lint v1 rejecting the repository's v2 configuration - Full `go test ./...` reached all package tests but integration tests failed because PostgreSQL at `127.0.0.1:5433` was unavailable The remote branch was independently verified at the full SHA above. PR CI was in progress when checked.
sgcommand commented 2026-09-24 23:06:15 +00:00
Member
Copy Link
Copy Source

Closing — PR #6 (feat: add Prometheus metrics and dashboard) was merged on 2026-09-21.

Delivered:

  • Prometheus counters/histograms for completed, failed, requeued, job duration by database/group/name
  • Queue depth, queue count, and database count gauges
  • Configurable embedded HTTP server exposing /metrics plus embedded single-page HTML/CSS dashboard
  • go test (non-integration) PASS, go vet ./... PASS, go build PASS
  • Branch: issue-4-prometheus-metrics | Commit: f69cbea49f
Closing — PR #6 (feat: add Prometheus metrics and dashboard) was merged on 2026-09-21. Delivered: - Prometheus counters/histograms for completed, failed, requeued, job duration by database/group/name - Queue depth, queue count, and database count gauges - Configurable embedded HTTP server exposing `/metrics` plus embedded single-page HTML/CSS dashboard - `go test` (non-integration) PASS, `go vet ./...` PASS, `go build` PASS - Branch: issue-4-prometheus-metrics | Commit: f69cbea49f6a1748e3e0df9077a6f369102cfeb7
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
Priority
Critical
1
The priority is critical
Priority
High
2
The priority is high
Priority
Medium
3
The priority is medium
Priority
Low
4
The priority is low
Reviewed
Confirmed
1
Issue has been confirmed
Reviewed
Duplicate
2
This issue or pull request already exists
Reviewed
Invalid
3
Invalid issue
Reviewed
Won't Fix
3
This issue won't be fixed
Status
Blocked
1
Something is blocking this issue or pull request
Status
Need More Info
2
Feedback is required to reproduce issue or to continue work
Status
Abandoned
3
Somebody has started to work on this but abandoned work
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
hein (Hein) root sam sgcommand (SG Command) warkanum (Warky)
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: wdevs/pgsql-broker#4