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