Post-merge !351/!352/!353: indexer candle *_human migrate + leftover smoke #545

New issue

Closed

opened 2026-08-17 04:53:57 +00:00 by PlasticDigits · 4 comments

PlasticDigits commented

2026-08-17 04:53:57 +00:00

(Migrated from gitlab.com)

Summary

!1069 (#543), !1070 (#541), and !1071 (#542) are on main (7fdc3a44). Automated verify scripts are green. This issue tracks deploy + leftover manual/e2e work that was unchecked on those MRs.

Related: #543, #541, #542.

Must do — indexer candle migrate (#543)

indexer/migrations/20260817000000_candle_human_ohlc.sql adds open_human / high_human / low_human / close_human, then TRUNCATE candles and rebuilds from swap_events (USD from price_usd only; no human fallback).

Until production/QA indexer runs this migrate + rebuild:

GET /candles will not have *_human
inverted Price (USD) bars are dropped (empty pane), even though Last is correct

Do not run this blindly on a live DB without a backup window — truncate is destructive to the candle table (swap_events stay).

Acceptance

QA + production indexer have applied the migration
GET /candles for UST1/USTR includes *_human and factory USD ~1
After rebuild, /trade + /charts inverted USTR Last and last candle close agree (~0.012, not ~1.0)

Manual smoke still unchecked

#543 (columbus-5 or QA)

UST1/USTR, UST1/cUSTC, cLUNC/UST1 — both pill orientations — Last ≈ chart last-value; cLUNC factory axis is not 0.00; inverted cLUNC is not ~21260

#541

Light + dark, mobile + desktop: identity row wraps under the pair select, not over invert pill or ticket CTA
Keyboard: tab to copy/explorer; :focus-visible ring; Enter on explorer does not change the selected pair
Playwright P1–P3 against a live factory pair list (P4 already passed; P1–P3 skipped under PLAYWRIGHT_SKIP_CHAIN=1)

#542 (optional)

On-chain Create Pair for a novel pair (e2e-tx / LocalTerra) — not required to close #542
Existing-pair submit shows a humanized factory error (P3 only asserts no false success)

Out of scope

#544 / #540 volume-USD work (other open issues)
Do not change #543 invert math or #541/#542 UI in this issue unless migrate/smoke finds a regression

Verify already done on merge

make verify-issue-543   # 8/8
make verify-issue-541   # 11/11 (P1–P3 skipped)
make verify-issue-542   # 9/9 including Playwright P1–P5

## Summary !1069 (#543), !1070 (#541), and !1071 (#542) are on `main` (`7fdc3a44`). Automated verify scripts are green. This issue tracks **deploy + leftover manual/e2e** work that was unchecked on those MRs. Related: #543, #541, #542. ## Must do — indexer candle migrate (#543) `indexer/migrations/20260817000000_candle_human_ohlc.sql` adds `open_human` / `high_human` / `low_human` / `close_human`, then **`TRUNCATE candles`** and rebuilds from `swap_events` (USD from `price_usd` only; no human fallback). Until production/QA indexer runs this migrate + rebuild: - `GET /candles` will not have `*_human` - inverted Price (USD) bars are dropped (empty pane), even though Last is correct **Do not** run this blindly on a live DB without a backup window — truncate is destructive to the candle table (swap_events stay). ### Acceptance - [ ] QA + production indexer have applied the migration - [ ] `GET /candles` for UST1/USTR includes `*_human` and factory USD ~1 - [ ] After rebuild, `/trade` + `/charts` inverted USTR Last and last candle close agree (~`0.012`, not ~`1.0`) ## Manual smoke still unchecked ### #543 (columbus-5 or QA) - [ ] UST1/USTR, UST1/cUSTC, cLUNC/UST1 — both pill orientations — Last ≈ chart last-value; cLUNC factory axis is not `0.00`; inverted cLUNC is not `~21260` ### #541 - [ ] Light + dark, mobile + desktop: identity row wraps under the pair select, not over invert pill or ticket CTA - [ ] Keyboard: tab to copy/explorer; `:focus-visible` ring; Enter on explorer does not change the selected pair - [ ] Playwright P1–P3 against a live factory pair list (P4 already passed; P1–P3 skipped under `PLAYWRIGHT_SKIP_CHAIN=1`) ### #542 (optional) - [ ] On-chain Create Pair for a *novel* pair (`e2e-tx` / LocalTerra) — not required to close #542 - [ ] Existing-pair submit shows a humanized factory error (P3 only asserts no false success) ## Out of scope - #544 / #540 volume-USD work (other open issues) - Do not change #543 invert math or #541/#542 UI in this issue unless migrate/smoke finds a regression ## Verify already done on merge ```bash make verify-issue-543 # 8/8 make verify-issue-541 # 11/11 (P1–P3 skipped) make verify-issue-542 # 9/9 including Playwright P1–P5 ```

PlasticDigits commented

2026-08-17 04:53:57 +00:00

(Migrated from gitlab.com)

marked as related to #543

PlasticDigits commented

2026-08-17 04:53:58 +00:00

(Migrated from gitlab.com)

marked as related to #541

PlasticDigits commented

2026-08-17 04:53:59 +00:00

(Migrated from gitlab.com)

marked as related to #542

PlasticDigits commented

2026-08-17 09:59:10 +00:00

(Migrated from gitlab.com)

Production indexer https://indexer.dex.cl8y.com has the #543 candle *_human migrate.

GET /api/v1/pairs/terra16vxrhpvpcucu05y0nr862vf9hnqeh274uaff4s7hz4n0ea74006qf5hgqy/candles?interval=1h (UST1/USTR):

bars include open_human / high_human / low_human / close_human
factory USD close ~0.95–1.02 (not human ~77)
last 1h 2026-08-16T16:00Z close 0.946836 / close_human 77.2376 → invertUsd 0.0122588
last tape price_usd / price → same 0.0122588 (not ~1.0)

Same check on UST1/cUSTC (factory ~$1.07, invertUsd ~0.00491) and cLUNC/UST1 (factory close 4.70e-5, not 0.00; invertUsd 1.0, not ~21260).

Frontend at https://dex.cl8y.com is up (200). Closing: must-do indexer migrate + inverted Last vs last candle are live. Optional #542 novel Create Pair and #541 keyboard/layout walkthrough were not re-run in this check.

Production indexer `https://indexer.dex.cl8y.com` has the #543 candle `*_human` migrate. `GET /api/v1/pairs/terra16vxrhpvpcucu05y0nr862vf9hnqeh274uaff4s7hz4n0ea74006qf5hgqy/candles?interval=1h` (UST1/USTR): - bars include `open_human` / `high_human` / `low_human` / `close_human` - factory USD close ~`0.95`–`1.02` (not human ~77) - last 1h `2026-08-16T16:00Z` close `0.946836` / `close_human` `77.2376` → `invertUsd` **`0.0122588`** - last tape `price_usd` / `price` → same **`0.0122588`** (not ~`1.0`) Same check on UST1/cUSTC (factory ~`$1.07`, invertUsd ~`0.00491`) and cLUNC/UST1 (factory close `4.70e-5`, not `0.00`; invertUsd **`1.0`**, not ~`21260`). Frontend at `https://dex.cl8y.com` is up (200). Closing: must-do indexer migrate + inverted Last vs last candle are live. Optional #542 novel Create Pair and #541 keyboard/layout walkthrough were not re-run in this check.

PlasticDigits (Migrated from gitlab.com) closed this issue

2026-08-17 09:59:21 +00:00