Allow multiple caches use one SQL schema

[dmagda]

Vladimir,

Guess this has to be documented under Java Dev Guide section?
https://apacheignite-sql.readme.io/docs/schema-and-indexes <https://apacheignite-sql.readme.io/docs/schema-and-indexes>

Do we need to do the same for .NET and C++?

—
Denis

> Begin forwarded message:
>
> From: "Vladimir Ozerov (JIRA)" <[hidden email]>
> Subject: [jira] [Resolved] (IGNITE-6572) Allow multiple caches use one SQL schema
> Date: October 25, 2017 at 4:47:00 AM PDT
> To: [hidden email]
>
>
>     [ https://issues.apache.org/jira/browse/IGNITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>
> Vladimir Ozerov resolved IGNITE-6572.
> -------------------------------------
>    Resolution: Fixed
>
>> 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)

[Vladimir Ozerov]

Hi Denis,

I do not see any section in docs mentioning that it is impossible to have
several caches in the same schema. If this is so, there is no need to fix
anything in docs.

On Wed, Oct 25, 2017 at 6:35 PM, Denis Magda <[hidden email]> wrote:

> Vladimir,
>
> Guess this has to be documented under Java Dev Guide section?
> https://apacheignite-sql.readme.io/docs/schema-and-indexes <
> https://apacheignite-sql.readme.io/docs/schema-and-indexes>
>
> Do we need to do the same for .NET and C++?
>
> —
> Denis
>
> > Begin forwarded message:
> >
> > From: "Vladimir Ozerov (JIRA)" <[hidden email]>
> > Subject: [jira] [Resolved] (IGNITE-6572) Allow multiple caches use one
> SQL schema
> > Date: October 25, 2017 at 4:47:00 AM PDT
> > To: [hidden email]
> >
> >
> >     [ https://issues.apache.org/jira/browse/IGNITE-6572?page=
> com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
> >
> > Vladimir Ozerov resolved IGNITE-6572.
> > -------------------------------------
> >    Resolution: Fixed
> >
> >> 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)
>
>