hive activity https://gitlab.syncad.com/hive 2026-03-17T03:36:11Z tag:gitlab.syncad.com,2026-03-17:339426 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T03:36:11Z dan Dan Notestein

Dan Notestein (70908333) at 17 Mar 03:36

Fix hypertable index creation: WITH clause placement and error reco...

tag:gitlab.syncad.com,2026-03-17:339424 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T02:32:36Z dan Dan Notestein

Dan Notestein (d9619c50) at 17 Mar 02:32

Use transaction_per_chunk for hypertable indexes, skip pg_dump test

tag:gitlab.syncad.com,2026-03-17:339422 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T01:48:19Z dan Dan Notestein

Dan Notestein (f6e0308d) at 17 Mar 01:48

Use separate transactional connection for hypertable indexes

tag:gitlab.syncad.com,2026-03-17:339421 Dan Notestein pushed to project branch fix/healthcheck-block-id-query at hive / haf_api_node 2026-03-17T01:34:46Z dan Dan Notestein

Dan Notestein (888781f2) at 17 Mar 01:34

Show run start time and HAF container uptime on state page

tag:gitlab.syncad.com,2026-03-17:339420 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T01:17:53Z dan Dan Notestein

Dan Notestein (1f9aa74a) at 17 Mar 01:17

Add lock_timeout for hypertable index creation

tag:gitlab.syncad.com,2026-03-17:339419 Dan Notestein pushed to project branch fix/catalog-concurrent-registration at hive / haf 2026-03-17T01:03:33Z dan Dan Notestein

Dan Notestein (edde755c) at 17 Mar 01:03

Add advisory locks to prevent concurrent catalog modification errors

... and 1 more commit

tag:gitlab.syncad.com,2026-03-17:339417 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T00:50:51Z dan Dan Notestein

Dan Notestein (16dec608) at 17 Mar 00:50

Fix scope: move index_constraint_name declaration before try block

tag:gitlab.syncad.com,2026-03-17:339416 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T00:41:09Z dan Dan Notestein

Dan Notestein (d3be1ad2) at 17 Mar 00:41

Skip CONCURRENTLY for hypertable indexes in poll_and_create

tag:gitlab.syncad.com,2026-03-17:339415 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T00:18:18Z dan Dan Notestein

Dan Notestein (e5fc3648) at 17 Mar 00:18

Handle inherited FK constraints from hypertable references

tag:gitlab.syncad.com,2026-03-17:339411 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T00:11:27Z dan Dan Notestein

Dan Notestein (b3f7e7fa) at 17 Mar 00:11

Fix FK conditional: use pg_class.relkind instead of timescaledb views

tag:gitlab.syncad.com,2026-03-17:339408 Dan Notestein opened merge request !948: Fix tuple concurrently updated in catalog registration at hive / haf 2026-03-17T00:06:32Z dan Dan Notestein

Summary

  • Adds pg_advisory_xact_lock(hashtext('hive_catalog_modification')) to serialize concurrent modifications to HAF catalog tables (hafd.contexts, hafd.registered_tables, hafd.triggers)
  • Prevents PostgreSQL "tuple concurrently updated" errors when multiple HAF apps (e.g., hivemind, block_explorer, balance_tracker) start simultaneously and register their contexts/tables

Problem

When multiple apps create contexts and register tables concurrently, their transactions can attempt to INSERT/UPDATE the same catalog rows simultaneously. PostgreSQL raises ERROR: tuple concurrently updated — an immediate failure (not a deadlock) that crashes the app startup.

Approach

Uses transaction-scoped advisory locks (pg_advisory_xact_lock) with a single shared lock key across all catalog-modifying functions:

  • hive.context_create — INSERT into hafd.contexts and hafd.contexts_attachment
  • hive.context_remove — DELETE from hafd.contexts and related tables
  • hive.register_table — INSERT into hafd.registered_tables and hafd.triggers
  • hive.unregister_table — DELETE from hafd.registered_tables and related cleanup

Advisory locks are lightweight (no table-level locks), automatically released at transaction end, and only serialize the catalog mutation path — they don't affect normal app operations like app_next_block.

Test plan

  • Existing hfm_functional_tests pass (context creation, table registration, removal)
  • Verify no regression in single-app startup path
  • Manual test: start 3+ apps simultaneously against the same HAF instance
tag:gitlab.syncad.com,2026-03-17:339407 Dan Notestein pushed new project branch fix/catalog-concurrent-registration at hive / haf 2026-03-17T00:06:18Z dan Dan Notestein

Dan Notestein (7ac83e7d) at 17 Mar 00:06

Add advisory locks to prevent concurrent catalog modification errors

tag:gitlab.syncad.com,2026-03-17:339406 Dan Notestein pushed to project branch feature/timescaledb-compression at hive / haf 2026-03-17T00:04:36Z dan Dan Notestein

Dan Notestein (2debdbe6) at 17 Mar 00:04

Make TimescaleDB hypertable conversion conditional

tag:gitlab.syncad.com,2026-03-16:339400 Dan Notestein pushed new project branch feature/timescaledb-compression at hive / haf 2026-03-16T23:41:50Z dan Dan Notestein

Dan Notestein (619c6bbc) at 16 Mar 23:41

Add TimescaleDB columnar compression for hafd.operations

... and 19 more commits

tag:gitlab.syncad.com,2026-03-16:339393 Dan Notestein deleted project branch fix/revert-bodyval-from-develop at hive / haf_block_explorer 2026-03-16T23:33:27Z dan Dan Notestein

Dan Notestein (64a8961f) at 16 Mar 23:33

tag:gitlab.syncad.com,2026-03-16:339392 Dan Notestein pushed to project branch develop at hive / haf_block_explorer 2026-03-16T23:33:26Z dan Dan Notestein

Dan Notestein (64a8961f) at 16 Mar 23:33

Pin test runner image to working digest

... and 8 more commits

tag:gitlab.syncad.com,2026-03-16:339391 Dan Notestein accepted merge request !470: Revert bodyval code accidentally merged into develop at hive / haf_block_explorer 2026-03-16T23:33:26Z dan Dan Notestein

Summary

MR !467 (feature/defer-haf-indexes) was branched off the bodyval migration code, so merging it into develop dragged in 4 bodyval prerequisite commits. Subsequent MRs added more bodyval-dependent CI fixes on top.

This reverts all bodyval-specific changes from develop:

  • 0e02c67 Migrate from body_binary to body_value
  • 8f3d574 Update submodules and CI to bodyval branches
  • ab5720b Set HAFAH_VERSION to bodyval branch image
  • 80786e5 Fix path filter timeout using body_value
  • 4c8671d Revert HAF/HAfAH to body-value-migration
  • d3577f1 Fix test docker-compose entrypoint for bodyval HAF

Also fixes register_haf_indexes() in hafbe_app.sql which was written against bodyval (body_value) but needs body_binary::jsonb -> 'value' on develop.

The bodyval branch (feature/body-value-migration) has its own independent copies of all these changes — nothing is lost.

Non-bodyval features preserved

  • 5b7b588 Defer HAF table index creation (kept, indexes fixed to use body_binary)
  • 9041e51 Fix $$ dollar-quote conflict (kept)
  • UID consolidation commits (kept)
  • All other develop-only work (kept)
tag:gitlab.syncad.com,2026-03-16:339383 Eric Frias pushed to project branch ipv6-attempt-2 at hive / hive 2026-03-16T23:14:18Z efrias Eric Frias

Eric Frias (900b22b1) at 16 Mar 23:14

Update fc submodule: fix tcp_server IPv6 listening

tag:gitlab.syncad.com,2026-03-16:339382 Eric Frias pushed to project branch ipv6-support at hive / fc 2026-03-16T23:14:07Z efrias Eric Frias

Eric Frias (5997c78a) at 16 Mar 23:14

Fix tcp_server to support IPv6 listening endpoints

tag:gitlab.syncad.com,2026-03-16:339381 Dan Notestein pushed to project branch fix/revert-bodyval-from-develop at hive / haf_block_explorer 2026-03-16T23:01:11Z dan Dan Notestein

Dan Notestein (64a8961f) at 16 Mar 23:01

Pin test runner image to working digest