[
https://issues.apache.org/jira/browse/IGNITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16207556#comment-16207556
]
Denis Mekhanikov commented on IGNITE-6572:
------------------------------------------
[~vozerov]
All calls to registerCache, unregisterCache and registerType of
IgniteH2Indexing class are performed under the same mutex in
GridQueryProcessor. So there is no need to make this logic thread-safe, as it
is never performed concurrently.
> Allow multiple caches use one SQL schema
> ----------------------------------------
>
> Key: IGNITE-6572
> URL: https://issues.apache.org/jira/browse/IGNITE-6572
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Denis Mekhanikov
> Assignee: Denis Mekhanikov
> Labels: usability
> Fix For: 2.4
>
>
> When trying to create more than one cache with the same SQL schema name, the
> following exception is thrown:
> {noformat}
> Exception in thread "main" class org.apache.ignite.IgniteException: Schema
> already registered: TEST_SCHEMA
> at
> org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:957)
> at org.apache.ignite.Ignition.start(Ignition.java:350)
> at
> org.apache.ignite.examples.repro.schema.SchemaExampleNode.main(SchemaExampleNode.java:7)
> Caused by: class org.apache.ignite.IgniteCheckedException: Schema already
> registered: TEST_SCHEMA
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerCache(IgniteH2Indexing.java:2110)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1393)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:784)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:845)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1185)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1884)
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCachesOnLocalJoin(GridCacheProcessor.java:1755)
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:619)
> at
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1901)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> at java.lang.Thread.run(Thread.java:748)
> {noformat}
> It should be allowed to share schema between caches. Currently it works for
> PUBLIC schema only.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
