[IGNITE-8107] Drop cache with SQL table, recreate table on a different cache - cluster fails to activate

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Assignee: Unassigned
• Reporter: Ilya Kasnacheev
• Created: 02/Apr/18 13:30
• Updated: 02/Apr/18 13:31

Description

This is a bizzare twist on IGNITE-8021

Imagine you have a cache "tbl" created by public API with corresponding table "tbl".TBL. You also have PDS. Drop this cache, CREATE TABLE TBL with corresponding SQL_PUBLIC_TBL cache. It would work, but if you shut down cluster and try to bring it online, it will fail to activate:

SchemaOperationException [code=3, msg=Table already exists: TBL]

Issue Links

• is related to: IGNITE-8021 Destroyed caches can be return to life by restart grid