58 Commits

This Branch

This Branch

All Branches

Author	SHA1	Message	Date
james.maes	7c5e7a9320	Merge pull request 'build(deps): align with Gitea registry (parent 2.2.1, QQQ 4.1.0-RC.26)' (#39) from deps/align-gitea into develop	2026-11-07 18:37:05 +00:00
james.maesandClaude Opus 5.5	f0ecacc3e9	test: regenerate OpenAPI contract for QQQ 4.1.0-RC.26 ... QQQ RC.26 adds the shared BasicErrorResponseV1 schema to extension models; regenerate the committed fragment and allow that core schema. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-07 12:30:25 -06:00
james.maesandClaude Opus 5.5	725446709b	build(deps): align with Gitea registry (parent 2.2.1, QQQ 4.1.0-RC.26) ... pom.xml: parent -> 2.2.1 pom.xml: qqq.snapshot.version: 4.1.0-RC.13 -> 4.1.0-RC.26 pom.xml: added qqq.version=4.1.0-RC.26 (parent BOM import) Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-07 17:59:16 +00:00
james.maes	d578b5180a	Merge pull request 'ci: pin shared workflow to v1' (#38) from ci/pin-v1-develop into develop	2026-11-06 16:06:22 +00:00
james.maesandClaude Opus 5.5	cf106d4301	ci: pin shared workflow to v1 ... Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-06 14:08:36 +00:00
james.maes	a26a175aa8	Merge pull request 'ci: use shared ci-workflows Maven workflow' (#37) from ci/ci-workflows into develop	2026-11-05 23:16:16 +00:00
CI	aff84d5add	ci: rerun shared workflow	2026-11-05 16:24:46 -06:00
james.maesandClaude Opus 5.5	171b0d3fad	ci: use shared ci-workflows Maven workflow ... Replace the platform-ci release callers with one caller of KofTwentyTwo/ci-workflows maven.yaml (qqq-orb port). Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-11-05 22:04:26 +00:00
forge-recovery	b70c234c79	ci: enroll shared Gitea lifecycle	2026-11-02 22:15:48 +00:00
forge-recovery	ef58b9d8ad	ci: enroll shared Gitea lifecycle	2026-11-02 21:33:08 +00:00
forge-recoveryandCodex	5d82358d2b	ci: enroll shared Gitea release-candidate lifecycle ... Co-Authored-By: Codex <noreply@openai.com>	2026-11-02 20:16:11 +00:00
3 people	3468453335	ci: add the isolated postpublish job to the QRun release caller ... Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com> Co-Authored-By: Codex <noreply@openai.com>	2026-11-02 15:48:51 +00:00
3 people	612f474e91	ci: move the QRun release caller to the thin v2 contract ... Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com> Co-Authored-By: Codex <noreply@openai.com>	2026-11-02 06:17:47 +00:00
forge-recoveryandCodex	f005c40083	ci: add the identical QRun release caller ... Co-Authored-By: Codex <noreply@openai.com>	2026-11-02 04:10:32 +00:00
james.maesandClaude Fable 5.1	d46b6ca222	feat(provider): H2 statistics provider and per-area capabilities (#34) ... H2StatsProvider over INFORMATION_SCHEMA (statements via QUERY_STATISTICS, sessions, blocking, connections, indexes, size, settings, approximated table rows and sizes, text plans); per-area provider capabilities with rules skipped where a provider lacks the data; a vendor registry with a seam for MySQL/MariaDB; provider-specific setup and health checks; an Enable statement statistics action; and the H2 plan guard (single SELECT/WITH only, side-effecting functions refused, EXPLAIN ANALYZE only for non-admin users, read-only connection, always rolled back). Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>	2026-11-01 06:14:44 -06:00
james.maesandCodex	4fd2c30b07	ci: adopt managed orb 0.8 patch track (#28) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 15:26:36 -05:00
james.maesandCodex	65e63551f9	ci: adopt shared orb 0.7.18 (#27) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 14:43:20 -05:00
james.maesandCodex	ccc0cc2842	ci: adopt shared orb 0.7.17 (#26) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 14:15:18 -05:00
james.maesandCodex	9178646423	ci: centralize branch verification and source scanning (#23) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 12:17:56 -05:00
james.maesandCodex	681598be57	ci: adopt central orb 0.7.12 and stable gates (#21) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 08:56:36 -05:00
james.maesandCodex	ea9036509c	ci: centralize rc release completion in qqq orb (#20) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 02:25:42 -05:00
james.maesandCodex	2a2ba58b06	ci: adopt shared orb 0.7.11 (#19) ... Co-authored-by: Codex <noreply@openai.com>	2026-10-21 00:57:50 -05:00
james.maes	61e9c22563	Merge pull request #18 from QRun-IO/feature/central-ci ... ci: adopt shared QQQ orb standard	2026-10-20 18:57:48 -05:00
james.maesandCodex	65922dd413	ci: adopt verified central QQQ orb 0.7.3 ... Co-Authored-By: Codex <noreply@openai.com>	2026-10-20 18:52:28 -05:00
james.maes	bdaf35fc3e	Merge pull request #17 from QRun-IO/feature/bounded-spike-history ... fix(alerts): page spike history instead of holding 7 days of query snapshots	2026-10-16 15:54:56 -05:00
james.maesandClaude Opus 5.5	c49b479620	fix(alerts): page spike history instead of holding 7 days of query snapshots ... SnapshotEvaluator.spikes loaded RuleContext.window("query_snapshot", 7) as QRecords on every snapshot evaluation (every collection interval on the worker). kof22 writes ~33,000 query snapshots a day, so by day 7 that is ~230,000 records per evaluation. history() now reads the window in BATCH_SIZE keyset pages (only OK and PARTIAL snapshots, as before) and keeps per statement only the current interval time, the latest capture time and earlier interval times in a primitive double array. Median, twelve-sample baseline and the one-hour absence rule are unchanged (SnapshotEvaluatorTest still passes). SpikeHistoryBoundedTest counts every query snapshot QQQ materializes: 2,500 samples never exceed one 1,000-row page, failed snapshots and samples outside the window are excluded, the current interval is found. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-16 15:24:44 -05:00
james.maes	de991509ca	Merge pull request #16 from QRun-IO/feature/bounded-attribution-reads ... fix(attribution): sum attribution in the database, page the daily rollup (prod OOM)	2026-10-16 15:15:33 -05:00
james.maesandClaude Opus 5.5	fd0116fbd0	fix(analyze): read attribution as database sums in the hourly analysis ... dbPerfAnalyze (hourly, on the worker) loaded the full day of db_perf_attribution through RuleContext.window and cached it for the rules: ~570,000 rows. kof22 worker working set jumped from ~660 MiB to ~1.84 GiB at every :07-:08 run on 2026-10-16 (2 Gi limit, 1.5 GB heap). RuleContext.window("attribution", days) now returns AggregateAction sums (units, statements, rowsCount, errors, totalMs; max maxMs) grouped by unitKind, unitName, tableName, operation: the only fields the rules (OVER_AUDITED, HOT_JOB) read. AttributionBoundedReadTest proves no detail rows are loaded and the totals are unchanged. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-16 15:04:23 -05:00
james.maesandClaude Opus 5.5	744ff04ade	fix(attribution): sum attribution in the database, page the daily rollup ... The Attribution home widget queried every db_perf_attribution row of the last 24 hours into QRecords and summed them in Java. kof22 writes about 30,000 attribution rows an hour, so one render loaded ~570,000 rows (540 MB in PostgreSQL). On 2026-10-16 a single admin request logged "Large number of records in QueryOutputList" at 50k, 100k and 250k rows and the web pod died with OutOfMemoryError: Java heap space about 50 s later, after slowing every other request with GC thrash. - DbPerfWidgetRenderer.attribution() now uses AggregateAction: SUM of statements and totalMs grouped by unitKind, unitName, tableName, ordered by time and capped at 5,000 groups (prod has ~1,000). - RollupService reads the day's attribution detail in 1,000-row keyset pages through the new DbPerfStore.forEachPage, so the nightly rollup on the worker is bounded by distinct keys instead of the day's rows. - AttributionBoundedReadTest counts every detail record QQQ materializes (post-query customizer): the widget loads none, the rollup never holds more than BATCH_SIZE at once, and sums stay correct across pages. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-16 14:34:58 -05:00
james.maes	fdcad364f1	Merge pull request #10 from QRun-IO/ci/release-rc-secrets-inherit ... ci(release-rc): pass secrets so the shared workflow can sign the RC tag	2026-10-16 08:04:25 -05:00
james.maes	7c71e384c9	Merge pull request #12 from QRun-IO/fix/collector-failures ... fix(collect): no stack overflow on huge statements; every failure closes the run as FAILED	2026-10-15 17:43:04 -05:00
james.maesandClaude Opus 5.5	b882e3d0f0	fix(collect): no stack overflow on huge statements; every failure closes the run ... The normalizer folded IN and VALUES lists with nested-repetition regular expressions, which threw StackOverflowError on kof22's 60 KB statements. That Error escaped catch(Exception), so runs stayed RUNNING, nothing was logged and no alert fired. List folding is now a linear token scan, the collector catches Throwable (rethrowing OutOfMemoryError), logs class and frame at ERROR, marks FAILED and alerts, and stale RUNNING runs are closed. Verified against kof22's 4,462 real statement texts (under 1 s). Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 17:40:01 -05:00
james.maes	bb7e852a35	Merge pull request #11 from QRun-IO/fix/single-attribution-runtime ... fix(attribution): one active attribution runtime per JVM	2026-10-15 17:09:55 -05:00
james.maesandClaude Opus 5.5	8a34ac4404	ci(release-rc): pass secrets to the shared workflow so it can sign the RC tag ... QRun-IO/.github#2 adds a tag-and-release job that signs vX with the QRUN_TAG_SIGNING_KEY secret after Maven Central confirms the artifact. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 16:19:54 -05:00
james.maesandClaude Opus 5.5	63d4c9669f	fix(attribution): one active attribution runtime per JVM ... Statement listeners are JVM-wide. Starting attribution on another instance now stops the previous runtime's listener and flusher, so repeated server starts (tests, hot swaps) never pin old instances. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 16:11:08 -05:00
james.maes	1663f48073	Merge pull request #9 from QRun-IO/fix/table-icons ... fix(nav): distinct icon per table; cuts 0.1.0-RC.3	2026-10-15 14:15:35 -05:00
james.maesandClaude Opus 5.5	0b517d7e16	fix(nav): a distinct icon per table and a storage app icon ... Every db_perf_ table used the speed icon, which repeats in the nav and clashes with web performance (kof22's nav icon uniqueness check). Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 14:12:56 -05:00
james.maes	1bc250c1b8	Merge pull request #8 from QRun-IO/fix/widget-columns ... fix(home): at most four columns per widget table; cuts 0.1.0-RC.2	2026-10-15 13:25:03 -05:00
james.maesandClaude Opus 5.5	c9652fd541	fix(home): at most four columns per widget table, plain headers ... Top queries, live activity, attribution, repeated statements and tables fold secondary facts into a muted second line of the first cell, so the home stays readable at every width (kof22's widget readability guard). Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 13:22:12 -05:00
james.maes	8446ab1f0b	Merge pull request #7 from QRun-IO/feature/attribution ... feat: QQQ attribution and N+1 detection (QQQ 4.1.0-RC.13); cuts 0.1.0-RC.1	2026-10-15 12:55:23 -05:00
james.maesandClaude Opus 5.5	fe41490559	Merge develop (rule seed text) into feature/attribution; number the sample_rate changeset 34 ... Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 12:52:02 -05:00
james.maesandClaude Opus 5.5	34db3cdff6	Merge develop into feature/attribution; help for sampleRate, README and CHANGELOG ... Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 12:21:26 -05:00
james.maes	d61684b15e	Merge pull request #6 from QRun-IO/fix/rule-seed-text ... fix(rules): helpful rule descriptions and threshold labels; spec alert names	2026-10-15 12:18:59 -05:00
james.maesandClaude Opus 5.5	f0b544b074	fix(rules): helpful rule labels, descriptions and threshold labels; spec alert type names ... Seeded suggestion rules get plain descriptions of what each finds and what to do, and threshold labels without stray quotes. The spec now names the alert types dbperf.* (core rejects underscores). Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 12:15:51 -05:00
james.maes	890df96bc1	Merge pull request #5 from QRun-IO/feature/plans-and-home ... feat: plan viewer, UI API extension, app home, help and docs	2026-10-15 12:12:51 -05:00
james.maesandClaude Opus 5.5	a571fe4c3a	Merge develop (findings, alerts, health) into feature/plans-and-home; help for finding actions ... Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 12:09:57 -05:00
james.maesandClaude Opus 5.5	f8d25d1f7c	feat(ui): plan viewer, db-performance UI API extension, app home widgets, help bundle and docs ... Query plan record action and POST explain: plain or generic EXPLAIN, and EXPLAIN (ANALYZE, BUFFERS) for single SELECTs in a rolled-back READ ONLY transaction with statement_timeout, behind explain_analyze, always audited, ANALYZE plans and parameters never stored. UI API extension /qqq/v1/qbit/db-performance (overview, activity with live text only for view_live_text, explain, statements/lookup) with a committed OpenAPI fragment and contract test. Eight full-width typed home widgets. Data-driven help bundle with a coverage test. README, CHANGELOG and UPGRADE. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 12:06:37 -05:00
james.maes	1f14317e7e	Merge pull request #4 from QRun-IO/feature/findings ... feat: suggestions engine, finding actions, alerts and health	2026-10-15 11:54:19 -05:00
james.maesandClaude Opus 5.5	f218a1c820	feat(findings): suggestions engine, finding actions, alerts and health checks ... Fourteen rules read their db_perf_rule row and produce deduplicated, ranked findings with evidence and ready-to-commit Liquibase snippets (never applied). Acknowledge, Mark resolved, Ignore and Reopen are standard record actions. Collection failures, query spikes, connection saturation and blocked chains raise and resolve keyed QAlerts; the collector, stats access and connections register core health checks. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 11:51:46 -05:00
james.maesandClaude Opus 5.5	564ebf8d97	feat(attribution): QQQ statement attribution and N+1 detection ... Registers a core StatementExecutionListener (QQQ 4.1.0-RC.13) that aggregates statements per unit of work (route, scheduled job, process), table, operation and fingerprint in bounded memory, detects repeated statement shapes per unit, and flushes each window with one batched insert per table from a daemon thread that never measures itself. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>	2026-10-15 11:44:26 -05:00