[
https://issues.apache.org/jira/browse/IGNITE-6568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16196867#comment-16196867
]
Alexander Paschenko commented on IGNITE-6568:
---------------------------------------------
Tests are fine, [~agoncharuk] could you please have a look at the code?
> Failed to DROP table created by DDL query after restart
> -------------------------------------------------------
>
> Key: IGNITE-6568
> URL: https://issues.apache.org/jira/browse/IGNITE-6568
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.1
> Reporter: Vasiliy Sisko
> Assignee: Alexander Paschenko
> Fix For: 2.3
>
> Attachments: DropTableExample-project.tar.gz
>
>
> In attached project:
> # Run node by using of CreateTableStartup class.
> # Stop node.
> # Run node by using of DropTableStartup class.
> On try to stop cache showed next exception:
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
