Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

Database AdministrationDumpFreeze

0 likes · 14 min read

Diagnosing Freeze and Dump Issues in OceanBase Memstore

ITPUB

Mar 24, 2022 · Databases

How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors

This article explains the cause of PostgreSQL "database is not accepting commands to avoid wraparound data loss" errors, details the XID allocation and wraparound mechanisms, and provides manual and automated vacuum‑freeze solutions with concrete SQL commands and scripts.

Database MaintenanceFreezeVacuum

0 likes · 14 min read

How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors