RE: Apache Ignite & unixODBC and truncating text

2018-01-08 Thread Alexey Popov
Hi Bagsiur, It is some mono lib error below, not a user-code. Can you share a simple code reproducer? Just to see the order of actions in your code. Thank you, Alexey From: bagsiur Sent: Tuesday, January 9, 2018 10:36 AM To: user@ignite.apache.org Subject: Re: Apache Ignite & unixODBC and trun

Re: JDBC thin client load balancing and failover support

2018-01-08 Thread rizal123
Hi Val, According to this ticket 'IGNITE-7029'. How long it will be *Live*? At least tell me the estimated time? Because I have the same problem, about failover and Jdbc thin can access multiple Node (IP Address). And I need to go to POC. regards, -Rizal -- Sent from: http://apache-ignite-u

Re: Apache Ignite & unixODBC and truncating text

2018-01-08 Thread bagsiur
So, I use Apache Ignite in 2.3.0 version. Im not C# programmer but I compile attached C# example by mono: mcs -out:odbcvarchar.exe -r:System.dll -r:System.Data.dll odbcvarchar.cs And after when I run it I have fallowing errors: [ERROR] FATAL UNHANDLED EXCEPTION: System.EntryPointNotFoundExcepti

Re: How to make full use of network bandwidth?

2018-01-08 Thread Michael Jay
Thank you, Alexey. I'll try you advice and let you know the result later. Thanks again. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Best practice Apache Ignite Data-Grid with Java EE application

2018-01-08 Thread vkulichenko
Hi Franz, Running an Ignite client node embedded into an application would be the best way to interact with the cluster. You will have all the APIs available and also it's the preferred option from performance standpoint. Ignite already has thread pool pre configured, there is no need to specify

Re: Limit cache size ?

2018-01-08 Thread vkulichenko
Ignite stores data in off-heap memory, so you can't limit the number of entries, but you can limit the amount of memory allocated for caches. This is done via data region configuration: https://apacheignite.readme.io/docs/memory-configuration -Val -- Sent from: http://apache-ignite-users.70518.

Why does Ignite de-allocate memory regions ONLY during shutdown?

2018-01-08 Thread John Wilson
Hi, I was looking at the UnsafeMemoryProvide and it looks to me that allocated direct memory regions are deallocated only during shutdown. https://github.com/apache/ignite/blob/c5a04da7103701d4ee95910d90ba786a6ea5750b/modules/core/src/main/java/org/apache/ignite/internal/mem/unsafe/UnsafeMemoryPr

Limit cache size ?

2018-01-08 Thread Mikael
Hi! Is there any way I can limit the number of items in a cache ? I know the JCache API does not support it, only the time based expiration, but using that mean that a cache can grow a lot if it gets fed a lot of items in a short time, something like the LRU eviction but that deletes older it

Protect Ignite clusters from Meltdown and Spectre

2018-01-08 Thread Denis Magda
Make sure your Ignite clusters are protected from the fierce vulnerabilities that rocked the world: https://blogs.apache.org/ignite/entry/protecting-apache-ignite-from-meltdown — Denis

Best practice Apache Ignite Data-Grid with Java EE application

2018-01-08 Thread Franz Mathauser
hello @all, i'm currently evaluating some data-grid solutions to replace my data-backend. i want to use apache ignite as backend data-grid to serve data within a javaee application. is the apache ignite native client sutable to integrate the data-grid with the javaee application? which threadpoo

Re: Ignite work directory usage?

2018-01-08 Thread ilya.kasnacheev
Hello Denis! There seems to be cases where matching workDir for different nodes (including client nodes) will cause problems: http://apache-ignite-users.70518.x6.nabble.com/MarshallerContextImpl-Failed-to-write-class-name-to-file-td18439.html There, on Windows, two nodes try to update binary mar

RE: Exception when connecting to cache / table.

2018-01-08 Thread Thomas Isaksen
Hi Ilya! Thank you that was it. I can connect now. Awesome product! Regards -- Thomas Isaksen From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com] Sent: mandag 8. januar 2018 15.07 To: user@ignite.apache.org Subject: Re: Exception when connecting to cache / table. Hello Thomas! You should

Re: Exception when connecting to cache / table.

2018-01-08 Thread Ilya Kasnacheev
Hello Thomas! You should not supply cache configuration to access caches created by DDL. It's neither required nor useful. Just use ignite.cache("testCache"); - by name. You can always invoke CREATE IF NOT EXISTS to ensure that cache indeed exists. Regards, -- Ilya Kasnacheev 2018-01-08 16:3

Re: Date type field in select query is returning wrong value when Time zones of Ignite Client and Server are different

2018-01-08 Thread Ilya Kasnacheev
Hello! I was able to reproduce the behaviour that you are describing. I have suspicion that it has to do with separate handling of date types in H2, which is used in Ignite for SQL queries. I will investigate this further, see if there are work-arounds. Regards, -- Ilya Kasnacheev 2018-01-02

Exception when connecting to cache / table.

2018-01-08 Thread Thomas Isaksen
I have created my first TABLE in Ignite and I am trying to connect to it but I am getting this error message: class org.apache.ignite.IgniteException: Cache configuration mismatch (local cache was created via Ignite API, while remote cache was created via CREATE TABLE I'm not exactly sure what

Re: How to make full use of network bandwidth?

2018-01-08 Thread Alexey Popov
Hi Michael, Did you try non-default parameters for 1) socketSendBuffer and socketReceiveBuffer [1] in JDBC connection string? 2) socketSendBufferSize and socketReceiveBufferSize [2] in Ignite server node configuration for SqlConnectorConfiguration? Please change them to 128k and make a try. JDB

Re: Force flush of IGFS to secondary file system in DUAL_ASYNC mode

2018-01-08 Thread ilya.kasnacheev
Hello! After reviewing IGFS code, I think that you can do the following: You should save all file paths that are being migrated, and then call await(collectionWithAllFilePaths) on IgfsImpl. If it's a huge number of files, I imagine you can do this in batches. It will do the same synchronous wait

Re: off heap memory usage

2018-01-08 Thread Alexey Popov
Hi Colin, Unfortunately, you can't get the exact off-heap size. There are several tickets here https://issues.apache.org/jira/browse/IGNITE-6814 https://issues.apache.org/jira/browse/IGNITE-5583 http://apache-ignite-users.70518.x6.nabble.com/Cache-size-in-Memory-td17226.html You are using (page

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread kotamrajuyashasvi
Hi In Ignite ODBC all operations are sql based and as you mentioned sql transactions feature is not available yet. So cannot use it. So just exploring all light weight C++ client options available which support Ignite Transactions. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread Evgenii Zhuravlev
Right now, this client implemented only for .NET, but it's not even released yet. I'm not sure about transactions since design document doesn't contain any information about it. BTW, why you don't want to use ODBC from C++? 2018-01-08 13:13 GMT+03:00 kotamrajuyashasvi : > Hi > > according to >

Re: java.lang.IllegalStateException: Cache has been closed:

2018-01-08 Thread Alexey Popov
Hi Raj, IgniteCache implements AutoCloseable interface. [1] You can't access it once IgniteCache.close() is called (implicitly via try-with-resource or explicitly). [1] https://docs.oracle.com/javase/tutorial/essential/exceptions/tryResourceClose.html Thanks, Alexey -- Sent from: http://apac

Re: Connection problem between client and server

2018-01-08 Thread Jeff Jiao
Hi Denis, We think the problem is when a client connect to an existing cluster, server node will send the attributes of all the nodes in the cluster(Servers & Clients) to that new client. it will be a lot of data here... We may also have problems for our network configuration, we are still invest

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread kotamrajuyashasvi
Hi according to https://cwiki.apache.org/confluence/display/IGNITE/IEP-9+Thin+Client+Protocol we can perform cache operations like get(),put() etc using thin client protocol which uses tcp socket communication with the Ignite server. I would like to know if similarly we can send a request to sta

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread Evgenii Zhuravlev
Could you tell, what do you understand as ignite Thin Client Protocol? Evgenii 2018-01-08 12:39 GMT+03:00 kotamrajuyashasvi : > Hi > > Thanks for your response. > I would like to know if Transaction operations on Ignite cache at key-value > level(not SQL) can be performed using the Thin Client P

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread kotamrajuyashasvi
Hi Thanks for your response. I would like to know if Transaction operations on Ignite cache at key-value level(not SQL) can be performed using the Thin Client Protocol. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Apache Ignite & unixODBC and truncating text

2018-01-08 Thread Alexey Popov
Hi Bagsuir, What Ignite version are you using? Could you please share a reproducible example of the issue you have? Or can you try the C# example attached (VS 2017)? Thank you, Alexey odbcvarchar.cs -- Sent from: ht

Re: Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread Evgenii Zhuravlev
Hi, Transactional SQL is not available yet, it will be fully available when this ticket will be implemented: https://issues.apache.org/jira/browse/IGNITE-3478 Evgenii 2018-01-08 12:12 GMT+03:00 kotamrajuyashasvi : > Hi > > I would like to perform Ignite Transaction operations from a C++ program

Transaction operations using the Ignite Thin Client Protocol

2018-01-08 Thread kotamrajuyashasvi
Hi I would like to perform Ignite Transaction operations from a C++ program using the Ignite Thin Client Protocol. Is it possible to do so ? If this feature is not available now, will it be added in future ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/