You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Denis Magda (JIRA)" <ji...@apache.org> on 2017/06/17 19:07:01 UTC
[jira] [Created] (IGNITE-5530) H2 can create indexes imported by
Web Console from RDBMS
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)