You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ilya Kasnacheev (Jira)" <ji...@apache.org> on 2019/10/21 12:42:00 UTC
[jira] [Commented] (IGNITE-10660) Can't drop index created for
dynamic cache
[ https://issues.apache.org/jira/browse/IGNITE-10660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16956022#comment-16956022 ]
Ilya Kasnacheev commented on IGNITE-10660:
------------------------------------------
However, you can do
{{DROP INDEX "cache1".test_idx_1;}}
> Can't drop index created for dynamic cache
> ------------------------------------------
>
> Key: IGNITE-10660
> URL: https://issues.apache.org/jira/browse/IGNITE-10660
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.7
> Reporter: Alex Volkov
> Priority: Major
>
> Here are steps to reproduce:
> # Start cluster with persistence.
> # Start cache with configuration (transactional, replicated full_sync with query entity).
> # Connect to cluster using sqlline.
> # Create index on this cache.
> # Try to drop index created on step 4.
> Expecting result:
> Index dropped.
> Actual result:
> Got error:
> {code:java}
> [avolkov@lab37 bin]$ ./sqlline.sh --color=true --verbose=true --showWarnings=true --showNestedErrs=true --outputFormat=csv -u jdbc:ignite:thin://lab37:10800
> Setting property: [showWarnings, true]
> Setting property: [showNestedErrs, true]
> Setting property: [outputFormat, csv]
> issuing: !connect jdbc:ignite:thin://lab37:10800 '' '' org.apache.ignite.IgniteJdbcThinDriver
> Connecting to jdbc:ignite:thin://lab37:10800
> Connected to: Apache Ignite (version 2.7.1#20181210-sha1:a39dbf0f)
> Driver: Apache Ignite Thin JDBC Driver (version 2.7.1#20181210-sha1:a39dbf0f)
> Autocommit status: true
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> sqlline version 1.3.0
> 0: jdbc:ignite:thin://lab37:10800> !tables
> 'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','TABLE_TYPE','REMARKS','TYPE_CAT','TYPE_SCHEM','TYPE_NAME','SELF_REFERENCING_COL_NAME','REF_GENERATION'
> '','cache_group_1_015','ALLTYPESINDEXED','TABLE','','','','','',''
> '','cache_group_1_001','ALLTYPESINDEXED','TABLE','','','','','',''
> '','cache1','ALLTYPESINDEXED','TABLE','','','','','',''
> 0: jdbc:ignite:thin://lab37:10800> select * from "cache1".ALLTYPESINDEXED;
> 'STRCOL','LONGCOL'
> No rows selected (0.576 seconds)
> 0: jdbc:ignite:thin://lab37:10800> create index test_idx_1 on "cache1".ALLTYPESINDEXED(STRCOL);
> No rows affected (0.05 seconds)
> 0: jdbc:ignite:thin://lab37:10800> drop index test_idx_1;
> Error: Index doesn't exist: TEST_IDX_1 (state=42000,code=3006)
> java.sql.SQLException: Index doesn't exist: TEST_IDX_1
> at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
> at sqlline.Commands.execute(Commands.java:823)
> at sqlline.Commands.sql(Commands.java:733)
> at sqlline.SqlLine.dispatch(SqlLine.java:795)
> at sqlline.SqlLine.begin(SqlLine.java:668)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> 0: jdbc:ignite:thin://lab37:10800> !index
> 'TABLE_CAT','TABLE_SCHEM','TABLE_NAME','NON_UNIQUE','INDEX_QUALIFIER','INDEX_NAME','TYPE','ORDINAL_POSITION','COLUMN_NAME','ASC_OR_DESC','CARDINALITY','PAGES','FILTER_CONDITION'
> '','cache_group_1_001','ALLTYPESINDEXED','true','','ALLTYPESINDEXED_LONGCOL_IDX','3','0','LONGCOL','A','0','0',''
> '','cache1','ALLTYPESINDEXED','true','','ALLTYPESINDEXED_STRCOL_ASC_IDX','3','0','STRCOL','A','0','0',''
> '','cache1','ALLTYPESINDEXED','true','','TEST_IDX_1','3','0','STRCOL','A','0','0',''
> '','cache_group_1_015','ALLTYPESINDEXED','true','','ALLTYPESINDEXED_LONGCOL_IDX','3','0','LONGCOL','A','0','0',''
> {code}
>
> In node log I see the exception:
>
> {code:java}
> [16:01:15,412][SEVERE][client-connector-#179][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=drop index test_idx_1, args=[], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]]
> class org.apache.ignite.internal.processors.query.IgniteSQLException: Index doesn't exist: TEST_IDX_1
> at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.convert(DdlStatementsProcessor.java:644)
> at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.runDdlStatement(DdlStatementsProcessor.java:244)
> at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFieldsNative(IgniteH2Indexing.java:1977)
> at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2141)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2135)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2130)
> at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2707)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2144)
> at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511)
> at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245)
> at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:208)
> at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:162)
> at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:45)
> at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
> at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
> at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
> at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
> at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)