[IGNITE-6568] Failed to DROP table created by DDL query after restart

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.3
• Component/s: sql
• Assignee: Alexander Paschenko
• Reporter: Vasiliy Sisko
• Created: 06/Oct/17 06:45
• Updated: 10/Oct/17 07:07
• Resolved: 10/Oct/17 07:07

Description

In attached project:

1. Run node by using of CreateTableStartup class.
2. Stop node.
3. Run node by using of DropTableStartup class.
   On try to stop cache showed next exception:

   Exception in thread "main" class org.apache.ignite.internal.processors.query.IgniteSQLException: Unexpected DLL operation failure: class org.apache.ignite.IgniteCheckedException: Only cache created with CREATE TABLE may be removed with DROP TABLE [cacheName=SQL_PUBLIC_CITY]
   	at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.runDdlStatement(DdlStatementsProcessor.java:280)
   	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1385)
   	at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1923)
   	at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1919)
   	at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
   	at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2401)
   	at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1927)
   	at startup.DropTableStartup.main(DropTableStartup.java:21)
   Caused by: javax.cache.CacheException: class org.apache.ignite.IgniteCheckedException: Only cache created with CREATE TABLE may be removed with DROP TABLE [cacheName=SQL_PUBLIC_CITY]
   	at org.apache.ignite.internal.processors.cache.GridCacheUtils.convertToCacheException(GridCacheUtils.java:1327)
   	at org.apache.ignite.internal.IgniteKernal.destroyCache0(IgniteKernal.java:3118)
   	at org.apache.ignite.internal.processors.query.GridQueryProcessor.dynamicTableDrop(GridQueryProcessor.java:1436)
   	at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.runDdlStatement(DdlStatementsProcessor.java:212)
   	... 7 more
   Caused by: class org.apache.ignite.IgniteCheckedException: Only cache created with CREATE TABLE may be removed with DROP TABLE [cacheName=SQL_PUBLIC_CITY]
   	at org.apache.ignite.internal.processors.cache.ClusterCachesInfo.processCacheChangeRequests(ClusterCachesInfo.java:628)
   	at org.apache.ignite.internal.processors.cache.ClusterCachesInfo.onCacheChangeRequested(ClusterCachesInfo.java:392)
   	at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onCustomEvent(GridCacheProcessor.java:2927)
   	at org.apache.ignite.internal.managers.discovery.GridDiscoveryManager$4.onDiscovery0(GridDiscoveryManager.java:664)
   	at org.apache.ignite.internal.managers.discovery.GridDiscoveryManager$4.onDiscovery(GridDiscoveryManager.java:564)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.notifyDiscoveryListener(ServerImpl.java:5461)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processCustomMessage(ServerImpl.java:5280)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processMessage(ServerImpl.java:2654)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processMessage(ServerImpl.java:2445)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$MessageWorkerAdapter.body(ServerImpl.java:6639)
   	at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.body(ServerImpl.java:2531)
   	at org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)
   

Issue Links

• links to: GitHub Pull Request #2815