ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Konstantinov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-1146) Implement summary page with configuration downloads.
Date Tue, 01 Sep 2015 04:13:45 GMT

    [ 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:13 AM:
--------------------------------------------------------------------

I'm loaded metadata from DB2 and start(used 7.3.3-p6) 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 (test-cluster-2.xml).

> 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)

Mime
View raw message