[IGNITE-8625] Dynamic SQL index recreate after cache clear may result in AssertionError or JVM crash

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Cannot Reproduce
• Fix Version/s: 2.9, 2.8.1
• Component/s: persistence, sql
• Labels: MakeTeamcityGreenAgain sql-stability
• Assignee: Dmitriy Sorokin
• Reporter: Ivan Rakov
• Created: 28/May/18 12:09
• Updated: 13/Apr/20 23:32
• Resolved: 13/Apr/20 23:32

Description

After recreation of previously dropped SQL index (in persistent mode), root page of new index B+ tree may contain links to data entries from previous index tree. If these entries were removed or relocated to another data page, attempt to dereference these links may throw AssertionError or even cause JVM crash.
Patch with reproducer is attached.

P.S. Please note that with IGNITE-4958 fix old invalid links may refer to non-data page - it might have been recycled into page with any other type. Such case will cause AssertionError on page read lock attempt. Rolling back IGNITE-4958 may help with debugging.

Issue Links

• is fixed by: IGNITE-12061 Silently fail while try to recreate already existing index with differ inline_size.