You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2016/04/26 00:36:00 UTC
Re: Exception while using primary key with “underscore” character in apache ignite
Hi,
Can you please properly subscribe to the mailing list so that the community
can receive email notifications? Here is the instruction:
http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1
anishdevasia wrote
> Following exception occurs when using apache ignite data grid with schema
> import utility. A table "employee" created with primary key "emp_no" as
> the column name. generated pojo classes and configuration using apache
> ignite schema import utility. tried executing example program that comes
> with distribution. Following it the exception. apache ignite version is :
> 1.5.0-final
> It seems like if the table is having any index that has columns with "_"
> character is causing this issue.
>
> [16:45:58,890][ERROR][exchange-worker-#49%null%][GridDhtPartitionsExchangeFuture]
> Failed to reinitialize local partitions (preloading will be stopped):
> GridDhtPartitionExchangeId [topVer=AffinityTopologyVersion [topVer=1,
> minorTopVer=1], nodeId=1073ac4a, evt=DISCOVERY_CUSTOM_EVT]
> class org.apache.ignite.IgniteCheckedException: Failed to register query
> type: TypeDescriptor [name=Employees, fields={empNo=class
> java.lang.Object, birthDate=class java.sql.Date, firstName=class
> java.lang.Object, lastName=class java.lang.Object, gender=class
> java.lang.Object, hireDate=class java.sql.Date},
> indexes={PRIMARY=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:1167)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:457)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1038)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1648)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCachesStart(GridCacheProcessor.java:1563)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.startCaches(GridDhtPartitionsExchangeFuture.java:956)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:523)
> at
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.h2.jdbc.JdbcSQLException: Column "EMP_NO" not found; SQL
> statement:
> CREATE TABLE "EmployeesCache".Employees (_key OTHER NOT NULL,_val
> OTHER,empNo OTHER,birthDate DATE,firstName OTHER,lastName OTHER,gender
> OTHER,hireDate DATE) engine
> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
> [42122-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.getColumn(Table.java:626)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$TableDescriptor.createIndexes(IgniteH2Indexing.java:1984)
> at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.
> <init>
> (GridH2Table.java:106)
> at
> org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:675)
> at
> org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:659)
> 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:700)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1288)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1160)
> ... 10 more
> [16:45:58,890][ERROR][exchange-worker-#49%null%][GridCachePartitionExchangeManager]
> Runtime error caught during grid runnable execution: GridWorker
> [name=partition-exchanger, gridName=null, finished=false,
> isCancelled=false, hashCode=2115830072, interrupted=false,
> runner=exchange-worker-#49%null%]
> java.lang.NullPointerException
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.onExchangeDone(GridCacheProcessor.java:1723)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.onDone(GridDhtPartitionsExchangeFuture.java:1109)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.onDone(GridDhtPartitionsExchangeFuture.java:87)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:334)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:873)
> at
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> at java.lang.Thread.run(Thread.java:745)
Most likely there is something wrong in the generated configuration. Please
provide your POJOs and the CacheConfig class.
-Val
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Exception-while-using-primary-key-with-underscore-character-in-apache-ignite-tp4500p4514.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Exception while using primary key with “underscore” character in apache ignite
Posted by Alexey Kuznetsov <ak...@gridgain.com>.
There were a lot of bugs fixed in Schema Import Utility recently.
Could you try to re-generate POJOs and configs one more time using Schema
Import Utility from latest [nightly build][1]?
[1]:
https://builds.apache.org/view/H-L/view/Ignite/job/Ignite-nightly/lastSuccessfulBuild/
On Tue, Apr 26, 2016 at 5:36 AM, vkulichenko <va...@gmail.com>
wrote:
> Hi,
>
> Can you please properly subscribe to the mailing list so that the community
> can receive email notifications? Here is the instruction:
>
> http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1
>
>
> anishdevasia wrote
> > Following exception occurs when using apache ignite data grid with schema
> > import utility. A table "employee" created with primary key "emp_no" as
> > the column name. generated pojo classes and configuration using apache
> > ignite schema import utility. tried executing example program that comes
> > with distribution. Following it the exception. apache ignite version is :
> > 1.5.0-final
> > It seems like if the table is having any index that has columns with "_"
> > character is causing this issue.
> >
> >
> [16:45:58,890][ERROR][exchange-worker-#49%null%][GridDhtPartitionsExchangeFuture]
> > Failed to reinitialize local partitions (preloading will be stopped):
> > GridDhtPartitionExchangeId [topVer=AffinityTopologyVersion [topVer=1,
> > minorTopVer=1], nodeId=1073ac4a, evt=DISCOVERY_CUSTOM_EVT]
> > class org.apache.ignite.IgniteCheckedException: Failed to register query
> > type: TypeDescriptor [name=Employees, fields={empNo=class
> > java.lang.Object, birthDate=class java.sql.Date, firstName=class
> > java.lang.Object, lastName=class java.lang.Object, gender=class
> > java.lang.Object, hireDate=class java.sql.Date},
> > indexes={PRIMARY=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:1167)
> > at
> >
> org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291)
> > at
> >
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:457)
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1038)
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1648)
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCachesStart(GridCacheProcessor.java:1563)
> > at
> >
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.startCaches(GridDhtPartitionsExchangeFuture.java:956)
> > at
> >
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:523)
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297)
> > at
> >
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: org.h2.jdbc.JdbcSQLException: Column "EMP_NO" not found; SQL
> > statement:
> > CREATE TABLE "EmployeesCache".Employees (_key OTHER NOT NULL,_val
> > OTHER,empNo OTHER,birthDate DATE,firstName OTHER,lastName OTHER,gender
> > OTHER,hireDate DATE) engine
> > "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
> > [42122-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.getColumn(Table.java:626)
> > at
> >
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$TableDescriptor.createIndexes(IgniteH2Indexing.java:1984)
> > at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.
> > <init>
> > (GridH2Table.java:106)
> > at
> >
> org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:675)
> > at
> >
> org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:659)
> > 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:700)
> > at
> >
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1288)
> > at
> >
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1160)
> > ... 10 more
> >
> [16:45:58,890][ERROR][exchange-worker-#49%null%][GridCachePartitionExchangeManager]
> > Runtime error caught during grid runnable execution: GridWorker
> > [name=partition-exchanger, gridName=null, finished=false,
> > isCancelled=false, hashCode=2115830072, interrupted=false,
> > runner=exchange-worker-#49%null%]
> > java.lang.NullPointerException
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.onExchangeDone(GridCacheProcessor.java:1723)
> > at
> >
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.onDone(GridDhtPartitionsExchangeFuture.java:1109)
> > at
> >
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.onDone(GridDhtPartitionsExchangeFuture.java:87)
> > at
> >
> org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:334)
> > at
> >
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:873)
> > at
> >
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297)
> > at
> >
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> > at java.lang.Thread.run(Thread.java:745)
>
> Most likely there is something wrong in the generated configuration. Please
> provide your POJOs and the CacheConfig class.
>
> -Val
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Exception-while-using-primary-key-with-underscore-character-in-apache-ignite-tp4500p4514.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com