[
https://issues.apache.org/jira/browse/IGNITE-1232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15148401#comment-15148401
]
Semen Boikov commented on IGNITE-1232:
--------------------------------------
Moved code to the branch ignite-1232, run TC, there are some issues:
1. GridH2IndexingGeoSelfTest fails, 'explain' shows that scan index is selected
instead of spatial index.
2. If indexed key has affinity key configuration then cache creation fails
(added simple test IgniteCacheJoinQueryTest):
{noformat}
Column "AFFKEY" not found; SQL statement:
CREATE TABLE "".Integer (_key OTHER NOT NULL,_val INT) engine
"org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
[42122-191]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.table.Table.getColumn(Table.java:680)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.<init>(GridH2Table.java:119)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:786)
at
org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:770)
{noformat}
3. Test IgniteCacheQueryNodeRestartDistributedJoinSelfTest hangs, in dump I see
that exchange-worker waits for partition rent, looks like issue with partitions
reserve/release:
{noformat}
"exchange-worker-#256%near.IgniteCacheQueryNodeRestartDistributedJoinSelfTest3%"
prio=6 tid=0x0000000021f0d000 nid=0x21cc waiting on condition
[0x000000002a95e000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x00000007888b1b48> (a
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtLocalPartition$1)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:834)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(AbstractQueuedSynchronizer.java:994)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(AbstractQueuedSynchronizer.java:1303)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get0(GridFutureAdapter.java:159)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get(GridFutureAdapter.java:117)
at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtPartitionTopologyImpl.waitForRent(GridDhtPartitionTopologyImpl.java:186)
at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtPartitionTopologyImpl.beforeExchange(GridDhtPartitionTopologyImpl.java:271)
at
org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:861)
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)
{noformat}
4. It was not possible to create/destory cache and then create again since
entry was not removed from IgniteH2Indexing.dataTables on cache destory. Did
quick fix to avoid test suites hang (3f6d0c9).
> Support distributed SQL JOIN
> -----------------------------
>
> Key: IGNITE-1232
> URL: https://issues.apache.org/jira/browse/IGNITE-1232
> Project: Ignite
> Issue Type: Improvement
> Reporter: Sergi Vladykin
> Assignee: Sergi Vladykin
> Fix For: 1.6
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
