Re: TcpCommunicationSpi failed to establish connection to node, node will be dropped from cluster

[wiltu]

Hi Ilya
Thanks for your response. I think you are right.
So, I tried to set "-Djava.net.preferIPv4Stack=true" and there isn't a huge
amount of TIME_WAIT connections, but still has one node dropped from the
cluster.

ignite log : 
ignite-a228fd5c.log
 
 

Regards,
Wilson





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

INSERT and MERGE statements

[vitalys]

I am running Ignite v.25 and I am trying to populate cache using SQL
statements via DBeaver.

I create a cache called TAXRATE with the following object structure : 

SCENARIO VARCHAR
VALUEDATE   VARCHAR
ENTITY VARCHAR
PRODUCTGROUP   VARCHAR
YEARINTEGER
AMOUNT   DOUBLE
KEY   VARCHAR

Here is an INSERT statement I run : 

*INSERT INTO TAXRATE.TAXRATE
VALUES ('SCENARIO','12-03-2019','5','9',2019,3.3,'mykey');*

and I am getting an error : 

/SQL Error [1] [5]: Failed to execute DML statement [stmt=INSERT INTO
TAXRATE.TAXRATE
VALUES ('SCENARIO','12-03-2019','5','9',2019,3.3,'mykey'), params=null]/

Here is an MERGE statement :

*MERGE INTO TAXRATE.TAXRATE (scenario,
VALUEDATE,ENTITY,PRODUCTGROUP,"YEAR",AMOUNT,"KEY")
--KEY (VALUATIONDATE)
VALUES ('SCENARIO','12-03-2019','5','9',2019,3.3,'mykey');*

and here is the same error I am getting : 

/SQL Error [1] [5]: Failed to execute DML statement [stmt=MERGE INTO
TAXRATE.TAXRATE (scenario,
VALUEDATE,ENTITY,PRODUCTGROUP,"YEAR",AMOUNT,"KEY")
--KEY (VALUATIONDATE)
VALUES ('SCENARIO','12-03-2019','5','9',2019,3.3,'mykey'), params=null]/


Is there any way to populate the cache using SQL  INSERT and/or MERGE?



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Set Expiry Policies When Creating Cache Using Java Thin Client

[Shane Duan]

I mean ClientCacheConfiguration

On Tue, Jul 2, 2019 at 10:48 AM Shane Duan  wrote:

> Hi Igniters,
>
> How can I set expiry policies if I have to create cache using Java Thin
> client. I did not see any API to do so in ClientConfiguration.
>
> Thanks,
> Shane
>

Set Expiry Policies When Creating Cache Using Java Thin Client

[Shane Duan]

Hi Igniters,

How can I set expiry policies if I have to create cache using Java Thin
client. I did not see any API to do so in ClientConfiguration.

Thanks,
Shane

Re: Thick client/thin client difference and how to get thin client port

[Shane Duan]

I am having similar problem: I am testing with a one-node-cluster. After
restart the Ignite cluster(server), Java thin client is not reconnecting.
There is no port change on server for my case since I defined client port
in the Ignite configuration:

org.apache.ignite.client.ClientConnectionException: Ignite cluster is
unavailable
at
org.apache.ignite.internal.client.thin.TcpClientChannel.read(TcpClientChannel.java:333)
at
org.apache.ignite.internal.client.thin.TcpClientChannel.receive(TcpClientChannel.java:154)
at
org.apache.ignite.internal.client.thin.ReliableChannel.service(ReliableChannel.java:126)
at
org.apache.ignite.internal.client.thin.TcpClientCache.get(TcpClientCache.java:82)
at
com.esri.arcgis.datastore.model.cachestore.BinaryTest.main(BinaryTest.java:69)

import org.apache.ignite.IgniteBinary;
import org.apache.ignite.Ignition;
import org.apache.ignite.binary.BinaryObject;
import org.apache.ignite.client.ClientCache;
import org.apache.ignite.client.IgniteClient;
import org.apache.ignite.configuration.ClientConfiguration;

public class BinaryTest {

  public static void main(String[] args) {

IgniteClient igniteClient = null;

try{

  // Prepare a Ignite thin client
  String hostName = args[0];
  Integer portNumber = Integer.parseInt(args[1]);
  String userName = args[2];
  String password = args[3];

  ClientConfiguration cfg = new
ClientConfiguration().setAddresses(hostName + ":" + portNumber);
  cfg.setUserName(userName);
  cfg.setUserPassword(password);

  igniteClient = Ignition.startClient(cfg);

  // Get IgniteBinary object using the ignite thin client.
  IgniteBinary binary = igniteClient.binary();

  // Build two test binary object.
  // Note: we are defining the attributes for the binary object on the fly.
  BinaryObject val1 = binary.builder("person")
  .setField("id", 1, int.class)
  .setField("name", "Tom J", String.class)
  .build();
  BinaryObject val2 = binary.builder("person")
  .setField("id", 2, int.class)
  .setField("name", "Jeffson L", String.class)
  .build();

  // Create a cache, keep it as binary.
  ClientCache cache =
igniteClient.getOrCreateCache("persons").withKeepBinary();

  // Store the testing objects.
  cache.put(1, val1);
  cache.put(2, val2);


  
  // Please restart Ignite server here.
  

  // Get the objects.
  BinaryObject cachedVal1 = cache.get(1);
  System.out.println("Person1");
  System.out.println("\tID   = " + cachedVal1.field("id"));
  System.out.println("\tName = " + cachedVal1.field("name"));

  BinaryObject cachedVal2 = cache.get(2);
  System.out.println("Person2");
  System.out.println("\tID   = " + cachedVal2.field("id"));
  System.out.println("\tName = " + cachedVal2.field("name"));

  // Destroy the cache.
  System.out.print("Dropped caches...");
  igniteClient.destroyCache("persons");

} catch (Exception e) {
  e.printStackTrace();
} finally {
  if (igniteClient != null) {
try {
  igniteClient.close();
} catch (Exception ignore) {
}
  }
}
  }

}


On Mon, Jul 1, 2019 at 5:38 AM Alex Plehanov 
wrote:

> Hello, Rick
>
> There should be a message in the server log:
> "Client connector processor has started on TCP port x" with "INFO"
> level.
>
> пн, 1 июл. 2019 г. в 10:26, rick_tem :
>
>> Thanks for your response.  I tried 10801 and it failed.  My question is
>> how
>> do I find out which port it is using?
>>
>> Thanks,
>> Rick
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: [WARNING][query-#491%ServerNode%][IgniteH2Indexing] Query execution is too long

[Ilya Kasnacheev]

Hello!

I can see that you are selecting whole table.

It is recommended to use LIMIT clause or use lazy=true (available as JDBC
connection parameter and as SqlFieldsQuery setter).

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 16:49, siva :

> Hi,
> I am using Apache Ignite v2.7.5 as thinclient and server in .net core and
> running in window vm.
>
> After getting long running query warning, server getting down.
>
> Server log:
> --
> ignite-15e6d7d4.log
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1379/ignite-15e6d7d4.log>
>
>
>
> Server config xml file
> --
> server-config.xml
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1379/server-config.xml>
>
>
> Client config xml file
> -
> client-config.xml
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1379/client-config.xml>
>
>
>
> Cache config:
> 
>
>
> I am using RAM-128GB, CPU-32.
>
> Anything else need let me know.
> Please,Any one give me suggestion,How to solve above warning,any
> configuration missing?.
>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

[WARNING][query-#491%ServerNode%][IgniteH2Indexing] Query execution is too long

[siva]

Hi,
I am using Apache Ignite v2.7.5 as thinclient and server in .net core and
running in window vm.

After getting long running query warning, server getting down.

Server log:
--
ignite-15e6d7d4.log
 
 


Server config xml file
--
server-config.xml
  

Client config xml file
-
client-config.xml
  


Cache config:



I am using RAM-128GB, CPU-32.

Anything else need let me know.
Please,Any one give me suggestion,How to solve above warning,any
configuration missing?.






--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Data taking more time to load using GetDataStreamer

[Ilya Kasnacheev]

Hello!

I have no idea why, but when I have added Console.WriteLine, it's the same
value over and over. I think that's in code outside of Apache Ignite.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 15:49, siva :

> Thanks for reply ilya.kasnacheev.
>
> No.
> I thing confussion between foreach loop iteration there I'm taking EmpId
> value from Employee Object and setting into new JObject,because of that
> it's
> every time new key.
>
> I am not taking same key could you little explain where same key
> getting
> inserted or  it's any formatting issue ?
>
> Please see below image,how is the key getting generated .
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1379/Screenshot_1.png>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Delete performance

[Ilya Kasnacheev]

Hello!

I think you can use ds.removeData(k) all right.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 15:37, Mike Needham :

> Is there an example of how to do that?  I cannot find any sample code that
> does a delete using the streamer other than the ds.remove().
>
> On Tue, Jul 2, 2019 at 4:22 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> You can have a custom StreamReceiver that will remove entries from cache.
>> It's a pity we don't ship it by default.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пн, 1 июл. 2019 г. в 23:32, Mike Needham :
>>
>>> Hi All,
>>>
>>> I have a cache that has approx 2 million records and is stored as a
>>> queryable object (SQL).  What is the fastest way to perform deletes on this
>>> cache?  I have been using a SqlFielsQuery to issue a SQL delete statement
>>> but that seems to be very slow?  I add/update using a dataStreamer, is
>>> there some equivalent for deletes?
>>>
>>> Thanks in advance
>>>
>>> --
>>> *Don't be afraid to be wrong. Don't be afraid to admit you don't have
>>> all the answers. Don't be afraid to say "I think" instead of "I know."*
>>>
>>
>
> --
> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
> the answers. Don't be afraid to say "I think" instead of "I know."*
>

Re: Data taking more time to load using GetDataStreamer

[siva]

Thanks for reply ilya.kasnacheev.

No.
I thing confussion between foreach loop iteration there I'm taking EmpId
value from Employee Object and setting into new JObject,because of that it's
every time new key.

I am not taking same key could you little explain where same key getting
inserted or  it's any formatting issue ?

Please see below image,how is the key getting generated .
 



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Delete performance

[Mike Needham]

Is there an example of how to do that?  I cannot find any sample code that
does a delete using the streamer other than the ds.remove().

On Tue, Jul 2, 2019 at 4:22 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> You can have a custom StreamReceiver that will remove entries from cache.
> It's a pity we don't ship it by default.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 1 июл. 2019 г. в 23:32, Mike Needham :
>
>> Hi All,
>>
>> I have a cache that has approx 2 million records and is stored as a
>> queryable object (SQL).  What is the fastest way to perform deletes on this
>> cache?  I have been using a SqlFielsQuery to issue a SQL delete statement
>> but that seems to be very slow?  I add/update using a dataStreamer, is
>> there some equivalent for deletes?
>>
>> Thanks in advance
>>
>> --
>> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
>> the answers. Don't be afraid to say "I think" instead of "I know."*
>>
>

-- 
*Don't be afraid to be wrong. Don't be afraid to admit you don't have all
the answers. Don't be afraid to say "I think" instead of "I know."*

Re: Why datastructure are not dataRegion bounded

[nikhil dhiman]

I am replying via mail, not working via site

On Tue, Jul 2, 2019, 3:45 PM Ilya Kasnacheev 
wrote:

> Hello!
>
> Well, I can see your message, meaning you probably are.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> вт, 2 июл. 2019 г. в 08:15, nikhil dhiman :
>
>> HI All, I am not been able to post or reply
>>
>> On Tue, Jun 25, 2019 at 7:47 PM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> I did not try, but you can supply groupName in CollectionConfiguration,
>>> and pre-start a cache in this groupName in required region so that all
>>> caches belonging to that group will be stored there.
>>>
>>> Can you check?
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> вт, 25 июн. 2019 г. в 09:17, dhiman_nikhil :
>>>
 While going through the below code, i found this issue.
 Ignite ignite = Ignition.ignite();

 // Non-colocated queue which will be distributed
 // across all data nodes.
 IgniteQueue queue = ignite.queue("queueName", 20, new
 CollectionConfiguration());

 // Add queue elements.
 for (int i = 0; i < 20; i++)
 queue.add("Value " + Integer.toString(i));

 // Poll queue elements.
 for (int i = 0; i < 20; i++)
 System.out.println("Polled value: " + queue.poll());

 How to make sure above code is bounded to specific data Region with
 persistence on for few data structure and off for few??



 --
 Sent from: http://apache-ignite-users.70518.x6.nabble.com/

>>>

Re: Why datastructure are not dataRegion bounded

[Ilya Kasnacheev]

Hello!

Nabble is a purely auxiliary addition to mailing list, you can skip it
altogether.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 14:28, nikhil dhiman :

> I am replying via mail, not working via site
>
> On Tue, Jul 2, 2019, 3:45 PM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> Well, I can see your message, meaning you probably are.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> вт, 2 июл. 2019 г. в 08:15, nikhil dhiman :
>>
>>> HI All, I am not been able to post or reply
>>>
>>> On Tue, Jun 25, 2019 at 7:47 PM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 I did not try, but you can supply groupName in CollectionConfiguration,
 and pre-start a cache in this groupName in required region so that all
 caches belonging to that group will be stored there.

 Can you check?

 Regards,
 --
 Ilya Kasnacheev


 вт, 25 июн. 2019 г. в 09:17, dhiman_nikhil :

> While going through the below code, i found this issue.
> Ignite ignite = Ignition.ignite();
>
> // Non-colocated queue which will be distributed
> // across all data nodes.
> IgniteQueue queue = ignite.queue("queueName", 20, new
> CollectionConfiguration());
>
> // Add queue elements.
> for (int i = 0; i < 20; i++)
> queue.add("Value " + Integer.toString(i));
>
> // Poll queue elements.
> for (int i = 0; i < 20; i++)
> System.out.println("Polled value: " + queue.poll());
>
> How to make sure above code is bounded to specific data Region with
> persistence on for few data structure and off for few??
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Trying to get MariaDB data loaded into Ignite through a web console created config

[Ilya Kasnacheev]

Hello again!

Forgot to say, it takes cache name as 1st arg.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 13:38, Ilya Kasnacheev :

> Hello!
>
> Unfortunately we don't seem to have any support to do this from any
> tooling.
>
> You will have to execute something like this in your Docker container:
>
> import org.apache.ignite.Ignite;
> import org.apache.ignite.Ignition;
>
> public class Preloader {
> public static void main(String[] args) {
> Ignition.setClientMode(true);
> try (Ignite ignite = Ignition.start("/path/to/ignite.xml")) {
> ignite.cache(args[0]).loadCache(null);
> }
> }
> }
>
> you should compile it against ignite libs and execute on your docker.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 19 июн. 2019 г. в 08:20, Steven Castano :
>
>> It’s not failing I guess... I thought it was supposed to auto populate
>> when the cluster started up. Then I was just trying to run the class file
>> through java, but that wasn’t working. I was hoping there was some sort of
>> command line option to put the data in there.
>>
>> I’m trying to research how to quickly write a java app that will load
>> them, but I can’t seem to find any instructions or examples.
>>
>> Sent from my iPhone
>>
>> On Jun 19, 2019, at 1:05 AM, Denis Magda  wrote:
>>
>> Cache loading can be triggered from the application side only at the
>> moment. It's unsupported for Python yet.
>>
>> The easiest way here is to make LoadCaches.java workable in your Docker
>> environment. Share an exception generated by the class. You said it failing
>> there.
>>
>> -
>> Denis
>>
>>
>> On Tue, Jun 18, 2019 at 9:56 PM Steven Castano 
>> wrote:
>>
>>> Create a sample app how? In java or something? Is there no way to get
>>> the instance to load the caches when it starts?
>>>
>>> I’m not a big java coder at all, I do most of my stuff in Python… is
>>> there a simple way in python to connect to the cluster and issue the load
>>> caches command? Or maybe an already made Java app that someone has out
>>> there that I could use as an example?
>>>
>>> *SMC
>>>
>>> Steven Castano | stevenmcast...@yahoo.com
>>> Secure PGP Key: www.stevenmcastano.com/pgpkey
>>>
>>>
>>>
>>> On Jun 19, 2019, at 12:43 AM, Denis Magda  wrote:
>>>
>>> Steven,
>>>
>>> Create a sample app based on LoadCaches and deploy it in Docker. It
>>> should work out.
>>>
>>> --
>>> Denis Magda
>>>
>>>
>>> On Fri, Jun 14, 2019 at 5:17 PM Steven Castano 
>>> wrote:
>>>
 Thanks… that got me much farther… I was able to generate a config, get
 the docker image built with the Dockerfile and deploy a running container
 which now connects back to the web console. It shows all of my caches
 created for each of the tables I wanted to import, but I can’t seem to
 figure out how to load the data. the LoadCaches.java file doesn’t want to
 run inside the docker container. So I appear to have all my caches, but
 they’re all empty. The screencast only shows how to run it in an IDE, not
 on the command line once it’s built.

 *SMC

 Steven Castano | stevenmcast...@yahoo.com
 Secure PGP Key: www.stevenmcastano.com/pgpkey



 On Jun 14, 2019, at 6:38 PM, Denis Magda  wrote:

 Hi Steven,

 Please check out a series of screencast "Ignite Web Console - Automatic
 RDBMS Integration" that shows how to use to complete this process:
 https://ignite.apache.org/screencasts.html

 It might be the case that with docker you need to pass the settings
 differently. Please, check docker configuration settings:
 https://apacheignite.readme.io/docs/docker-deployment

 -
 Denis


 On Thu, Jun 13, 2019 at 1:44 PM Steven Castano <
 stevenmcast...@yahoo.com> wrote:

> So I was able to get a 2 node cluster started, v2.7.5 and got the
> web-console running through a docker container. I’m even able to load the
> MariaDB JDBC driver and connect to my database.
>
> The problem I’m having is that when I’m done configuring things and I
> save and download the .zip file for the cluster configuration… I don’t 
> know
> where to put it. No matter where I store it on my server I keep getting a
> “file not found” type error when looking for the properties file.
>
> Even when creating a cluster with all the defaults not even connected
> to another database with no persistence, I still can’t get the downloaded
> project files working. Is there something I’m missing, or maybe a good
> tutorial online I can follow??
>
> *SMC
>
> Steven Castano | stevenmcast...@yahoo.com
> Secure PGP Key: www.stevenmcastano.com/pgpkey
>
>
>
>

>>>

Re: Trying to get MariaDB data loaded into Ignite through a web console created config

[Ilya Kasnacheev]

Hello!

Unfortunately we don't seem to have any support to do this from any tooling.

You will have to execute something like this in your Docker container:

import org.apache.ignite.Ignite;
import org.apache.ignite.Ignition;

public class Preloader {
public static void main(String[] args) {
Ignition.setClientMode(true);
try (Ignite ignite = Ignition.start("/path/to/ignite.xml")) {
ignite.cache(args[0]).loadCache(null);
}
}
}

you should compile it against ignite libs and execute on your docker.

Regards,
-- 
Ilya Kasnacheev


ср, 19 июн. 2019 г. в 08:20, Steven Castano :

> It’s not failing I guess... I thought it was supposed to auto populate
> when the cluster started up. Then I was just trying to run the class file
> through java, but that wasn’t working. I was hoping there was some sort of
> command line option to put the data in there.
>
> I’m trying to research how to quickly write a java app that will load
> them, but I can’t seem to find any instructions or examples.
>
> Sent from my iPhone
>
> On Jun 19, 2019, at 1:05 AM, Denis Magda  wrote:
>
> Cache loading can be triggered from the application side only at the
> moment. It's unsupported for Python yet.
>
> The easiest way here is to make LoadCaches.java workable in your Docker
> environment. Share an exception generated by the class. You said it failing
> there.
>
> -
> Denis
>
>
> On Tue, Jun 18, 2019 at 9:56 PM Steven Castano 
> wrote:
>
>> Create a sample app how? In java or something? Is there no way to get the
>> instance to load the caches when it starts?
>>
>> I’m not a big java coder at all, I do most of my stuff in Python… is
>> there a simple way in python to connect to the cluster and issue the load
>> caches command? Or maybe an already made Java app that someone has out
>> there that I could use as an example?
>>
>> *SMC
>>
>> Steven Castano | stevenmcast...@yahoo.com
>> Secure PGP Key: www.stevenmcastano.com/pgpkey
>>
>>
>>
>> On Jun 19, 2019, at 12:43 AM, Denis Magda  wrote:
>>
>> Steven,
>>
>> Create a sample app based on LoadCaches and deploy it in Docker. It
>> should work out.
>>
>> --
>> Denis Magda
>>
>>
>> On Fri, Jun 14, 2019 at 5:17 PM Steven Castano 
>> wrote:
>>
>>> Thanks… that got me much farther… I was able to generate a config, get
>>> the docker image built with the Dockerfile and deploy a running container
>>> which now connects back to the web console. It shows all of my caches
>>> created for each of the tables I wanted to import, but I can’t seem to
>>> figure out how to load the data. the LoadCaches.java file doesn’t want to
>>> run inside the docker container. So I appear to have all my caches, but
>>> they’re all empty. The screencast only shows how to run it in an IDE, not
>>> on the command line once it’s built.
>>>
>>> *SMC
>>>
>>> Steven Castano | stevenmcast...@yahoo.com
>>> Secure PGP Key: www.stevenmcastano.com/pgpkey
>>>
>>>
>>>
>>> On Jun 14, 2019, at 6:38 PM, Denis Magda  wrote:
>>>
>>> Hi Steven,
>>>
>>> Please check out a series of screencast "Ignite Web Console - Automatic
>>> RDBMS Integration" that shows how to use to complete this process:
>>> https://ignite.apache.org/screencasts.html
>>>
>>> It might be the case that with docker you need to pass the settings
>>> differently. Please, check docker configuration settings:
>>> https://apacheignite.readme.io/docs/docker-deployment
>>>
>>> -
>>> Denis
>>>
>>>
>>> On Thu, Jun 13, 2019 at 1:44 PM Steven Castano 
>>> wrote:
>>>
 So I was able to get a 2 node cluster started, v2.7.5 and got the
 web-console running through a docker container. I’m even able to load the
 MariaDB JDBC driver and connect to my database.

 The problem I’m having is that when I’m done configuring things and I
 save and download the .zip file for the cluster configuration… I don’t know
 where to put it. No matter where I store it on my server I keep getting a
 “file not found” type error when looking for the properties file.

 Even when creating a cluster with all the defaults not even connected
 to another database with no persistence, I still can’t get the downloaded
 project files working. Is there something I’m missing, or maybe a good
 tutorial online I can follow??

 *SMC

 Steven Castano | stevenmcast...@yahoo.com
 Secure PGP Key: www.stevenmcastano.com/pgpkey




>>>
>>

Re: Why datastructure are not dataRegion bounded

[Ilya Kasnacheev]

Hello!

Well, I can see your message, meaning you probably are.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 08:15, nikhil dhiman :

> HI All, I am not been able to post or reply
>
> On Tue, Jun 25, 2019 at 7:47 PM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> I did not try, but you can supply groupName in CollectionConfiguration,
>> and pre-start a cache in this groupName in required region so that all
>> caches belonging to that group will be stored there.
>>
>> Can you check?
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> вт, 25 июн. 2019 г. в 09:17, dhiman_nikhil :
>>
>>> While going through the below code, i found this issue.
>>> Ignite ignite = Ignition.ignite();
>>>
>>> // Non-colocated queue which will be distributed
>>> // across all data nodes.
>>> IgniteQueue queue = ignite.queue("queueName", 20, new
>>> CollectionConfiguration());
>>>
>>> // Add queue elements.
>>> for (int i = 0; i < 20; i++)
>>> queue.add("Value " + Integer.toString(i));
>>>
>>> // Poll queue elements.
>>> for (int i = 0; i < 20; i++)
>>> System.out.println("Polled value: " + queue.poll());
>>>
>>> How to make sure above code is bounded to specific data Region with
>>> persistence on for few data structure and off for few??
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>
>>

Re: OR condition in where clause

[Ilya Kasnacheev]

Hello!

You can use EXPLAIN to see whether index was used or not. I suggest you to
check your specific queries.

Regards,
-- 
Ilya Kasnacheev


вт, 2 июл. 2019 г. в 10:17, Prasad Bhalerao :

> As per this doc
> ,
> if the query contains OR operator indexes may not be used as expected. As a
> work around the query can be rewritten using UNION ALL condition.
>
> But if I use "USE INDEX" hint to force query optimizer to use given index,
> will it solve the problem with OR operator?
>
> Is it guaranteed that query optimizer will always use the index provided
> in "USE INDEX" hint?
>
> Thanks,
> Prasad
>

Re: Delete performance

[Ilya Kasnacheev]

Hello!

You can have a custom StreamReceiver that will remove entries from cache.
It's a pity we don't ship it by default.

Regards,
-- 
Ilya Kasnacheev


пн, 1 июл. 2019 г. в 23:32, Mike Needham :

> Hi All,
>
> I have a cache that has approx 2 million records and is stored as a
> queryable object (SQL).  What is the fastest way to perform deletes on this
> cache?  I have been using a SqlFielsQuery to issue a SQL delete statement
> but that seems to be very slow?  I add/update using a dataStreamer, is
> there some equivalent for deletes?
>
> Thanks in advance
>
> --
> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
> the answers. Don't be afraid to say "I think" instead of "I know."*
>

Re: Random CorruptedTreeException from Apache Ignite

[Maxim Pudov]

Here is the ticket: https://issues.apache.org/jira/browse/IGNITE-11953

вт, 2 июл. 2019 г. в 11:17, Maxim Pudov :

> There is a known issue with cache groups which lead to
> CorruptedTreeException. Try to remove
> cacheCfg.setGroupName(groupName);
> from your configuration. I'll check whether JIRA ticket was created or not
> for this problem.
>
> ср, 26 июн. 2019 г. в 04:17, SamsonLai :
>
>> Yes they are created using JAVA API. The JAVA version is 1.8 and please
>> find
>> below the code we used to create and get the caches. Thanks.
>>
>> private IgniteCache getIgniteCache(String cacheName, String
>> groupName){
>> CacheConfiguration cacheCfg = new CacheConfiguration();
>> cacheCfg.setName(cacheName);
>> cacheCfg.setBackups(0);
>> cacheCfg.setCacheMode(CacheMode.REPLICATED);
>>
>> cacheCfg.setGroupName(groupName);
>> cacheCfg.setAtomicityMode(CacheAtomicityMode.TRANSACTIONAL);
>>
>> return this.ignite.getOrCreateCache(cacheCfg);
>> }
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: Random CorruptedTreeException from Apache Ignite

[Maxim Pudov]

There is a known issue with cache groups which lead to
CorruptedTreeException. Try to remove
cacheCfg.setGroupName(groupName);
from your configuration. I'll check whether JIRA ticket was created or not
for this problem.

ср, 26 июн. 2019 г. в 04:17, SamsonLai :

> Yes they are created using JAVA API. The JAVA version is 1.8 and please
> find
> below the code we used to create and get the caches. Thanks.
>
> private IgniteCache getIgniteCache(String cacheName, String
> groupName){
> CacheConfiguration cacheCfg = new CacheConfiguration();
> cacheCfg.setName(cacheName);
> cacheCfg.setBackups(0);
> cacheCfg.setCacheMode(CacheMode.REPLICATED);
>
> cacheCfg.setGroupName(groupName);
> cacheCfg.setAtomicityMode(CacheAtomicityMode.TRANSACTIONAL);
>
> return this.ignite.getOrCreateCache(cacheCfg);
> }
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

OR condition in where clause

[Prasad Bhalerao]

As per this doc
,
if the query contains OR operator indexes may not be used as expected. As a
work around the query can be rewritten using UNION ALL condition.

But if I use "USE INDEX" hint to force query optimizer to use given index,
will it solve the problem with OR operator?

Is it guaranteed that query optimizer will always use the index provided in
"USE INDEX" hint?

Thanks,
Prasad