tencent cloud

TDSQL-C for MySQL

DocumentationTDSQL-C for MySQLKernel FeaturesInspection and Repair of Kernel IssuesParallel Replay of Spatial Index redo Logs Causes Instance crash and Failure to Provide Write Services

Parallel Replay of Spatial Index redo Logs Causes Instance crash and Failure to Provide Write Services

PDF
Focus Mode
Font Size
Last updated: 2025-12-08 15:56:17

Problem

Parallel replay of spatial index redo logs causes instance crash and inability to provide write services.

Issue Triggering Scenario

Using spatial index triggers spatial index split and merge, and simultaneously, other operations add SX/X locks to the (0,0) data page but do not write physical logs, which may cause inconsistency in page lsn storage, resulting in small tables being blacklisted.

Kernel Version Related to the Issue

TXSQL 8.0 3.1.16.001 and TXSQL 8.0 3.1.16.002.

Fixed Kernel Version

TXSQL 8.0 3.1.16.003.

Checking Method

Instances with TXSQL 8.0 kernel versions 3.1.16.001 and 3.1.16.002 both have risks when using spatial indexes.

Fixing Method

Upgrade the kernel version to TXSQL 8.0 3.1.16.003. For the procedure, see Upgrading the kernel minor version.
Previous Topic: Instant change column redo Flaw in Buffer Calculation Causes crashNext Topic: Billing Overview

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback