Re: Add ignite jars using maven

[Vinokurov Pavel]

I think the right way is to add dependencies into the pom file.

2018-02-12 10:37 GMT+03:00 Rajarshi Pain :

> Hi,
>
>
> Previously i was manually adding all the jars to my build path, now i am
> using maven to do this. Is there any way to add all ignite jars with it's
> dependency in to the project?
> Or i have to add one by into the pom file?
>
>
> --
>
> Thanks
> Rajarshi
>



-- 

Regards

Pavel Vinokurov

RE: Timeout while running checkpoint

[Josephine Barboza]

No I haven’t overridden checkpointFreq value.

From: Vinokurov Pavel [mailto:vinokurov.pa...@gmail.com]
Sent: Monday, February 12, 2018 1:03 PM
To: user@ignite.apache.org
Subject: Re: Timeout while running checkpoint

Hi,

The timeout could be caused by value 
PersistentStoreConfiguration#checkpointFreq parameter.
Have you overrided checkpointFreq config parameter?

2018-02-12 10:05 GMT+03:00 Josephine Barboza 
>:
Hi,
I’m constantly seeing a lot of information logs after setting up a cluster in 
ignite of two nodes

Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, 
checkpointLockHoldTime=1ms, reason='timeout']

Why could the process be timing out? I am using persistent store configuration 
with v2.1.

Thanks,
Josephine
IMPORTANT NOTICE: This email and any files transmitted with it are confidential 
and intended solely for the use of the individual or entity to whom they are 
addressed. If you have received this email in error, please notify the system 
manager and/or the sender immediately.



--

Regards

Pavel Vinokurov

Add ignite jars using maven

[Rajarshi Pain]

Hi,


Previously i was manually adding all the jars to my build path, now i am
using maven to do this. Is there any way to add all ignite jars with it's
dependency in to the project?
Or i have to add one by into the pom file?


-- 

Thanks
Rajarshi

Re: Timeout while running checkpoint

[Vinokurov Pavel]

Hi,

The timeout could be caused by value
PersistentStoreConfiguration#checkpointFreq
parameter.
Have you overrided *checkpointFreq* config parameter?

2018-02-12 10:05 GMT+03:00 Josephine Barboza :

> Hi,
>
> I’m constantly seeing a lot of information logs after setting up a cluster
> in ignite of two nodes
>
>
>
> Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms,
> checkpointLockHoldTime=1ms, reason='timeout']
>
>
>
> Why could the process be timing out? I am using persistent store
> configuration with v2.1.
>
>
>
> Thanks,
>
> Josephine
> IMPORTANT NOTICE: This email and any files transmitted with it are
> confidential and intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this email in error, please
> notify the system manager and/or the sender immediately.
>



-- 

Regards

Pavel Vinokurov

Timeout while running checkpoint

[Josephine Barboza]

Hi,
I'm constantly seeing a lot of information logs after setting up a cluster in 
ignite of two nodes

Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, 
checkpointLockHoldTime=1ms, reason='timeout']

Why could the process be timing out? I am using persistent store configuration 
with v2.1.

Thanks,
Josephine
IMPORTANT NOTICE: This email and any files transmitted with it are confidential 
and intended solely for the use of the individual or entity to whom they are 
addressed. If you have received this email in error, please notify the system 
manager and/or the sender immediately.

Re: Ignite with Spring Cache on K8S, eviction problem

[Vinokurov Pavel]

Spring creates a composite key that might be not suitable for the
distributed Ignite cache.
You could use the custom composite key using concatenation #user+ " - "+#id.


2018-02-09 17:50 GMT+03:00 lukaszbyjos :

> Hi. I have k8s cluster with one ignite server and few services as clients.
> I have problem with evicting values using spring annotations.
> Apps have cache "example-user" and when one service evict by key another
> one
> still have values.
>
> There you can find cache config and example repo for spring
> https://gist.github.com/Mistic92/8649515ff026e24ca0870ed61739a17c
>
> What should I change or do because currently I don't have any idea :(
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 

Regards

Pavel Vinokurov

Re: slow query performance against berkley db

[Rajesh Kishore]

Dear all

Request you to kindly suggest me if my approach is wrong ? The idea of
replacing berkley db with Ignite would not work out if the query is slow ,
whats the best model to be used with Ignite for my usecase.

Thanks,
Rajesh

On Fri, Feb 9, 2018 at 9:38 AM, Rajesh Kishore 
wrote:

> Igniters any pointers pls.
>
> Regards,
> Rajesh
>
> On Wed, Feb 7, 2018 at 9:15 AM, Rajesh Kishore 
> wrote:
>
>> Hi Dmitry,
>>
>> Thanks a ton.
>>
>> What is not convincing to me is with just *.1 M  in main table and* *2 M
>> records in other table * , sql query is taking around 24 sec, that is
>> worrisome.
>> In local cache mode , I tried both using partitioned and non partitioned
>> mode , the result is same.
>> All I wanted to know , is my approach is wrong  somewhere? I am sure
>> igniters would correct me with my approach used.
>>
>> Regards,
>> -Rajesh
>>
>> On Wed, Feb 7, 2018 at 8:23 AM, Dmitriy Setrakyan 
>> wrote:
>>
>>> Hi Rajesh,
>>>
>>> Please allow the community some time to test your code.
>>>
>>> As far as testing single node vs. distributed, when you have more than
>>> one node, Ignite will split your data set evenly across multiple nodes.
>>> This means that when running the query, it will be executed on each node on
>>> smaller data sets in parallel, which should provide better performance. If
>>> your query does some level of scanning, then the more nodes you add, the
>>> faster it will get.
>>>
>>> D.
>>>
>>> On Tue, Feb 6, 2018 at 5:02 PM, Rajesh Kishore 
>>> wrote:
>>>
 Hi All
 Please help me in getting the pointers, this is deciding factor for us
 to further evaluate ignite. Somehow we are not convinced with just  . 1 m
 records it's not responsive as that of Berkley db.
 Let me know the strategy to be adopted, pointers where I am doing
 wrong.

 Thanks
 Rajesh

 On 6 Feb 2018 6:11 p.m., "Rajesh Kishore" 
 wrote:

> Further to this,
>
> I am re-framing what I have , pls correct me if my approach is correct
> or not.
>
> As of now, using only node as local cache and using native persistence
> file system. The system has less number of records around *.1 M *in
> main table and 2 M in supporting table.
>
> Using sql to retrieve the records using join , the sql used is
> 
> ---
>  final String query1 = "SELECT "
> + "f.entryID,f.attrName,f.attrValue, "
> + "f.attrsType "
> + "FROM "
> +"( select st.entryID,st.attrName,st.attrValue,
> st.attrsType from "
> +"(SELECT at1.entryID FROM \"objectclass\".Ignite_ObjectC
> lass"
> + " at1 WHERE "
> + " at1.attrValue= ? )  t"
> +" INNER JOIN 
> \"Ignite_DSAttributeStore\".IGNITE_DSATTRIBUTESTORE
> st ON st.entryID = t.entryID "
> + " WHERE st.attrKind IN ('u','o') "
> +" ) f "
> + " INNER JOIN "
> + " ( "
> +" SELECT entryID from \"dn\".Ignite_DN where parentDN
> like ? "
>  +")  "
> +" dnt"
> + " ON f.entryID = dnt.entryID"
> + " order by f.entryID";
>
> String queryWithType = query1;
> QueryCursor cursor = cache.query(new SqlFieldsQuery(
> queryWithType).setEnforceJoinOrder(true).setArgs("person",
> "dc=ignite,%"));
> System.out.println("SUBTREE "+cursor.getAll() );
>
>
> 
> ---
>
> The corresponding EXPLAIN plan is
> 
>
> [[SELECT
> F.ENTRYID,
> F.ATTRNAME,
> F.ATTRVALUE,
> F.ATTRSTYPE
> FROM (
> SELECT
> ST.ENTRYID,
> ST.ATTRNAME,
> ST.ATTRVALUE,
> ST.ATTRSTYPE
> FROM (
> SELECT
> AT1.ENTRYID
> FROM "objectclass".IGNITE_OBJECTCLASS AT1
> WHERE AT1.ATTRVALUE = ?1
> ) T
> INNER JOIN "Ignite_DSAttributeStore".IGNITE_DSATTRIBUTESTORE ST
> ON 1=1
> WHERE (ST.ATTRKIND IN('u', 'o'))
> AND (ST.ENTRYID = T.ENTRYID)
> ) F
> /* SELECT
> ST.ENTRYID,
> ST.ATTRNAME,
> ST.ATTRVALUE,
> ST.ATTRSTYPE
> FROM (
> SELECT
> AT1.ENTRYID
> FROM "objectclass".IGNITE_OBJECTCLASS AT1
> WHERE AT1.ATTRVALUE = ?1
> ) T
> /++ SELECT
> AT1.ENTRYID
> FROM "objectclass".IGNITE_OBJECTCLASS AT1
> /++ 

Question on ports exposed in kubernetes setup

[Vishwas Bm]

Hi,

I have setup ignite on kubernetes using this link
.
The setup is ready, I wanted to try few curl commands as mentioned in this
link .

As per the ignite kubernetes setup guide, the rest port is
But when I try it, it gives empty reply.
As per my understanding 8080 is the port for curl commands by default. So I
exposed 8080 port and then tried the curl command and it worked.

As per the setup guide, following ports are exposed:

- containerPort: 11211 # REST port number.-
containerPort: 47100 # communication SPI port number.-
containerPort: 47500 # discovery SPI port number.-
containerPort: 49112 # JMX port number.- containerPort: 10800
# SQL port number.


So I wanted to know, what is the port  11211 used for and what is the
actual rest port.


*Thanks & Regards,*

*Vishwas *