23690388299
85%

Ran 28 Mar 2026 05:29PM UTC

Jobs 0

Files 0

Run time –

Badge

Embed ▾

pending completion

Build # 23690388299

Build Type

push

github

Committed by

web-flow

Commit Message

Fix the saving of the statistics on PosgreSQL #14124 (#14129)

* fix: deduplicate postgres sorted set bulk ops to prevent pkey violation

sortedSetIncrByBulk and sortedSetAddBulk did not deduplicate (key, value)
pairs before INSERT, causing "duplicate key value violates unique constraint
legacy_zset_pkey" errors since PostgreSQL ON CONFLICT only resolves against
existing table rows, not within-statement duplicates.

Also adds missing pageviews:ap metrics to analyticsKeys sorted set.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

* fix: use upsert with RETURNING to prevent postgres analytics write failures

Replace the INSERT ON CONFLICT DO NOTHING + separate SELECT verification
pattern with INSERT ON CONFLICT DO UPDATE RETURNING. The old pattern had
an unreliable gap between INSERT and SELECT causing random "failed to
insert keys for objects" errors that blocked all analytics writes.

The no-op upsert (DO UPDATE SET type = existing type) guarantees every
row is returned via RETURNING, eliminating the need for a separate SELECT
and the "missing keys" check entirely. Also deduplicates the keys array
to prevent "cannot affect row a second time" errors with DO UPDATE.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

---------

Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

Run Details

Source Files on build 23690388299

Detailed source file information is not available for this build.

NodeBB / NodeBB / 23690388299
85%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on build 23690388299

NodeBB / NodeBB / 23690388299 85%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on build 23690388299

NodeBB / NodeBB / 23690388299
85%

README BADGES
x