You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/10/06 12:21:00 UTC

[jira] [Commented] (IGNITE-6568) Failed to DROP table created by DDL query after restart

    [ https://issues.apache.org/jira/browse/IGNITE-6568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194524#comment-16194524 ] 

ASF GitHub Bot commented on IGNITE-6568:
----------------------------------------

GitHub user alexpaschenko opened a pull request:

    https://github.com/apache/ignite/pull/2815

    IGNITE-6568 cache descriptor SQL attribute store/restore fix

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-6568

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/2815.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #2815
    
----
commit 150afd3e88ba2f9151121e35ec6829e3ec03df34
Author: Alexander Paschenko <al...@gmail.com>
Date:   2017-10-06T12:17:19Z

    IGNITE-6568 cache descriptor SQL attribute store/restore fix

----


> 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)