[jira] [Created] (IGNITE-5530) H2 can create indexes imported by Web Console from RDBMS

[Anton Vinogradov (Jira)]

Denis Magda created IGNITE-5530:
-----------------------------------

             Summary: H2 can create indexes imported by Web Console from RDBMS
                 Key: IGNITE-5530
                 URL: https://issues.apache.org/jira/browse/IGNITE-5530
             Project: Ignite
          Issue Type: Bug
    Affects Versions: 2.0, 2.1
            Reporter: Denis Magda
            Assignee: Alexey Kuznetsov
            Priority: Blocker
             Fix For: 2.1


Used the latest version of Web Console and its configuration wizard for version 2.0. A server node started from the generated project immediately fails with the exception below:
{code}
com.intellij.rt.execution.application.AppMain startup.ServerNodeCodeStartup
Jun 17, 2017 11:23:30 AM java.util.logging.LogManager$RootLogger log
SEVERE: Failed to resolve default logging config file: config/java.util.logging.properties
[11:23:31]    __________  ________________
[11:23:31]   /  _/ ___/ |/ /  _/_  __/ __/
[11:23:31]  _/ // (7 7    // /  / / / _/  
[11:23:31] /___/\___/_/|_/___/ /_/ /___/  
[11:23:31]
[11:23:31] ver. 2.0.0#20170430-sha1:d4eef3c6
[11:23:31] 2017 Copyright(C) Apache Software Foundation
[11:23:31]
[11:23:31] Ignite documentation: http://ignite.apache.org
[11:23:31]
[11:23:31] Quiet mode.
[11:23:31]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat}
[11:23:31]
[11:23:31] OS: Mac OS X 10.12.5 x86_64
[11:23:31] VM information: Java(TM) SE Runtime Environment 1.8.0_77-b03 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.77-b03
[11:23:31] Initial heap size is 128MB (should be no less than 512MB, use -Xms512m -Xmx512m).
[11:23:31] Configured plugins:
[11:23:31]   ^-- None
[11:23:31]
[11:23:31] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides.
[11:23:31] Security status [authentication=off, tls/ssl=off]
Jun 17, 2017 11:23:33 AM org.apache.ignite.logger.java.JavaLogger error
SEVERE: Got exception while starting (will rollback startup routine).
class org.apache.ignite.IgniteCheckedException: Failed to execute SQL statement on internal H2 database: CREATE INDEX PRIMARY ON "CountrylanguageCache".Countrylanguage ("COUNTRYCODE" DESC, "LANGUAGE" DESC, "_KEY" ASC)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSql(IgniteH2Indexing.java:875)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.addInitialUserIndex(IgniteH2Indexing.java:780)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:2009)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1859)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1306)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:756)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:817)
        at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1265)
        at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:898)
        at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:1013)
        at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1895)
        at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1647)
        at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1075)
        at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:595)
        at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:519)
        at org.apache.ignite.Ignition.start(Ignition.java:322)
        at startup.ServerNodeCodeStartup.main(ServerNodeCodeStartup.java:16)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX PRIMARY[*] ON ""CountrylanguageCache"".COUNTRYLANGUAGE (""COUNTRYCODE"" DESC, ""LANGUAGE"" DESC, ""_KEY"" ASC) "; expected "identifier"; SQL statement:
CREATE INDEX PRIMARY ON "CountrylanguageCache".Countrylanguage ("COUNTRYCODE" DESC, "LANGUAGE" DESC, "_KEY" ASC) [42001-195]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.getSyntaxError(DbException.java:205)
        at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:3197)
        at org.h2.command.Parser.parseCreate(Parser.java:4374)
        at org.h2.command.Parser.parsePrepared(Parser.java:365)
        at org.h2.command.Parser.parse(Parser.java:320)
        at org.h2.command.Parser.parse(Parser.java:292)
        at org.h2.command.Parser.prepareCommand(Parser.java:257)
        at org.h2.engine.Session.prepareLocal(Session.java:573)
        at org.h2.engine.Session.prepareCommand(Session.java:514)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:482)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSql(IgniteH2Indexing.java:870)
        ... 21 more

[11:23:33] Cancelled rebalancing from all nodes [topology=null]
[11:23:33] Cancelled rebalancing from all nodes [topology=null]
[11:23:33] Cancelled rebalancing from all nodes [topology=null]
[11:23:33] Ignite node stopped OK [name=Ignite-MySQL-Cluster, uptime=00:00:02:775]
Exception in thread "main" class org.apache.ignite.IgniteException: Failed to execute SQL statement on internal H2 database: CREATE INDEX PRIMARY ON "CountrylanguageCache".Countrylanguage ("COUNTRYCODE" DESC, "LANGUAGE" DESC, "_KEY" ASC)
        at org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:949)
        at org.apache.ignite.Ignition.start(Ignition.java:325)
        at startup.ServerNodeCodeStartup.main(ServerNodeCodeStartup.java:16)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to execute SQL statement on internal H2 database: CREATE INDEX PRIMARY ON "CountrylanguageCache".Countrylanguage ("COUNTRYCODE" DESC, "LANGUAGE" DESC, "_KEY" ASC)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSql(IgniteH2Indexing.java:875)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.addInitialUserIndex(IgniteH2Indexing.java:780)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:2009)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1859)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1306)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:756)
        at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:817)
        at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1265)
        at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:898)
        at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:1013)
        at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1895)
        at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1647)
        at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1075)
        at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:595)
        at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:519)
        at org.apache.ignite.Ignition.start(Ignition.java:322)
        ... 6 more
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX PRIMARY[*] ON ""CountrylanguageCache"".COUNTRYLANGUAGE (""COUNTRYCODE"" DESC, ""LANGUAGE"" DESC, ""_KEY"" ASC) "; expected "identifier"; SQL statement:
CREATE INDEX PRIMARY ON "CountrylanguageCache".Countrylanguage ("COUNTRYCODE" DESC, "LANGUAGE" DESC, "_KEY" ASC) [42001-195]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.getSyntaxError(DbException.java:205)
        at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:3197)
        at org.h2.command.Parser.parseCreate(Parser.java:4374)
        at org.h2.command.Parser.parsePrepared(Parser.java:365)
        at org.h2.command.Parser.parse(Parser.java:320)
        at org.h2.command.Parser.parse(Parser.java:292)
        at org.h2.command.Parser.prepareCommand(Parser.java:257)
        at org.h2.engine.Session.prepareLocal(Session.java:573)
        at org.h2.engine.Session.prepareCommand(Session.java:514)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:482)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSql(IgniteH2Indexing.java:870)
        ... 21 more

Process finished with exit code 1

{code}

Use the project attached to reproduce the issue.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)