What follows are the release notes for the YugabyteDB 2024.2 release series. Content will be added as new notable features and changes are available in the patch releases of the YugabyteDB 2024.2 release series. For an RSS feed of all release series, point your feed reader to the [RSS feed for releases](../index.xml). {{< note title="CDC - gRPC Connector compatibility" >}} YugabyteDB v2024.2 requires gRPC Connector dz.1.9.5.yb.grpc.2024.2.3 or later. {{< /note >}} ## v2024.2.8.0 - February 23, 2026 {#v2024.2.8.0} **Build:** `2024.2.8.0-b85` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.8.0/yugabytedb-2024.2.8.0-b85-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.8.0/yugabytedb-anywhere-2024.2.8.0-b85-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.8.0-b85 ``` ### Improvements #### YSQL * Optimized the postgres build process by removing the redundant and time-consuming install_wrapper.py. {{}} * Enables integration of YSQL with PG's snapshot management for Repeatable Read isolation level. {{}} * Disables snapshot switching support for Repeatable Read isolation. {{}} * Deprecated the flag `ysql_conn_mgr_max_phy_conn_percent` and introduced new flag `ysql_conn_mgr_reserve_internal_conns` for reserving connections for internal operations. {{}} * Adds a Java test to verify that the `avg_wait_time_ns` stat is updated for the control connection pool. {{}} * Logs `ysql_dump` output on script failure during DB cloning. {{}} #### YCQL * Enables clearing the YCQL MetaData cache via the `yb-ts-cli` tool. {{}} #### DocDB * Introduced `InterprocessSharedMemoryObject` and `InterprocessMappedRegion` to wrap `boost::interprocess` calls, converting exceptions to `Status` returns. {{}} * Adds the `ysql_clone_disable_connections` flag to allow YSQL database connections during cloning. {{}} * Enables detailed data and checksum dumps for tablets via new commands, aiding in consistency checks and troubleshooting. {{}} * Enables `log-dump` to read encrypted WAL files using the `master_addresses` flag. {{}} * Suppresses error logs for missing files on deletion to streamline operations. {{}} * Reworked the load balancer to not hold `CatalogManager::mutex_` for each placement run, thus improving efficiency. {{}} * Logs tserver start time and PID for easier troubleshooting. {{}} * Tracks and alerts on more RPC rejections due to memory pressure. {{}} * Enables system catalog flush and compaction across all yb-master peers. {{}} * Reduces log frequency to once per second for tablets stuck in bootstrapping. {{}} * Marks `follower_unavailable_considered_failed_sec` as a runtime flag. {{}} * Ensures reliable xCluster history cutoff by backfilling `namespace_id` when necessary. {{}} * Added new `/snapshots` endpoint to tserver UI displaying space overhead information of snapshots, including snapshot ID, time, cumulative required space, exclusive data space, and schedule ID. {{}} * Reenables LogReader memory limit in xCluster following resolution of TryConsume bug. {{}} * Adds yb-admin command `are_nodes_safe_to_take_down ` to check if nodes can be taken down without losing quorum. {{}} * Simplifies load balancer's placement info management. {{}} * Prevents sending of `YBParsePrepareErrorResponse` packet for unnamed prepared statements. {{}} * Added compiler errors to Odyssey build for improved compile-time checking. {{}} #### CDC * Added runtime flag to control CDC with Savepoints and Rollback feature, and introduced tests for rollback and savepoint behavior. {{}} * Reduced logging levels in `CatalogManager::FindXReplStreamsMarkedForDeletion` when a table is dropped. {{}} ### Bug fixes #### YSQL * Allows yb-admin ysql_catalog_version command to return per-DB Catalog Version value for a provided database. {{}} * Fixed an issue where integer overflow in the new cost model could lead to negative cost estimates, resulting in poor plan choices. {{}} * Disallowed Batched Nested Loop joins when the inner relation is a temporary table to prevent cache lookup errors or assertion failures. {{}} * Fixes quoting for unique constraints during schema restores. {{}} * Ensures accurate index updates in `INSERT ... ON CONFLICT` for partial indexes. {{}} * Fixed issue where unique index data was missing for colocated databases after restore, now preserving implicit tablegroup oid. {{}} * Fixed a bug in YugabyteDB's backup and restoration process involving the mismatch of colocation_id in colocated databases. The fix preserves the original colocation_id when implicit indexes are created during the ALTER TABLE statement, ensuring that the colocation ids are consistent after restoration. {{}} * Fixed a metadata correctness bug that caused errors when using minimal preloading with negative caching. {{}} * Restored legacy mode costing and path creation behavior in YSQL. This is achieved by reverting BNL specific changes and negating a side effect on row count estimation introduced by boolean index fix. {{}} * Mitigate frequent read restart errors when concurrently executing CREATE TEMP TABLE commands. {{}} * Fixed a missing build dependency issue in the yb_pgwrapper library that caused a failure when running build with clean-postgres. {{}} * Adds flag for parameter yb_ignore_bool_cond_for_legacy_estimate, allowing setting via flag before upgrading from 2.20. {{}} * Removes redundant `yb_cdc_snapshot_read_time` field, simplifying snapshot management. {{}} * Fixes crashes during complex row comparisons in YSQL queries. {{}} * Refines text linting rules by updating file exclusion patterns in `.arclint`. {{}} * Ensures accurate data return from index scans by correctly fetching needed values for rechecks. {{}} * Fixed issue where server connection gets stuck due to full server write buffer after ungraceful client disconnects. {{}} * Implemented a fix to remove stale entries from the server's hashmap during connection manager reset phase. {{}} * Fixed the Connection Manager's support for replication connections, ensuring that it independently manages these connections, aligning with PostgreSQL's behavior. {{}} * Reduces CPU usage in connection manager by improving `epoll_*` functions and fixing syntax errors. {{}} * Eliminated potential TCP deadlock in YSQL by changing to asynchronous write in `od_frontend_remote_client`. {{}} #### YCQL * Enables retrying YCQL analyze steps for `OBJECT_NOT_FOUND` errors to refresh cache. {{}} * Prevents crashes by correctly handling NULL index references in YCQL queries. {{}} * Ensures YCQL truncate command waits for index tables as well. {{}} #### DocDB * Allows removal of associated intentsdb keys during tablet startup to prevent potential pileup and slower queries. {{}} * Adds extra logging to track data inconsistency when `durable_wal_write` is set to false. {{}} * Changes error message to "Unable to find the leader" for clarity. {{}} * Fixes tablet split validation to handle 0x0000 as an empty key for hash partitions. {{}} * Ensures successful cloning of altered databases by managing connection permissions during the operation. {{}} * Prevents data loss on followers during tablet splits by using MVCC for split operations. {{}} * Introduces `min_replay_txn_first_write_ht` to address transaction data loss that occurred due to incorrect filtering of transactions on bootstrap. {{}} * Automatically cleans up discarded checkpoints to prevent disk full issues during remote bootstraps. {{}} * Limits the number of entries per trace to prevent memory bloat during long running operations. {{}} * Fixes a bug in DBIter fast mode that caused process crashes during unique index back in HasDuplicateUniqueIndexValueBackward. {{}} * Disables intent filtering for bootstrap due to transaction filtering issues with `use_bootstrap_intent_ht_filter` set to true. {{}} * Fixes a regression that allowed restoring to a time earlier than the maximum retention window, potentially causing database instability. {{}} * Ensures correct resetting of the wait state in the WAL appender thread. {{}} * Skips parent tablet in data dumps for colocated tables. {{}} * Disables tablet splits during table hide operations to prevent state inconsistencies and lock leaks. {{}} * Modified `od_write` function to prevent double free of `mm_msg_t` objects and enhanced `machine_msg_free` to handle NULL messages. {{}} * Maintains correct message order by buffering ParameterStatus updates. {{}} * Handles sync timeout more effectively during connection resets. {{}} * Resolves Bind packet forwarding issue for unnamed prepared statements. {{}} * Fixes a potential segfault when handling auth errors in Auth Passthrough mode. {{}} #### CDC * Fixes the issue where UPAM gets stuck for colocated tablets with indexes, ensuring continuity of CDC operations. {{}} * Restores CDC support for Savepoints and Rollbacks, now controlled by a new flag. {{}} * Fixes endpoint verification failures by using DNS hostnames for local connections. {{}} * Enables `cdc_enable_savepoint_rollback_filtering` by default, enhancing CDC support. {{}} * Reduces the frequency of log spam due to missing tablet warnings by changing logging parameters. {{}} ## v2024.2.7.3 - February 3, 2026 {#v2024.2.7.3} **Build:** `2024.2.7.3-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.7.3/yugabytedb-2024.2.7.3-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.7.3/yugabytedb-anywhere-2024.2.7.3-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.7.3-b1 ``` ### Bug fixes #### YSQL - Ensures consistent index updates during `INSERT ... ON CONFLICT` operations. {{}} #### DocDB - Fixes crash by replacing speculative read with multiple smaller reads in `FastDecodeSignedVarInt()`. {{}} ## v2024.2.7.2 - January 16, 2026 {#v2024.2.7.2} **Build:** `2024.2.7.2-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.7.2/yugabytedb-2024.2.7.2-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.7.2/yugabytedb-anywhere-2024.2.7.2-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.7.2-b1 ``` ### Bug fix #### YSQL - Fixed an issue where bind packets were not forwarded to the backend in certain cases involving unnamed prepared statements. {{}} ## v2024.2.7.1 - December 31, 2025 {#v2024.2.7.1} **Build:** `2024.2.7.1-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.7.1/yugabytedb-2024.2.7.1-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.7.1/yugabytedb-anywhere-2024.2.7.1-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.7.1-b1 ``` ### Bug fix #### YSQL - Add flag for parameter yb_ignore_bool_cond_for_legacy_estimate. {{}} ## v2024.2.7.0 - December 30, 2025 {#v2024.2.7.0} **Build:** `2024.2.7.0-b62` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.7.0/yugabytedb-2024.2.7.0-b62-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.7.0/yugabytedb-anywhere-2024.2.7.0-b62-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.7.0-b62 ``` ### Improvements #### YSQL * Expands EXPLAIN (ANALYZE, DIST) output to include transaction type, enabling a more formal way to deduce transaction type. {{}} * Increases timeout for tserver catalog version wait to 30 seconds, reducing connection time outs. {{}} * Reduces peak memory usage in yb_active_session_history by filtering out rows more quickly. {{}} #### DocDB * Adjusts the `wal_size` metric to include the size of the current active, writable segment, ensuring accurate reflection of on-disk size. {{}} * Adds logging to detect and inform if scheduled tasks in the reactor run slower than expected. {{}} * Adds ASH instrumentation to snapshots for better tracking of backup and snapshot bottlenecks. {{}} * Capture TCMalloc and MemTrackers stats in logs when exceeding the root memtracker soft memory limit for easier memory issues investigation. {{}} * Adds tablet replica SST and WAL size to master UI and sorts tablets by partition key. {{}} #### CDC * Reduces logging levels in `CatalogManager::FindXReplStreamsMarkedForDeletion()` for cleaner logs. {{}} ### Bug fixes #### YSQL * Allows setting YSQL configuration parameters to a whitespace empty value without causing error. {{}} * Ensures deletion of table entries without causing parsing failure due to empty strings. {{}} * Eliminates occurrence of negative cost estimates in new cost model due to integer overflow, enhancing plan choices. {{}} * Forces loading of index expressions during index creation to prevent missed updates and potential inconsistencies. {{}} * Fixes a regression bug that caused an OBJECT_NOT_FOUND error during an index alteration, ensuring smoother table modifications. {{}} * Restores distinct error messages for `kAbort` and `kConflict` errors for clearer troubleshooting. {{}} * Fixes an error where a join condition was incorrectly pushed down in a batched nested loop, preventing crashes during planning. {{}} * Prevents crashes during scalar array operations with arrays of dimension greater than two. {{}} * Reduces transient memory spikes during long running write queries by fixing intra-query memory leaks. {{}},{{}} * Fixes a crash during commit on temporary tables when using the extended query protocol. {{}} * Restores legacy mode costing and path creation behavior, negating a side effect on row count estimation. {{}} * Mitigate frequent read restart errors when concurrently executing CREATE TEMP TABLE commands. {{}} * Removes stale server hashmap entries during connection manager reset phase to prevent errors. {{}} * Solves server connection issues when client disconnects ungracefully and data is still pending to be written. {{}} * Fixes connection manager crash during authentication due to double freeing of `msg` object. {{}} #### DocDB * Changes prevent unnecessary node crashes due to network issues during remote bootstrapping process cleanup. {{}} * Prevents silent data loss by failing the clone when a table is altering instead of cloning without data. {{}} * Disables TryConsume usage by LogReader to prevent user operations from being incorrectly blocked due to a bug. {{}} * Handles thread creation failure properly and falls back to RPC mechanism when thread cannot start. {{}} * Allows transaction table deletion by updating transaction versions only on live tablet servers. {{}} * Allows namespace_id to be correctly copied in TableInfo constructors to prevent empty return values. {{}} * Adjusts active log segment size tracking for accurate `wal_size` metric when reusing existing segments. {{}} * Ensures that failed ALTER TABLE statements roll back even in the event of a master crash. {{}} * Moves startup tablet cleanup to a background thread to prevent server crash during simultaneous server shutdown and tablet cleanup. {{}} * Allows DBIter fast next mode to correctly handle backward iteration to prevent process crashes. {{}} * Adjusts root memory tracker to prevent overestimation of consumption, avoiding false memory limit hits. {{}} * Fixes a bug in DBIter fast mode that caused process crashes during unique index back in HasDuplicateUniqueIndexValueBackward. {{}} * Disables intent filtering during bootstrap to avoid incorrect transaction filtering. {{}} * Truncates user and database names longer than 64 characters to prevent buffer overflow. {{}} * Avoids TCP deadlock by not using `od_write` in `od_frontend_remote_client`. {{}} * Prevents data loss by replacing `min_replay_txn_start_ht` with `min_replay_txn_first_write_ht` for improved transaction loading during bootstrap. {{}} #### CDC * Reverts a commit due to a misunderstanding about the effects of failures when writing to the CDC state table. {{}} * Prevent loss of records due to bugs in the `PeerMessageQueue::ReadReplicatedMessagesForConsistentCDC` implementation. {{}} * Allows large transactions for unqualified tables to stream correctly, preventing the virtual WAL from getting stuck. {{}} * Fixes CDC issue with virtual WAL restart after a DDL, preventing record decoding failure. {{}} * Filters out data from rolled-back savepoints in CDC streaming, ensuring only valid data is received by CDC consumers. {{}} * Prevents the "Trying to fetch already GCed intents" error by correctly updating and managing checkpoints for child tablets after a tablet split. {{}} * Stops applying the LogReader memory limit to CDC, a setting intended only for xCluster. {{}} * Adds "Log index cache entry for op index not found" error to retryable errors in cdcsdk_virtual_wal. {{}} * Reverses changes to support savepoints due to an exposed bug, specifically for version 2025.2.0. {{}} * Reduces the frequency of log spam due to missing tablet warnings by changing logging parameters. {{}} ## v2024.2.6.2 - December 22, 2025 {#v2024.2.6.2} **Build:** `2024.2.6.2-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.6.2/yugabytedb-2024.2.6.2-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.6.2/yugabytedb-anywhere-2024.2.6.2-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.6.2-b2 ``` ### Bug fix #### YSQL - Eliminates occurrence of negative cost estimates in new cost model due to integer overflow, enhancing plan choices. {{}} ## v2024.2.6.1 - November 11, 2025 {#v2024.2.6.1} **Build:** `2024.2.6.1-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.6.1/yugabytedb-2024.2.6.1-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.6.1/yugabytedb-anywhere-2024.2.6.1-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.6.1-b2 ``` ### Bug fixes * Fixes crash in Connection Manager when trying to create multiple connections where authentication failed. {{}} * Make connections sticky if hll_set_max_sparse() is set. {{}} * Fix issue with virtual WAL restart after DDL. {{}} ## v2024.2.6.0 - October 31, 2025 {#v2024.2.6.0} **Build:** `2024.2.6.0-b94` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.6.0/yugabytedb-2024.2.6.0-b94-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.6.0/yugabytedb-anywhere-2024.2.6.0-b94-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.6.0-b94 ``` ### Improvements #### YSQL * Ensures YSQL index backfill operations resume seamlessly after a master leader failover. {{}} * Removes the beta warning for the `ANALYZE` command starting in version 2024.2. {{}} * Adds support for deferred mode in `yb_read_after_commit_visibility` for writes. {{}} * Displays transaction type in EXPLAIN (ANALYZE, DEBUG) output. {{}} * Enhances row boundary settings for hash-partitioned tables using encoded DocKeys. {{}} * Introduces the `yb_fk_references_cache_limit` parameter to cap FK references cache entries at 65535. {{}} * Reduces master load by allowing auth backends to utilize the TServer cache during authorization checks. {{}} * Enables bounded staleness for PostgreSQL authentication backend cache using `pg_cache_response_trust_auth_lifetime_limit_ms`. {{}} * Sets stricter copyright enforcement for C++ files on master but reduces rule severity on backport branches. {{}} * Reduces master RPCs for PG auth backends by using TServer cache. {{}} * Avoids unnecessary memory spikes and ensures freshest catalog data for relationship cache initialization. {{}} * Streamlines request pagination in scans for consistent behavior across all directions. {{}} * Adds new YSQL configuration parameter `yb_enable_cbo=legacy_ignore_stats_bnl_mode`. {{}} * Adds a flag `ysql_enable_scram_channel_binding` to enable SCRAM with channel binding. {{}} * Enables viewing tcmalloc memory statistics for the connection manager. {{}} * Enhances CM decision-making by always using a custom ParameterStatus packet. {{}} * Allows setting YSQL configuration parameters to whitespace empty values without causing errors. {{}} #### DocDB * Limits TServer crashes by capping log reader memory usage in xCluster replication. {{}},{{}} * Enhances on-disk size metrics to include snapshots, improving cluster balancer accuracy. {{}} * Adds new wait events for ASH instrumentation to identify bottlenecks during bootstrap. {{}} * Limits TServer crashes by capping log reader memory usage in xCluster replication. {{}} * Fixes a vulnerability allowing incorrect database row access or modification. {{}} * Ensures AuthOK messages are sent immediately to clients, simplifying future changes. {{}} * Allows users to specify SSL ciphers and minimum TLS version on webserver ports. {{}} * Temporarily disables TryConsume feature in LogReader to prevent incorrect blocking of user operations due to a memory bug. {{}} #### CDC * Displays replica identity map in `list_change_data_streams` output. {{}} * Enhances error propagation from `GetChanges` to clients for more transparency. {{}} * Handles error propagation from CDC to client for missing footer in segments. {{}},{{}} * Prevents LogReader memory limit from being wrongly applied to CDC, avoiding crashes during WAL resume. {{}},{{}} ### Bug fixes #### YSQL * Ensures `TimeZone` is not lowercased in connection manager for correct pgJDBC interpretation. {{}} * Avoids segmentation faults in ASH queries by initializing wait states to `kIdle` instead of `kUnused`. {{}} * Enables accurate tablespace dependency tracking for tables moved via `ALTER TABLE SET TABLESPACE`. {{}} * Disables writes to role profile tables during YSQL upgrades to prevent errors. {{}} * Ensures the correct renew strategy for `IsRenewRequired` works as expected. {{}} * Ensures `yb_enable_cbo` correctly activates when legacy YSQL configuration parameters are ON. {{}} * Adds options to enable pre-2024.1 BNL cost behavior in non-CBO mode. {{}} * Reduces unnecessary catalog version increments for renames on temporary relations. {{}} * Fixes crashes when locking rows in temporary tables by setting the correct transaction state. {{}} * Fixes a regression bug that caused an `OBJECT_NOT_FOUND` error during an index alteration, ensuring smoother table modifications. {{}} * Fixes a memory leak by using condition variables for signal handling in the connection manager. {{}} * Prevents indefinite stalls in multi-route pooling by ensuring signals are broadcast across all routes. {{}} * Enables defining the maximum percentage of total YSQL connections for the connection manager. {{}} #### DocDB * Ensures tablet server limits in the UI exclude dead or blacklisted nodes, providing accurate data metrics. {{}} * Prevents potential deadlocks in Raft operations by managing flusher state effectively. {{}} * Allows SST files with specific row or column TTLs to remain candidates for compaction. {{}} * Ensures tablet split handling on the consumer side does not cause incorrect mappings due to race conditions. {{}} * Eliminates redundant `rocksdb_block_cache_bytes_read` metrics to reduce noise and overhead. {{}} * Restores deletion of table info objects to prevent memory overload. {{}} * Enhances metrics to better estimate cluster balancing times and validate the accuracy of the balancing algorithm. {{}} * Enforces TLS v1.2 for secure webserver connections. {{}} * Preserves cluster balancer metrics correctly across all placements including read replicas. {{}} * Fixes issues with aborted transactions during promotions preventing stuck operations. {{}} * Increases data metric's capacity to handle over 4 GB for balancing. {{}} * Adds a memory tracker to monitor temporary memory used when reading WALs, preventing TServer crashes. {{}} * Adds CRC checksum to RPC calls to detect data corruption. {{}} * Reduces segmentation faults by isolating cascading timeout handling to auth processes. {{}},{{}},{{}},{{}} * Eliminates stale hashmap entries on parse errors, enhancing protocol-level prepared statement handling. {{}} * Renames conflicting random number functions to prevent data race issues. {{}} * Avoids crashes and data races during shutdown by safely managing thread resources and memory clean-up. {{}} #### CDC * Ensures unique sorting of batched shard records using `write_id` to prevent data loss. {{}} * Ensures only tables in a publication are checked for `CHANGE` replica identity. {{}} * Handles error propagation from CDC to client for missing footer in segments. {{}} ## v2024.2.5.1 - September 11, 2025 {#v2024.2.5.1} **Build:** `2024.2.5.1-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.5.1/yugabytedb-2024.2.5.1-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.5.1/yugabytedb-anywhere-2024.2.5.1-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.5.1-b1 ``` ### Bug fix - Enforces TLS v1.2 for secure webserver connections. {{}} ## v2024.2.5.0 - August 29, 2025 {#v2024.2.5.0} **Build:** `2024.2.5.0-b59` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.5.0/yugabytedb-2024.2.5.0-b59-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.5.0/yugabytedb-anywhere-2024.2.5.0-b59-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.5.0-b59 ``` ### New feature - [Ephemeral disk support](/v2024.2/deploy/checklist/#ephemeral-disks) {{}}. Added support for ephemeral disks for on-premises universes to improve performance for read-heavy workloads. ### Improvements #### YSQL * Captures and returns per-RPC metrics for write operations. {{}} * Adds a constructor to `Result` class for simplified handling of convertible results. {{}} * Displays write RPC metrics in `EXPLAIN (ANALYZE, DIST, DEBUG)` output. {{}} * Displays TCMalloc and PGGate memory stats in `pg_log_backend_memory_contexts` for enhanced debugging. {{}} * Enables testing backup and restore processes with role checks in YBC. {{}} * Ensures all `COPY FROM` commands in a transaction block use one transaction unit. {{}} * Includes transaction isolation level in serialization error messages. {{}} #### DocDB * Fixes overflow in `FormatBytesAsStr` to prevent large memory allocations. {{}} * Speeds up write operations by using `ScopedStatistics`, reducing TServer insert time. {{}} * Reduces thread usage by removing CDC-specific `yb_client` from `PgClientServiceImpl`. {{}} * Enables core dumps on FATAL errors with new flag `disable_core_dumps_on_fatal`. {{}} #### CDC * Prevents data loss during restarts by not sending checkpoints if tablet safe time exceeds slot restart time. {{}} #### Other * Allows users to specify SSL ciphers and minimum TLS version on webserver ports. {{}} ### Bug fixes #### YSQL * Fixes errors and crashes when creating temporary tables with `ON COMMIT DROP`. {{}} * Resolves GCC 13 release build failures on Linux. {{}} * Switches to reading from the latest catalog during YSQL GUC processing to prevent "Snapshot too old" errors. {{}} * Disables automatic retries for `COPY FROM/TO` commands. {{}} * Assigns accurate query IDs to RPCs executed outside of executor hooks. {{}} * Fixes crash by initializing CacheMemoryContext during backend startup. {{}} * Prevents server crashes when multiple backend processes terminate while one holds a spinlock. {{}} * Supports accurate cost estimates for hypothetical indexes in both old and new models. {{}},{{}} * Fixes crash when using planner hints with hypothetical indexes. {{}} * Prevents crashes during PostgreSQL backend exit when ASH is enabled. {{}} * Reverts recent changes to handle postmaster PANIC, improving stability during error scenarios. {{}} * Enhances pgaudit to skip auditing of relations without permissions, reducing logging errors and improving efficiency. {{}} * Resolves `pgaudit stack is not empty` errors and skips auditing for permission-less relations. {{}} * Enables `yb_db_admin` roles to set PL speculative execution parameters. {{}} * Ensures accurate catalog read counts for the first query in a session. {{}} * Ensures `yb_enable_cbo` correctly activates when legacy YSQL configuration parameters are ON. {{}} * Adds options to enable pre-2024.1 BNL cost behavior in non-CBO mode. {{}} * Prevents crashes by ensuring thread-safe rule de-referencing during route cleanup. {{}} * Prevents crashes by holding route locks until the server closes in multi-route pooling. {{}} * Prevents cascading timeouts during authentication lags in the connection manager. {{}} * Enhances stability for YSQL connection manager during COPY operations from Go drivers. {{}} * Fixes a memory leak by using condition variables for signal handling in the connection manager. {{}} * Prevents indefinite stalls in multi-route pooling by ensuring signals are broadcast across all routes. {{}} * Fixes crashes during `ysqlsh` connections with empty passwords under load. {{}} #### DocDB * Fixes unnecessary error logs during transaction loading with CDC enabled. {{}} * Prevents thread metric data from disappearing over time. {{}} * Enhances the stability of document reads by validating key prefixes before processing. {{}} * Ensures safety by updating `TabletPeer::GetNamespaceId` to use `shared_tablet_safe`. {{}} * Ensures OID counters in cloned or restored databases avoid conflicts after table drops. {{}} * Prevents master crashes during index backfill by handling empty indexes correctly. {{}} * Adds a wait event for transactions with SERIALIZABLE READ ONLY DEFERRABLE. {{}} * Fixes placement logic to support wildcards in cloud info for tablet selection. {{}} * Fixes a bug to ensure correct data storage in PostgreSQL table cache requests. {{}} * Disables transaction trace logs when `FLAGS_txn_slow_op_threshold_ms` is set to 0 to prevent log spew. {{}},{{}} * Reduces segmentation faults by isolating cascading timeout handling to auth processes. {{}},{{}},{{}},{{}} * Enhances visibility of `ALTER ROLE ... SET` configurations across multiple databases. {{}} #### CDC * Ensures CDC streams data for non-transactional YCQL tables correctly. {{}} ## v2024.2.4.2 - December 16, 2025 {#v2024.2.4.2} **Build:** `2024.2.4.2-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.4.2/yugabytedb-2024.2.4.2-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.4.2/yugabytedb-anywhere-2024.2.4.2-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.4.2-b2 ``` This is a YugabyteDB Anywhere-only release, with no changes to YugabyteDB. ## v2024.2.4.1 - August 20, 2025 {#v2024.2.4.1} **Build:** `2024.2.4.1-b4` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.4.1/yugabytedb-2024.2.4.1-b4-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.4.1/yugabytedb-anywhere-2024.2.4.1-b4-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.4.1-b4 ``` ### Bug fixes #### YSQL * Resolves GCC 13 release build failures on Linux. {{}} * Prevents PostgreSQL process crashes on exit when ASH is enabled. {{}} * Prevents cascading timeouts during authentication lags in the connection manager. {{}} * Fixes crashes during `ysqlsh` connections with empty passwords under load. {{}} * Enhances stability for YSQL connection manager during COPY operations from Go drivers. {{}} * Prevents crashes by holding route locks until the server closes in multi-route pooling. {{}} * Fixes a memory leak by using condition variables for signal handling in the connection manager. {{}} * Prevents indefinite stalls in multi-route pooling by ensuring signals are broadcast across all routes. {{}} * Prevents crashes by ensuring thread-safe rule de-referencing during route cleanup. {{}} * Reduces segmentation faults by isolating cascading timeout handling to auth processes. {{}},{{}},{{}},{{}} #### DocDB * Prevents deadlocks by reverting an update that blocked rpc threads. {{}} #### CDC * Ensures CDC streams data for non-transactional YCQL tables correctly. {{}} ## v2024.2.4.0 - July 14, 2025 {#v2024.2.4.0} **Build:** `2024.2.4.0-b89` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.4.0/yugabytedb-2024.2.4.0-b89-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.4.0/yugabytedb-anywhere-2024.2.4.0-b89-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.4.0-b89 ``` ### New feature * [Connection Manager](/v2024.2/explore/going-beyond-sql/connection-mgr-ysql/). - Reduced the cost of binding logical to physical connections to improve performance and lower application-level latencies, specifically by optimizing the GUC workflow. {{}} - Added SCRAM-SHA-256 [authentication method](/v2024.2/additional-features/connection-manager-ysql/ycm-setup/#authentication-methods) support for Connection Manager. ### Improvements #### YSQL * Enables speculative execution for certain PL statements to avoid unnecessary flushes, enhancing performance. {{}} * Reduces catalog version increments by optimizing auto-analyze batch processing. {{}} * Displays the number of rows removed by implicit index rechecks in the query plan. {{}},{{}} * Enhances accuracy of cost modeling for backward index scans based on the `use_fast_backward_scan` flag. {{}} * Adds a new YSQL parameter `yb_enable_cbo` for safer query optimization without statistics. {{}} * Enables automatic logging of peak heap snapshots on backend exits for enhanced debugging. {{}} * Enables setting `ysql_yb_enable_cbo` flag on tserver for query optimization. {{}} * Enables conditional checks for role existence in `ysql_dump` outputs with the `dump_role_checks` flag. {{}} * Increases the timeout for detecting `pg_yb_catalog_version` mode from 10 seconds to 20 seconds. {{}} * Reduces query execution latency by optimizing GUC handling in Connection Manager. {{}} #### DocDB * Adds data block consistency check to `sst_dump` tool. {{}} * Adds flag to allow tablet writes after a compaction failure. {{}} * Adds `remove_corrupt_data_blocks_unsafe` flag for `yb-ts-cli compact_tablet` command. {{}} * Ensures only voter peers are considered for leadership during a leader stepdown. {{}} * Upgrades OpenSSL to version 3.0.16 and enhances aarch64 support. {{}} * Displays RBS progress details on the master's Cluster Balancer UI page. {{}} * Enables file determination at compaction start by default. {{}} * Adds detailed cluster balancer warnings to the master UI page. {{}} * Enables conditional tracing of ASH events to conserve memory. {{}} * Displays cluster balancer tasks on the master UI page. {{}} * Streamlines tablespace validation by centralizing logic, enhancing future feature support. {{}} * Deprecates the `load_balancer_count_move_as_add` flag to simplify cluster balancing. {{}} #### yugabyted * Corrects VCPU display in yugabyted UI for k8s deployments. {{}} * Adds an environment variable to show accurate CPU details in Kubernetes deployments. {{}} * Upgrades yugabyted UI TypeScript version to `5.0.4` for better package compatibility. {{}} ### Bug fixes #### YSQL * Renames on unique constraints now update associated DocDB table names. {{}} * Disables neg hit optimization for inherited cache when minimal preload is on. {{}} * Enhances upgrades for indexes with hash column groups to correctly handle aliases and metadata. {{}} * Allows placement of table replicas in any specified region or zone using `*` wildcard. {{}} * Ensures secondary index scans remain consistent during concurrent deletes in YSQL. {{}} * Reduces sequence-related errors when using `ysql_conn_mgr_sequence_support_mode=pooled_with_currval_lastval`. {{}} * Fixes crash for UPDATE projections on partitioned tables with out-of-order columns. {{}} * Increases the default `ysql_output_buffer_size` to 1MiB to enhance query retries and reduce errors. {{}} * Ensures metadata consistency in upgraded indexes with renamed columns during YSQL major upgrades. {{}} * Fixes secondary index scan cost estimation on colocated tables. {{}} * Ensures YSQL statistics tables are saved and persist after a database restart. {{}} * Optimizes `ANALYZE` command for large rows, preventing RPC errors. {{}} * Fixes a memory leak in `yb_cancel_transaction` by freeing YbcStatus. {{}} * Ensures DROP COLUMN correctly rewrites child partitions when needed. {{}} * Ensures accurate EXPLAIN output for forward scans with aggregate pushdown. {{}} * Fixes crash by initializing CacheMemoryContext during backend startup. {{}} #### DocDB * Prevents creation of tablespaces with duplicate placement blocks. {{}} * Prevents deadlocks and unresponsiveness during high-load schema changes by fetching table info asynchronously. {{}} * Reduces follower lag by ensuring consistent Raft config during tablet splits. {{}} * Extends cloning timeout for multi-region deployments to prevent premature timeouts. {{}} * Ensures accurate replication for transactional writes on xCluster range partitioned tables. {{}} * Ensures post-split compactions complete even if background compactions are in progress. {{}} * Ensures consistent data reads by setting propagated safe time only after successful operation replication. {{}} * Prevents incorrect query results due to invalid seek keys in internal iterator operations. {{}} * Eliminates duplicate MasterService metrics for improved monitoring clarity. {{}} * Prevents unbounded growth of the `recently_applied_map` by not adding read-only transactions, conserving memory. {{}} * Prevents data loss by ensuring databases are flushed before updating flush markers. {{}} * Ensures tablets remain effectively managed during transition from RF1 to higher replication factors. {{}} * Adjusts `DocRowwiseIterator` to correctly include nulls for `NULLS FIRST` sorting. {{}} * Ensures long-running reads access the correct schema version after updates and compactions. {{}} * Fixes compaction errors from schema version mismatches by storing missing-value info. {{}} * Fixes the issue of recording "query id 0" in Active Session History samples. {{}} * Blocks nonconcurrent index creation on xCluster replicated tables. {{}} * Enables `yb-pbc-dump` to decrypt and process encrypted protobuf files using specified keys. {{}} * Ensures `pg_locks` query reliability when a node is down by continuing to serve requests. {{}} * Ensures column ID continuity in backups by preserving `next_column_id`. {{}} * Enables YSQL tracing even when `pg_client_use_shared_memory` is active. {{}},{{}},{{}} * Ensures no deadlock when threads wait on PgResponseCache for query results. {{}} * Ensures accurate logging in PgAudit by using `strdup` to prevent garbage values. {{}} * Reduces memory usage by optimizing `pg_locks` with specific iterator settings and intent limits. {{}} #### CDC * Ensures reliable CDC stream functionality during index creation, preventing schema packing errors. {{}} * Prevents deletion of child tablet entries during metadata cleanup. {{}} * Ensures hidden tablets are accessible during CDC stream fetches to prevent errors. {{}} * Optimizes CDC streams by sending a single BEGIN and COMMIT record for colocated tables. {{}},{{}} ## v2024.2.3.3 - August 11, 2025 {#v2024.2.3.3} **Build:** `2024.2.3.3-b4` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.3.3/yugabytedb-2024.2.3.3-b4-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.3.3/yugabytedb-anywhere-2024.2.3.3-b4-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.3.3-b4 ``` ### Bug fix #### CDC * Ensures CDC streams data for non-transactional YCQL tables correctly. {{}} ## v2024.2.3.2 - June 24, 2025 {#v2024.2.3.2} **Build:** `2024.2.3.2-b6` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.3.2/yugabytedb-2024.2.3.2-b6-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.3.2/yugabytedb-anywhere-2024.2.3.2-b6-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.3.2-b6 ``` ### Bug fixes #### YSQL * Disables neg hit optimization for inherited cache when minimal preload is on. {{}} #### DocDB * Prevents incorrect query results due to invalid seek keys in internal iterator operations. {{}} * Adjusts `DocRowwiseIterator` to correctly include nulls for `NULLS FIRST` sorting. {{}} ## v2024.2.3.1 - June 13, 2025 {#v2024.2.3.1} **Build:** `2024.2.3.1-b3` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.3.1/yugabytedb-2024.2.3.1-b3-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.3.1/yugabytedb-anywhere-2024.2.3.1-b3-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.3.1-b3 ``` ### Improvement #### YSQL * Enables speculative execution for certain PL statements to avoid unnecessary flushes, enhancing performance. {{}} ### Bug fix #### DocDB * Ensures accurate replication for transactional writes on xCluster range partitioned tables. {{}} ## v2024.2.3.0 - May 16, 2025 {#v2024.2.3.0} **Build:** `2024.2.3.0-b116` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.3.0/yugabytedb-2024.2.3.0-b116-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.3.0/yugabytedb-anywhere-2024.2.3.0-b116-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.3.0-b116 ``` ### Highlights This release brings significant enhancements focused on performance, flexibility, and operational improvements: **Enhanced Query Performance with Parallel Queries** {{}} Experience faster query execution on **colocated tables** with the introduction of [PostgreSQL's Parallel Queries](/v2024.2/additional-features/parallel-query/). This allows the database to leverage multiple CPU cores for quicker results. Support for sharded tables is coming soon. **Greater Flexibility in Cross-Cluster Replication** {{}} Gain more control with the ability to temporarily enable write operations on xCluster Standby universes and read/write access on replicas in SQL [transactional mode](/v2024.2/architecture/docdb-replication/async-replication/#transactional). This exception-based access, configurable via a session-level configuration parameter, accommodates specific operational needs and tool integrations. **Enhanced Data Privacy with PostgreSQL Anonymizer** {{}} YugabyteDB now includes the [PostgreSQL Anonymizer extension](/v2024.2/additional-features/pg-extensions/extension-pganon/), which allows you to mask or replace sensitive data (PII or commercially sensitive information) directly in the database. ### Change log
View the detailed changelog ### Improvements #### YSQL * Exempts walsender from YSQL backend checks to prevent index creation timeouts. {{}} * Enables viewing TCMalloc heap snapshots for PG backend processes via new YSQL functions. {{}} * Enhances `yb_servers` function to include `universe_uuid` for better cluster identification. {{}} * Enables pushdown of UUID and datetime types in mixed mode. {{}},{{}} * Enables function pushdown for MOD, LIKE, ASCII, SUBSTRING in mixed mode upgrades. {{}} * Adds `enable_pg_anonymizer` flag for enabling the PostgreSQL anonymizer extension. {{}} * Displays index name for missing index row errors in `yb_index_check`. {{}} * Logs now detail the cause and context of read restart errors for better troubleshooting. {{}} * Limits output buffer to 8kB to ensure compatibility with certain clients. {{}} * Enables manual skipping of index backfill in YSQL with `CREATE INDEX NONCONCURRENTLY`. {{}} * Enables viewing length and bounds histograms in `pg_stats`. {{}} #### YCQL * Allows setting `NULL` values in YCQL JSONB columns. {{}} #### DocDB * Allows using intermediate CA certs in server cert files for node-to-node encryption. {{}} * Tracks ByteBuffer memory usage with `MemTracker`. {{}} * Allows adjusting `rocksdb_compact_flush_rate_limit_bytes_per_sec` without restarting the tablet server. {{}} * Cloning now uses the geographically closest TServer, reducing timeouts. {{}} * Enhances handling of expired snapshots by retrying deletion tasks automatically. {{}} * Enables tracking of thread metrics by specific thread pool names for enhanced monitoring. {{}} * Enhances maintainability by consolidating tablespace validation logic into `TablespaceParser`. {{}} #### CDC * Reduces logging frequency for certain CDC errors to avoid clutter. {{}} * Advances CDC restart time even without new writes, controlled by `cdcsdk_update_restart_time_interval_secs` flag. {{}} * Enhances CDC restart time updates with more accurate timing control via the `cdcsdk_update_restart_time_interval_secs` flag. {{}} * Prevents table drop if it's part of a publication during logical replication. {{}} * Reduces `yb_walsender_poll_sleep_duration_empty_ms` from 1 second to 10 ms to speed up replication in sparse workloads. {{}} #### yugabyted * Displays Voyager version in two lines and uses camel case in the UI labels. {{}} * Prevents empty issue types or names in Voyager UI. {{}} ### Bug fixes #### YSQL * Reduces XID usage by generating one per `REFRESH MATERIALIZED VIEW CONCURRENTLY` operation. {{}} * Skips catalog version bump during in-place materialized view refresh. {{}} * Reduces read restart errors on concurrent writes to disjoint keys. {{}} * Enables testing of SECURITY LABEL with dummy_seclabel. {{}} * Ensures correct column mapping for partitioned tables during `INSERT ON CONFLICT` updates. {{}},{{}} * Sets query ID for background workers earlier to ensure correct tracking. {{}} * Enhances estimation of result tuple size in edge cases, preventing division by zero errors. {{}} * Fixes memory leaks in the PostgreSQL anonymizer extension and optimizes test scheduling. {{}} * Fixes incorrect role name quoting in `ysql_dumpall`. {{}} * Ensures stable behavior in Connection Manager when using multiple connections. {{}} * Fixes `\d` command for indexes with spaces in their names. {{}} * Fixes issues with `INSERT ON CONFLICT DO UPDATE` to prevent secondary index corruption. {{}} * Modifies `ysql_dumpall` to combine `CREATE ROLE` and `ALTER ROLE` for effective role management. {{}} * Ensures stable operation of refresh materialized view during major upgrades. {{}} * Refactors FK cache management into a separate class for cleaner architecture. {{}} * Enhances index scans and partition pruning for BOOLEAN conditions. {{}} * Optimizes deferred FK constraint checks by reading ybctids at transaction end. {{}} * Enables setting follower reads YSQL configuration parameters anytime during a connection. {{}} * Fixes the error handling in INSERT ON CONFLICT statements when using read-committed transactions. {{}} * Enhances accuracy of seek-next estimation for index scans and paged results. {{}} * Refines cost model tuning using server-side execution times for more accurate query optimization. {{}} * Prevents crashes by handling non-variable expressions in single-row updates or deletes. {{}} * Prevents relcache reference leaks in `yb_get_ybctid_width`. {{}} * Optimizes cost modeling for primary index scans to assume sequential disk block fetching. {{}} * Introduces custom SQL error codes for better error handling in parallel queries. {{}} * Lowers default RPC message size limit to prevent overflow. {{}} * Enhances `yb_index_check` to verify materialized view indexes' consistency. {{}} * Enables ANALYZE command to gather top-level statistics for partitioned tables. {{}} * Corrects estimations for inner table scans in Batched Nested Loop Joins. {{}} * Fixes integer overflow in BNL cost estimation, preventing negative values. {{}} * Prevents unnecessary aborts of top-level transactions when only a subtransaction conflicts. {{}} * Fixes inaccurate row estimates in `yb_cost_bitmap_table_scan` by removing incorrect overwrites. {{}} * Fixes port conflict handling between Connection Manager and PostgreSQL. {{}} * Prevents restoring non-colocated databases as colocated during backup. {{}} * Adds a new YSQL configuration parameter `yb_neg_catcache_ids` to customize negative caching for catalog caches. {{}},{{}} * Preserves enum sort order during backup and restore processes. {{}} * Enables geolocation costing in the new cost model with `yb_enable_geolocation_costing`. {{}} * Corrects the description for `ysql_yb_enable_ash` flag. {{}} * Ensures successful restoration of enum types from old backups by changing errors to warnings. {{}} * Logs now include odd `pg_enum` OID during restore to better trace issues with missing sortorder values. {{}} * Restores the call to `ScheduleCheckObjectIdAllocators` inadvertently removed. {{}} * Fixes a use-after-free bug in ysql_dump by copying tablegroup_name. {{}} * Separates read-after-commit tests into their own file. {{}} #### DocDB * Fixes load balancing for rewritten tables in colocated databases. {{}} * Ensures tables no longer get stuck in HIDING state during failures. {{}} * Prevents resource waste by checking disk space before remote bootstrap operations. {{}} * Fixes deadlock in tablet servers using shared memory, preventing crashes. {{}} * Fixes a crash when `ProcessSupervisor` cannot restart a process. {{}} * Ensures yb-admin commands respect user-specified timeouts for table flushes and compactions. {{}} * Enhances transactional xCluster accuracy by using majority replicated OpId for ApplySafeTime calculations. {{}} * Ensures accurate `WaitForReplicationDrain` behavior by not mislabeling tablets as drained. {{}} * Enables cloning databases to any past time in the schedule's retention period. {{}} * Fixes handling of `db_max_flushing_bytes` to properly limit memory usage under high write loads. {{}} * Prevents unbounded growth of the `recently_applied_map` by not adding read-only transactions, conserving memory. {{}} * Prevents data loss by ensuring databases are flushed before updating flush markers. {{}} * Prevents false conflict detection in snapshot isolation operations. {{}} * Enables successful cloning of sequences to historical times by extending the `yb_disable_catalog_version_check` effect. {{}} * Enhances system table deletion during `ysql_upgrade` by ensuring clean removal from `SysTableInfoPB`. {{}} * Enhances leader lease handling to support multiple revisions during rapid leadership changes. {{}} * Stops tracking recently applied transactions if `use_bootstrap_intent_ht_filter` is set to false, reducing memory usage. {{}} * Prevents `yb-admin` crashes by correctly handling argument count for `create_database_snapshot`. {{}} * Prevents deadlocks during background compaction and transaction loading. {{}} * Improves error handling for shared memory operations in DocDB. {{}} * Removes 60-second timeout upper bound on admin RPCs and adds new `yb_client_admin_rpc_timeout_sec` flag. {{}} #### CDC * Ensures only relevant transactional records are streamed, preventing `COMMIT` record errors. {{}} * Prevents CDC crashes by logging a warning for dropped indexes on colocated tables. {{}} * Prevents data loss by not streaming records during transaction load. {{}} * Ensures reliable CDC stream functionality during index creation, preventing schema packing errors. {{}} #### yugabyted * Checks for chrony service before enabling clockbound during node start. {{}} * Preserves the universe key locally after enabling EAR for recovery scenarios. {{}}
## v2024.2.2.5 - August 5, 2025 {#v2024.2.2.5} **Build:** `2024.2.2.5-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.5/yugabytedb-2024.2.2.5-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.5/yugabytedb-anywhere-2024.2.2.5-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.5-b2 ``` ### Bug fix #### YSQL * Prevents 'pgaudit stack is not empty' error for nested call statements, and enhances pgaudit by skipping audits of permission-less relations. {{}} ## v2024.2.2.4 - May 19, 2025 {#v2024.2.2.4} **Build:** `2024.2.2.4-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.4/yugabytedb-2024.2.2.4-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.4/yugabytedb-anywhere-2024.2.2.4-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.4-b1 ``` This is a YugabyteDB Anywhere-only release, with no changes to YugabyteDB. ## v2024.2.2.3 - May 6, 2025 {#v2024.2.2.3} **Build:** `2024.2.2.3-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.3/yugabytedb-2024.2.2.3-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.3/yugabytedb-anywhere-2024.2.2.3-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.3-b1 ``` This is a YugabyteDB Anywhere-only release, with no changes to YugabyteDB. ## v2024.2.2.2 - April 9, 2025 {#v2024.2.2.2} **Build:** `2024.2.2.2-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.2/yugabytedb-2024.2.2.2-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.2/yugabytedb-anywhere-2024.2.2.2-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.2-b2 ``` ### Change log
View the detailed changelog ### Bug fixes #### YSQL * Prevent timeouts by exempting the walsender process from the YSQL backend check so that the index creation can proceed without waiting for the walsender to catch up to the latest catalog version. {{}}
## v2024.2.2.1 - March 11, 2025 {#v2024.2.2.1} **Build:** `2024.2.2.1-b6` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.1/yugabytedb-2024.2.2.1-b6-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.1/yugabytedb-anywhere-2024.2.2.1-b6-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.1-b6 ``` ### Change log
View the detailed changelog ### Bug fixes #### YSQL * Reduces XID usage by generating one per `REFRESH MATERIALIZED VIEW CONCURRENTLY` operation. {{}} * Fixes issues with `INSERT ON CONFLICT DO UPDATE` to prevent secondary index corruption. {{}} * Ensures stable operation of refresh materialized view during major upgrades. {{}} #### DocDB * Fixes load balancing for rewritten tables in colocated databases. {{}} #### yugabyted * Checks for chrony service before enabling clockbound during node start. {{}}
## v2024.2.2.0 - February 28, 2025 {#v2024.2.2.0} **Build:** `2024.2.2.0-b70` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.2.0/yugabytedb-2024.2.2.0-b70-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.2.0/yugabytedb-anywhere-2024.2.2.0-b70-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.2.0-b70 ``` ### Known issue yugabyted does not work under Docker in v2024.2.2.0. ### New features #### Core Database * Non-disruptive adding of indexes for xCluster - Adding an index to a database configured with bi-directional xCluster Replication (or other non-transactional xCluster Replication) is now a non-disruptive, no-downtime operation. * Read committed isolation now {{}}. When a transaction runs on this isolation level, a query sees only data committed before the query began and never sees either dirty data or concurrent transaction changes committed during query execution. * Execution for Queries using InsertOnConflict clause are optimized for efficient execution for YugabyteDB distributed architecture. {{}} * Support for synchronized sessions with export snapshot - Now supports pg_export_snapshot to offer consistent visibility of existing data across concurrent transactions and import using SET TRANSACTION by the current transaction. {{}} #### CDC * Support for LSN comparison across replication slots - Users are now will be able to add LSN type at the time of replication slot creation. This will enable users to compare two LSNs irrespective of the slots. {{}} * Support for ALTER TABLE operations on CDC-enabled tables, addressing a key limitation. Users can now modify the table schema even when the table is configured for Change Data Capture (CDC). {{}} #### yugabyted * yugabyted enables native support for enhanced time sync using ClockBound service. {{}} * yugabyted enables support for IPV6. {{}} #### YSQL * Ensures cached plans correctly depend on user roles, addressing {{}}. {{}} ### Change log
View the detailed changelog ### Improvements #### YSQL * Enables batching for INSERT ON CONFLICT with foreign key triggers. {{}} #### DocDB * Enables safe index creation on bidirectional xCluster tables without halting operations. {{}} #### CDC * Reduces unnecessary cleanup requests for logically replicated tables. {{}} * Reduces `cdcsdk_publication_list_refresh_interval_secs` to 15 minutes by default. {{}} * Enables automatic tablet splitting with logical replication by fixing hidden tablet deletion bugs. {{}} * Adds `cdcsdk_flush_lag` metric and fixes bugs in other CDC metrics. {{}},{{}} * Limits the number of VirtualWAL instances per TServer with `cdc_max_virtual_wal_per_tserver` flag. {{}} * Adds parallel logical replication with consistent tablet subsetting under the `ysql_yb_enable_consistent_replication_from_hash_range` flag. {{}} * Reduces log verbosity in virtual WAL to prevent large log files. {{}} * Enables tests for optimized WAL reads in CDC for TSAN builds. {{}} #### yugabyted * Displays universe UUID instead of a blank in the "Cluster Name" field on the yugabyted-ui settings page. {{}} ### Bug fixes #### YSQL * Ensures DDL operations continue smoothly by retrying background tasks on polling errors. {{}} * Enables `pg_authid` table prefetching during login to reduce RPCs and prevent errors. {{}} * Ensures Batched Nested Loop joins correctly check for hashable join clauses. {{}} * Clears session state on retrying a query to avoid errors and conflicts. {{}} * Reverts `ALTER DATABASE RENAME` and `ALTER DATABASE OWNER` to global impact. {{}} * Fixes issues with `INSERT ON CONFLICT` queries using `SPI_execute_with_args`. {{}} * Fixes memory leaks and segmentation faults in YSQL Connection Manager. {{}} * Corrects a bug in YugabyteDB where using `yb_enable_expression_pushdown` on aggregates in trivial subqueries with `OFFSET 0` returned values from incorrect columns. {{}} * Fixes potential negative cost calculations for large table scans by using `double` for estimates. {{}} * Prevents returning corrupt data for `INSERT ON CONFLICT` with `RETURNING` when read batching is enabled. {{}} * Enhances error transparency when dropping databases or users. {{}} * Enhances protocol flow for consistency in batched query executions using a new flag `ysql_conn_mgr_optimized_extended_query_protocol`. {{}} * Enables seamless execution of unnamed prepared statements across different backends. {{}} * Tracks sticky connection metrics on the Prometheus endpoint. {{}} * Eliminates segmentation faults caused by a bug in Odyssey's list iteration macro, which incorrectly handled NULL pointers and led to core dumps. {{}} #### DocDB * Enhances transactional xCluster accuracy by using majority replicated OpId for ApplySafeTime calculations. {{}} * Prevents crash during transaction abort by adjusting lock handling. {{}} * Prevents xCluster failures caused by same-name table re-creation during non-DBScoped DR. {{}} * Upgrades tcmalloc and abseil to prevent crashes from `malloc_usable_size(nullptr)`. {{}} #### CDC * Fixes metric lag by adding dummy entries for expired tablets. {{}} * Reduces log verbosity by changing the log level for virtual WAL destroy statements. {{}} #### yugabyted * Adds `use_client_to_server_encryption` flag to secure login data. {{}}
## v2024.2.1.0 - January 30, 2025 {#v2024.2.1.0} **Build:** `2024.2.1.0-b185` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.1.0/yugabytedb-2024.2.1.0-b185-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.1.0/yugabytedb-anywhere-2024.2.1.0-b185-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.1.0-b185 ``` ### New features #### Core Database * Added support for [native connection pooling](/v2024.2/explore/going-beyond-sql/connection-mgr-ysql/). {{}} * The [CDC data now will be retained for 24 hours by default](/v2024.2/additional-features/change-data-capture/using-logical-replication/advanced-configuration/#retention-of-resources) in case the CDC client/consumer is offline. {{}} * Disk Usage Metrics for Point in Time Recovery (PITR) and PIT Backup - [Metrics for disk storage consumed by retaining DB change history](/v2024.2/launch-and-manage/monitor-and-alert/metrics/cache-storage/#sst-files) (for PITR, or for Backup/Restore with PIT restores) are now tracked and available. {{}} * [Avoids updating columns which are included in any Index and Foreign key constraints when the columns values are not changed](/v2024.2/reference/configuration/yb-tserver/#yb-skip-redundant-update-ops). {{}} ### Change log
View the detailed changelog ### Improvements #### YSQL * Enables authentication via a specialized backend, enhancing security and reliability. {{}},{{}} * Enables toggling authentication method in YSQL using the `ysql_conn_mgr_use_auth_backend` flag. {{}} * Prevents catalog version bumps on no-op `ALTER ROLE` commands, saving system resources. {{}} #### YCQL * Tracks microsecond precision timestamps in YCQL with new metric `cql_microseconds_timestamps_used`. This tracking occurs if the `cql_revert_to_partial_microsecond_support` flag is true. {{}} #### DocDB * Limits concurrent remote bootstraps per TServer using `load_balancer_max_inbound_remote_bootstraps_per_tserver` flag. {{}} * Reduces unnecessary attribute map creations during Prometheus metric aggregation. {{}} * Enhances RBS throttling by focusing on active fetch sessions and adjusts expiration logic. {{}},{{}} * Skips schema validation for newly added tables in xCluster replication to handle schema changes. {{}} * Passes `automatic_ddl_mode` to xCluster pollers for enhanced replication handling. {{}} * Enables xCluster to handle non-colocated ALTER TABLE commands without pausing replication. {{}} * Replaces `ProducerSchemaPB` with `SchemaVersionsPB` for xCluster configurations. {{}} * Introduces the `rocksdb_determine_compaction_input_at_start` flag, allowing the selection of SST files for compaction when the task starts rather than when it's queued. {{}} #### CDC * Avoids caching IntentDB block reads for CDC to prevent redundant data access. {{}} * Automatically removes metrics when a CDC stream is deleted. {{}} * Speeds up tablet bootstrap under CDC by skipping initial WAL segments, controlled by `skip_wal_replay_from_beginning_with_cdc` flag. {{}} * Enables `kNoCacheQueryId` to prevent crashes during RocksDB operations. {{}} ### Bug fixes #### YSQL * Enables `ALTER SEQUENCE` commands to change sequence name, schema, and owner without errors. {{}} * Disables in-place index updates by default to address index inconsistency issues. {{}} * Increases YSQL connection manager's thread stack size to 512 KB to prevent crashes on Alma 9 machines. {{}} * Enhances performance during nested loop joins by ensuring correct limit resets in colocated index scans. {{}} * Removes time sync service requirement from the prerequisites. {{}} * Fixes foreign key checks to avoid errors with unique indexes. {{}} * Enhances consistency and correctness of INSERT...ON CONFLICT queries via YBCTID infrastructure integration and index management. {{}},{{}} * Re-enables in-place index updates by default after fixing related inconsistencies. {{}} * Ensures restart read time does not exceed the global limit to avoid inconsistent reads. {{}} * Accurately estimates the cost of partial index scans by including index conditions. {{}} * Reduces memory usage spikes by using a new memory context for `RelationBuildTriggers`. This change avoids high memory consumption when preloading `pg_trigger` data on schemas with many triggers. {{}} * Disables index update optimization by default to fix `ON CONFLICT UPDATE` issues. {{}} #### DocDB * TServers now reject remote bootstrap requests for previously deleted tablets. {{}} * Sets a default 10MB max size for RocksDB MANIFEST files, now configurable via flags. {{}} * Enhances visibility for unexpected rate limiter sleep times in RBS (Remote Bootstrap) threads. {{}} * Eliminates inconsistencies by not including inactive tablets in `OpenTable` operations. {{}} * Switches pg_cron back to using standard `SIGTERM` handling for cleaner shutdowns. {{}} * Prevents crashes during compaction when `ysql_enable_packed_row` is off and existing packed rows are present. {{}} * Ensures consistent tablegroup assignments for colocated table backups without using explicit tablespaces. {{}} * Eliminates segmentation faults by ensuring `CleanupHiddenTables` holds a write lock during `Upsert`. {{}} * Fixes error for select queries in large tables by adjusting backward scan bounds. {{}} * Prevents fatal errors during multiple splits and PITR restores. {{}} * Reduces unnecessary checks when adding tables in alter replication requests. {{}} * Fixes shutdown path issues to prevent fatal errors during RPC completion. {{}} * Resolves scheduling of contentious waiters to the correct, larger RPC thread-pool. {{}} * Reduces latency by enhancing early resume of RPCs blocked on aborted transactions. {{}} * Adds a flag to limit multiple pending compactions for priority pools. {{}} #### CDC * Allows sending a null "before image" for CDC if `cdc_send_null_before_image_if_not_exists` flag is true. {{}} * Enhances accuracy of transaction start time logging for better consistency in CDC. {{}} * Fixes memory leaks in the walsender's handling of transactions and file nodes. {{}} * Excludes expired or irrelevant entries from metrics calculations for more accurate reporting. {{}} * Ensures null values are now correctly captured in CDC before image records. {{}}
## v2024.2.0.0 - December 9, 2024 {#v2024.2.0.0} **Build:** `2024.2.0.0-b145` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2024.2.0.0/yugabytedb-2024.2.0.0-b145-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2024.2.0.0/yugabytedb-anywhere-2024.2.0.0-b145-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2024.2.0.0-b145 ``` ### Highlights We're excited to announce the [Early Access](/stable/releases/versioning/#early-access-ea) and [General Availability](/stable/releases/versioning/#general-availability-ga) of the following powerful new features in YugabyteDB aimed at simplifying operations, enhancing functionality, and improving performance. **YugabyteDB Kubernetes Operator** {{}} The [YugabyteDB Kubernetes Operator](/stable/quick-start/kubernetes/#yugabytedb-kubernetes-operator) is a powerful tool designed to automate deploying, scaling, and managing YugabyteDB clusters in Kubernetes environments. It streamlines database operations, reducing manual effort for developers and operators. For more information, refer to the [YugabyteDB Kubernetes Operator](https://github.com/yugabyte/yugabyte-k8s-operator) GitHub project. **Active session history** {{}} Get real-time and historical views of system activity by sampling session activity in the database. This feature can be used to troubleshoot performance issues effectively. For more information, refer to [Active Session History](/v2024.2/explore/observability/active-session-history/) (ASH) documentation. **Instant database cloning** {{}} [Instant database cloning](/v2024.2/manage/backup-restore/instant-db-cloning/) allows you to quickly create independent copies of your database for data recovery, development, and testing. Clones can be created in seconds, and initially consume no additional disk space because they share the same data files as the original database at creation but operate independently after that. Clones can be created as of now or at any time in the recent past (within a configurable history retention period), enabling developers to experiment without impacting production performance. This feature also provides a safety net for rapid recovery from accidental SQL or CQL human errors that cause data loss or corruption. **pg_cron extension** {{}} The [pg_cron extension](/v2024.2/additional-features/pg-extensions/extension-pgcron/) brings a cron-based job scheduler into the database. With pg_cron, you can schedule YSQL commands using familiar cron syntax, including jobs on intervals as fine as seconds. While pg_cron operates on a single node known as the pg_cron leader, the queries it schedules leverage the full resources of the distributed cluster. On node failure, leadership is automatically transferred, ensuring continuous availability and smooth scheduling operations. **pg_partman extension** {{}} Use the [pg_partman extension](/v2024.2/additional-features/pg-extensions/extension-pgpartman/) to create and manage both time- and serial-based (aka range-based) table partition sets. pg_partman simplifies managing table partitions based on time or serial IDs, automating their creation and maintenance. pg_partman is often used in combination with [pg_cron](/v2024.2/additional-features/pg-extensions/extension-pgcron/) for data lifecycle management, and specifically for managing data aging, retention, and expiration. **Colocated tables with tablespaces** {{}} Starting this release, you can create [colocated tables with tablespaces](/v2024.2/additional-features/colocation/#colocated-tables-with-tablespaces). With this enhancement, you can now take advantage of colocated tables for geo-distributed use cases, eliminating the need for trade-offs between distributing data across specific regions. You enable the feature using the `ysql_enable_colocated_tables_with_tablespaces` flag. **Improvement to backward scans** {{}} The performance of YSQL backward table scans (for example, a descending-sorted query occurs against a table that is sorted ascending) has been improved by up to 10x in this release. You enable the feature using the `use_fast_backward_scan` flag. **Improved query performance by using shared memory for PG-to-TServer communication** {{}} This enhancement significantly reduces communication overhead between the PostgreSQL backend and TServer, which plays a critical role in both read and write flows. We observed a 10+% increase in throughput and a 10+% decrease in latency in workloads like TPCC and YCSB. This improvement is particularly impactful in the following scenarios: * Colocation. When queries are guaranteed to route to the tablet leader, communication overhead is minimized. * Queries involving multiple round trips, such as paginated reads or unbatched requests, benefit from reduced latency. This feature is controlled by the `pg_client_use_shared_memory` flag, which is enabled by default starting in v2024.2.0. **New YB-TServer and YB-Master memory allocation settings** {{}} YugabyteDB uses [memory division flags](/v2024.2/reference/configuration/yb-master/#memory-division-flags) to specify how memory should be divided between different processes (for example, [YB-TServer](/v2024.2/architecture/yb-tserver/) versus [YB-Master](/v2024.2/architecture/yb-master/)) on a YugabyteDB node as well as within processes. New v2024.2.0 universes created using yugabyted or YugabyteDB Anywhere use the recommended memory settings for YSQL (introduced in v2024.1) by default (the [--use_memory_defaults_optimized_for_ysql](/v2024.2/reference/configuration/yb-tserver/#use-memory-defaults-optimized-for-ysql) flag is set to true). Also turned on by default is `--enforce_tablet_replica_limits`, which enforces tablet replica limits based on the memory allocated to per-tablet overhead across the universe. When turned on, any CREATE TABLE request that would create too many tablets returns an error, and tablet splitting is also blocked if the result would be too many tablets. In addition, YugabyteDB will alert you if your system currently has too many tablets. If you are *upgrading* a universe, you may want to review your memory division settings and adjust them if desired; see [Best practices](/stable/develop/best-practices-develop/data-modeling-perf/#minimize-the-number-of-tablets-you-need). ### New features * [xCluster support in yugabyted](/v2024.2/reference/configuration/yugabyted/#set-up-xcluster-replication-between-clusters). Adds support for setting up and managing xCluster replication between two clusters deployed using yugabyted. * [Semi-automatic xCluster replication](/v2024.2/deploy/multi-dc/async-replication/async-replication-transactional/). Provides simplified management of YSQL transactional xCluster replication. xCluster management operations are now only required when adding and removing databases from replication. DDL changes can now be made by any database administrator or user with database permissions, and no longer require SSH access or intervention by an IT administrator. * [xCluster observability](/v2024.2/yugabyte-platform/alerts-monitoring/alert-policy-templates/#xcluster-config-tables-are-in-bad-state). Improved ability for users to monitor xCluster metrics like Replication Lag, Safetime Lag, and replication errors. {{}} * [Follower reads](/v2024.2/explore/going-beyond-sql/follower-reads-ysql/). Added support for setting `yb_read_from_followers=true` inside a transaction block using SET LOCAL. This allows greater convenience when setting follower reads for single transactions. You must set `yb_read_from_followers` before any statement is executed in the block. * [Improved query performance](/v2024.2/reference/configuration/yb-tserver/#pg-client-use-shared-memory). Implemented shared memory for PostgreSQL to TServer communication to minimize latency and enhance query performance by reducing communication overhead. This enhancement is part of [Enhanced PostgreSQL compatibility mode](../../../reference/configuration/postgresql-compatibility/). * [Precision Time Protocol (PTP) support](/v2024.2/deploy/manual-deployment/system-config/#configure-precision-time-protocol). PTP is a network protocol designed for highly accurate time synchronization across devices in a network. {{}} * [AWS ClockBound support](/v2024.2/deploy/manual-deployment/system-config/#configure-clockbound). [ClockBound](https://github.com/aws/clock-bound) is an open source daemon that allows you to compare timestamps to determine order for events and transactions, independent of an instance's geographic location; it improves clock accuracy by several orders of magnitude. {{}} * SELECT query performance. Enables the batching for locking the rows and thus helps improve the performance of the queries which lock more than 1 row using SELECT FOR UPDATE. * Sequential scan speed. Improved ANALYZE and sequential scan performance by leveraging OS-level read-ahead, resulting in up to 8x faster ANALYZE operations. * ALTER support. Added support for miscellaneous ALTER TABLE DDLs. * Catalog caching. Added ability to find catalog tables that can be pre-loaded to improve latency for the first query in a connection, or after a DDL change in the cluster. {{}} * CDC connector on Confluent Hub. YugabyteDB CDC Connector is now available in Confluent Hub. {{}} * [Connection pooling](/v2024.2/explore/going-beyond-sql/connection-mgr-ysql/). Added support for built-in connection pooling. {{}} ### Change log
View the detailed changelog ### Improvements #### YSQL * Enhances logging for YSQL version mismatch errors and DDL operations. {{}} * Enables control over in-place index updates with `yb_enable_inplace_index_update`. {{}} * Allows use of `UNLOGGED` tables syntax, handling it as `LOGGED` with a warning. {{}},{{}} * Reduces memory usage by compressing large catalog objects in catcache. {{}} * Enables DDL atomicity by default, enhancing schema version consistency. {{}} * Adds a new YSQL view for YCQL statement metrics to aid in query analysis and troubleshooting. {{}} * Displays distinct index columns directly in EXPLAIN output. {{}} * Enables controlled activation of the DDL atomicity feature during upgrades. {{}} * Enhances session management by updating read times more consistently. {{}} * Allows loading only `pg_shdepend` in `YbInitPinnedCacheIfNeeded` for cross-database DDLs. {{}} * Enables monitoring of YCQL statements through a new YSQL view, enhancing query analysis. {{}} * Enhances schema version consistency by re-invalidating table cache post-`ALTER TABLE` with DDL atomicity. {{}} * Adds new monitoring columns to `localhost:13000/statements` for enhanced tracking. {{}} * Enables logging for global-impact DDL statements that adjust all database catalog versions. {{}} * Sorts YSQL extensions into three specific directories for better organization. {{}} * Fixes schema version mismatch after `ALTER TABLE` in production builds, ensuring reliable schema updates. {{}} * Introduces the `yb_parallel_range_size` parameter to customize parallel range sizes. {{}} * Removes the unused `keep_order` field from `YbctidGenerator` for streamlined processing. {{}} * Introduces the `yb_enable_parallel_append` flag to disable parallel append and avoid exposing unannounced features. {{}} * Enhances code clarity and performance with style and logic refinements. {{}} * Enables creation of dummy vector indexes in YSQL with placeholder functionality. {{}} * Disallows move and copy operations for LWFunction to prevent misuse. {{}} * Streamlines and deduplicates logic for `ybgin` and `lsm` access methods, enhancing support for new index types. {{}} * Enables CREATE/DROP ACCESS METHOD grammar, supporting custom access methods and extensions. {{}} * Clarifies log messages for DDL atomicity in TableSchemaVerificationTask. {{}} * Eliminates duplicated logic for YSQL hidden column `ybrowid` handling. {{}} * Adds save and restore functionality for `ConsistentReadPoint` state. {{}} * Ensures consistent table names in backup/restore scenarios by not renaming DocDB tables during legacy rewrites. {{}} * Disables Python checks on all third-party PG extensions. {{}} * Simplifies coding in PgDml and related classes by streamlining parameters and functions. {{}} * Enables the optimizer to prefer backward scans when `FLAGS_use_fast_backward_scan` is enabled. {{}} * Adds new flags for role management in YSQL backups and restores. {{}} * Enhances code clarity and documentation for Batch Nested Loop Join logic. {{}} * Introduces a dedicated auth-backend for YSQL to handle connection authentication, enhancing security and streamlining the process. {{}} * Ensures correct error handling by adding a missing InvalidOid check in YSQL. {{}} * Enables authentication via a specialized backend, enhancing security and reliability. {{}},{{}} * Enables toggling authentication method in YSQL using the `ysql_conn_mgr_use_auth_backend` flag. {{}} #### YCQL * Adds error message for unsupported `GROUP BY` in YCQL; introduces flag to suppress it. {{}} * Resolves timestamp precision mismatches in YCQL, aligning inserts and index scans to millisecond precision. {{}},{{}} #### DocDB * Tracks and analyzes disk I/O by stack trace, enhancing debugging and system understanding. {{}} * Resolves a build failure that arose from a naming conflict in debug flags. {{}} * Blocks writes based on total bytes being flushed, not just memtable count. {{}} * Enables background DNS resolution to prevent RPC delays. {{}},{{}} * Enhances load balancer to prioritize under-replicated tablets first. {{}} * Introduces a flag to toggle between new and legacy memory default settings. {{}} * Logs memory stack traces to help diagnose OOM errors, with configurable throttling. {{}} * Upgrades non-FIPS OpenSSL to 3.0.15 and removes CentOS 7 builds. {{}} * Prevents overloading by correctly categorizing bootstrapping tablets in load balancing. {{}} * Deprecates unused flags to reduce confusion and streamline configurations. {{}} * Ensures debug builds can restart from release builds for easier debugging. {{}} * Streamlines xCluster management by relocating specific table and stream mappings to `XClusterSourceManager`. {{}} * Enables faster backward scans in DocDB with new flags for optimization. {{}} * Enhances error messages for unset preview flags in `allowed_preview_flags_csv`. {{}} * Ensures `GetChangesForXCluster` does not return invalid safe times. {{}} * Adjusts TServer memory recommendations and adds new defaults based on node RAM size. {{}} * Adds usearch and fp16 libraries for enhanced vector indexing. {{}} * Ensures correct error messages are shown when creating tables or tablegroups. {{}} * Enables replication of DDL schemas and user settings across clusters. {{}} * Ensures early, clear error messages on timeouts by introducing a flag `are_nodes_safe_to_take_down_timeout_buffer_ms`. {{}} * Removes the "No active snapshot" warning log to streamline debugging. {{}} * Ensures DDLs are rerun exactly once by checking `replicated_ddls` before execution. {{}} * Streamlines xCluster stream creation by centralizing functionality in `XClusterClient::CreateXClusterStream`. {{}} * Adds `skip_producer_stream_deletion` flag to speed up xCluster DR failovers. {{}} * Reduces thread usage by reusing the server messenger for AutoFlags. {{}} * Reduces thread usage by reusing server processes in stateful service clients. {{}} * Enhances validation with `SCHECK_PB_FIELDS_NOT_EMPTY` to ensure PB fields are non-empty. {{}} * Ensures `DROP TABLE` operation with atomic DDL waits until the table is fully deleted. {{}} * Enhances extensibility by splitting `yb_xcluster_ddl_replication.c` into multiple files. {{}} * Removes deprecated xCluster JSON format to streamline functionality. {{}} * Blocks multi-statement DDL queries to prevent replication issues. {{}} * Reduces complexity in `catalog_manager` by relocating RPC endpoints to `MasterClusterHandler`. {{}} * Adds `read-time` option to `ysql_dump` help for point-in-time database dumps. {{}} * Renames flag to `xcluster_consumer_thread_pool_size` for clearer usage and efficiency. {{}} * Removes unnecessary locks in DeleteOrHideTabletsAndSendRequests to prevent deadlocks. {{}} * Adds column sorting to stack trace tracking UI for easier data analysis. {{}} * Introduces session-based in-memory table locking for improved concurrency control. {{}} * Uses table IDs instead of names for matching in xCluster DDL replication setup. {{}} * Speeds up backward scans for flat doc reader with packed row V2. {{}} * Reuses TServer `yb::client` in `CDCService` to reduce resource usage and fix optimization issues. {{}} * Standardizes xCluster client usage and streamlines client creation in `XClusterConsumer`. {{}} * Ensures replication setup is successful only if all components are healthy. {{}} * Displays `external_hybrid_time` in log-dump to detect xCluster target writes. {{}} * Adds `SOURCE_UNREACHABLE` and `SYSTEM_ERROR` enums to xCluster for better error reporting. {{}} * Allows requesting xCluster streams by producer table IDs for accurate replication setup. {{}} * Adds easier access and tracking controls to stack trace endpoints. {{}} * Renamed and relocated xCluster components to streamline management and functionality. {{}} * Removes deprecated namespace replication code, enhancing system performance. {{}} * Enhances pggate to recognize fast backward scan capabilities for better query cost estimation. {{}} * Ensures debug builds can restart from release builds by making column ID representations consistent. {{}} * Enhances flags UI by hiding invalid flags and empty categories. {{}} * Enables storing and loading vector index updates in DocDB. {{}} * Streamlines statistics management in `IntentAwareIterator`. {{}} * Speeds up backward scans by caching keys, enabling quicker and more efficient data retrieval. {{}} * Allows configuring tablet splits based on size ratios with `FLAGS_tablet_split_min_size_ratio`. {{}} * Simplifies tracking heartbeat processes by relocating code to `master_heartbeat_service.cc`. {{}},{{}} * Simplifies clone state management by moving retry data to in-memory structure. {{}} * Streamlines heartbeat code management by relocating it to `master_heartbeat_service.cc`. {{}},{{}} * Enhances code readability by moving heartbeat code to `master_heartbeat_service.cc`. {{}},{{}} * Moves tcmalloc profiling code to the util directory for better organization. {{}} * Introduces `enable_rwc_lock_debugging` flag to control RWCLock debug logging. {{}} * Switches `CloneStateInfo` object handling to `std::shared_ptr` for future flexibility. {{}} * Ensures schema names are not empty in `YBTableName` settings. {{}} * Simplifies management by shifting certain managers from Catalog Manager to Master. {{}},{{}} * Enhances visibility of the `hidden` state in Master/Tserver UI tables. {{}} * Reduces unnecessary reads during CQL INSERT operations with range keys. {{}} * Adds `pg_yb_logical_client_version` table to manage session configurations. {{}} * Adds an `ABORTED` state for failed clones in YugabyteDB. {{}} #### CDC * Ensures CDC streams are not deleted when all associated tables are dropped. {{}} * Adds new `yb-admin` commands to manage CDC streams, including removing tables. {{}},{{}} * Prevents tables with enum array columns from being added to CDC streams. {{}} * `yb_enable_cdc_consistent_snapshot_streams` flag is now default true and automatic. {{}} * Sets retention barriers on tablets during table creation for PG replication. {{}} * Allows changing and persisting the `cdcsdk_publication_list_refresh_interval_secs` flag value for safer LSN handling. {{}} * Allows configuring default replica identity for tables using the `ysql_yb_default_replica_identity` flag. {{}} * Enables toggling dynamic table addition in virtual WAL with `cdcsdk_enable_dynamic_table_addition` flag. {{}} * Uses replication slot names to differentiate between consumption models. {{}} * Supports creation of old model streams via yb-admin in upgraded environments. {{}} * Allows setting per-table replica identity for CDC streams using the `ysql_yb_enable_replica_identity` flag. {{}} * Suppresses NOTICE messages when setting `yb_read_time` from walsender. {{}} * Speeds up tablet bootstrap under CDC by skipping initial WAL segments, controlled by `skip_wal_replay_from_beginning_with_cdc` flag. {{}} #### yugabyted * Ensures `RENAME DATABASE` accurately follows connection rules. {{}} * Tracks role changes accurately by using `role_oid` instead of `role`. {{}} * Enables tracking of single-use YSQL configuration parameters in Connection Manager. {{}} * Enhances session consistency by using `role_oid` for `session_authorization` in Connection Manager. {{}} * Enables sticky connections when setting specific YSQL configuration parameters. {{}} * Enhances stability by destroying control connections during configuration reloads. {{}} * Enables better handling of complex YSQL configuration parameters using sticky connections. {{}} * Adds a new `/pitr` endpoint and UI screen for listing scheduled PITRs. {{}} * Adds `upgrade_finalize` command to yugabyted CLI for post-upgrade tasks. {{}} * Enables flags directly on `yb-master` and `yb-tserver` for better setting accuracy. {{}} * Alerts users about version mismatches between nodes via the UI. {{}} * Deprecates Python 2 in yugabyted and shifts to Python 3. {{}},{{}} * Enables scalable parsing of multi-valued flags in `yugabyted` without code duplication. {{}} * Corrects CPU usage calculation in the Sankey diagram. {{}} * Ensures startup parameters with spaces parse correctly with YSQL Connection Manager. {{}} * Allows specifying multiple data directories using `additional_data_dir` flag. {{}} * Enables management of xCluster replication using `yugabyted` commands. {{}} * Adds `permanent_uuid` to `:7000/api/v1/tablet-servers` for more reliable UUID retrieval. {{}} * Ensures accurate CPU usage metrics in the YCQL table by updating `prev_ticks_` each iteration. {{}} * Prevents errors during node restart when `data_dir` is missing from the configuration. {{}} * `collect_logs` now works even if `yugabyted` is not running. {{}} ### Bug fixes #### YSQL * Fixes error for index with bool NULLS LAST in YSQL. {{}} * Fixes YSQL upgrade exception in single connection mode. {{}} * Allows YB Admins without superuser status to run `pg_locks`. {{}} * Ensures safe upgrades by verifying pggate compatibility before sending `Scanned Rows`. {{}} * Disables in-place index updates by default to address index inconsistency issues. {{}} * Fixes out-of-bounds memory error in HashAggregate with duplicate hash keys. {{}} * Eliminates memory leaks in the YSQL cache system for improved database stability. {{}} * Fixes memory leak affecting catalog cache refresh during upgrades. {{}} * Fixes memory leaks in `CacheMemoryContext` to stabilize cache memory size after refresh. {{}} * Prevents YSQL DDL operations from returning control until related rollbacks complete. {{}} * Enhances index scan efficiency by modeling remote index filters in cost calculations. {{}} * Fixes issues with colocation in table rewrites and partitions. {{}},{{}} * Renames `ddl_rollback_enabled` to `yb_ddl_rollback_enabled` for clarity. {{}} * Adds network latency to startup costs and fixes bug for small table costs. {{}} * Disables bitmap scans by default to prevent regressions with CBO. {{}} * Reduces unnecessary logging when `catalog_version_table_in_perdb_mode` is set to true. {{}} * Correctly identifies unbatchable filters in indexpath creation. {{}} * Enables control of optimizer statistics via the `ysql_yb_enable_optimizer_statistics` flag. {{}} * Fixes buffer overflow during `ALTER TABLE SET TABLESPACE` operation. {{}} * Resolves deadlock issues when deleting a table and its index concurrently in YB-Master. {{}} * Ensures consistent query results with JSONB columns by fixing recheck criteria in index scans. {{}} * Fixes query accuracy by ensuring RHS values fit the LHS data type in index conditions. {{}} * Blocks query layer retries for multi-statement queries to prevent unintended effects. {{}} * Fixes TServer startup to correctly maintain per-database catalog version mode. {{}} * Fixes a bug in index tuple width calculation for cost estimation. {{}} * Ensures RowCompareExpressions correctly enforce non-null column conditions. {{}} * Reduces schema version mismatch errors during consecutive DDL statements with atomicity enabled. {{}} * Enables consistent DDL execution across databases by fixing flag behavior. {{}} * Introduces `ysql_min_new_version_ignored_count` flag to prevent delays in TServer crashes when versions mismatch. {{}} * Resolves PostgreSQL process crashes on the "show all" command by correcting text description locations for the `yb_enable_ddl_atomicity_infra` parameter. {{}} * Fixes restarts of UPDATE ...RETURNING queries in debug builds. {{}} * Reverts naming from "Storage SQL" to "Remote SQL" in `postgres_fdw.c`. {{}} * Ensures ALTER TABLE operates correctly after rules are dropped with `old` rewrite off. {{}} * Ensures `pg_locks` displays correct table OID instead of relfilenode after table rewrites. {{}} * Resolves flag clashes by setting `YB_AT_REWRITE_ALTER_PRIMARY_KEY` to `0x8000`. {{}} * Fixes PostgreSQL crashes triggered by enabling `yb_debug_log_catcache_events`. {{}} * Enables backward parallel scans in YSQL for more flexible data querying. {{}} * Stops unnecessary CPU use and log warnings when YSQL is disabled. {{}} * Corrects log messages for successfully dropped columns to indicate "roll forward" instead of "rollback". {{}} * Enhances stability by modifying batch operation constraints for indexed queries. {{}} * Reduces crashes and allocation errors in specific join operations. {{}} * Reduces errors by giving BNL hashtable its own expression context. {{}} * Re-enables rechecking for RowCompareExpressions to enhance accuracy with NULL inputs. {{}} * Corrects style declaration of `YbDdlRollbackEnabled` to eliminate GCC errors. {{}} * Fixes an issue with invalid pointer usage in relation data loading. {{}} * Enhances `yb_get_range_split_clause` to handle decoding errors gracefully, preventing backup issues. {{}} * Fixes memory leaks in `ybcFetchNextHeapTuple` by properly freeing YBCStatus. {{}} * Stops the YSQL webserver properly on SIGTERM to prevent coredumps. {{}} * Adds warnings and errors for system catalog table misuse. {{}} * Fixes primary key inheritance when attaching partitions with `ALTER TABLE`. {{}} * Prevents OID collision by excluding OID 65535 for database allocation. {{}} * Skips relfilenode checks for parent partition tables in schema verification. {{}} * Enhances accuracy in backward prefix-based scans by removing `kGroupEnd` markers. {{}} * Removes an unused function to reduce confusion. {{}} * Ensures bitmap scans correctly recheck results using all necessary columns, preventing incorrect query results. {{}} * Corrects handling of `IN` expressions on single columns to prevent incorrect tuple path execution. {{}} * Corrects data type error in tuple range checks during scans. {{}} * Ensures creating shared relations during YSQL upgrade increments catalog version globally. {{}} * Adds a function to reset statistics collected by the ANALYZE command. {{}} * Fixes a bug to prevent crashes and errors by ensuring correct column numbers are used for recheck. {{}} * Fixes a deadlock issue during DDL operations by adjusting lock handling. {{}} * Eliminates false log errors in DDL operations by ensuring callback invocation correctness. {{}} * Adjusts handling of INCLUDE columns in index scans to ensure proper sorting. {{}} * Enhances the `EXPLAIN` command to accurately report subquery distinct index scans. {{}} * Enhances sequence cache uniqueness by using database and sequence OIDs together. {{}} * Fixes crash in `Values Scan` by repairing SubPlans in multi-row VALUES lists. {{}} * Enables faster inserts into tables with identity columns by optimizing single-shard transactions. {{}} * Fixes log formatting and memory deallocation in `yb_pclose_check`. {{}} * Resumes `drop column` operations if alterations miss the initial completion step. {{}} * Eliminates unnecessary wait for concurrent transaction completion in DEFERRABLE READ ONLY transactions. {{}} * Prevents TServer crashes by altering type lookup for certain SAOPs. {{}} * Blocks `REINDEX` and `TRUNCATE` on system tables using table rewrite. {{}} * Ensures parent partitioned tables correctly rewrite during operations, preventing backup/restore errors. {{}} * Assumes indexes contain 1000 rows when statistics are unavailable, ensuring better query planning. {{}} * Fixes foreign key checks to avoid errors with unique indexes. {{}} * Adds error prevention for pushed-down expressions that access the catalog cache. {{}} * Increases YSQL connection manager's thread stack size to 512 KB to prevent crashes on Alma 9 machines. {{}} * Fixes memory leaks in YSQL Connection Manager for improved stability. {{}} * Ensures xCluster YBClients connect using specified addresses by setting `skip_master_flagfile`. {{}} * Disables index update optimization by default to fix `ON CONFLICT UPDATE` issues. {{}} #### YCQL * Stops automatic regeneration of deleted `cassandra` role on cluster restart. {{}} #### DocDB * Enhances read latency measurement during remote bootstrap with compression adjustments. {{}} * Prevents data corruption by handling blind writes in heartbeat processing. {{}} * Avoids crashes from parsing invalid timestamps in LTO builds by updating exception handling. {{}} * Eliminates unnecessary flush during snapshot deletion, preventing write blocks. {{}} * Resolves deadlocks in xCluster setup by standardizing lock order. {{}} * Ensures scans honor set timeouts to avoid indefinite read operations. {{}} * Enables restores to times just before the oldest snapshot in a schedule. {{}} * Ensures full xCluster error info is sent to masters post-failover. {{}} * Adds validation to prevent deletion of snapshots used in restores and vice versa. {{}} * Prevents server crashes during table truncation by safely shutting down iterators before releasing locks. {{}} * TServers now reject remote bootstrap requests for previously deleted tablets. {{}} * Sets a default 10MB max size for RocksDB MANIFEST files, now configurable via flags. {{}} * Ensures creating an index fails if it can't be added to transactional replication. {{}} * Enables `ysql_skip_row_lock_for_update` as an auto-flag to ensure safe upgrades. {{}} * Eliminates inconsistencies by not including inactive tablets in `OpenTable` operations. {{}} * Ensures consistent memory usage estimation for write operations at bootstrap and runtime. {{}} * Now truncates error messages over 1KB in `AsyncRpc::Failed` to prevent crashes. {{}} * Ensures hidden tables and tablets are excluded from snapshot generation to prevent cloning issues. {{}} * Prevents crashes during leader changes by clearing old leader data properly. {{}} * Renames flag `min_secustomerent_size_to_rollover_at_flush` to specify units. {{}} * Adjusts the class of the `enable_automatic_tablet_splitting` flag to ensure xCluster compatibility. {{}} * Switches from `scoped_refptr` to `std::shared_ptr` to safely manage memory in TabletInfo, preventing use-after-free errors. {{}},{{}} * Ensures cotable IDs match in snapshots and restores for colocated tablets. {{}} * Ensures replication consistency for new tables in colocated databases after T-server restarts. {{}} * Switches pg_cron back to using standard `SIGTERM` handling for cleaner shutdowns. {{}} * Ensures consistent tablegroup assignments for colocated table backups without using explicit tablespaces. {{}} * Eliminates fatal errors during tabletPB creation by ensuring atomic operations. {{}} * Prevents race conditions during WAL closure and consensus destruction. {{}} * Adds TSAN suppression for `boost::regex_match` to eliminate false positives. {{}} * Restores compilation on almalinux8 fastdebug gcc11. {{}} * Fixes metric attribute collisions and ensures correct metric types for tablets. {{}} * Avoids segmentation faults in `yb-master` by checking for null pointers before use. {{}} * Reduces logging redundancy during checkpoint operations to VLOG(1). {{}} * Blocks DML on databases exclusively under STANDBY xCluster mode. {{}} * Extends the lifecycle of the session in CDC State Table callback to prevent crashes. {{}} * Prevents duplicate connection destruction attempts during concurrent failures. {{}} * Enables viewing RPC bind addresses in the master leader UI. {{}} * Prevents node crash during WAL rotation if the log is closed. {{}} * Prevents crashes by ensuring background tasks aren't deleted prematurely during callbacks. {{}} * Ensures graceful shutdown by waiting for all callback completions in `PollTransactionStatusBase`. {{}} * Fixes compilation error on AlmaLinux 8 with gcc11 by initializing `prev_op`. {{}} * Fixes an incorrect TSAN suppression path for `boost::regex_match`. {{}} * Speeds up load balancer actions by allowing tablet additions on TS with pending deletes. {{}} * Enhances stability by handling RPC shutdowns and task aborts more effectively. {{}} * Prevents crashes during remote bootstrap with non-leader peers by enhancing session handling. {{}} * Delays `min_running_ht` initialization until after tablet bootstrap completes. {{}} * Ensures `skip_table_tombstone_check` is set for colocated tables. {{}} * Prevents crashes during catalog reloads by safely handling null `cluster_config_`. {{}} * Reduces the interval for tablet server metrics heartbeat to prevent misreporting leaderless tablets. {{}} * Reduces resource usage by reusing server `yb_client` in xCluster Consumer. {{}} * Fixes `pg_locks` to handle lock queries without specified transactions correctly. {{}} * Clarifies flag descriptions for memory division as a percentage of the hard memory limit. {{}} * Restores functionality of CI builds on GCC 12, debug AlmaLinux 9. {{}} * Ensures xCluster DDL replication captures the actual user's role, not the superuser. {{}} * Enhances logging for MemTable flushes to track memory limits more effectively. {{}} * Prevents corrupted characters in Prometheus metric descriptions during scrapes. {{}} * Fixes column drop cascading when dependent objects are dropped. {{}} * Enhances YSQL version upgrade process by refining master branch coding. {{}} * Adds flag to disable intent filtering during bootstrap to prevent data corruption. {{}} * Allows large byte requests on RateLimiter by breaking them into smaller chunks. {{}} * Restores the missing home icon in the master UI navigation bar. {{}} * Disables the `read-time` option in `ysql_dump` help to ensure correct DDL handling. {{}} * Enables `yb-admin` to correctly accept snapshot retention settings. {{}} * Resolves a build failure by removing unreachable code. {{}} * Renaming YSQL migration script from V60 to V59.1 ensures proper versioning and script ordering. {{}} * Fixes load balancer logic to correctly handle leader stepdown tasks. {{}} * Enhances system thread management for faster performance. {{}} * Deprecates the `enable_pg_savepoints` flag to prevent incorrect behaviors and enhance transaction reliability. {{}} * Prevents "schema version mismatch" errors after using DROP INDEX. {{}} * Ensures hidden split parent tablets are correctly represented as leaderless. {{}} * Ensures xCluster setup fails if the stream state update to `ACTIVE` fails. {{}} * Returns an empty response from `pg_replication_slots` when `ysql_yb_enable_replication_commands` is false. {{}} * Eliminates unnecessary warning logs about cluster configuration versions. {{}} * Prevents FATAL errors after multiple splits and PITR restores. {{}} #### CDC * Prevents memory leaks in the `GetChanges` RPC by deleting its MemoryContext. {{}} * Adds more debug logs to `ListReplicationSlots` for better debugging of CDC state issues. {{}} * Prevents new indexes and materialized views from being added to existing CDC streams. {{}} * Prevents non-eligible tables from being added to CDC streams, reducing resource usage. {{}},{{}},{{}} * Introduces new flag `cdcsdk_enable_identification_of_non_eligible_tables` for automatic identification of non-eligible tables in CDC streams, eliminating the need for manual master restarts for cleanup control. {{}},{{}},{{}} * Ensures accurate server clock timestamps in logical replication XLogData. {{}} * Enhances accuracy of transaction start time logging for better consistency in CDC. {{}} * Fixes memory leaks in the walsender's handling of transactions and file nodes. {{}} * Enhances memory management in walsender by implementing deep freeing of record batches. {{}} * Adds debug logs in walsender for better issue investigation. {{}} * Reduces memory leaks in CDC streaming by managing record batches in a separate memory context. {{}} * Logs errors as warnings when cleaning up virtual WAL after logical replication ends. {{}} * Fixes directory creation for serialized transactions during replication. {{}} * Disables loading replication slots from disk on startup to prevent crashes. {{}} * Adds enhanced debug logs for easier CDC stress run troubleshooting. {{}} * Reduces unnecessary RPC calls for non-distributed transaction rollbacks. {{}} * Enhances restart LSN calculation accuracy by updating transaction tracking logic. {{}} * Removes `table_name` and `table_id` attributes from CDCSDK metrics to prevent TServer crashes. {{}} * Fixes segmentation faults in walsender by updating replica identities for dynamically added tables. {{}} * Ensures omitted values in logical replication are preserved by serializing the `yb_is_omitted` array. {{}} * Fixes premature tablet exclusion in CDC streams based on timeout settings. {{}} * Fixes a race condition in CDC dynamic table creation by checking tablet initialization. {{}} * Fixes incorrect removal of the `BEGIN` record in CDC streams when no DML changes occur. {{}} * Eliminates startup issues by always using the record's commit time for Walsender operations. {{}} * Adds support for CDC with dynamic OID data types like hstore and enum arrays. {{}} * Clears cached schema on re-fetch to ensure correct DDL records delivery. {{}}