RATATOSK
← All releases

Vitessv22.0.2

Security 4Breaking changes 5Important fixes 17Enhancements 3Dependency updates 6Other changes 26

Get Vitess alerts

Email is sent weekly only when there are changes to check; critical security advisories are sent immediately.

Security4

GetPermissions now zeroes password checksums

Affectssetups using vtctldclient GetPermissions(Inferred)

Previously, GetPermissions did not zero PasswordChecksum before marshaling the permissions response.

Show release-note lines
 * [release-22.0] Potential fix for code scanning alert no. 2992: Clear-text logging of sensitive information (#18754) [#18759](https://github.com/vitessio/vitess/pull/18759)
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

File backup path traversal blocked

Affectsfile backup storage

Previously, ListBackups() used the supplied dir without preventing traversal outside the storage root, including through the GetBackups RPC on the vtctld server. Paths that resolve outside the root now return an error when listing, reading, starting, or removing backups.

Show release-note lines
### Security 
#### Backup and Restore
 * [release-22.0] Address dir traversal in file backup storage `GetBackups` RPC (#18814) [#18817](https://github.com/vitessio/vitess/pull/18817) 
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

Vitess Java driver dependency vulnerability fixed

Affectsinstallations using the Vitess Java driver(Inferred)

The driver previously used vulnerable commons-lang 2.6; it now uses org.apache.commons:commons-lang3 3.19.0.

Show release-note lines
#### Java
 * [release-22.0] Resolve `commons-lang` vulnerability in Java driver (#18768) [#18796](https://github.com/vitessio/vitess/pull/18796) 
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

Breaking changes5

Heartbeat reader reports stale heartbeats as errors

AffectsVTTablet instances using the heartbeat reader for replication tracking(Inferred)

When MySQL stalled and heartbeat updates stopped, vttablet was not marked as not serving. Now, Status returns an error if no heartbeat arrives for more than twice the heartbeat interval.

Show release-note lines
 * [release-22.0] Fix `vttablet` not being marked as not serving when MySQL stalls (#17883) [#18454](https://github.com/vitessio/vitess/pull/18454)
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

GetSchema omits view definitions when EnableViews is disabled

AffectsVTTablet/Schema Tracker configurations with EnableViews disabled(Inferred)

Previously, GetSchema could still return view definitions when EnableViews was disabled. Now, requests for views return no definitions, while requests for all schema definitions return table definitions only.

Show release-note lines
 * [release-22.0] Fix GetSchema RPC to prevent returning view definitions when EnableViews is disabled (#18513) [#18517](https://github.com/vitessio/vitess/pull/18517)
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

BuiltinBackupEngine file-close retries with a failure limit

Affectssetups using the BuiltinBackupEngine for backup or restore(Inferred)

Previously, backup and restore code called Close directly, and a failed backup-file operation could be retried by existing per-file handling. Now close failures are retried with backoff up to 20 times; if they persist, the operation returns FAILED_PRECONDITION and the caller does not retry that file operation.

Show release-note lines
 * [release-22.0] BuiltinBackupEngine: Retry file close and fail backup when we cannot (#18848) [#18861](https://github.com/vitessio/vitess/pull/18861) 
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

VReplication marks ER_BINLOG_CREATE_ROUTINE_NEED_SUPER unrecoverable

AffectsVReplication workflows with binary logging enabled

This includes CREATE TRIGGER operations that fail because SUPER privilege is missing while binary logging is enabled.

Evidence“err: sqlerror.NewSQLError(sqlerror.ERBinlogCreateRoutineNeedSuper, "unknown", "error applying event: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) (errno 1419) (sqlstate HY000) during query: CREATE DEFINER=`root`@`localhost` TRIGGER upd_customer BEFORE UPDATE ON customer FOR EACH ROW SET @email = NEW.email + \" (updated)\""),” vitessio/vitess/pull/18819 ↗
Show release-note lines
 * [release-22.0] VReplication: Treat ER_BINLOG_CREATE_ROUTINE_NEED_SUPER as unrecoverable (#18784) [#18819](https://github.com/vitessio/vitess/pull/18819) 
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

VDiff sidecar schema updated for faster queries

AffectsVDiff using the internal sidecar database

Some VDiff queries against the internal sidecar database performed poorly, and running VDiff could lead to primary VTTablet crashes.

Evidence“This pull request intends to improve the performance of some of the queries executed by VDiff against the internal sidecar database.” vitessio/vitess/pull/18579 ↗
Show release-note lines
 * [release-22.0] Fix: Improve VDiff internal query performance (#18579) [#18632](https://github.com/vitessio/vitess/pull/18632)
github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

Important fixes17Silent failure2

  • Scalar aggregation fixed for empty results
    AffectsVTGate scalar aggregations with literal or parameter expressions(Inferred)

    When the input result set is empty, literal and parameter expressions are now evaluated through evalengine as part of the aggregation.

     * [release-22.0] Fix scalar aggregation with literals in empty result sets (#18477) [#18491](https://github.com/vitessio/vitess/pull/18491)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • SimpleProjection names-only fields restored
    AffectsVTGate queries using SimpleProjection in names-only mode, including prepared-query field retrieval(Inferred)

    In names-only mode, a simple projection could show no fields; it now returns the input fields and applies non-empty projected column names. Prepared-query field retrieval returns the expected field names and types.

     * [release-22.0] Fix for simple projection showing no fields (#18489) [#18493](https://github.com/vitessio/vitess/pull/18493)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • VSchema foreign-key metadata follows table routing
    Affectsforeign-key-bearing tables routed to another keyspace or table

    When table routing sends a table elsewhere, VSchema construction skips adding foreign-key relationships to its source-keyspace table. The destination keyspace retains its schema-defined relationships.

     * [release-22.0]  Fix foreign key relation with routed tables (#18537) [#18541](https://github.com/vitessio/vitess/pull/18541)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Replication tracker resets replicationLagSeconds
    AffectsVTTablet replication trackers on primary tablets or with replication tracking disabled

    The metric is reset to zero when a tablet becomes primary and when Status runs in primary or disabled mode.

     * [release-22.0] repltracker: reset replica lag when we are primary (#18800) [#18806](https://github.com/vitessio/vitess/pull/18806)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • VTTablet runs queries independently after waiter-cap overflowSilent failure
    AffectsVTTablet query consolidation(Inferred)

    Before this fix, affected queries could return an empty result without an error.

     * [release-22.0] Fix bug where query consolidator returns empty result without error when the waiter cap exceeded (#18782) [#18832](https://github.com/vitessio/vitess/pull/18832) 
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Full key-range coverage fixed in GenerateShardRanges
    Affectssetups using GenerateShardRanges(Inferred)

    Before this fix, it could return shard names that did not cover the full range.

    #### vtctl
     * [release-22.0] fix: Fix `GenerateShardRanges` returning shard names that don't cover the full range (#18641) [#18654](https://github.com/vitessio/vitess/pull/18654)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • VTGate subquery limit handling fixedSilent failure
    AffectsVTGate queries with a positive sqlSelectLimit(Inferred)

    When SQL SELECT LIMIT is set through a session variable or JDBC's .setMaxRows, it was also applied to subqueries, producing incorrect results: with sql_select_limit = 1, a count over a three-row subquery returned 1 instead of 3.

     * [release-22.0] fix sqlSelectLimit propagating to subqueries (#18716) [#18872](https://github.com/vitessio/vitess/pull/18872)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Impossible-query formatting fixed for UNION statements
    Affectsimpossible queries containing UNION, including queries with a CTE(Inferred)

    Their generated SQL now adds where 1 != 1 to every SELECT branch, including in CTE-containing queries.

     * [release-22.0] bugfix: Fix impossible query for UNION (#18463) [#18465](https://github.com/vitessio/vitess/pull/18465)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Online DDL VReplication restart after failed cut-over
    AffectsOnline DDL migrations using VReplication

    When the cut-over rename fails, the executor attempts to restart the migration’s VReplication workflow; a failed restart is logged.

     * [release-22.0] Online DDL: resume vreplication after cut-over/RENAME failure (#18428) [#18437](https://github.com/vitessio/vitess/pull/18437)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Unnecessary srvtopo watcher notifications fixed
    Affectssetups using srvtopo watchers(Inferred)

    During topology outages, updates could repeatedly notify listeners even when cached data was available. Now, errors with cached data leave listeners silent; successful updates and errors without cached data still notify them.

     * [release-22.0] Fix watcher storm during topo outages (#18434) [#18440](https://github.com/vitessio/vitess/pull/18440)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Correct column counts in VTGate plans for group-only aggregation over derived tables
    AffectsVTGate queries with group-only aggregation over a derived table

    Before this release, these queries could produce an incorrect number of columns.

     * [release-22.0] bugfix: Plan group by only on top of derived tables correctly (#18505) [#18511](https://github.com/vitessio/vitess/pull/18511)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Connection-pool waits unblock on closure
    Affectssetups using the smart connection pool(Inferred)

    Previously, a goroutine waiting for a connection could hang if the pool closed while it waited. Now the wait returns ErrConnPoolClosed.

     * [release-22.0] CONNPOOL: Fix race condition when waiting for connection (#18713) [#18721](https://github.com/vitessio/vitess/pull/18721)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • VDiff extra-row reconciliation panic fixed
    AffectsVDiff extra-row reconciliation(Inferred)

    VDiff could panic when ExtraRowsSource or ExtraRowsTarget exceeded its corresponding extra-diff slice. Reconciliation now sizes its matching work from the available row-diff slices.

     * [release-22.0] Fix a panic in VDiff when reconciling extra rows. (#18585) [#18596](https://github.com/vitessio/vitess/pull/18596) 
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • AtomicCopy workflows use normal retry handling after copying
    AffectsVReplication workflows with subtype AtomicCopy

    Previously, any error on a workflow started with AtomicCopy could trigger termination, even after it had left the Copying phase.

     * [release-22.0] Avoid terminating atomic copy workflows on error if they are out of copy phase (#18475) [#18487](https://github.com/vitessio/vitess/pull/18487)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • MoveTables sequence initialization now escapes names
    AffectsMoveTables --initialize-target-sequences runs with names that require escaping

    During a traffic switch, sequence initialization could fail with a SQL syntax error when the generated query used names containing dashes. The generated query now escapes database and sequence names in this path.

     * [release-22.0] VReplication: Ensure proper handling of keyspace/database names with dashes (#18762) [#18772](https://github.com/vitessio/vitess/pull/18772)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • Repeated Row Streamer heartbeats fixed
    AffectsVTTablet Row Streamer streams that send VStreamRowsResponse heartbeats.(Inferred)

    After sending the first heartbeat, the sender stopped responding to later heartbeat-ticker events. It now continues sending heartbeat responses on each ticker event until the stream context is canceled.

     * [release-22.0] [Bugfix] Broken Heartbeat system in Row Streamer (#18390) [#18398](https://github.com/vitessio/vitess/pull/18398)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md
  • VTTablet sequence counters reset after successful updates
    AffectsVTTablet sequence backing tables(Inferred)

    After a traffic switch, cached sequence values could persist, producing duplicate values and duplicate-key errors. After a successful sequence-value update, the next insert ID is fetched from the sequence table instead of using stale in-memory counters.

     * [release-22.0] Reset in-memory sequence info on vttablet on UpdateSequenceTables request (#18415) [#18445](https://github.com/vitessio/vitess/pull/18445)
    github.com/vitessio/vitess/blob/main/changelog/22.0/22.0.2/changelog.md

Enhancements3

Dependency updates6

5 more, none mentioning security
  • * [release-22.0] Upgrade the Golang version to `go1.24.7` [#18621](https://github.com/vitessio/vitess/pull/18621)
  • * [release-22.0] Upgrade the Golang version to `go1.24.9` [#18737](https://github.com/vitessio/vitess/pull/18737)
  • * [release-22.0] Bump vite from 4.5.9 to 4.5.14 in /web/vtadmin (#18485) [#18500](https://github.com/vitessio/vitess/pull/18500)
  • * [release-22.0] Bump @babel/runtime from 7.26.0 to 7.27.6 in /web/vtadmin (#18467) [#18502](https://github.com/vitessio/vitess/pull/18502)
  • * [release-22.0] Bump form-data from 4.0.1 to 4.0.4 in /web/vtadmin (#18473) [#18504](https://github.com/vitessio/vitess/pull/18504)
Other changes26

Summaries are produced by AI, so they can be wrong, and they are provided without warranty.