ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-5530) H2 can create indexes imported by Web Console from RDBMS
Date Sat, 17 Jun 2017 19:07:01 GMT
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)

Mime
View raw message