LLM WikiAccess-protected knowledge portal

WIKI

2026-W31 Worklog

AI Summary Purpose Record cross repository work and career state changes for ISO week 31 of 2026. Key points 2026 07 28 The user reported that the Daangn Software Engineer, Data application was rejected. The application was submitted on 202

경로ai/worklog/2026/2026-W31.md
카테고리Worklog
태그#crawler #infra #mysql #portfolio #report #security #w31 #worklog

# 2026-W31 Worklog

AI Summary

Purpose:

Key points:

application was rejected. The application was submitted on 2026-07-24.

neither was inferred.

to reflect the result.

replaced curl/libcurl 7.76.1 el9 RPMs with upstream curl 8.21.0 as a new layer, without rebuilding the app (embedded-key layers preserved bit-identical). Deliverable: ~/Downloads/labradorlabs_master-bts_4.0.0-curl8.21.tar.gz.

and portfolio package. Independent CEO/CTO/Tech Lead reviews passed at 97/98/96, but the deterministic document-quality score was 91.2 because verified direct must-have coverage is 6/10. No final-submission archive was created under the binding 95-point gate.

without removing content. Final visual QA passed at 96/97 for layout and CJK typography, with no clipping or orphan blockers.

Relevant when:

Do not read full document unless:

Linked documents:

Open Questions

preserving for later targeting analysis.

Details

2026-07-28 — Daangn Software Engineer, Data result

(streaming/Kafka/GCP/experimentation platform) remain application-time fit notes, not verified rejection reasons.

2026-07-29 — BTSv4 image: curl/libcurl CVE remediation without app rebuild

Context: a customer vulnerability scan flagged curl/libcurl < 8.21.0 (CVE-2026-8286 and ~20 others) in labradorlabs/master-bts:4.0.0. The BTS application code does not use curl/libcurl at all; the packages came from UnifiedDockerfile's microdnf install curl (debug convenience) on the mysql:8.4.0 (Oracle Linux 9.4) base. A full image rebuild was ruled out because the app has embedded keys and a wrong redeploy risks customer impact.

What was done:

mysql-shell. mysqld, rpm, and all /app binaries (Go/PyInstaller) do not link it. el9 libcurl has NO versioned symbols, so an upstream default build is ABI-compatible (SONAME libcurl.so.4).

aa1b66a70eace83dc624508745646c08ae561de512ab403adffb93ac87fc72e6) in an oraclelinux:9 builder with OpenSSL/zlib/nghttp2/libpsl/libidn2/brotli.

image + rpm -e --nodeps curl libcurl + COPY of new /usr/bin/curl and /usr/lib64/libcurl.so.4 + ldconfig. All 19 original layers preserved bit-identical (verified via RootFS diff_ids); 4 layers added.

curl 8.21.0 / libcurl 8.21.0 with working HTTPS + CA bundle; microdnf makecache works through the new libcurl (librepo ABI proven); mysqld --version and live SELECT VERSION() OK; startup logs of original vs patched containers identical (47 lines, timestamp-normalized diff empty); process lists identical.

(207MB, sha256 0cc9edc5c3d4a80f314e1731ddc630dfa2292f1707a9fd62b0709e7e6570883f), built with --provenance=false (single manifest, old-docker compatible). Reproducible patch Dockerfile kept at ~/Downloads/bts-curl-patch/.

Caveats recorded:

el9 libcurl RPM back in (dangling mysql-shell dependency) and overwrite the 8.21.0 file. Runtime never does this; only manual debugging would.

UnifiedDockerfile (nothing in the repo invokes it) or bake this 8.21.0 build into the release pipeline.

2026-07-29 — CJ Olive Young Data Engineer tailored application package

Context:

resume and portfolio.

ai/sources/career/2026-07-29-cj-oliveyoung-data-engineer-wanted-351571.md.

Package:

career/맞춤이력서/cj-oliveyoung-data-engineer/.

the captured posting, requirement map, portfolio plan, evidence audit, review manifest, and deterministic quality report.

metrics and decisions use the canonical yellow <b> highlighter.

Evidence and fit:

contradictory, role-boundary, and prohibited production-skill findings are all zero.

gaps remain Kafka real-time streaming, real-time cross-system sync, Spark, REST API Bulk semantics/throughput, OGG/Debezium production use, Google Cloud, and named Data Mart construction.

Python/FastAPI provides raw binlog files after XOR scrambling part of the header; the customer-side Go Updater decompresses MySQL 8.4 ZSTD Transaction_payload data and parses/applies ROW events. The public CDC detail source was corrected locally, but its stale live page was not linked from the submission PDFs.

Verification:

blockers.

compliance and 97 for CJK typography; no spacing, clipping, tofu, or orphan blockers. The portfolio remains on its prior render-7 verification.

95; evidence, ATS, artifact, and reviewer gates pass.

glyphs, or broken page numbers. Linked public detail pages and GitHub returned HTTP 200.

the working folder and were not copied to career/최종 이력서/.

2026-07-30 — CJ Olive Young Data Engineer package: Claude review round, gate passed (95.1)

Cross-agent follow-up on the Codex package in career/맞춤이력서/cj-oliveyoung-data-engineer/ (user request: additional review + 3-persona passes over resume and portfolio).

semantics unverified" to direct-with-scope-limits after locating direct evidence: the registry full-enumeration comparison finder tools are the user's own work (ai/wiki/projects/library-missing-improvements.md), and the NPM daily audit figures (3,825,366 packages / 890 missing / ~104 min) are recorded in ai/worklog/2026/2026-W23.md. Must-have support 6/10 → 7/10. Residual limit kept honest: no verified transfer contract or throughput SLA.

case 1, integrity bullet vs case 2), made the CI/CD kit and instance-split cards problem-action-result with verified facts (spec.md change-contract incident, FILE COMPONENT binlog delay motive), corrected the AWS→in-house server→IDC causal chain (W29), noted the one production DB EC2 instance that stayed on AWS (2026-07-22 source), restored the W29 RubyGems precision wording (idempotent full-version-list backfill, 1,310 versions applied), and disambiguated the Go escape fix as a crawler-code fix.

paths from the submission portfolio (they exposed the internal codename bts); replaced XOR scrambling with header 일부 난독화 in both submission artifacts (exact mechanism stays in the internal audit; matches the W23 decision to exclude XOR weakness detail); removed the English review-jargon "Gap" from the resume boundary row; replaced the one DIST DB mention with 배포 DB; kept lab-master per an explicitly recorded public-safe decision (already public on the portfolio site). OPTIMIZE non-propagation was rephrased from an engine assertion to the actual operating rule.

data-platform-systems-engineering.md; E05 replica motive → public CDC page), added rows E44–E52, and recorded accepted-as-is decisions for the three human/-anchored claims (E05 replica motive, E13 Airflow pool naming, E51 index-deletion team review) — TODO: consolidate these into ai/wiki/projects/bts.md and ai/wiki/people/career-timeline.md before the next application cycle.

IDC-incident line corrected from "zero" to the W29-corrected "1–2".

each revision (4 rounds total by Claude). Final round: CEO 96 / CTO 96 / Tech lead 96, zero blocking issues.

Verification: human-voice strict BAN 0/STRUCT 0/WARN 0; both PDFs re-rendered (A4, 2+5 pages), all 7 pages visually inspected; XOR/Gap/DIST/internal-path strings confirmed absent from extracted PDF text; portfolio item links canonicalized to redirect-free URLs (HTTP 200).

because the user has not yet decided to submit.

2026-08-03 — CJ Olive Young package: user-directed de-AI pass + portfolio expansion to 8 pages

AI-generated, and the 4-case submission portfolio is too thin.

requirement-map/evidence-audit). Varied one of four repeated "파일 기반 배치형 CDC" phrasings.

cases picked from the public portfolio: CASE 05 sync observability (binlog-shipping-monitoring-v2: 5 servers, Vector→TimescaleDB→Grafana, 4 dashboard areas, N+1 completion rule), CASE 06 RAW-preserve/re-parse ETL redesign (etl-flow-redesign: 10M-100M external requests per recollection → 0 on migrated sources; in progress since 2026-03; 2d→5min kept as design estimate; SeaweedFS not counted as S3), CASE 07 library component table redesign (library-table-redesign: collation-mismatch view join 1.3M-row scans vs 6k direct join per EXPLAIN, identifier policy; 팀장·CTO review boundary). Cover reworked: connection-formula lead replaced with a factual index sentence; six unnumbered theme cards (numbers removed after review flagged a 6-cards-vs-7-cases mismatch); CASE 06 scoped against CASE 02 (vulnerability sources were already raw-first; library/package collection was the one-take pipeline).

section); three new public pages live-checked 200 and added to the verification table; E53/E56 anchored to W23; accepted-as-is note extended to E54/E56/E58.

blocking issues. Deterministic gate: 95.1/100, all hard gates pass. 10 rendered pages visually inspected; human-voice strict 0/0/0.

2026-08-03 (2nd) — resume to 3 pages, portfolio to 11 cases/12 pages (user request)