Parallel Replay of Spatial Index redo Logs Causes Instance crash and Failure to Provide Write Services
Last updated: 2025-12-08 15:56:17
Parallel Replay of Spatial Index redo Logs Causes Instance crash and Failure to Provide Write Services
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback