ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Semen Boikov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-1232) Support distributed SQL JOIN
Date Tue, 16 Feb 2016 10:18:18 GMT

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

Mime
View raw message