Re: Please test it and include in the next version if is possible: Modifications in rest-http module (Added JSF,jndi for jdbc/ignite and tunning for threads of jetty embedded)

[Alexey Kuznetsov]

Hi, mastercracker3d!

The right way to change code is the following:
1. Create account in Apache Ignite JIRA
https://issues.apache.org/jira/projects/IGNITE
2. Create issue in JIRA.
3. Prepare pull request.
4. Send e-mail on dev-list (see:
https://ignite.apache.org/community/resources.html#mail-lists)
5. After successful review you PR may be merged to master.

Hope this helps!

On Sun, Dec 29, 2019 at 12:38 AM mastercracker3d 
wrote:

> Hi community, I modified the Java Classes: GridJettyRestHandler and
> GridJettyRestProtocol It's including support for JSF WebPages, auto load
> JNDI for JDBC/Ignite, Tunning for Thread of Jetty Embedded. Please remove
> old libraries of Jetty. The list of depencies are the next:
> commons-dbcp2-2.7.0.jar commons-lang-2.6.jar commons-pool2-2.8.0.jar
> el-ri-1.0.jar *ignite-rest-http-2.7.6.jar must be Modified with the
> classes GridJettyRestHandler and GridJettyRestProtocol)*
> ignite-web-2.7.6.jar jackson-annotations-2.9.6.jar jackson-core-2.9.6.jar
> jackson-databind-2.9.6.jar javax.el-api-3.0.1-b06.jar
> javax.servlet-api-4.0.1.jar jboss-jsf-api_2.2_spec-2.2.14.jar
> jetty-continuation-9.4.22.v20191022.jar jetty-http-9.4.22.v20191022.jar
> jetty-io-9.4.22.v20191022.jar jetty-jndi-9.4.22.v20191022.jar
> jetty-plus-9.4.22.v20191022.jar jetty-security-9.4.22.v20191022.jar
> jetty-server-9.4.22.v20191022.jar jetty-servlet-9.4.22.v20191022.jar
> jetty-util-9.4.22.v20191022.jar jetty-webapp-9.4.22.v20191022.jar
> jetty-xml-9.4.22.v20191022.jar jsf-api-2.2.19.jar jsf-impl-2.2.19.jar
> jsp-api-2.2.1-b03.jar log4j-1.2.17.jar slf4j-api-1.7.7.jar
> slf4j-log4j12-1.7.7.jar tomcat-servlet-api-9.0.10.jar Inside of the web.xml
> in the webpage is need add the next lines: Ignite DataSource Reference
> jdbc/ignite javax.sql.DataSource Container
> com.sun.faces.config.ConfigureListener Call to Datasource from java:
> (DataSource) initContext.lookup("java:comp/env/jdbc/ignite");
> GridJettyRestHandler.java
> <http://apache-ignite-users.70518.x6.nabble.com/file/t1813/GridJettyRestHandler.java>
> GridJettyRestProtocol.java
> <http://apache-ignite-users.70518.x6.nabble.com/file/t1813/GridJettyRestProtocol.java>
> --
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>


-- 
Alexey Kuznetsov

Re: GridGain Web Console is available free of charge for Apache Ignite

[Alexey Kuznetsov]

Hi,  Prasad

Thanks for reporting this issue.
Could you describe how I can reproduce these issues locally?
What tooling I could use?

We need this to check that issues were fixed before next release.

Thanks!

On Tue, Dec 10, 2019 at 3:10 PM Prasad Bhalerao <
prasadbhalerao1...@gmail.com> wrote:

> Hi,
>
> We found 3 vulnerabilities while scanning Grid Gain Web console
> application.
>
> We are using HTTP and not HTTPS due to some issues on our side. Although
> vulnerabilities are of lower severity, but thought of reporting it here.
>
> 1) HTTP TRACE / TRACK Methods Enabled. (CVE-2004-2320
> <https://nvd.nist.gov/vuln/detail/CVE-2004-2320>, CVE-2010-0386
> <https://nvd.nist.gov/vuln/detail/CVE-2010-0386>, CVE-2003-1567
> <https://nvd.nist.gov/vuln/detail/CVE-2003-1567>)
> 2) Session Cookie Does Not Contain the "Secure" Attribute.
> 3) Web Server HTTP Trace/Track Method Support Cross-Site Tracing
> Vulnerability. (CVE-2004-2320
> <https://nvd.nist.gov/vuln/detail/CVE-2004-2320>, CVE-2007-3008
> <https://nvd.nist.gov/vuln/detail/CVE-2007-3008>)
>
> Can these be fixed?
>
> Thanks,
> Prasad
>
>
> On Tue, Dec 10, 2019 at 4:39 PM Denis Magda  wrote:
>
>> It's free software without limitations. Just download and use it.
>>
>> -
>> Denis
>>
>>
>> On Tue, Dec 10, 2019 at 1:21 PM Prasad Bhalerao <
>> prasadbhalerao1...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Can apache ignite users use it for free in their production environments?
>>> What license does it fall under?
>>>
>>> Thanks,
>>> Prasad
>>>
>>> On Fri, Oct 4, 2019 at 5:33 AM Denis Magda  wrote:
>>>
>>>> Igniters,
>>>>
>>>> There is good news. GridGain made its distribution of Web Console
>>>> completely free. It goes with advanced monitoring and management
>>>> dashboard
>>>> and other handy screens. More details are here:
>>>>
>>>> https://www.gridgain.com/resources/blog/gridgain-road-simplicity-new-docs-and-free-tools-apache-ignite
>>>>
>>>> -
>>>> Denis
>>>>
>>>

-- 
Alexey Kuznetsov

Re: Query Monitoring

[Alexey Kuznetsov]

Hi,

There will be SQL Views instead.

See:
 https://issues.apache.org/jira/browse/IGNITE-10347
 https://issues.apache.org/jira/browse/IGNITE-11435

-- 
Alexey Kuznetsov

Re: SQL XML configuration for timestamp problematic when using sybase as third party persistence

[Alexey Kuznetsov]

Hi,

You may try to implement your Sybase  JdbcTypesTransformer.
That will correctly extract Sybase datetime and convert it to Timestamp.

You can take JdbcTypesDefaultTransformer, extend it.
And configure cache store with your transformer (see
o.a.i.cache.store.jdbc.CacheJdbcPojoStoreFactory#setTransformer)

-- 
Alexey Kuznetsov

Re: Ignite Web Console partition monitoring - ratio for Keys in offheap is NEGATIVE number

[Alexey Kuznetsov]

Hi, James Wang!

This is a deviation from "ideal" mean value.
So it means that this node contains less keys than "ideal" mean value for
4.7%

"Ideal" means all data distributed over cluster in uniform fashion.
In "ideal" situation this metric should be zero.

This metric is useful to detect situation when you data distribution over
cluster became non uniform.


On Thu, Feb 21, 2019 at 3:22 PM James Wang 王升平 (edvance CN) <
james.w...@edvancesecurity.com> wrote:

> Hi Support,
>
>
>
> I am curious about partition monitoring page in web console (
> console.gridgain.com)
>
> But I find that ratio for *Keys in offheap* is NEGATIVE number ? What
> does it mean ?
>
>
>
> Thank you.
>
>
>
>
>
> James Wang / *ed**vance*
>
> Mobile/WeChat:
>
> +86 135 1215 1134
>
> Email:
>
> james.w...@edvancesecurity.com
>
> Hotline:
>
> +86 400 099 2608
>
> Support:
>
> chinasupp...@edvancesecurity.com
>
> *One Step **Ʌ**head*
>
>
>
> This message contains information that is deemed confidential and
> privileged. Unless you are the addressee (or authorized to receive for the
> addressee), you may not use, copy or disclose to anyone the message or any
> information contained in the message. If you have received the message in
> error, please advise the sender by reply e-mail and delete the message.
>


-- 
Alexey Kuznetsov

Re: Authorization Plugin

[Alexey Kuznetsov]

Hi, Sergio!

May be this article will be useful for you:
http://smartkey.co.uk/development/securing-an-apache-ignite-cluster

-- 
Alexey Kuznetsov

Re: local deployment of web-console-standalone

[Alexey Kuznetsov]

Hi, Alan.

1. About "backend/agent_dists/ignite-web-agent-2.7.0.zip" - it is a kind of
"template".
When user clicks "Download agent"  link in web console, web server take
"ignite-web-agent-2.7.0.zip"
add "default.properties" with user token and send to user. So, in general
you can make "default.properties" manually.
User  token can be found at "Profile" screen.

2. About why Web Console not working - so far I have no ideas :(
I can suggest only one thing - download sources and try to launch from
sources in dev mode and see how it goes.
May be in dev mode you will see some additional debug output.

3. Web Agent also could be started from sources (if needed).

-- 
Alexey Kuznetsov

Re: Implementing custom plugin

[Alexey Kuznetsov]

Hi!

As far as I know, you need create a file
"src/main/resources/META-INF/services/org.apache.ignite.plugin.PluginProvider"
with full class name of your plugin.

Hope this helps.

-- 
Alexey Kuznetsov

Re: Web Console set up

[Alexey Kuznetsov]

Hi,

Both way will work.

1) Each user can download Web Agent and connect to cluster via Web Console.

2) Admin download Web Agent and put several users tokens to
default.properties file as comma separated string and start Web Agent, now
users that listed in that property can connect to cluster via We Console.
In case of new user, admin should add/remove token to default.properties
file and restart Web Agent. You can find user token at "Profile" screen.

Hope this helps.

-- 
Alexey Kuznetsov

Re: Web Console set up

[Alexey Kuznetsov]

Hi,

You should NOT download  Web agent docker image.
You should download Web agent from started Web Console (a link in a footer).
I created issue to support your use case: IGNITE-10889
<https://issues.apache.org/jira/browse/IGNITE-10889> Web Console should
work with Web Agent started from Docker image.

-- 
Alexey Kuznetsov

Re: Ignite we-console security

[Alexey Kuznetsov]

Hi, Sheshananda!

I merged IGNITE-9845 to master. And it will be available in Ignite 2.8.
This will allow to configure SSL for Web Console in "DEV" mode and in
"Direct install" mode.

Please, note that IGNITE-10668 is under development for now.
When finished, it will enable SSL configuration in "Docker" mode.

-- 
Alexey Kuznetsov

Re: Ignite we-console security

[Alexey Kuznetsov]

Hi, Sheshananda!

So, you are running Web Console in Dev mode?
"npm start" in console? or You are building Docker images?

Any way it seems that you need to wait IGNITE-9845 and IGNITE-10668
Both of mentioned ticked will be merged to master in a couple of days.

Or you can manually configure Nginx to handle SSL.

On Fri, Dec 21, 2018 at 9:53 AM Shesha Nanda 
wrote:

> Hi Alexey,
>
> I have cloned *apache-ignite-2.7.0* source code and following below link
> to build.
>
>
> https://github.com/apache/ignite/blob/ignite-2.7/modules/web-console/DEVNOTES.txt
>
> --
> *Regards*
>
> *Sheshananda*
>


-- 
Alexey Kuznetsov

Re: Ignite we-console security

[Alexey Kuznetsov]

Hi, Sheshananda!

How are you starting Ignite Web console?
Docker? Direct install? Build from sources?

On Wed, Dec 19, 2018 at 2:17 PM Shesha Nanda 
wrote:

> Hi,
>
> Could you please let me know the steps to configure SSL security for the
> Ignite web-console.
>
> --
> *Regards*
>
> *Sheshananda *
>


-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com

Re: web console

[Alexey Kuznetsov]

Hi, Skollur.

I just checked that web agent works fine under Oracle & Open JDK 8.
It seems that you have some problems in your environment.

Please check that you have correct java installed.
And attach exact output from web agent console.


On Wed, Dec 19, 2018 at 2:35 AM Skollur  wrote:

> I am trying to ocnnect web console and downloaded ignite-web-agent-2.7.1.
> It
> doesnt seems to support java 1.8 and getting an error "jdk1.8.0_171 was
> unexpected at this time." What is the java version supported for
> ignite-web-agent-2.7.1?
>

-- 
Alexey Kuznetsov

Re: Web Agent configurations to connect Secured(SSL) IGNITE

[Alexey Kuznetsov]

Hi,

I would also add to Ilya's answer that I almost finished with IGNITE-9845
(it is on review right now).
https://issues.apache.org/jira/browse/IGNITE-9845

That will add explicit way to configure SSL for Web Agent.

-- 
Alexey Kuznetsov

Re: Web Agent configurations to connect Secured(SSL) IGNITE

[Alexey Kuznetsov]

See: https://docs.oracle.com/cd/E19830-01/819-4712/ablqw/index.html

You may need to modify ignite-web-agent.sh with "-D" JVM options.

-- 
Alexey Kuznetsov

Re: Web Agent configurations to connect Secured(SSL) IGNITE

[Alexey Kuznetsov]

Hi, Sheshananda,

This feature is under development:
https://issues.apache.org/jira/browse/IGNITE-9845
But as far as I know, you can set SSL options via system properties

On Mon, Dec 10, 2018 at 5:07 PM Shesha Nanda 
wrote:

> Hi,
>
> I have installed IGNITE sever by enabling security for the REST API.
>
> Now I am trying to connect  Web Agent to the ignite server but am not
> getting option to pass pem keys in the  Web Agent's  *ignite-web-agent.sh
> *scrip.
>
>
> Please let me know the configurations to pass pem file.
>
>
> --
> *Regards*
>
> *Sheshananda*
>


-- 
Alexey Kuznetsov

Re: Ignite web console

[Alexey Kuznetsov]

Hi Viraj Rathod,

1. Make sure that you copied "ignite-rest-http" folder from "libs/optional"
to "libs".
This module is required by Web Console in order to communicate with cluster
via REST.
Cluster should be restarted if "ignite-rest-http" was not in "libs".

2. Please attach log from Web Agent.

3. Take a look at docs:
https://apacheignite-tools.readme.io/docs/getting-started

On Tue, Dec 4, 2018 at 9:35 PM Viraj Rathod  wrote:

> How do I launch my localhost on the default 8090 port and connect it to my
> cluster.
> I have installed ignite and running 2 nodes on RHEL azure boxes.
> The ignite-web-agent.sh file is successful but how do I see my caches on
> the web console which is console.gridgrain.com?
> --
> Regards,
> Viraj Rathod
>


-- 
Alexey Kuznetsov

Re: Gridgain Console monitoring question

[Alexey Kuznetsov]

Hi, Charu.

The main reason is https://issues.apache.org/jira/browse/IGNITE-6677

In other words queries history will be collected only for thous queries that
 were executed with selected "Use selected cache as default schema name"
checkbox.

Once IGNITE-6677 will be fixed, you will see all queries in history.


On Fri, Nov 30, 2018 at 12:54 PM charshar  wrote:

> Hi,
>We are using open source Ignite and have configured the basic web
> console
> monitoring.
> However, we are unable to do the following :
>
>  - Queries History
>  - Explain plan of the queries.
>
> We can see the running queries. The parameter
> cacheConfiguration.queryDetailMetricsSize has been set to a value of 100.
> What are we missing??
>
> Thanks,
> Charu
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>


-- 
Alexey Kuznetsov

Re: control.sh from remote terminal?

[Alexey Kuznetsov]

Hi, Jose.

Yes it can.

Just run conrol.sh without options and you will see help about its
parameters.

>> control.sh [--host HOST_OR_IP] [--port PORT]

On Wed, Nov 28, 2018 at 11:25 PM joseheitor  wrote:

> Can control.sh connect to a remote cluster?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>


-- 
Alexey Kuznetsov

Re: Automated cache generation to clone a SQL schema?

[Alexey Kuznetsov]

Hi, sv!

Before ignite-2.0 & Web Console there was "Schema Import Utility"

See https://github.com/apache/ignite/tree/ignite-1.9/modules/schema-import

Code of that utility is written on Java.

It simply read metadata from JDBC and generate stuff.
You can write you own custom utility in a couple of days.

-- 
Alexey Kuznetsov

Re: Issues running Ignite with Cassandra and spark.

[Alexey Kuznetsov]

Hi,  Shrey!

Just as idea - Ignite now has persistence (see
https://apacheignite.readme.io/docs/distributed-persistent-store),
 may be you can completely replace  Cassandra with Ignite?

In this case all data always be actual, no need to sync with external db.

-- 
Alexey Kuznetsov

Re: Ignite Web Agent

[Alexey Kuznetsov]

Hi, Daryl !

It seems that you were able to run Web Console from docker.
Did you managed to open it in browser?
If yes, there a link "Download agent" in footer, try to click it.
It should allow you to download a web agent that you can unpack and run
near to your cluster.

Let me know if it helps.

>
> --
Alexey Kuznetsov

Re: webconsole generated project - cache load performance

[Alexey Kuznetsov]

Hi!

Could you provide more details?
Ignite version? DB Vendor and version you are loading data from?
Ignite cluster size (number of nodes)? Does each node in cluster run on
separate host?

Attach your generated project and DDL of data you are loading.


On Sat, Sep 15, 2018 at 2:18 AM wt  wrote:

> Hi
>
> Is there a way to make the loading run faster for a project that has been
> generated by the web console. I am loading 4 million records and it is
> taking 30+ minutes
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>


-- 
Alexey Kuznetsov

Re: Ignite Thin Client Continuous Query

[Alexey Kuznetsov]

Gordon,

How about to start several client nodes "near" to cluster and use them as
"proxies" for your desktop GUI apps?
You may write some code that will push data from client node to you GUI app.
This will require some coding of course.

-- 
Alexey Kuznetsov

Re: Is there some tools to get Node `ConsistentID`?

[Alexey Kuznetsov]

It will be available in Visor CMD in Ignite 2.7
See https://issues.apache.org/jira/browse/IGNITE-8506 (with screenshot).

On Thu, Aug 23, 2018 at 4:23 PM Ilya Kasnacheev 
wrote:

> Hello!
>
> How about ignite.cluster().localNode().consistentId()?
>
> Regards,
>
> --
> Ilya Kasnacheev
>
> 2018-08-23 4:17 GMT+03:00 huzx :
>
>> Hi, Guys:
>>
>>  Is there some tools to get `ConsistentID` of the server node?  I
>> found
>> the `ID` in topology is not `ConsistentID`
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>> --
>> Alexey Kuznetsov
>> <http://apache-ignite-users.70518.x6.nabble.com/>
>>
>

Re: Possible issue with Web Console

[Alexey Kuznetsov]

Vishwas,

You may clone Ignite repo and cherry-pick a commit.
And build from sources.

Will this work for you?

On Fri, Aug 17, 2018 at 5:27 PM vbm  wrote:

> Hi,
>
> Can this fix be backported to 2.5 or 2.6 version ?
>
> Regards,
> Vishwas
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
> --
> Alexey Kuznetsov
> <http://apache-ignite-users.70518.x6.nabble.com/>
>

Re: Confusion/inaccurate visor stats

[Alexey Kuznetsov]

Hi!

> 1) In Data region metrics, why is everything 0?
Did you enable metrics?

See:
  DataRegionConfiguration dataRegionCfg = new DataRegionConfiguration();
  dataRegionCfg.setMetricsEnabled(true);

> 4) Total busy time is 15s, the upload took longer than that.
This is actually time spend in compute engine see:
org.apache.ignite.cluster.ClusterMetrics
/**
 * Gets total time this node spent executing jobs.
 * @return Total time this node spent executing jobs.
 */
public long getTotalBusyTime();

I hope 2) & 3) will answer some one who knows about it.

-- 
Alexey Kuznetsov

Re: WebConsole does not see cluster

[Alexey Kuznetsov]

Hi,  KJQ!

You will need ignite-rest-http module in class path for those nodes that
you are planning to use as gateways for Web Console.
Having only one node will means that if this single node goes down - you
will lose connection to cluster from Web Console.

You may have several agents running and configured to communicate with
different nodes.
See  node-uri option in Web Agent "README.txt"

Or starting from Ignite 2.7 (already in master, but was not released yet)
you may specify several cluster nodes URIs as comma separated string.

>- I see in "caches" my cache.  Should I see my configurations in
> configurations as well or is that only for created ones?
It is not clear for me what did you mean.
Can you attach a screenshot with example?



On Tue, Aug 14, 2018 at 1:32 AM KJQ  wrote:

> So, I finally got this working.
>
> I ended up:
> - Copying the rest-http module into my main Ignite node (the only one who's
> IP i am using for discovery right now).
>
> - I shell into the running "ignite" instance and run the web agent from
> there (not outside the containers)
>
> Questions:
>
> - I see in "caches" my cache.  Should I see my configurations in
> configurations as well or is that only for created ones?
>
> - Where do I need the agent and rest api?  It seems like having it in the
> one node will suffice.  Do I need to have both on every node?
>
>
>
> -
> KJQ
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
> --
> Alexey Kuznetsov
> <http://apache-ignite-users.70518.x6.nabble.com/>
>

Re: Possible issue with Web Console

[Alexey Kuznetsov]

Hi!

Could you describe how you are starting Web Console?
Also, from what DB you are importing tables?
Could you attach a SQL script that we can try to reproduce?

Import should work in open source Web Console.


On Tue, Aug 14, 2018 at 2:01 AM sv  wrote:

> Web Console, Configure -> Import from Database, select some tables,
> Download
> project:
> The downloaded .zip file does not contain any of the Model java classes for
> the tables, and the XML file does not contain any queryEntities definitions
> for any of the tables.  When I click on "Project Structure" before the
> download, I clearly see all the Model classes in there, and when I look at
> the 'Model' part of the UI, it shows all the fields that go into the
> queryEntities section, but the export contains none of those.  What's more,
> is that AFTER the export, all the Model classes disappear from the 'Project
> Structure'.
>
> I have tried:
> - Web Agent 2.5 (Ignite cluster 2.5)
> - Web Agent 2.6 (Ignite cluster 2.5)
> The behaviour is identical in both cases.
>
> I have also tried GridGain console (which is currently 2.4.4), and it works
> perfectly.
>
> Is this an issue with open source Web Console vs the GridGain version?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
> --
> Alexey Kuznetsov
> <http://apache-ignite-users.70518.x6.nabble.com/>
>

Re: Web console project upload

[Alexey Kuznetsov]

Orel,

Could you share command that you used to deploy Web Console?

If in that command data folder was configured to some folder of you local
file system, it means that all data can be restored.
Otherwise, data was inside docker image and I'm afraid it was also deleted.

Also you may try to restore docker container if it was not purged, see for
example here
https://stackoverflow.com/questions/29202787/restore-deleted-container-docker


Alexey Kuznetsov


On Thu, Aug 9, 2018 at 6:26 PM Orel Weinstock (ExposeBox) <
o...@exposebox.com> wrote:

> Hi,
>
> I've built up a project on a web console deployed via docker and
> accidentally deleted the image. This resulted in the whole project
> disappearing server side (obviously). The problem is I can't upload the
> project I have so that I can continue editing it on the Web Console. Is
> this something that is "in the works" or should I just back up the
> /var/lib/mongo folder somewhere?
>
> --
>
> --
> *Orel Weinstock*
> Software Engineer
> Email:o...@exposebox.com 
> Website: www.exposebox.com
>
>

Re: If the authenticationEnabled is true Ignite web control conneced failed

[Alexey Kuznetsov]

Actually, IGNITE-8428 already in master and will be released together with
Ignite-2.7.
As for https://console.gridgain.com  it may be updated in the beginning of
August.

On Thu, Jul 26, 2018 at 6:17 AM Denis Magda  wrote:

> Alexey K.,
>
> Please shed some light on when the secured cluster support will be
> released? I know it's already ready and just waiting its time to see the
> world.
>
> --
> Denis
>
> On Wed, Jul 25, 2018 at 6:34 AM ezhuravlev 
> wrote:
>
>> As for now, web agent can't connect to the secure Ignite cluster, this
>> functionality should be available with version 2.7
>>
>> Evgenii
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>> --
>> Alexey Kuznetsov
>> <http://apache-ignite-users.70518.x6.nabble.com/>
>>
>

Re: How do I rename multiple clusters

[Alexey Kuznetsov]

Hi,

As a workaround you may set IGNITE_CLUSTER_NAME  env variable for all nodes
in cluster.

On Thu, Jul 26, 2018 at 6:09 PM Evgenii Zhuravlev 
wrote:

> Hi,
>
> There is no such thing like "cluster name" in Ignite right now. However,
> I've found a ticket in Jira for adding it:
> https://issues.apache.org/jira/browse/IGNITE-6597
>
> Also, here is the thread on dev list regarding this feature:
> http://apache-ignite-developers.2346864.n4.nabble.com/Cluster-name-td15490.html
>
> Regards,
> Evgenii
>
> 2018-07-26 8:49 GMT+03:00 hulitao198758 :
>
>> The ignite official console monitors multiple clusters, but all cluster
>> names
>> are uuid names, which are difficult to manage. How do you change multiple
>> clusters to other names
>>
>> Ignite Web Control
>> Like this：
>>
>>   Cluster:0D8FC815
>>   Cluster:0E30C03F
>>
>> When there are many clusters, it is not easy to find them. Can you rename
>> them
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>> --
>> Alexey Kuznetsov
>> <http://apache-ignite-users.70518.x6.nabble.com/>
>>
>

Re: control.bat authentication support

[Alexey Kuznetsov]

Stan,

I think that we should add support for authentication in control.sh
One more tool will confuse Ignite users.

On Tue, May 22, 2018 at 3:53 AM, Stanislav Lukyanov <stanlukya...@gmail.com>
wrote:

> Hi,
>
>
>
> Ignite doesn’t provide built-in support for authentication, so the
> built-in control.bat/sh also don’t have stubs for that.
>
> So yes, I guess you need to write your own tool.
>
>
>
> A tool like that would be pretty simple though – just start a client node,
> parse command line arguments and
>
> map them to the methods of the ignite.cluster().
>
>
>
> Stan
>
>
>
> *From: *Olexandr K <olexandr.kundire...@gmail.com>
> *Sent: *17 мая 2018 г. 17:09
> *To: *user@ignite.apache.org
> *Subject: *control.bat authentication support
>
>
>
> Hi guys,
>
>
>
> I configured Ignite user/password authentication by adding custom plugin.
>
> It works fine in server/client nodes and visor but I can't find any auth
> support in control.bat
>
> I checked it's source code and don't see any place where I can provide
> credentials.
>
>
>
> Should I write my own control tool or how can I solve this?
>
>
>
> BR, Oleksandr
>
>
>



-- 
Alexey Kuznetsov

Re: Example of SQL query

[Alexey Kuznetsov]

Denis,

If this will be awailable in ignite-2.5

Why link is pointing to 2.4 ?

On Thu, May 10, 2018 at 9:53 PM, Denis Magda <dma...@apache.org> wrote:

> Guys,
>
> Starting with Ignite 2.5 it will be possible to use other types of keys in
> addition to String: https://apacheignite.readme.io/v2.4/docs/rest-api-
> 25#section-data-types
>
> --
> Denis
>
> On Thu, May 10, 2018 at 4:39 AM, Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> I didn't exactly get 1), but I'm sure your best bet is to use
>> keyConfiguration (CacheKeyConfiguration) in this case to set affinity key.
>> Otherwise you're at risk of getting "incompatible affinity keys" error.
>>
>> BTW isn't it a better topic for dev@? Care to crosspost?
>>
>> Regards,
>>
>> --
>> Ilya Kasnacheev
>>
>> 2018-05-09 14:46 GMT+03:00 aealexsandrov <aealexsand...@gmail.com>:
>>
>>> Hi again,
>>>
>>> We already discussed about it recently. At the moment some things works
>>> incorrect in 2.4:
>>>
>>> 1)Rest API only support String as key and value. And looks like you can't
>>> use affinity key on strings for the same issue. But if you can setup it
>>> using AffinityKeyMapper anotation:
>>>
>>> public static class Key {
>>> @AffinityKeyMapped
>>> @QuerySqlField(index = true)
>>> private final Stringkey;
>>>
>>> public Key(Stringkeykey) {
>>> this.key = key;
>>> }
>>>
>>> public Stringkey getKey() {
>>> return key;
>>> }
>>> }
>>>
>>> And put it:
>>>
>>> CacheConfiguration<Key, Person> cfg = new CacheConfiguration<>("cache");
>>>
>>> It should work like example from here:
>>>
>>> http://apache-ignite-users.70518.x6.nabble.com/Inconsistency
>>> -reading-cache-from-code-and-via-REST-td21228.html#a21293
>>>
>>> 2)qryexe doesn't work correct. At some reason it ignores _key and _value
>>> fields. Looks like it could be solved in future releases.
>>>
>>> How I am going to show you some working examples how you avoid second
>>> problem:
>>>
>>> StartServerNode.java
>>> <http://apache-ignite-users.70518.x6.nabble.com/file/t1704/S
>>> tartServerNode.java>
>>> StartClientNode.java
>>> <http://apache-ignite-users.70518.x6.nabble.com/file/t1704/S
>>> tartClientNode.java>
>>>
>>> 1)qryfldexe - exactly the same that you want but had another syntax:
>>>
>>> Here -
>>> select%20firstName%2C%20lastName%20from%20Person%20where%20_
>>> key%20%3D%201%20or%20_key%20%3D%203
>>> is select firstName, lastName from Person where _key = 1 or _key = 3
>>>
>>> http://127.0.0.1:8080/ignite?cmd=qryfldexe=10
>>> Name=Person=select%20firstName%2C%20lastName%20from%20Pe
>>> rson%20where%20_key%20%3D%201%20or%20_key%20%3D%203
>>>
>>> {"successStatus":0,"error":null,"sessionToken":null,"respons
>>> e":{"items":[["John1","Doe1"],["John3","Doe3"]],"last":true,
>>> "fieldsMetadata":[{"schemaName":"Person","typeName":"PERSON"
>>> ,"fieldName":"FIRSTNAME","fieldTypeName":"java.lang.
>>> String"},{"schemaName":"Person","typeName":"PERSON","
>>> fieldName":"LASTNAME","fieldTypeName":"java.lang.String"}],"queryId":4}}
>>>
>>> 2)get command return the value of some key:
>>>
>>> http://127.0.0.1:8080/ignite?cmd=get=Person=3
>>>
>>> {"successStatus":0,"affinityNodeId":"37f9d00d-8a7a-4db4-a1af
>>> -16471a548ce1","error":null,"sessionToken":null,"response":
>>> {"firstName":"John3","lastName":"Doe3","id":"3"}}
>>>
>>> 3)getall command return several values for some keys
>>>
>>> http://127.0.0.1:8080/ignite?cmd=getall=Person=1=2
>>>
>>> {"successStatus":0,"affinityNodeId":null,"error":null,"sessi
>>> onToken":null,"response":{"1":{"firstName":"John1","lastName
>>> ":"Doe1","id":"1"},"2":{"firstName":"John2","lastName":
>>> "Doe2","id":"2"}}}
>>>
>>> Hope that it will help you.
>>>
>>> BR,
>>> Andrei
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>
>>
>>
>


-- 
Alexey Kuznetsov

Re: Query on Ignite web console

[Alexey Kuznetsov]

 Vishwas,

There is no such API to get security token of Web Console.

What are you tying to implement?

Actually there no need in web console and web agent if you just need to
execute some SQL.
You may use JDBC/ODBC/REST see:

https://apacheignite.readme.io/docs/rest-api
https://apacheignite-sql.readme.io/docs/sql-reference-overview


On Mon, Apr 16, 2018 at 11:21 PM, vbm <bmvish...@gmail.com> wrote:

> Hi Denis,
>
> Thanks for the information. I have started using web console now.
>
> When the user is created as part of web console, a security token is
> created.
> The ignite-web-agent is dependent on this security token.
>
> Currently the starting of a ignite-web agent looks more of a manual step
> because of this security token. I wanted to automate the process of ignite
> web agent connecting to the console.
>
> Are there any rest api for web console with which we can create user and
> also get the security token for a particular user.
>
>
> Regards,
> Vishwas
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: Webconsole on Hadoop/Spark cluster

[Alexey Kuznetsov]

Ganesh,

Take a look for this docs:
https://apacheignite-tools.readme.io/docs/getting-started

On Mon, Apr 2, 2018 at 3:50 AM, ganesh <ganeshi...@gmail.com> wrote:

> Hi
>
> I'm new bee to ignite. I have just installed Apache Ignite on Spark cluster
> and tried running sample jobs.
>
> I found about webconsole to monitor memory and metrics in ignite.  Could
> you
> please you point me to steps to install webconsole on spark cluster?
>
> Appreciate you help
>
> Regards,
> Ganesh
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: Apache Ignite nightly release builds

[Alexey Kuznetsov]

+1 to get nightly builds WITHOUT login.

On Thu, Mar 22, 2018 at 3:38 PM, Dmitriy Setrakyan <dsetrak...@apache.org>
wrote:

> Why do we need to ask people to login to get a nightly build? Anyway to
> open it to public without a login?
>
>

-- 
Alexey Kuznetsov

Re: Get all data of one cache in Ignite without creating a new ignite node

[Alexey Kuznetsov]

Rick,

Java think client may be released in some nearest release.
You can track its progress here:
https://issues.apache.org/jira/browse/IGNITE-7421
Meanwhile you can use client node or JDBC or REST.

-- 
Alexey Kuznetsov

Re: Re: About Apache Ignite 2.4 with jdk

[Alexey Kuznetsov]

 Hello, Lucky.

In Ignite 2.4 JDK 7 support was dropped (see release notes).

You will need to use JDK8 or fork Ignite project and try to fix compilation
under JDK7.


-- 
Alexey Kuznetsov

Re: Using Rest module cache not getting created

[Alexey Kuznetsov]

Hi,  Vishwas

It is known issue with REST.
I fixed it recently in https://issues.apache.org/jira/browse/IGNITE-7725

It will be available in ignite-2.5 because it was late to push it in
ignite-2.4 due to code freeze.

You can wait for  ignite-2.5 or build from sources from master branch.


On Sun, Mar 4, 2018 at 10:20 AM, vbm <bmvish...@gmail.com> wrote:

> Hi,
>
> I am using ignite 2.3. I have added the ignite-rest-http folder under libs
> folder.
>
> Ignite version command is working as expected:
> curl http://10.194.11.99:8080/ignite?cmd=version
> {"successStatus":0,"sessionToken":null,"error":null,"response":"2.3.0"}
>
>
> But when I try to create cache it returns success but cache is not getting
> created:
> curl http://10.194.11.99:8080/ignite?cmd=getorcreate=myCache
> [1] 11814
> {"successStatus":0,"sessionToken":null,"error":null,"response":null}
>
> I verified using ignite visor script, only default cache is present.
> Can you let me know, what is wrong here.
>
>
> Regards,
> Vishwas
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: Ignite indexes and persistence

[Alexey Kuznetsov]

Hi,

Did you test on single node or cluster?
Could you describe in more ditails and provide configs?

On Wed, Feb 21, 2018 at 11:24 PM, lawrencefinn <lar...@gmail.com> wrote:

> I've been testing ignite durable memory with trying to load a lot more data
> than I have configured for the dataregion, thereby using disk for a lot of
> data.  I was wondering how indexes get persisted to disk in this situation
> where more data exists than will fit in memory?  Is there a way to
> configure
> index memory size?  The reason I ask this is because I notice that count
> queries are very slow with disk utilization, but if an index is in memory
> it
> should be fast to perform the count.  Even select one field queries that
> utilize an index and return a relatively small data set (like 4000 rows)
> takes minutes.  If the index were in memory, it should be pretty cheap to
> read from the disk once the items are known.  It also seems weird that the
> same query does not get faster when I run it again, shouldn't those 4000
> items be pulled into memory?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: QuerySqlFunction

[Alexey Kuznetsov]

Hi,

AFAIK,  PeerClassLoading works only with Ignite compute subsystem.
For SQL functions you need to deploy them in cluster before use.



On Thu, Feb 15, 2018 at 4:29 AM, Williams, Michael <
michael.willi...@transamerica.com> wrote:

> What changes do I need to do to make ZeroDeploy work with QuerySqlFunction
>  definitions? I’m following the example and adding the class as follows,
> but even with peer class loading enabled, I get a gnarly error. Can clients
> marshal to servers? Any advice?
>
>
>
>
>
> import org.apache.ignite.cache.query.annotations.QuerySqlFunction;
>
>
>
> public class MyFunctions {
>
> @QuerySqlFunction
>
> public static int sqr(int x) {
>
> return x * x;
>
> }
>
> }
>
>
>
> …
>
> cfg.setPeerClassLoadingEnabled(true);
>
> cfg.setClientMode(true);
>
> cfg.setDeploymentMode(DeploymentMode.CONTINUOUS);
>
> try(Ignite ignite = Ignition.start(cfg))
>
> …
>
> myCache.setSqlFunctionClasses(MyFunctions.class);
>
> …
>
>
>
>
>
> Error:
>
> class org.apache.ignite.IgniteCheckedException: Failed to find class with
> given class loader for unmarshalling (make sure same versions of all
> classes are available on all nodes or
>
> enable peer-class-loading) [clsLdr=sun.misc.Launcher$
> AppClassLoader@764c12b6, cls=IgniteStartup.MyFunctions]
>
> at org.apache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(
> JdkMarshaller.java:126)
>
> at org.apache.ignite.marshaller.AbstractNodeNameAwareMarshalle
> r.unmarshal(AbstractNodeNameAwareMarshaller.java:94)
>
> at org.apache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(
> JdkMarshaller.java:143)
>
> at org.apache.ignite.marshaller.AbstractNodeNameAwareMarshalle
> r.unmarshal(AbstractNodeNameAwareMarshaller.java:82)
>
> at org.apache.ignite.internal.util.IgniteUtils.unmarshal(
> IgniteUtils.java:9795)
>
> at org.apache.ignite.spi.discovery.tcp.messages.
> TcpDiscoveryCustomEventMessage.message(TcpDiscoveryCustomEventMessage
> .java:81)
>
> at org.apache.ignite.spi.discovery.tcp.ServerImpl$
> RingMessageWorker.notifyDiscoveryListener(ServerImpl.java:5460)
>
> at org.apache.ignite.spi.discovery.tcp.ServerImpl$
> RingMessageWorker.processCustomMessage(ServerImpl.java:5282)
>
> at org.apache.ignite.spi.discovery.tcp.ServerImpl$
> RingMessageWorker.processMessage(ServerImpl.java:2656)
>
>
>
> Thanks,
>
> *Mike Williams*
>
>
>



-- 
Alexey Kuznetsov

Re: ignite-schedule latest version?

[Alexey Kuznetsov]

Hi,

I filed issue about ignite-schedule some time ago [1].
But it was not resolved yet.


[1] https://issues.apache.org/jira/browse/IGNITE-5565

On Wed, Dec 27, 2017 at 6:40 AM, vkulichenko <valentin.kuliche...@gmail.com>
wrote:

> Hi,
>
> You should specify the same version for all Ignite artifacts in your
> project. If you're using 2.3, ignite-schedule:2.3.0 should be used.
>
> Artifacts for this module are not deployed to Maven central after 1.2 due
> to
> licensing restrictions (it uses LGPL dependencies). So you should either
> build from source, or try using 3rd party repositories [1].
>
> [1] https://ignite.apache.org/download.cgi#3rdparty
>
> -Val
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: Can Ignite me used for everyday processes, storage, reading, writing, etc. together with SQL

[Alexey Kuznetsov]

Rick,

You are testing Ignite in mode that will not show its true power.
Ignite is a _Distributed_ system, so, it _can_ outperform classic DB in
distributed mode.

On Tue, Dec 12, 2017 at 2:34 PM, Rick Alexander <imedita...@gmail.com>
wrote:

> No clusters setup yet, 1 node, 1 host, running on a VM.
>
>
>
> On Tue, Dec 12, 2017 at 2:09 AM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> Hi, Rick
>>
>> Could you describe how many are you running Ignite cluster?
>> How many nodes? On how many hosts? Some virtual OS or bare metal?
>>
>>
>> On Tue, Dec 12, 2017 at 12:46 PM, Rick Alexander <imedita...@gmail.com>
>> wrote:
>>
>>> Can Ignite me used for everyday processes, storage, reading, writing,
>>> etc. together with SQL?
>>>
>>> We're having a situation where the queries on Ignite are much, much
>>> slower than on SQL.
>>>
>>> Has anyone gone from an SQL environment to Ignite before?
>>>
>>> Our goals are to speed up and scale our current and future databases,
>>> whether it's starting with the db's we have in SQL now and going to another
>>> DB type later, or something else.
>>>
>>> Any help is appreciated.
>>>
>>
>>
>>
>> --
>> Alexey Kuznetsov
>>
>
>


-- 
Alexey Kuznetsov

Re: Can Ignite me used for everyday processes, storage, reading, writing, etc. together with SQL

[Alexey Kuznetsov]

Hi, Rick

Could you describe how many are you running Ignite cluster?
How many nodes? On how many hosts? Some virtual OS or bare metal?


On Tue, Dec 12, 2017 at 12:46 PM, Rick Alexander <imedita...@gmail.com>
wrote:

> Can Ignite me used for everyday processes, storage, reading, writing, etc.
> together with SQL?
>
> We're having a situation where the queries on Ignite are much, much slower
> than on SQL.
>
> Has anyone gone from an SQL environment to Ignite before?
>
> Our goals are to speed up and scale our current and future databases,
> whether it's starting with the db's we have in SQL now and going to another
> DB type later, or something else.
>
> Any help is appreciated.
>



-- 
Alexey Kuznetsov

Re: Apache Ignite Web Consol Monitor

[Alexey Kuznetsov]

Hi,

The monitoring tab is provided as an add-on by GridGain. However, Ignite
users can use it for free via Ignite console version hosted here:
https://console.gridgain.com/

If you prefer to have it installed in your infrastructure then you need to
contact the vendor or create a similar one add-on.

-- 
Alexey Kuznetsov

Re: Apache Ignite Web console query tab error

[Alexey Kuznetsov]

Hi!

There a bug in modules/web-console/frontend/app/utils/SimpleWorkerPool.js

To fix you need to add missing import:
   import 'rxjs/add/operator/map';

And rebuild frontend.

This is already fixed in master.

-- 
Alexey Kuznetsov

Re: Ignite web console and we agent are running not able to see clusters

[Alexey Kuznetsov]

Hi, gkiran292!

Did you managed to start web agent and connect cluster to Web console?



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

Re: Does ignite-schedule not upgrade after 2.1.0?

[Alexey Kuznetsov]

Aurora,

Could you provide more details about your problem?
Why did you need ignite-schedule?
And what upgrade are you expecting?

On Fri, Nov 3, 2017 at 6:00 PM, Aurora <2565003...@qq.com> wrote:

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



-- 
Alexey Kuznetsov

Re: odbc and apache ignite/ c++ clients

[Alexey Kuznetsov]

Hi,

You can start from docs: https://apacheignite-cpp.readme.io/docs

On Wed, Oct 18, 2017 at 9:54 AM, Anirudha Jadhav <aniru...@nyu.edu> wrote:

> I need a way to access ignite IMDG/DB from c/c++.
>
> The JNI c++ clients is not an option for us.
>
> i am currently exploring performance between redis / memchached c/c++
> clients
>
> Q: does ignite ODBC drivers also have a JNI dependency?
>
> Q: what the best approach to access remote ignite grids from c++ with KV
> and SQl lookups?
>
>
> thanks a lot,
>
> --
> Ani
>



-- 
Alexey Kuznetsov

Re: Java 9

[Alexey Kuznetsov]

Evgenii,

Hadoop is an optional module.
How about ignite-core? Could it be started under Java 9?

On Fri, Oct 13, 2017 at 2:21 PM, Evgenii Zhuravlev <e.zhuravlev...@gmail.com
> wrote:

> Paolo,
>
> As most frameworks and platforms, Ignite contains low-level logic, which
> was changed in Java 9. For example, in Java 9 application classloader is
> not a UrlClassLoader anymore, while in ignite-hadoop we used methods from
> UrlClassLoader for implementing class loading logic.
>
> So, --add-opens and other flags will not help right now, the community
> should do some changes in code first.
>
> Evgenii
>
>

Alexey Kuznetsov

Re: Indexing fields of non-POJO cache values

[Alexey Kuznetsov]

Just as idea.

What if we can to declare a kind of "references" or "aliases" for fields in
such cases?
And this will help us to avoid duplication of data.

For example in JavaScript I could (almost on the fly) declare getters and
setters that could be as aliases for my data.


On Fri, Oct 13, 2017 at 12:39 AM, Andrey Kornev <andrewkor...@hotmail.com>
wrote:

> Hey Andrey,
>
> Thanks for your reply!
>
> We've been using a slightly different approach, where we extract the
> values of the indexable leaf nodes and store them as individual fields of
> the binary object along with the serialized tree itself. Then we configure
> the cache to use those fields as QueryEntities. It works fine and this way
> we avoid using joins in our queries.
>
> However an obvious drawback of such approach is data duplication. We end
> up with three copies of a field value:
>
> 1) the leaf node of the tree,
> 2) the field of the binary object, and
> 3) Ignite index
>
> I was hoping that there may be a better way to achieve this. In particular
> I'd like to avoid storing the value as a field of a binary object (copy #2).
>
> One possible (and elegant) approach to solving this problem would be to
> introduce a way to specify a method (or a closure) for a QueryEntity in
> addition to currently supported BinaryObject field/POJO attribute.
>
> Regards
> Andrey
>
> --
> *From:* Andrey Mashenkov <andrey.mashen...@gmail.com>
> *Sent:* Thursday, October 12, 2017 6:25 AM
> *To:* user@ignite.apache.org
> *Subject:* Re: Indexing fields of non-POJO cache values
>
> Hi,
>
> Another way here is to implement your own query engine by extending
> IndexingSPI interface, which looks much more complicated.
>
> On Thu, Oct 12, 2017 at 4:23 PM, Andrey Mashenkov <
> andrey.mashen...@gmail.com> wrote:
>
>> Hi,
>>
>> There is no way to index such data as is. To index data you need to have
>> entry_field<->column mapping configured.
>> As a workaround here, leaves can be stored in cache as values.
>>
>> E.g. you can have a separate cache to index leaf nodes, where entries
>> will have 2 fields: "original tree key" field and "leaf node value" indexed
>> field.
>> So, you will be able to query serialized tree-like structures via SQL
>> query with JOIN condition on  "original tree key" and WHERE condition on
>> "leaf node value" field.
>> Obviously, you will need to implement intermediate logic to keep data of
>> both caches consistent.
>>
>>
>> On Wed, Oct 11, 2017 at 9:40 PM, Andrey Kornev <andrewkor...@hotmail.com>
>> wrote:
>>
>>> Hello,
>>>
>>> Consider the following use case: my cache values are a
>>> serialized tree-like structure (as opposed to a POJO). The leaf nodes of
>>> the tree are Java primitives. Some of the leaf nodes are used by the
>>> queries and should be indexed.
>>>
>>> What are my options for indexing such data?
>>>
>>> Thanks
>>> Andrey
>>>
>>
>>
>>
>> --
>> Best regards,
>> Andrey V. Mashenkov
>>
>
>
>
> --
> Best regards,
> Andrey V. Mashenkov
>



-- 
Alexey Kuznetsov

Re: Cache size in Memory

[Alexey Kuznetsov]

Hi,

Take a look at documentation:
https://apacheignite.readme.io/docs/memory-metrics

You can multiply TotalAllocatedPages on page size to get an estimation.

On Tue, Oct 3, 2017 at 3:35 AM, pradeepchanumolu <pradeepb...@gmail.com>
wrote:

> Hi ,
>
> Can someone let me know how to get the stats of the cache like how large
> (like how many MB/GB) is the cache in memory (both on and off heap)?
>
> Currently, I can only get number of entries in the cache using the
> cache.size(CachePeekMode.ONHEAP), cache.size(CachePeekMode.OFFHEAP).
>
> cache.metrics() returns the Cache Metrics but doesn't have any methods to
> return the total size in gb/mb of the cache in memory.
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
> --
> Alexey Kuznetsov
> <http://apache-ignite-users.70518.x6.nabble.com/>
>

Re: Question about number of total onheap and offheap cache entries.

[Alexey Kuznetsov]

Hi Ray!

Could you show your cache configuration?

In case if you set "onHeapEnabled=true" Ignite will "cache" values in heap
during get & sql operations.
And heap metric will be > 0.

As for 2.3 - it will be released by the end of October.
You can always try to build from sources from master.
https://ignite.apache.org/download.cgi#build-source


On Tue, Oct 3, 2017 at 12:23 AM, Ray <ray...@cisco.com> wrote:

> Thank you Vasiliy for your answer.
>
> In the ticket, it looks like the problem is with the off-heap entry count.
> But my question is why the on-heap entry count is always the same as the
> off-heap entry count?
> Ignite stores the cache off-heap by default, so in design there will be
> zero
> on-heap entry count when the cache is not visited, right?
> Or is there some eviction configuration I need to set up for the entries to
> be evicted after they are visited and brought on-heap?
> I've been watching the visor stats for a day now, and the cache is not
> visited during the day.
> But the on-heap entry count is still not zero.
>
> And is there any release date for Ignite 2.3?
>
> Thanks
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: POJO get from any ignite console? visor or rest?

[Alexey Kuznetsov]

Binti,

You can try to use Web Console [1] "Queries screen"  and execute SCAN on
you cache.

[1] https://ignite.apache.org/features/datavisualization.html

On Fri, Sep 22, 2017 at 2:32 AM, bintisepaha <binti.sep...@tudor.com> wrote:

> Hi, I see that ignire rest API does not yet have support for json/custom
> objects lookup by key.
> But is this something I can do via JMX or visor or a management console?
>
> I only would like to see how the object looks in the cache easily.
> The key is usually a composite key of 2 integers.
>
> Let me know if there is a quick web based way to access this.
>
> Thanks,
> Binti
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>



-- 
Alexey Kuznetsov

Re: Re: Re: Fetched result set too large

[Alexey Kuznetsov]

Hi Lucky,

You can build Ignite from sources. Will this work for you?

On Wed, Sep 13, 2017 at 9:07 PM, Lucky <wanxing...@163.com> wrote:

> Oh,No!
> This is the worst news today.
> I have to try  another way to resolve it.
>
> Anyway,Thanks a lot.
>
>
>
>
> At 2017-09-13 14:46:00, "Вячеслав Коптилин" <slava.kopti...@gmail.com>
> wrote:
>
> Hi Lucky,
>
> Unfortunately, there is no release date on Apache Ignite releases page [1].
> Usually, new Ignite release become available twice a year.
>
> [1] https://issues.apache.org/jira/projects/IGNITE?
> selectedItem=com.atlassian.jira.jira-projects-plugin:release-page
>
> Thanks.
>
> 2017-09-13 5:27 GMT+03:00 Lucky <wanxing...@163.com>:
>
>> Thanks.
>> When will the 2.3 be released?
>>
>>
>>
>> At 2017-09-12 22:58:34, "slava.koptilin" <slava.kopti...@gmail.com> wrote:
>> >Hi Lucky,
>> >
>> >It seems that this issue was resolved
>> >https://issues.apache.org/jira/browse/IGNITE-5991
>> >The fix will be available in Apache Ignite 2.3
>> >
>> >Thanks!
>> >
>> >
>> >
>> >
>> >--
>> >Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>>
>>
>>
>>
>
>
>
>
>



-- 
Alexey Kuznetsov

Re: ignite visor not workin in case ignite is started from a tomcat

[Alexey Kuznetsov]

Hi!

Can you prepare a simple project to reproduce the issue?
Also please specify versions of Ignite and Tomcat.

On Tue, Aug 8, 2017 at 1:18 PM, neerajbhatt <neerajbhatt2...@gmail.com>
wrote:

> Hi All
>
> We have a web application deployed in tomcat, from which we are starting
> ignite server
> It seems in this scenario ignite visor is not able to detect ignite
> instance.
>
> In case we start ignite from a java class(not through tomcat), ignite visor
> is able to connect to ignite and give cache details
>
> Please suggest how we can use ignite visor (in case ignite s started from a
> tomcat)
>
> Thanks
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/ignite-visor-not-workin-in-case-
> ignite-is-started-from-a-tomcat-tp16043.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Trouble using latest Ignite Web Console (2.1)

[Alexey Kuznetsov]

Muthu,

1) If you declare id in your POJO you will consume memory twice, because id
is already a key that will be used to put into cache.
Do you really need this?

2) Actually you could do this with web console, but a bit tricky...
Go to "Summary screen" -> Scroll down to "Client" section -> Click on
"POJO" tab -> check "Include key fields" check box -> click "Download"
POJOs will be generated with key fields.


On Sat, Aug 5, 2017 at 4:26 AM, Muthu <muthu.kumara...@gmail.com> wrote:

> Hi Alexey,
>
> Just to add a little more context & summarize...I have been really trying
> to get this to work for a while so i can begin deploying ignite but as yet
> i haven't manged to get this working...below are the current list of issues,
>
> 1. The cache fails loading with the configurations generated from web
> console when i bring it up on spring boot (problems with H2 Indexing...)
> 2. The model files generated is missing the primary key field & its
> getters/setters. For example for the table "dcm.emp" i described earlier
> (in the sample project on github that i shared), the generated model DTOs
> did not have the field "private String id;" and the corresponding getters &
> setters for it..i had to add it manually in the DTO and edit the equals,
> hashCode & toString to fix it. I think manually doing this for a lot of
> tables is very cumbersome...
>
> public class Dept implements Serializable {
> ...
> ...
> private String id;
>
> public String getId() {
> return id;
> }
>
> public void setId(String id) {
> this.id = id;
> }
> ...
> ...
> }
>
>
> Regards,
> Muthu
>
> -- The real danger with modern technology isn't that machines will begin
> to think like people, but that people will begin to think like machines.
> -- Faith is to believe what you do not see; the reward of this faith is to
> see what you believe.
>
> On Fri, Aug 4, 2017 at 1:50 AM, Muthu <muthu.kumara...@gmail.com> wrote:
>
>> Hi Alexey,
>>
>> Try this, https://github.com/softwarebrahma/IgniteCacheWithAutomaticEx
>> ternalPersistence
>>
>> Can be run like below,
>>
>> java -jar -Ddb.host=localhost -Ddb.port=5432 -Ddb.name=postgres
>> -DIGNITE_QUIET=false target\CacheAutomaticPersistence-0.0.1-SNAPSHOT.jar
>>
>> Regards,
>> Muthu
>>
>> -- The real danger with modern technology isn't that machines will begin
>> to think like people, but that people will begin to think like machines.
>> -- Faith is to believe what you do not see; the reward of this faith is
>> to see what you believe.
>>
>> On Thu, Aug 3, 2017 at 8:50 PM, Alexey Kuznetsov <akuznet...@apache.org>
>> wrote:
>>
>>> Muthu,
>>>
>>> Can you attach a simple example to reproduce this exception?
>>>
>>>
>>> On Fri, Aug 4, 2017 at 4:08 AM, Muthu <muthu.kumara...@gmail.com> wrote:
>>>
>>>> Sure Alexey...thanks. I am using PostgreSQL version 9.6. The driver is
>>>> a bit old...its 9.4.1212 JDBC 4
>>>> <https://jdbc.postgresql.org/download/postgresql-9.4.1212.jre6.jar>
>>>>  (postgresql-9.4.1212.jre6.jar )..but i was using it without any
>>>> issues with 1.9 version of web console (previous one).
>>>>
>>>> On the workaround thingy, the problem is when i generate the
>>>> models/artifacts from it (console.gridgain.com) & deploy it on ignite
>>>> 2.1.0 it fails starting up with this error (it was failing even with 2.0 &
>>>> was fixed after i identified it..more details here,
>>>> https://stackoverflow.com/questions/44468342/automatic-persi
>>>> stence-unable-to-bring-up-cache-with-web-console-generated-m
>>>> ode/44901117). I thought later on that the ignite version from there
>>>> is grid gain's ignite version & that may not be compatible with the open
>>>> source ignite 2.1.0. Is it not true?
>>>>
>>>> INFO: Started cache [name=ignite-sys-cache, memoryPolicyName=sysMemPlc,
>>>> mode=REPLICATED, atomicity=TRANSACTIONAL]
>>>> Aug 03, 2017 12:34:36 PM org.apache.ignite.logger.java.JavaLogger error
>>>> SEVERE: Failed to reinitialize local partitions (preloading will be
>>>> stopped): GridDhtPartitionExchangeId [topVer=AffinityTopologyVersion
>>>> [topVer=1, minorTopVer=0], nodeId=e9b2cf46, evt=NODE_JOINED]
>>>> class org.apache.ignite.IgniteCheckedException: Failed to register
>>>>

Re: cache partitions

[Alexey Kuznetsov]

Hi!

What Ignite version do you use?
Also attach server and clients nodes configuration.
We will try to reproduce.



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/cache-partitions-tp14063p14440.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Ignite web console

[Alexey Kuznetsov]

What version of ignite are you using?

May be Docker will be more suitable for you?
See: https://apacheignite-tools.readme.io/docs/docker-deployment



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-web-console-tp13659p14439.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Ignite File System Support in R or Python

[Alexey Kuznetsov]

Answered in separate thread.

On Thu, Jun 29, 2017 at 11:38 AM, Ishan Jain <jain.isha...@gmail.com> wrote:

> Can someone provide documentation for Ignite File system support with
> scala?
>
> On Tue, Jun 27, 2017 at 12:08 PM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> Hi,
>>
>> I have no idea about R an Python.
>>
>> But as for Scala - Ignite is written on Java, and could be used from
>> Scala without any problems
>>
>> On Tue, Jun 27, 2017 at 11:26 AM, ishan-jain <jain.isha...@gmail.com>
>> wrote:
>>
>>> Is there a support for ignite file system running over hadoop file
>>> system in
>>> R or Python?
>>> Is there a support in scala?
>>>
>>>
>>>
>>>
>>>
>>> --
>>> View this message in context: http://apache-ignite-users.705
>>> 18.x6.nabble.com/Ignite-File-System-Support-in-R-or-Python-tp14088.html
>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>
>>
>>
>>
>> --
>> Alexey Kuznetsov
>>
>
>


-- 
Alexey Kuznetsov

Re: Ignite File System API with Scala

[Alexey Kuznetsov]

Hi!

See docs: https://apacheignite-fs.readme.io/docs/in-memory-file-system

IGFS is implemented on Java and could be used from Scala directly.

On Thu, Jun 29, 2017 at 12:27 PM, ishan-jain <jain.isha...@gmail.com> wrote:

> Hello
>
> Can someone provide documentation for ignite File System API in scala?
>
> Thanks in advance.
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Ignite-File-System-API-with-Scala-tp14153.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Ignite File System Support in R or Python

[Alexey Kuznetsov]

Hi,

I have no idea about R an Python.

But as for Scala - Ignite is written on Java, and could be used from Scala
without any problems

On Tue, Jun 27, 2017 at 11:26 AM, ishan-jain <jain.isha...@gmail.com> wrote:

> Is there a support for ignite file system running over hadoop file system
> in
> R or Python?
> Is there a support in scala?
>
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Ignite-File-System-Support-in-R-or-Python-tp14088.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: New version of Web Console Released

[Alexey Kuznetsov]

Not, yet.

It will be available with Ignite-2.1 release.
As far as I know 2.1 could be released in 2 or 3 weeks.

On Sat, Jun 24, 2017 at 4:26 AM, Muthu <muthu.kumara...@gmail.com> wrote:

> Hi Alexey,
>
> Is the latest web console available as a docker image that i can pick
> up?...i see this but it seems is a month old...
>
> https://hub.docker.com/r/apacheignite/web-console-standalone/
>
> Regards,
> Muthu
>
> On Mon, Jun 19, 2017 at 8:04 PM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> Igniters!
>>
>> I'd like to announce that we redeployed the new version Ignite Web
>> Console on GridGain infrastructure (https://console.gridgain.com) where
>> you can give it a try right a way.
>>
>> *NOTE*:
>>   1) You may need to refresh page (F5 or Ctrl+R) in order to reload Web
>> Console.
>>   2) You will need to download new web agent
>>
>> *What's new:*
>>   1) Import schema from RDBMS:
>> 1.1) Use unique index if no primary index defined on table.
>> 1.2) Fixed bug with "PRIMARY" index on MySql.
>> 1.3) Generate different datasources on import from different RDBMS.
>>   2) Added ability to show notification to all Web Console user (useful
>> to notify about planned WebConsole updates).
>>   3) Added "Basic" configuration - to configure cluster in several clicks.
>>   4) Added panel with information about "Compute".
>>
>> Stay tuned for updates!
>>
>> --
>> Alexey Kuznetsov
>>
>
>


-- 
Alexey Kuznetsov

New version of Web Console Released

[Alexey Kuznetsov]

Igniters!

I'd like to announce that we redeployed the new version Ignite Web Console
on GridGain infrastructure (https://console.gridgain.com) where you can
give it a try right a way.

*NOTE*:
  1) You may need to refresh page (F5 or Ctrl+R) in order to reload Web
Console.
  2) You will need to download new web agent

*What's new:*
  1) Import schema from RDBMS:
1.1) Use unique index if no primary index defined on table.
1.2) Fixed bug with "PRIMARY" index on MySql.
1.3) Generate different datasources on import from different RDBMS.
  2) Added ability to show notification to all Web Console user (useful to
notify about planned WebConsole updates).
  3) Added "Basic" configuration - to configure cluster in several clicks.
  4) Added panel with information about "Compute".

Stay tuned for updates!

-- 
Alexey Kuznetsov

Re: Ignite web console and we agent are running not able to see clusters

[Alexey Kuznetsov]

Hi!

Did you copy "ignite-rest-http" from "libs\optional" to "libs" ?
Web Agent and cluster node communicate via REST HTTP.
You will need to restart nodes after you coping "ignite-rest-http" from
"libs\optional" to "libs".


Alexey



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-web-console-and-we-agent-are-running-not-able-to-see-clusters-tp13871p13967.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Visor CLI not working (Apache Ignite 2.0.0)

[Alexey Kuznetsov]

Amit,

Please attach full config.

On Sun, Jun 18, 2017 at 2:15 AM, Amit Pundir <amitpun...@gmail.com> wrote:

> Hi Everyone,
> I am using Ignite 2.0.0 and trying to launch the visorcmd cli. It shows the
> 'Connected' message but always outputs 'No caches found' message. The
> aforementioned cache exists on the cluster though as I can query it through
> a java client.
>
> The commands I use to run Ignite cache and the visorcmd cli are mentioned
> below -
>
> *Ingite Command* - ./bin/ignite.sh
> *Visor Command* - ./bin/ignitevisorcmd.sh -cfg=config/default-config.xml
>
>
> /I have modified the default-config.xml to use the TcpIpFinder cluster
> configuration and added the seed node IPs./
>
> Is there anything incorrect/missing in what I am doing.
>
> Thanks for the help in advance.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Visor-CLI-not-working-Apache-Ignite-2-0-0-tp13893.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Ignite 2.0 visor issue

[Alexey Kuznetsov]

Amit,

Could you provide config for node?

On Fri, Jun 16, 2017 at 4:18 PM, Amit Pundir <amitpun...@gmail.com> wrote:

> Hi,
> I am also facing the same issue with visor on ignite 2.0.0.
> Could you please let me know what the resolution was at your end.
>
>
> Thanks
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Ignite-2-0-visor-issue-tp12460p13869.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Ignite web console not running in browser

[Alexey Kuznetsov]

Hi!

Did you try exactly: http://localhost:9000/ ?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Ignite-web-console-not-running-in-browser-tp13701p13702.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Automatic Persistence : Unable to bring up cache with web console generated models ("org.apache.ignite.IgniteCheckedException: Failed to register query type" exception is thrown)

[Alexey Kuznetsov]

Muthu,

Please create separate threads on user for mentioned problems: code
generation (if needed), spring transactions, JDBC.

I'm lost in this "big" number of text lines.

-- 
Alexey Kuznetsov

Re: Automatic Persistence : Unable to bring up cache with web console generated models ("org.apache.ignite.IgniteCheckedException: Failed to register query type" exception is thrown)

[Alexey Kuznetsov]

Muthu,

>>2. With Ignite/Web Console, if a DB table insert/update/delete operation
were to happen to the database directly is there a way to have that
automatically picked up into the cache (so its always in sync with the DB
tables)?
>> I know this is too much to ask. I ask because we currently have code
which uses MyBatis as ORM to read/write to PostgreSQL DB & i need to build
a cache without trying to integrate with MyBatis which is problematic.
>> I have some tools in mind & things like messaging based loads, etc to
try but if Ignite does this with some integration that would be great.

First of all, I would like to state that it is not correct mix  Ignite and
Web Console in this context.
Web Console - is just an *EXTERNAL tool*. It could generate some code for
you and also allows to execute some Ad-hock SQL queries and monitor your
cluster. That's all.

Second, there only one way to have caches and DB in sync - do ALL data
modifications via Ignite caches only.
And configure caches to write-through  to your DB.

So, you should directly use Ignite as DB -> configure your ORM to work with
Ignite as with DB via Ignite JDBC driver.
And configure caches to write-through  to your DB.


-- 
Alexey Kuznetsov

Re: Automatic Persistence : Unable to bring up cache with web console generated models ("org.apache.ignite.IgniteCheckedException: Failed to register query type" exception is thrown)

[Alexey Kuznetsov]

L_TO_DEFAULT, SEQUEN*
> *CE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK,
> REFERENCES, ,, )"; SQL statement:*
> *CREATE TABLE "DcmEmpCache".Emp (_key VARCHAR VISIBLE NOT NULL,_val OTHER
> VISIBLE,_ver OTHER INVISIBLE) engine
> "org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$H2TableEngine"
> [42001-193]*
> at org.h2.message.DbException.getJdbcSQLException(
> DbException.java:345)
> at org.h2.message.DbException.getSyntaxError(DbException.java:205)
> at org.h2.command.Parser.getSyntaxError(Parser.java:537)
> at org.h2.command.Parser.read(Parser.java:3186)
> at org.h2.command.Parser.readIfMore(Parser.java:885)
> at org.h2.command.Parser.parseCreateTable(Parser.java:6043)
> at org.h2.command.Parser.parseCreate(Parser.java:4238)
> at org.h2.command.Parser.parsePrepared(Parser.java:362)
> at org.h2.command.Parser.parse(Parser.java:317)
> at org.h2.command.Parser.parse(Parser.java:293)
> at org.h2.command.Parser.prepareCommand(Parser.java:254)
> at org.h2.engine.Session.prepareLocal(Session.java:561)
> at org.h2.engine.Session.prepareCommand(Session.java:502)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.
> java:1203)
> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.
> java:170)
> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing$H2TableEngine.createTable(IgniteH2Indexing.java:3975)
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.createTable(IgniteH2Indexing.java:2006)
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.registerType(IgniteH2Indexing.java:1859)
> ... 64 more
>
>
> Below is my table schema,
>
> *CREATE TABLE dcm.emp*
> *(*
> *  id text NOT NULL,*
> *  ename text,*
> *  job text,*
> *  mgr text,*
> *  hiredate date,*
> *  sal integer,*
> *  comm integer,*
> *  deptid text,*
> *  CONSTRAINT pk_emp PRIMARY KEY (id),*
> *  CONSTRAINT fk_deptid FOREIGN KEY (deptid)*
> *  REFERENCES dcm.dept (id) MATCH SIMPLE*
> *  ON UPDATE RESTRICT ON DELETE CASCADE*
> *)*
> *WITH (*
> *  OIDS=FALSE*
> *);*
> *ALTER TABLE dcm.emp*
> *  OWNER TO postgres;*
>
>
> Regards,
> Muthu
>



-- 
Alexey Kuznetsov

Re: swift store as secondary file system

[Alexey Kuznetsov]

Hi, Antonio!

What is a "swift store"?
Could you give a link?

On Sat, Jun 10, 2017 at 7:32 AM, Antonio Si <antonio...@gmail.com> wrote:

> Hi,
>
> Is there a secondary file system implementation for a swift store?
>
> Thanks.
>
> Antonio.
>



-- 
Alexey Kuznetsov

Re: Ignite Web Console

[Alexey Kuznetsov]

Hi Muthu,

I think if you generate artifacts with Web Console and use Ignite not as L2
cache for MyBatis,
but use Ignite as DB and connect  MyBatis to Ignite via JDBC driver this
should work.

You may try to implement simple Proof-Of-Concept: create couple of tables
in RDBMS (Person and Organisation for example)
Import them in web console + and try to access from MyBatis via JDBC driver.

What do you think?

On Thu, Jun 8, 2017 at 6:50 AM, Muthu <muthu.kumara...@gmail.com> wrote:

> Hi Folks,
>
> Does the new Ignite web console have full support for automatic RDBMS
> integration as mentioned @ https://apacheignite-tools.
> readme.io/docs/automatic-rdbms-integration
>
> Can Ignite do the caching with the Web console's RDBMS Integration or Model
> support being used to play the role of the persistence framework so that it
> will be an all Ignite stack?
>
> I ask this because today we are using MyBatis for persistence & were
> thinking of using Ignite as L2 cache but found that the support is very
> rudimentary & not really useful.
>
> The ORM use case is,
>
> 1. A way to write DTOs to ignite cache which will then automatically
> (async aswell) persist to DB (model/DTO generation, db persistence, etc by
> using Web console's artifacts)
>   -- This includes insert, update & delete and batch/bulk operations
>
> 2. A way to read from ignite cache which will automatically read from DB
> if not in cache
>   -- This includes read based on any predicate (where clause), custom
> select sql queries, bulk operations
>
> Regards,
> Muthu
>



-- 
Alexey Kuznetsov

Re: Clustering in apache ignite

[Alexey Kuznetsov]

Hi, Debasis.

Docs: http://apacheignite.readme.io/docs
Examples: Download release (https://ignite.apache.org/download.cgi) and go
to examples folder.
Make search over this user list and stack overflow.
Read blogs: https://ignite.apache.org/blogs.html

Ask *SPECIFIC questions *on user list.


On Wed, May 31, 2017 at 11:47 AM, Debasis Pradhan <debasis@gmail.com>
wrote:

> Hi Alexey,
>
> Thanks for the reply , almost all the examples related to cache/data . I
> need to learn more about clustering part (cluster metrics,apis and use
> case,sample code.)
>
> On Wed, May 31, 2017 at 10:05 AM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> Hi,
>>
>> A lot of videos: https://www.youtube.com/channel/UChYD3lCEnzHlWioUb2sNgSg
>> Docs: http://apacheignite.readme.io/docs
>>
>> On Wed, May 31, 2017 at 11:25 AM, dprbglr <debasis0...@gmail.com> wrote:
>>
>>> Hi ,
>>>
>>> Can anyone help to find the sample program or video tutorial or detailed
>>> pdf
>>> tutorial related to clustering.
>>>
>>>
>>>
>>> --
>>> View this message in context: http://apache-ignite-users.705
>>> 18.x6.nabble.com/Clustering-in-apache-ignite-tp13254.html
>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>
>>
>>
>>
>> --
>> Alexey Kuznetsov
>>
>
>
>
> --
> *Thanks *
> *Debasis*
> *9972429889*
>



-- 
Alexey Kuznetsov

Re: New version of Web Console released

[Alexey Kuznetsov]

Muthu,

It is better to start separate thread on user list about your use case.

On Wed, Jun 7, 2017 at 4:22 PM, Muthu <muthu.kumara...@gmail.com> wrote:

>
> Thanks Alexey! for the pointers. For the ORM alternate case the use case
> is the below (basically today we are thinking of using Ignite with MyBatis
> with Ignite being the L2 cache (among other things) & MyBatis being the
> persistence framework, the question is can Ignite do the cache with the Web
> console's RDBMS Integration or Model support being used to play the role
> of the persistence framework so it will be an all Ignite thingy),
>
> 1. A way to write DTOs to ignite cache which will then automatically
> (async aswell) persist to DB (model/DTO generation, db persistence, etc)
>   -- This includes insert, update & delete and batch/bulk operations
>
> 2. A way to read from ignite cache which will automatically read from DB
> if not in cache
>   -- This includes read based on any predicate (where clause), custom
> select sql queries, bulk operations
>
> Regards,
> Muthu
>
> On Wed, Jun 7, 2017 at 12:19 AM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> Muthu,
>>
>> >> Is the web console not part of or deploy-able from the ignite fabric
>> distrib
>> Yes. It is not part of binary distribution.
>> You can build it from sources or use Docker image (see:
>> https://hub.docker.com/r/apacheignite/web-console-standalone/tags/)
>>
>> >> .but i do not find any directory named "modules" under my IGNITE_HOME
>> You need to download SOURCE release.
>>
>>
>> >>> Can i download only a trial version from console.gridgain.com ?
>> No. console.gridgain.com contains Web Console that based on Apache
>> Ignite code base, but with additional features developed by GridGain.
>> Please contact GridGain for that.
>>
>> >> Will i able to use this as an alternative to say an ORM like MyBatis?
>> It depends in what you need. Please describe your use case.
>>
>>
>>
>> --
>> Alexey Kuznetsov
>>
>
>


-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com

Re: New version of Web Console released

[Alexey Kuznetsov]

Denis,

>>>Sounds great! BTW, was this ticket resolved as a part of the release:
>>> https://issues.apache.org/jira/browse/IGNITE-5303 (supporting multiple
RDBMS configurations from the wizard)

Yes we fixed this issue, now it is on testing with all major RDBMS.

-- 
Alexey Kuznetsov

Re: New version of Web Console released

[Alexey Kuznetsov]

Muthu,

>> Is the web console not part of or deploy-able from the ignite fabric
distrib
Yes. It is not part of binary distribution.
You can build it from sources or use Docker image (see:
https://hub.docker.com/r/apacheignite/web-console-standalone/tags/)

>> .but i do not find any directory named "modules" under my IGNITE_HOME
You need to download SOURCE release.


>>> Can i download only a trial version from console.gridgain.com ?
No. console.gridgain.com contains Web Console that based on Apache Ignite
code base, but with additional features developed by GridGain.
Please contact GridGain for that.

>> Will i able to use this as an alternative to say an ORM like MyBatis?
It depends in what you need. Please describe your use case.



-- 
Alexey Kuznetsov

Re: ignitevisor starting the node twice

[Alexey Kuznetsov]

Matt,

Could you share more details?
I think it is possible that "invisible / daemon node" could store some
state...
But We need a reproducible example.

On Tue, May 30, 2017 at 1:10 PM, Matt <dromitl...@gmail.com> wrote:

> Based on experience I would say that that "invisible node" is not
> completely transparent to the rest of the nodes. I'm not quite sure when or
> how, but I've seen it changes the behavior of the other nodes sometimes.
>
> I haven't payed much attention to this (I will next time) but may it be
> that it keeps some state even when all other nodes are down?
>
> I'm guessing that it keeps alive classes that were loaded using peer class
> loading (with default config), and when we relaunch some real nodes the
> state of the grid is not completely pristine.
>
> Not sure if that in particular is the case, but I've seen some weird
> things when visor is running.
>
> Matt
>
> On Mon, May 29, 2017 at 11:18 PM, Alexey Kuznetsov <akuznet...@apache.org>
> wrote:
>
>> You need to open configuration with proper discovery.
>> Usually that means - open same config you used to start your "real" nodes.
>>
>> On Tue, May 30, 2017 at 8:45 AM, I PVP <i...@hotmail.com> wrote:
>>
>>> Alexey,
>>>
>>> Thanks for answering.
>>>
>>> How do I make  ignitevisorcmd.sh  see my “real” node(s) ?
>>>
>>> best,
>>>
>>> IPVP
>>>
>>> On May 29, 2017 at 10:39:41 PM, Alexey Kuznetsov (akuznet...@apache.org)
>>> wrote:
>>>
>>> Hi, IPVP.
>>>
>>> Yes,  ignitevisorcmd.sh starts internal node in "daemon" mode.
>>> This node is "invisible" for other nodes and doe not have caches data
>>> and does not participate in compute task executions.
>>>
>>> See: IgniteConfiguration#setDaemon javadocs for more info.
>>>
>>> On Sat, May 27, 2017 at 9:19 PM, I PVP <i...@hotmail.com> wrote:
>>>
>>>> Does ignitevisorcmd.sh starts the node or is it a management interface?
>>>>
>>>> Why ignitevisorcmd.sh behaves like if Ignite was not started and  does
>>>> not see the cache that was created?
>>>>
>>>> ignite.sh starts fine. But,  when I start ignitevisorcmd.sh and type
>>>> the open command  it asks me for the configuration file and  even informing
>>>> the same configuration file used to start ignite   ignitevisor  says:
>>>>  "Ignite node started OK”  ,  it shows 00:00:00 uptime and the cache
>>>> command says "(wrn) : No caches found."
>>>>
>>>> Ignite is being started with "ignite.sh config/ignite-config.xml”
>>>>
>>>> ignite-config.xml has the following content:
>>>>
>>>> -
>>>> 
>>>>
>>>> http://www.springframework.org/schema/beans;
>>>>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
>>>>xsi:schemaLocation="
>>>>http://www.springframework.org/schema/beans
>>>>http://www.springframework.org/schema/beans/spring-beans.xsd”>
>>>>
>>>> 
>>>>
>>>>   
>>>>  
>>>> 
>>>> 
>>>> 
>>>> 
>>>>  
>>>>   
>>>>
>>>> 
>>>>
>>>> 
>>>> -
>>>>
>>>> Thanks
>>>>  IPVP
>>>>
>>>>
>>>
>>>
>>> --
>>> Alexey Kuznetsov
>>>
>>>
>>
>>
>> --
>> Alexey Kuznetsov
>>
>
>


-- 
Alexey Kuznetsov

New version of Web Console released

[Alexey Kuznetsov]

Igniters!

I'd like to announce that we just pushed new version of Ignite Web Console to
master branch
 and redeployed the new version on GridGain infrastructure (https://console
.gridgain.com) where you can give it a try right a way.

NOTE: You may need to refresh page (F5 or Ctrl+R) in order to reload Web
Console.

*What's new:*
 * Support for Ignite 1.x / Ignite 2.0
   You can configure, query and monitoring  Ignite 1.x and Ignite 2.0 from
single Web Console.

 * Improved build with web pack

*Coming soon:*
* Notifications about Web Console updates!
  Web console will show banner with warning about upcoming updates.

* Support for Ignite 2.1

* Improved stack trace for SQL errors.

Stay tuned for updates!


-- 
Alexey Kuznetsov

Re: ignitevisor starting the node twice

[Alexey Kuznetsov]

You need to open configuration with proper discovery.
Usually that means - open same config you used to start your "real" nodes.

On Tue, May 30, 2017 at 8:45 AM, I PVP <i...@hotmail.com> wrote:

> Alexey,
>
> Thanks for answering.
>
> How do I make  ignitevisorcmd.sh  see my “real” node(s) ?
>
> best,
>
> IPVP
>
> On May 29, 2017 at 10:39:41 PM, Alexey Kuznetsov (akuznet...@apache.org)
> wrote:
>
> Hi, IPVP.
>
> Yes,  ignitevisorcmd.sh starts internal node in "daemon" mode.
> This node is "invisible" for other nodes and doe not have caches data and
> does not participate in compute task executions.
>
> See: IgniteConfiguration#setDaemon javadocs for more info.
>
> On Sat, May 27, 2017 at 9:19 PM, I PVP <i...@hotmail.com> wrote:
>
>> Does ignitevisorcmd.sh starts the node or is it a management interface?
>>
>> Why ignitevisorcmd.sh behaves like if Ignite was not started and  does
>> not see the cache that was created?
>>
>> ignite.sh starts fine. But,  when I start ignitevisorcmd.sh and type the
>> open command  it asks me for the configuration file and  even informing the
>> same configuration file used to start ignite   ignitevisor  says:  "Ignite
>> node started OK”  ,  it shows 00:00:00 uptime and the cache command says
>> "(wrn) : No caches found."
>>
>> Ignite is being started with "ignite.sh config/ignite-config.xml”
>>
>> ignite-config.xml has the following content:
>>
>> -
>> 
>>
>> http://www.springframework.org/schema/beans;
>>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
>>xsi:schemaLocation="
>>http://www.springframework.org/schema/beans
>>    http://www.springframework.org/schema/beans/spring-beans.xsd”>
>>
>> 
>>
>>   
>>  
>> 
>> 
>> 
>> 
>>  
>>   
>>
>> 
>>
>> 
>> -
>>
>> Thanks
>>  IPVP
>>
>>
>
>
> --
> Alexey Kuznetsov
>
>


-- 
Alexey Kuznetsov

Re: ignitevisor starting the node twice

[Alexey Kuznetsov]

Hi, IPVP.

Yes,  ignitevisorcmd.sh starts internal node in "daemon" mode.
This node is "invisible" for other nodes and doe not have caches data and
does not participate in compute task executions.

See: IgniteConfiguration#setDaemon javadocs for more info.

On Sat, May 27, 2017 at 9:19 PM, I PVP <i...@hotmail.com> wrote:

> Does ignitevisorcmd.sh starts the node or is it a management interface?
>
> Why ignitevisorcmd.sh behaves like if Ignite was not started and  does not
> see the cache that was created?
>
> ignite.sh starts fine. But,  when I start ignitevisorcmd.sh and type the
> open command  it asks me for the configuration file and  even informing the
> same configuration file used to start ignite   ignitevisor  says:  "Ignite
> node started OK”  ,  it shows 00:00:00 uptime and the cache command says
> "(wrn) : No caches found."
>
> Ignite is being started with "ignite.sh config/ignite-config.xml”
>
> ignite-config.xml has the following content:
>
> -
> 
>
> http://www.springframework.org/schema/beans;
>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
>xsi:schemaLocation="
>http://www.springframework.org/schema/beans
>http://www.springframework.org/schema/beans/spring-beans.xsd”>
>
> 
>
>   
>  
> 
> 
> 
> 
>  
>   
>
> 
>
> 
> -
>
> Thanks
>  IPVP
>
>


-- 
Alexey Kuznetsov

Re: Install ignite in single machine

[Alexey Kuznetsov]

Hi!

To start Ignite cluster you need to:
  1) copy ignite binary distributive on each machine.
  2) configure discovery, see
https://apacheignite.readme.io/docs/cluster-config


On Sun, May 14, 2017 at 8:42 PM, ? ? <zhaoju...@outlook.com> wrote:

> Dear all,
>
> I notice that /bin/ignite.sh will start ignite, and ignite will
> automatically discover each other.
>
> I have several machines in same subnet, and want to run ignite in each
> machine, not in cluster mode.
>
> To achieve this, how to start ignite using command? Many thanks.
>
> --
> *Sent From Zhao Jun's iPhone 8 Plus*
>



-- 
Alexey Kuznetsov

Re: CacheAbstractJdbcStore batch deleteAll bug.

[Alexey Kuznetsov]

Gordon,

I created https://issues.apache.org/jira/browse/IGNITE-5199

Would you like to contribute fix for that bug?

On Thu, May 11, 2017 at 12:43 PM, Gordon Reid (Nine Mile) <
gordon.r...@ninemilefinancial.com> wrote:

> Sorry, I don’t have time to produce a sample right now, but I can see that
> this bug still exists in ignite 2.0
>
>
>
> Just look in CacheAbstractJdbcStore.deleteAll
>
>
>
> You can see that delStmt never gets updated after it is first initialized
>
>
>
> Thanks,
>
> Gordon.
>
>
>
> *From:* Alexey Kuznetsov [mailto:akuznet...@apache.org]
> *Sent:* Thursday, 27 April 2017 6:50 PM
> *To:* user@ignite.apache.org
> *Subject:* Re: CacheAbstractJdbcStore batch deleteAll bug.
>
>
>
> Hi, Gordon.
>
>
>
> Do you have a reproducer we could debug?
>
>
>
> Thanks.
>
>
>
> On Wed, Apr 26, 2017 at 9:50 AM, Gordon Reid (Nine Mile) <gordon.reid@
> ninemilefinancial.com> wrote:
>
> Actually the fix will be a little more complicated, because the variable
> “em” has already been updated to the new type before the last batch has
> been executed.
>
>
>
> *From:* Gordon Reid (Nine Mile) [mailto:gordon.r...@ninemilefinancial.com]
>
> *Sent:* Wednesday, 26 April 2017 12:05 PM
> *To:* user@ignite.apache.org
> *Subject:* CacheAbstractJdbcStore batch deleteAll bug.
>
>
>
> Hi Guys,
>
>
>
> I think there is a problem in CacheAbstractJdbcStore.deleteAll
>
>
>
> I find that sometimes, I see messages like this
>
>
>
> [DEBUG] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Delete entries from db [cache=D9Cache, keyType=com.nmf.model.trading.TradeKey,
> cnt=2]
>
> [WARN ] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Batch deleteAll returned unexpected updated row count [table=public.
> nmfctrade, entry=RiskRuleKey [id=1], expected=1, actual=0]
>
> [WARN ] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Batch deleteAll returned unexpected updated row count
> [table=public.nmfctrade, entry=RiskRuleKey [id=2], expected=1, actual=0]
>
>
>
> Note the entity types are different!
>
>
>
> Also look at the attached image. You can see the statement is still
> targeting Trade, but our entity is now Position.
>
>
>
> You can see in the code, that the delStmt never gets refreshed, when
> changing over to a different entity type.
>
>
>
> for (Object key : keys) {
> Object keyTypeId = typeIdForObject(key);
>
> em = entryMapping(cacheName, keyTypeId);
>
> if (delStmt == null) {
> delStmt = conn.prepareStatement(em.remQry);
>
> currKeyTypeId = keyTypeId;
> }
>
> if (!currKeyTypeId.equals(keyTypeId)) {
> if (log.isDebugEnabled())
> log.debug("Delete entries from db [cache=" + 
> U.*maskName*(cacheName) +
> ", keyType=" + em.keyType() + ", cnt=" + prepared + "]");
>
> executeBatch(em, delStmt, "deleteAll", fromIdx, prepared, lazyKeys);
>
> fromIdx += prepared;
>
> prepared = 0;
>
> currKeyTypeId = keyTypeId;
>
> }
>
>
>
>
>
> I believe should be something like this
>
>
>
> for (Object key : keys) {
> Object keyTypeId = typeIdForObject(key);
>
> em = entryMapping(cacheName, keyTypeId);
>
> if (delStmt == null) {
> delStmt = conn.prepareStatement(em.remQry);
>
> currKeyTypeId = keyTypeId;
> }
>
> if (!currKeyTypeId.equals(keyTypeId)) {
> if (log.isDebugEnabled())
> log.debug("Delete entries from db [cache=" + 
> U.*maskName*(cacheName) +
> ", keyType=" + em.keyType() + ", cnt=" + prepared + "]");
>
> executeBatch(em, delStmt, "deleteAll", fromIdx, prepared, lazyKeys);
>
> fromIdx += prepared;
>
> prepared = 0;
>
> currKeyTypeId = keyTypeId;
>
> delStmt = conn.prepareStatement(em.remQry);
> }
>
>
>
> Thanks,
>
> Gordon.
>
>
>
>
>
> This email and any attachments are proprietary & confidential and are
> intended solely for the use of the individuals to whom it is addressed. Any
> views or opinions expressed are solely for those of the author and do not
> necessarily reflect those of Nine Mile Financial Pty. Limited. If you have
> received this email in error, please let us know immediately by reply email
> and delete from your system. Nine Mile Financial Pty. Limited. ABN: 346
> 1349 0252
>
>
>
>
>

New version of Web Console released.

[Alexey Kuznetsov]

Igniters!

I'd like to announce that we just pushed new version of Ignite Web Console to
master branch
 and redeployed the new version on https://console.gridgain.com where you
can give it a try right a way.

NOTE 1: You will need to download new version of web-agent.
NOTE 2: You may need to refresh page (F5 or Ctrl+R) in order to reload Web
Console.

What's new:

  * Multi-cluster support (see:
https://apacheignite-tools.readme.io/docs/multi-cluster-support).
  * Added support for "Kubernetes - IP finder" on Cluster Configuration
screen.
  * Improved import metadata from RDBMS - added support for table aliases.
  * Many minor improvements and bugfixes.

Stay tuned for updates!

---
Alexey Kuznetsov

Re: CacheAbstractJdbcStore batch deleteAll bug.

[Alexey Kuznetsov]

Hi, Gordon.

Do you have a reproducer we could debug?

Thanks.

On Wed, Apr 26, 2017 at 9:50 AM, Gordon Reid (Nine Mile) <
gordon.r...@ninemilefinancial.com> wrote:

> Actually the fix will be a little more complicated, because the variable
> “em” has already been updated to the new type before the last batch has
> been executed.
>
>
>
> *From:* Gordon Reid (Nine Mile) [mailto:gordon.r...@ninemilefinancial.com]
>
> *Sent:* Wednesday, 26 April 2017 12:05 PM
> *To:* user@ignite.apache.org
> *Subject:* CacheAbstractJdbcStore batch deleteAll bug.
>
>
>
> Hi Guys,
>
>
>
> I think there is a problem in CacheAbstractJdbcStore.deleteAll
>
>
>
> I find that sometimes, I see messages like this
>
>
>
> [DEBUG] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Delete entries from db [cache=D9Cache, keyType=com.nmf.model.trading.TradeKey,
> cnt=2]
>
> [WARN ] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Batch deleteAll returned unexpected updated row count [table=public.
> nmfctrade, entry=RiskRuleKey [id=1], expected=1, actual=0]
>
> [WARN ] 2017-04-26 11:08:54.097 [flusher-0-#31%null%] CacheJdbcPojoStore -
> Batch deleteAll returned unexpected updated row count
> [table=public.nmfctrade, entry=RiskRuleKey [id=2], expected=1, actual=0]
>
>
>
> Note the entity types are different!
>
>
>
> Also look at the attached image. You can see the statement is still
> targeting Trade, but our entity is now Position.
>
>
>
> You can see in the code, that the delStmt never gets refreshed, when
> changing over to a different entity type.
>
>
>
> for (Object key : keys) {
> Object keyTypeId = typeIdForObject(key);
>
> em = entryMapping(cacheName, keyTypeId);
>
> if (delStmt == null) {
> delStmt = conn.prepareStatement(em.remQry);
>
> currKeyTypeId = keyTypeId;
> }
>
> if (!currKeyTypeId.equals(keyTypeId)) {
> if (log.isDebugEnabled())
> log.debug("Delete entries from db [cache=" + 
> U.*maskName*(cacheName) +
> ", keyType=" + em.keyType() + ", cnt=" + prepared + "]");
>
> executeBatch(em, delStmt, "deleteAll", fromIdx, prepared, lazyKeys);
>
> fromIdx += prepared;
>
> prepared = 0;
>
> currKeyTypeId = keyTypeId;
>
> }
>
>
>
>
>
> I believe should be something like this
>
>
>
> for (Object key : keys) {
> Object keyTypeId = typeIdForObject(key);
>
> em = entryMapping(cacheName, keyTypeId);
>
> if (delStmt == null) {
> delStmt = conn.prepareStatement(em.remQry);
>
> currKeyTypeId = keyTypeId;
> }
>
> if (!currKeyTypeId.equals(keyTypeId)) {
> if (log.isDebugEnabled())
> log.debug("Delete entries from db [cache=" + 
> U.*maskName*(cacheName) +
> ", keyType=" + em.keyType() + ", cnt=" + prepared + "]");
>
> executeBatch(em, delStmt, "deleteAll", fromIdx, prepared, lazyKeys);
>
> fromIdx += prepared;
>
> prepared = 0;
>
> currKeyTypeId = keyTypeId;
>
> delStmt = conn.prepareStatement(em.remQry);
> }
>
>
>
> Thanks,
>
> Gordon.
>
>
>
>
>
> This email and any attachments are proprietary & confidential and are
> intended solely for the use of the individuals to whom it is addressed. Any
> views or opinions expressed are solely for those of the author and do not
> necessarily reflect those of Nine Mile Financial Pty. Limited. If you have
> received this email in error, please let us know immediately by reply email
> and delete from your system. Nine Mile Financial Pty. Limited. ABN: 346
> 1349 0252
>
>
>
>
>
> This email and any attachments are proprietary & confidential and are
> intended solely for the use of the individuals to whom it is addressed. Any
> views or opinions expressed are solely for those of the author and do not
> necessarily reflect those of Nine Mile Financial Pty. Limited. If you have
> received this email in error, please let us know immediately by reply email
> and delete from your system. Nine Mile Financial Pty. Limited. ABN: 346
> 1349 0252
>
>
>
>
>
> This email and any attachments are proprietary & confidential and are
> intended solely for the use of the individuals to whom it is addressed. Any
> views or opinions expressed are solely for those of the author and do not
> necessarily reflect those of Nine Mile Financial Pty. Limited. If you have
> received this email in error, please let us know immediately by reply email
> and delete from your system. Nine Mile Financial Pty. Limited. ABN: 346
> 1349 0252
>



-- 
Alexey Kuznetsov

Re: Index

[Alexey Kuznetsov]

Hi!

You may try to use
1) https://apacheignite.readme.io/docs/rest-api#cache-metadata

2) org.apache.ignite.internal.visor.cache.VisorCacheMetadataTask (or see
how it is implemented).
But, PLEASE NOTE, this is internal API and may be changed in future
versions of Ignite.


On Tue, Apr 18, 2017 at 12:42 AM, javastuff@gmail.com <
javastuff@gmail.com> wrote:

> Webconsole is the only way? Visor or JMX or logs or sample JAVA API.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Index-tp11969p12004.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Index

[Alexey Kuznetsov]

See attached screenshot - how to check indexes.

 



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Index-tp11969p11985.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Persistent store connection pool xml configuration

[Alexey Kuznetsov]

Hi,

May be this:
https://apacheignite.readme.io/docs/persistent-store#section-cachejdbcpojostore



On Fri, Apr 14, 2017 at 12:27 AM, waterg <jessie.jianwei@gmail.com>
wrote:

> Hello,
>
> I'm looking into using connection pool for persistent store and found the
> example below.
>
> https://github.com/apache/ignite/blob/master/examples/
> src/main/java/org/apache/ignite/examples/datagrid/store/jdbc/
> CacheJdbcStoreExample.java
>
> What would be equivalent configuration in xml?
>
> Thank you!
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Persistent-store-connection-pool-xml-configuration-
> tp11959.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Lots of cache creation become slow

[Alexey Kuznetsov]

Cédric,

Just, curious, what for do you need 2000 caches on single node? :)


On Wed, Apr 12, 2017 at 8:47 PM, ctranxuan <cedric.tranx...@streamdata.io>
wrote:

> Thanks a lot for the answer!
> We'll try to run tests with these hints.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Lots-of-cache-creation-become-slow-tp11875p11906.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Sort queries are slow

[Alexey Kuznetsov]

Sergi,

May be it is worth to also add this advice on [1] ?

[1] https://apacheignite.readme.io/docs/indexes


On Tue, Apr 4, 2017 at 4:58 PM, Sergi Vladykin <sergi.vlady...@gmail.com>
wrote:

> You should create a group index on (A, B) and rewrite the query the
> following way:
>
> select * from Test where A = ''  order by A, B
>
> Semantically it will be the same, but it will use index (A, B) for search
> and sorting.
>
> Sergi
>
> 2017-04-04 12:18 GMT+03:00 Anil <anilk...@gmail.com>:
>
>> HI,
>>
>> i have created a table with columns A and B. A is indexed column. and use
>> following queries
>>
>> 1. select * from Test where A = ''
>> 2. select * from Test where A = ''  order by B
>>
>> #1 is fast as it uses default sorting of indexed column A. But #2 is slow.
>>
>> Do you think creating index on B will speed up #2 query ? i tried that as
>> well and no luck.
>>
>> are there any ways to improve the performance of #2 ? please advise.
>>
>> Thanks
>>
>>
>


-- 
Alexey Kuznetsov

Re: [GridCachePartitionExchangeManager] Pending transaction deadlock detection futures

[Alexey Kuznetsov]

Hi ght230,

I think that Visor CMD should work in client mode, but it is not
implemented yet.
Please create issue in Ignite JIRA for that.

On Sat, Apr 1, 2017 at 1:41 PM, ght230 <ght...@163.com> wrote:

> I want to know should Visor CMD be worked in client mode or daemon mode?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/GridCachePartitionExchangeManager-Pending-transaction-
> deadlock-detection-futures-tp11362p11638.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: [GridCachePartitionExchangeManager] Pending transaction deadlock detection futures

[Alexey Kuznetsov]

Val,

>> Does anyone have an idea why client mode in Visor affects behavior? I
thought we already forced client mode there, no?

Visor CMD was NOT reworked to client mode.
So Visor CMD starts server node in daemon mode.


On Wed, Mar 29, 2017 at 2:28 AM, Valentin Kulichenko <
valentin.kuliche...@gmail.com> wrote:

> cross-posting to dev list.
>
> Guys,
>
> Does anyone have an idea why client mode in Visor affects behavior? I
> thought we already forced client mode there, no?
>
> Alexey, you should know the answer. Can you please take a look at this
> thread?
>
> -Val
>
>
> On Tue, Mar 28, 2017 at 7:02 AM, ght230 <ght...@163.com> wrote:
>
>> Yes,I use custom build.
>>
>> Today I tried to set Ignition.setClientMode(true) for command "open" of
>> the
>> visorcmd.
>>
>> It seems the visorcmd will not stuck the whole cluster again.
>>
>> Is there anything wrong in "ClientMode" of the visorcmd?
>>
>>
>>
>> --
>> View this message in context: http://apache-ignite-users.705
>> 18.x6.nabble.com/GridCachePartitionExchangeManager-Pending-t
>> ransaction-deadlock-detection-futures-tp11362p11501.html
>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>
>
>


-- 
Alexey Kuznetsov

Re: Load data to cache

[Alexey Kuznetsov]

Hi!

Could you tell us exact version of MS SQL server and exact version of JDBC
driver?
And Ignite version.
We will try to reproduce your issue.

On Tue, Mar 28, 2017 at 6:37 PM, kavitha <kavithamr...@gmail.com> wrote:

> SQL database
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Load-data-to-cache-tp11394p11493.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

New version of Web Console released.

[Alexey Kuznetsov]

Igniters!

I'd like to announce that we just pushed new version of Ignite Web Console
to master branch
 and redeployed the new version on GridGain infrastructure (
https://console.gridgain.com) where you can give it a try right a way.

NOTE: You may need to refresh page (F5 or Ctrl+R) in order to reload Web
Console.

What's new:

  * Build with WebPack 2.
  * Added support for "Enforce join order" on Queries screen.
  * Improved errors handling on Queries screen. Now in case of error you
will see message from root cause.
  * Added "Running queries" screen that will show "long running queries"
and ability to cancel selected queries.
  * Added tracking of Web Console features usage on "Admin Panel" screen,
descibed here: https://apacheignite-tools.readme.io/docs/usage-tracing

-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com

Re: Scala API

[Alexey Kuznetsov]

Hi,

If you are talking about Scalar module, it is a kind of deprecated.
Ignite has nice API that could be easily used from directly Scala without
any problems.

On Wed, Feb 22, 2017 at 6:22 PM, timothy <timothy.y@newegg.com> wrote:

> Hi Guys:
>
> just want to know the Scala api for ignite, is it stable for
> production,
> is it always updated when ignite update ?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Scala-API-tp10793.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: monitoring issue -Connection to Ignite Node is not established

[Alexey Kuznetsov]

Hi!

Are you sure that you copied /libs/optional/ignite-rest-http to /libs
folder?


On Tue, Jan 24, 2017 at 8:57 PM, minisoft_rm <minisoft...@hotmail.com>
wrote:

> dear experts:
>
> I am using ignite 1.8 with agent 1.7.4
>
> after start the agent with default properties, I can import local db schema
> things into webconsole.
>
> but... the "monitoring clusters" function doesn't work. like below:
>
> in command line:
> [21:50:56,754][INFO ][EventThread][RestHandler] Failed connect to node and
> execute REST command
> [uri=http://localhost:8080/ignite?mtr=true=top=true]
>
>
> in browser:
> Connection to Ignite Node is not established
>
> Failed connect to node and execute REST command.
>
>
> I surely enjoyed this monitoring feature in previous version.. but this new
> 1.8 with 1.7.4 doesn't work.
>
> please tell me what changes product team make? thanks~
>
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/monitoring-issue-Connection-to-Ignite-Node-is-not-
> established-tp10216.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Error while writethrough operation in Ignite

[Alexey Kuznetsov]

Hi!

1) What version of Ignite are you using?
2) Oracle version? Oracle JDBC driver version?
3) It is possible to share with us Table create script?
We will try to reproduce. I see in logs: Caused by:
java.sql.SQLSyntaxErrorException:
ORA-00927: missing equal sign
May be there a bug in OracleDialect.

On Thu, Dec 22, 2016 at 7:22 PM, rishi007bansod <rishi007ban...@gmail.com>
wrote:

> But I have used CacheConfig file generated by schema import, what might be
> problem
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Error-while-writethrough-operation-
> in-Ignite-tp9696p9701.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: alter cache configuration after cache created.

[Alexey Kuznetsov]

Hi, Shawn Du!

No, it is not possible.

You need to destroy cache a re-create with new configuration.

On Mon, Dec 19, 2016 at 9:33 AM, Shawn Du <shawn...@neulion.com.cn> wrote:

> Hi,
>
>
>
> It is possible to alter cache configuration after cache created and
> running?
>
>
>
> Thanks
>
> Shawn
>



-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com