[
https://issues.apache.org/jira/browse/IGNITE-1146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14724758#comment-14724758
]
Pavel Konstantinov edited comment on IGNITE-1146 at 9/1/15 4:08 AM:
--------------------------------------------------------------------
I'm loaded metadata from DB2 and start node using generated xml and got:
{code}
class org.apache.ignite.IgniteException: Failed to register query type:
TypeDescriptor [name=org.apache.ignite.Comalgorithm, fields={APCSBJCODE=class
java.math.BigDecimal, APCID=class java.math.BigDecimal, AGRSBJCODE=class
java.math.BigDecimal, AGRID=class java.math.BigDecimal, DAOSBJCODE=class
java.math.BigDecimal, DAOID=class java.math.BigDecimal, CTPSBJCODE=class
java.math.BigDecimal, CTPID=class java.math.BigDecimal, apcsbjcode=class
java.math.BigDecimal, apcid=class java.math.BigDecimal, al
gcode=class java.math.BigDecimal, algisversioned=class java.lang.Short,
algtype=class java.lang.Integer, algcalcobjecttype=class java.lang.Integer,
algclasspath=class java.lang.String, algcomment=class java.lang.String,
algopendate=class java.sql.Date, algclosedate=class java.sql.Date,
algentstatus=class java.lang.Integer, agrsbjcode=class java.math.BigDecimal,
agrid=class java.math.BigDecimal, daosbjcode=class java.math.BigDecimal,
daoid=class java.math.BigDecimal, ctpsbjcode=class java.math.Bi
gDecimal, ctpid=class java.math.BigDecimal, algusefields=class
java.lang.String}, indexes={FK1COMALGORITHM=IndexDescriptor [type=SORTED],
FK3COMALGORITHM=IndexDescriptor [type=SORTED], FK4COMALGORITHM=IndexDescriptor
[type=SORTED], SQL050208183448780=IndexDescriptor [type=SORTED]},
fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object,
valTextIdx=false, registered=false]
at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:692)
at org.apache.ignite.Ignition.start(Ignition.java:349)
at
org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:289)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to register
query type: TypeDescriptor [name=org.apache.ignite.Comalgorithm,
fields={APCSBJCODE=class java.math.BigDecimal, APCID=class
java.math.BigDecimal, AGRSBJCODE=class java.math.BigDecimal, AGRID=class
java.math.BigDecimal, DAOSBJCODE=class java.math.BigDecimal, DAOID=class
java.math.BigDecimal, CTPSBJCODE=class java.math.BigDecimal, CTPID=class
java.math.BigDecimal, apcsbjcode=class java.math.BigDecimal, apcid=class java.m
ath.BigDecimal, algcode=class java.math.BigDecimal, algisversioned=class
java.lang.Short, algtype=class java.lang.Integer, algcalcobjecttype=class
java.lang.Integer, algclasspath=class java.lang.String, algcomment=class
java.lang.String, algopendate=class java.sql.Date, algclosedate=class
java.sql.Date, algentstatus=class java.lang.Integer, agrsbjcode=class
java.math.BigDecimal, agrid=class java.math.BigDecimal, daosbjcode=class
java.math.BigDecimal, daoid=class java.math.BigDecimal, ctpsbjcode=
class java.math.BigDecimal, ctpid=class java.math.BigDecimal,
algusefields=class java.lang.String}, indexes={FK1COMALGORITHM=IndexDescriptor
[type=SORTED], FK3COMALGORITHM=IndexDescriptor [type=SORTED],
FK4COMALGORITHM=IndexDescriptor [type=SORTED],
SQL050208183448780=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false,
registered=false]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:963)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:157)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:249)
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:925)
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:782)
at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:829)
at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1549)
at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1416)
at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:916)
at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:843)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:735)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:656)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:527)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:497)
at org.apache.ignite.Ignition.start(Ignition.java:346)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Повтор имени столбца "APCSBJCODE"
Duplicate column name "APCSBJCODE"; SQL statement:
CREATE TABLE "cache2".org_apache_ignite_Comalgorithm (_key OTHER NOT NULL,_val
OTHER,APCSBJCODE DECIMAL,APCID DECIMAL,AGRSBJCODE DECIMAL,AGRID
DECIMAL,DAOSBJCODE DECIMAL,DAOID DECIMAL,CTPSBJCODE DECIMAL,CTPID
DECIMAL,apcsbjcode DECIMAL,apcid DECIMAL,algcode DECIMAL,algisversioned
SMALLINT,algtype INT,algcalcobjecttype INT,algclasspath VARCHAR,algcomment
VARCHAR,algopendate DATE,algclosedate DATE,algentstatus INT,agrsbjcode
DECIMAL,agrid DECIMAL,daosbjcode DECIMAL,daoid DECIMAL,ctpsbjcode DECIMAL
,ctpid DECIMAL,algusefields VARCHAR) engine
"org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
[42121-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.table.Table.setColumns(Table.java:394)
at org.h2.table.TableBase.<init>(TableBase.java:44)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.<init>(GridH2Table.java:72)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:600)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:584)
at org.h2.schema.Schema.createTable(Schema.java:584)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:135)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:625)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1071)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:956)
... 15 more
Failed to start grid: Failed to register query type: TypeDescriptor
[name=org.apache.ignite.Comalgorithm, fields={APCSBJCODE=class
java.math.BigDecimal, APCID=class java.math.BigDecimal, AGRSBJCODE=class
java.math.BigDecimal, AGRID=class java.math.BigDecimal, DAOSBJCODE=class
java.math.BigDecimal, DAOID=class java.math.BigDecimal, CTPSBJCODE=class
java.math.BigDecimal, CTPID=class java.math.BigDecimal, apcsbjcode=class
java.math.BigDecimal, apcid=class java.math.BigDecimal, algcode=class java.ma
th.BigDecimal, algisversioned=class java.lang.Short, algtype=class
java.lang.Integer, algcalcobjecttype=class java.lang.Integer,
algclasspath=class java.lang.String, algcomment=class java.lang.String,
algopendate=class java.sql.Date, algclosedate=class java.sql.Date,
algentstatus=class java.lang.Integer, agrsbjcode=class java.math.BigDecimal,
agrid=class java.math.BigDecimal, daosbjcode=class java.math.BigDecimal,
daoid=class java.math.BigDecimal, ctpsbjcode=class java.math.BigDecimal,
ctpid=cla
ss java.math.BigDecimal, algusefields=class java.lang.String},
indexes={FK1COMALGORITHM=IndexDescriptor [type=SORTED],
FK3COMALGORITHM=IndexDescriptor [type=SORTED], FK4COMALGORITHM=IndexDescriptor
[type=SORTED], SQL050208183448780=IndexDescriptor [type=SORTED]},
fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object,
valTextIdx=false, registered=false]
{code}
XML attached (test-cluster-2.xml).
was (Author: pkonstantinov):
I'm loaded metadata from DB2 and start node using generated xml and got:
{code}
class org.apache.ignite.IgniteException: Failed to register query type:
TypeDescriptor [name=org.apache.ignite.Comalgorithm, fields={APCSBJCODE=class
java.math.BigDecimal, APCID=class java.math.BigDecimal, AGRSBJCODE=class
java.math.BigDecimal, AGRID=class java.math.BigDecimal, DAOSBJCODE=class
java.math.BigDecimal, DAOID=class java.math.BigDecimal, CTPSBJCODE=class
java.math.BigDecimal, CTPID=class java.math.BigDecimal, apcsbjcode=class
java.math.BigDecimal, apcid=class java.math.BigDecimal, al
gcode=class java.math.BigDecimal, algisversioned=class java.lang.Short,
algtype=class java.lang.Integer, algcalcobjecttype=class java.lang.Integer,
algclasspath=class java.lang.String, algcomment=class java.lang.String,
algopendate=class java.sql.Date, algclosedate=class java.sql.Date,
algentstatus=class java.lang.Integer, agrsbjcode=class java.math.BigDecimal,
agrid=class java.math.BigDecimal, daosbjcode=class java.math.BigDecimal,
daoid=class java.math.BigDecimal, ctpsbjcode=class java.math.Bi
gDecimal, ctpid=class java.math.BigDecimal, algusefields=class
java.lang.String}, indexes={FK1COMALGORITHM=IndexDescriptor [type=SORTED],
FK3COMALGORITHM=IndexDescriptor [type=SORTED], FK4COMALGORITHM=IndexDescriptor
[type=SORTED], SQL050208183448780=IndexDescriptor [type=SORTED]},
fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object,
valTextIdx=false, registered=false]
at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:692)
at org.apache.ignite.Ignition.start(Ignition.java:349)
at
org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:289)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to register
query type: TypeDescriptor [name=org.apache.ignite.Comalgorithm,
fields={APCSBJCODE=class java.math.BigDecimal, APCID=class
java.math.BigDecimal, AGRSBJCODE=class java.math.BigDecimal, AGRID=class
java.math.BigDecimal, DAOSBJCODE=class java.math.BigDecimal, DAOID=class
java.math.BigDecimal, CTPSBJCODE=class java.math.BigDecimal, CTPID=class
java.math.BigDecimal, apcsbjcode=class java.math.BigDecimal, apcid=class java.m
ath.BigDecimal, algcode=class java.math.BigDecimal, algisversioned=class
java.lang.Short, algtype=class java.lang.Integer, algcalcobjecttype=class
java.lang.Integer, algclasspath=class java.lang.String, algcomment=class
java.lang.String, algopendate=class java.sql.Date, algclosedate=class
java.sql.Date, algentstatus=class java.lang.Integer, agrsbjcode=class
java.math.BigDecimal, agrid=class java.math.BigDecimal, daosbjcode=class
java.math.BigDecimal, daoid=class java.math.BigDecimal, ctpsbjcode=
class java.math.BigDecimal, ctpid=class java.math.BigDecimal,
algusefields=class java.lang.String}, indexes={FK1COMALGORITHM=IndexDescriptor
[type=SORTED], FK3COMALGORITHM=IndexDescriptor [type=SORTED],
FK4COMALGORITHM=IndexDescriptor [type=SORTED],
SQL050208183448780=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false,
registered=false]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:963)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:157)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:249)
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:925)
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:782)
at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:829)
at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1549)
at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1416)
at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:916)
at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:843)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:735)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:656)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:527)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:497)
at org.apache.ignite.Ignition.start(Ignition.java:346)
... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Повтор имени столбца "APCSBJCODE"
Duplicate column name "APCSBJCODE"; SQL statement:
CREATE TABLE "cache2".org_apache_ignite_Comalgorithm (_key OTHER NOT NULL,_val
OTHER,APCSBJCODE DECIMAL,APCID DECIMAL,AGRSBJCODE DECIMAL,AGRID
DECIMAL,DAOSBJCODE DECIMAL,DAOID DECIMAL,CTPSBJCODE DECIMAL,CTPID
DECIMAL,apcsbjcode DECIMAL,apcid DECIMAL,algcode DECIMAL,algisversioned
SMALLINT,algtype INT,algcalcobjecttype INT,algclasspath VARCHAR,algcomment
VARCHAR,algopendate DATE,algclosedate DATE,algentstatus INT,agrsbjcode
DECIMAL,agrid DECIMAL,daosbjcode DECIMAL,daoid DECIMAL,ctpsbjcode DECIMAL
,ctpid DECIMAL,algusefields VARCHAR) engine
"org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
[42121-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.table.Table.setColumns(Table.java:394)
at org.h2.table.TableBase.<init>(TableBase.java:44)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.<init>(GridH2Table.java:72)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:600)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:584)
at org.h2.schema.Schema.createTable(Schema.java:584)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:135)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:625)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1071)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:956)
... 15 more
Failed to start grid: Failed to register query type: TypeDescriptor
[name=org.apache.ignite.Comalgorithm, fields={APCSBJCODE=class
java.math.BigDecimal, APCID=class java.math.BigDecimal, AGRSBJCODE=class
java.math.BigDecimal, AGRID=class java.math.BigDecimal, DAOSBJCODE=class
java.math.BigDecimal, DAOID=class java.math.BigDecimal, CTPSBJCODE=class
java.math.BigDecimal, CTPID=class java.math.BigDecimal, apcsbjcode=class
java.math.BigDecimal, apcid=class java.math.BigDecimal, algcode=class java.ma
th.BigDecimal, algisversioned=class java.lang.Short, algtype=class
java.lang.Integer, algcalcobjecttype=class java.lang.Integer,
algclasspath=class java.lang.String, algcomment=class java.lang.String,
algopendate=class java.sql.Date, algclosedate=class java.sql.Date,
algentstatus=class java.lang.Integer, agrsbjcode=class java.math.BigDecimal,
agrid=class java.math.BigDecimal, daosbjcode=class java.math.BigDecimal,
daoid=class java.math.BigDecimal, ctpsbjcode=class java.math.BigDecimal,
ctpid=cla
ss java.math.BigDecimal, algusefields=class java.lang.String},
indexes={FK1COMALGORITHM=IndexDescriptor [type=SORTED],
FK3COMALGORITHM=IndexDescriptor [type=SORTED], FK4COMALGORITHM=IndexDescriptor
[type=SORTED], SQL050208183448780=IndexDescriptor [type=SORTED]},
fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object,
valTextIdx=false, registered=false]
{code}
XML attached.
> Implement summary page with configuration downloads.
> ----------------------------------------------------
>
> Key: IGNITE-1146
> URL: https://issues.apache.org/jira/browse/IGNITE-1146
> Project: Ignite
> Issue Type: Sub-task
> Components: wizards
> Reporter: Andrey Novikov
> Assignee: Andrey Novikov
> Fix For: ignite-1.4
>
> Attachments: summary - client.png, summary - server.png,
> test-cluster-2.xml
>
>
> Generate:
> * sprint xml configuration;
> * java class with configuration;
> * java snipplet with configuration;
> * docker file for run with this configuration.
> Download all generated files as zip archive, generate client configuration.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
