Joseph Spiker spikerj
  • Joined on 2025-11-03
spikerj commented on issue spikerj/spikersoft-issues#642 2026-07-29 17:08:14 +00:00
[Infra][SonarQube] CE fails extracting LARGE uploaded reports: PGbytea ArrayIndexOutOfBoundsException reading ce_task_input (root cause of the old #344 crash)

Audited against origin/masterNOT DONE in the one part git can settle; the rest is live-state.

The image pin has not moved. sonarqube/docker-stack.yml:31 still reads `image:…

spikerj commented on issue spikerj/spikersoft-issues#643 2026-07-29 17:08:00 +00:00
[Decision][SonarQube] Rule-level noise policy: CA1873 (3.5k), CA1861 (1.4k), S101 (663), S1192 (404), S1075 (74) — ~70% of open backend findings

Audited against origin/masterdecision still not recorded, but the mechanism and precedent already exist, so this is smaller than it looks. Also flagging something adjacent I found while…

spikerj commented on issue spikerj/spikersoft-issues#659 2026-07-29 17:07:18 +00:00
[Go-Live Checklist][Container] Docker hardening: non-root USER, --no-install-recommends, disable curl/wget redirects (SonarQube hotspots S6471/S6500/S6506)

Audited against origin/masterPARTIAL, and substantially further along than the ticket suggests. Concrete numbers so the remainder is a checklist rather than a sweep.

**Non-root USER

spikerj commented on issue spikerj/spikersoft-issues#563 2026-07-29 17:05:19 +00:00
[Backend][MCPServer] Pre-deployment cleanup for SpikerSoft.AI.MCPServer — demo leftovers, unregistered prompts, no observability wiring, no stack/CI

Audited against origin/masterNOT DONE. All six items outstanding. File-verified:

  1. Demo leftovers live: Program.cs:88 EchoTool, :91 AddCustomer, :106 MyPrompts. 2.…
spikerj commented on issue spikerj/spikersoft-issues#601 2026-07-29 17:05:02 +00:00
Retire the three orphaned IInfluxMetricsRepository methods (QueryCpuMetricsAsync, QueryMetricsAsync, StreamMetricsAsync)

Audited against origin/masterNOT DONE, and I can now answer the question the ticket left open.

All three are still declared at `SpikerSoft.Data/Repositories/IInfluxMetricsRepository.cs:3…

spikerj commented on issue spikerj/spikersoft-issues#578 2026-07-29 17:04:30 +00:00
[Backend][Cleanup] Dependency audit — unused NuGet references across projects inflate every service image (ExCSS, Ical.Net, Redis.OM, Newtonsoft.Json, Configuration.* and more)

Audited against origin/masterPARTIAL (1 of 8 rows resolved), and ⚠️ one row in this ticket is factually wrong and would break production if acted on.

Strike the Ical.Net row before…

spikerj commented on issue spikerj/spikersoft-issues#705 2026-07-29 17:03:21 +00:00
[Epic][Blog][UX] Blog management & UX overhaul — findings from the 2026-07-18 full review

Epic status roll-up — audited every child against origin/master. Owner-delete shipped; none of the eight UX children have started. Posting once here rather than eight near-identical…

spikerj commented on issue spikerj/spikersoft-issues#781 2026-07-29 17:01:25 +00:00
Epic: Unified scheduling — recurrence engine + availability (calendar + iCal)

Epic status roll-up — audited all three phases plus both known follow-ups against origin/master. All three phases have shipped, including Phase 3, which the body still lists as…

spikerj commented on issue spikerj/spikersoft-issues#704 2026-07-29 16:59:30 +00:00
[GpuCoordinator][Bug] Lease grant races physical VRAM eviction — quiz-generation grant-fail-release cycles to DLQ while ImageDescription yields correctly

Audited at file level against origin/master. NOT DONE — and #822's work does not cover this, they're different axes.

**Defect (c), the failure-path CUDA leak — confirmed present, and I…

spikerj commented on issue spikerj/spikersoft-issues#726 2026-07-29 16:58:38 +00:00
Authenticated E2E walk: rpg-game, dungeon-crawler, duality-game fail with runtime TypeErrors (pre-existing on master)

Audited at file level against origin/masterNOT DONE, but the good news is the tests were not weakened. I specifically checked for the pin-rather-than-fix pattern that has turned up…

spikerj commented on issue spikerj/spikersoft-issues#858 2026-07-29 16:56:50 +00:00
artpipe env images: two RUN loops produce 17 GB and 16 GB single layers — split per model

Re-verified at file level against artpipe origin/main (tip 2053880) — NOT DONE. Both mega-layer loops are structurally unchanged:

  • docker/Dockerfile.model-env:74-78 — Layer 2:…
spikerj commented on issue spikerj/spikersoft-issues#777 2026-07-29 16:56:35 +00:00
[Content][Feature] Video captions: 8 media elements lack subtitle/description tracks (S4084, split from a11y epic #732)

Audited at file level against origin/masterNOT DONE. 0 of 8.

git grep -n "<track" origin/master across the entire spikersoft-angular repo returns zero hits — not just in…

spikerj commented on issue spikerj/spikersoft-issues#790 2026-07-29 16:56:19 +00:00
[Feature][Calendar] Create-for-child from the parent calendar — owner selector in the event modal (follow-up to #788)

Audited at file level against origin/masterNOT DONE. Neither half landed.

  • Backend: enumerating every route in SpikerSoft.Api/Domain/Calendar/CalendarController.cs shows…
spikerj commented on issue spikerj/spikersoft-issues#841 2026-07-29 16:56:07 +00:00
ArtPipeProcessor deploy: /mnt/infrastructure pull fails auth (stale checkout deployed, only a WARNING) + one stack's 'update out of sequence' aborts all later deploys

Re-verified at file level against today's tip (bba34a2e, i.e. after the #894 deploy-list changes) — NOT DONE, both halves.

Half 1 — the pull is still warn-and-continue. `.gitea/wor…

spikerj closed issue spikerj/spikersoft-issues#786 2026-07-29 16:55:50 +00:00
[Bug][Prod][Calendar] GET events threw for every pre-#781 event — required non-nullable AffectsAvailability missing from old documents (backfilled)
spikerj commented on issue spikerj/spikersoft-issues#786 2026-07-29 16:55:44 +00:00
[Bug][Prod][Calendar] GET events threw for every pre-#781 event — required non-nullable AffectsAvailability missing from old documents (backfilled)

Closing — this is the plainest case of the habit this audit is chasing: the body itself ends "Closing as fixed; reopen if the calendar still errors," and the state was never flipped. Seven…

spikerj commented on issue spikerj/spikersoft-issues#833 2026-07-29 16:54:53 +00:00
EPIC: Pixal3D as an Art Studio modeling backend

Epic status roll-up — audited all three children against origin/master / origin/main. Staying open: the code is done, but nothing can route to it yet.

spikerj commented on issue spikerj/spikersoft-issues#857 2026-07-29 16:52:49 +00:00
SECURITY: container registry serves anonymous pull tokens over the public internet

Re-ran this ticket's own reproduction just now (2026-07-29 ~16:12Z). Still vulnerable — no code change needed to confirm, the live check settles it.

Ran exactly the two steps from the body,…

spikerj commented on issue spikerj/spikersoft-issues#820 2026-07-29 16:11:42 +00:00
ArtStudio/photo-gallery downloads 404: artpipe workers write GridFS while API reads MinIO (stale pre-#783 deploy)

Audited against origin/masterstill live, and NOT resolved by #783/#852/#853 closing. Recording the mechanism, because it's easy to assume the migration covered this.

**The root cause is…

spikerj commented on issue spikerj/spikersoft-issues#787 2026-07-29 16:11:24 +00:00
[Bug][Backend] images/{id} intermittent 500: response wrote 163840 bytes against Content-Length 163409 (post-MinIO recurrence of the #758 signature) + Traefik compresses images wastefully

Audited against origin/masterPARTIAL, and I need to flag a disagreement between this ticket and #851 rather than paper over it.

What changed: I closed #851 earlier today, which…