Re: Index not getting applied

2019-03-06 Thread ashishb888
You can make good use of Index Hints. e.g. SELECT * FROM Person USE INDEX(index_age) WHERE salary > 15 AND age < 35; -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Index not getting applied

2019-03-06 Thread mausam
Hi, I am using Ignite Cache with Persistence. While execution over large tables, i noticed the below message repeatedly getting logged. [WARNING][query-#100%IGNITE%][IgniteH2Indexing] Query execution is too long [time=4863 ms, sql='SELECT PUBLIC.__Z0._KEY __C0_0, PUBLIC.__Z0._VAL __C0_1 FROM PUBL

Ignite client connection issue "Cache doesn't exists ..." even though cache severs and caches are up and running.

2019-03-06 Thread Hemasundara Rao
Hi, We have a Micro Service client to ignite cluster throwing exception "Cache doesn't exists ..." even though cache severs and caches are up and running. Could you please know us how to resolve this issue? Thanks and Regards, Hemasundara Rao Pottangi | Senior Project Leader [image: HotelHub-

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

2019-03-06 Thread Chandni
To add the java type configuration I am currently using is java.sql.TYPES.TIMESTAMP And java.sql.Timestamp -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

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

2019-03-06 Thread Chandni
Hi I am using Sybase as third party persistence and using XML to configure cache store factory. Sybase datetime displays date by default format : /mm/dd HH:mm:ss Am/pm Whereas Ignite is expecting a different format with nanoseconds. This is causing BinaryMarshaller to fail in deserialising

Re: Cannot exchange messages between two nodes.

2019-03-06 Thread Ropugg
Thanks all. I resolve it, since the second node didn't remoteListen by an inner logic. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: queries, we are evaluating to use Apache Ignite as caching layer on top of underlying Cassandra database.

2019-03-06 Thread Prasad Bhalerao
Just out of curiosity how are you planning to load 1 TB of data in cache, using datastreamer or cachestore? What's the expected time to load cache? Since you are not keeping back up, how are you going to handle the situation when any of the node crashes? This can happen in prod env, so what is the

Re: Exception on node startup: Attempted to release write lock while not holding it

2019-03-06 Thread Dmitry Lazurkin
Thank you for reply, Ilya. > Have you tried to start this on Nightly Build? Can you try that? No, on 2.7.0#20181130-sha1:256ae401. I will try Nightly Build. > If it still would not work, can you share your DB+wal files? I think yes, but it's 15 GB. On 3/6/19 6:59 PM, Ilya Kasnacheev wrote: > He

Re: Exception on node startup: Attempted to release write lock while not holding it

2019-03-06 Thread Ilya Kasnacheev
Hello! Have you tried to start this on Nightly Build? Can you try that? If it still would not work, can you share your DB+wal files? Regards, -- Ilya Kasnacheev вт, 5 мар. 2019 г. в 20:37, Dmitry Lazurkin : > Ignite version: 2.7.0#20181130-sha1:256ae401 > > >

Re: BLOB with JDBC Driver

2019-03-06 Thread Taras Ledkov
Hi, But SQL type BLOB isn't supported by Ignite. Please use BINARY SQL type. 06.03.2019 18:40, Taras Ledkov пишет: Hi, The JDBC Blob is supported by JDBC v2 driver (thick driver based on Ignite client node). Thin JDBC driver hasn't supported Blob yet. 06.03.2019 13:50, KR Kumar пишет: Hi -

Re: BLOB with JDBC Driver

2019-03-06 Thread Taras Ledkov
Hi, The JDBC Blob is supported by JDBC v2 driver (thick driver based on Ignite client node). Thin JDBC driver hasn't supported Blob yet. 06.03.2019 13:50, KR Kumar пишет: Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a blob into my cache table through jdbc? Thanx and

4 Apache Events in 2019: DC Roadshow soon; next up Chicago, Las Vegas, and Berlin!

2019-03-06 Thread Rich Bowen
Dear Apache Enthusiast, (You’re receiving this because you are subscribed to one or more user mailing lists for an Apache Software Foundation project.) TL;DR: * Apache Roadshow DC is in 3 weeks. Register now at https://apachecon.com/usroadshowdc19/ * Registration for Apache Roadshow Chicago is

Re: Re: TPS does not increase even though new server nodes added

2019-03-06 Thread Ilya Kasnacheev
Hello! I don't see very much going on here. Which one of those dumps are client which generate load? How do you generate it? Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 04:29, yu...@toonyoo.net : > you can see the full thread dump in the attarchment,the filename is > dump.zip > > ---

Re: Cannot exchange messages between two nodes.

2019-03-06 Thread Ilya Kasnacheev
Hello! Can you make a small reproducer project, share it with us? Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 16:08, Ropugg : > The two nodes have the same subscriber. > The only difference is the order of starting node. > The first started node, we call it as Node1, the second started n

Re: queries, we are evaluating to use Apache Ignite as caching layer on top of underlying Cassandra database.

2019-03-06 Thread Ilya Kasnacheev
Hello! You can try to see how many entries will fit in your single node (enable page eviction, see how much you can get before eviction is started), then scale it up after adding some buffer space. Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 12:28, Navneet Kumar : > Ilya, > Thanks for yo

Re: Connection to cluster failed. Error: Latest topology update failed.

2019-03-06 Thread Ilya Kasnacheev
Hello! It might take some time to rewind WAL. Consider starting it with -v (or -DIGNITE_QUIET=false) Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 16:26, James Wang 王升平 (edvance CN) < james.w...@edvancesecurity.com>: > Hi Support, > > > > My lab VM were shutdown by lack of power. But After

Re: Performance degradation in case of high volumes

2019-03-06 Thread Ilya Kasnacheev
Hello! I'm afraid that at this point even indexes do not fit in RAM so every insert needs to get index pages from disk, change them and put them back to make room for newer ones. Please consider having larger DataRegions. Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 16:26, Antonio Conforti

Re: BLOB with JDBC Driver

2019-03-06 Thread Ilya Kasnacheev
Hello! I don't think we support blobs at the moment. Use setBytes to store data as byte[]. Regards, -- Ilya Kasnacheev ср, 6 мар. 2019 г. в 13:58, KR Kumar : > Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a > blob > into my cache table through jdbc? > > Thanx and Rega

Connection to cluster failed. Error: Latest topology update failed.

2019-03-06 Thread edvance CN
Hi Support, My lab VM were shutdown by lack of power. But After I restart them, I find the console hang at [21:26:43] Topology snapshot [ver=35, locNode=2931204b, servers=3, clients=0, state=ACTIVE, CPUs=12, offheap=12.0GB, heap=3.0GB] [21:26:43] ^-- Baseline [id=3, size=3, online=3, offline=

Re: Performance degradation in case of high volumes

2019-03-06 Thread Antonio Conforti
Hello Ilya, thanks for reply. For answer to your questions today i runned again a test that i stopped at about 22 millions of entries: a) the approximate hardware and data region config used in the test: 2 hosts each with: Processor total : 2 Processor: 0 Name : Intel Xeon

Re: Cannot exchange messages between two nodes.

2019-03-06 Thread Ropugg
The two nodes have the same subscriber. The only difference is the order of starting node. The first started node, we call it as Node1, the second started node is Node2. The Node1 send a message, the Node2 will handle it as expected in remoteListen(@Nullable Object topic, IgniteBiPredicate p) But t

BLOB with JDBC Driver

2019-03-06 Thread KR Kumar
Hi - I trying out JDBC driver with ignite SQL tables. How do i insert a blob into my cache table through jdbc? Thanx and Regards, KR Kumar -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Backup make DataStreamer performance decreased a lot.

2019-03-06 Thread Ilya Kasnacheev
Hello! So I have re-ran it with backup. 2 nodes with 1 backup will load 15M entries slightly faster than 1 node which loads 30M entries without backups. So I would say that having backups is actually slightly faster. However, storing 15M entries without backups on 1 node is still 4-5x faster.

Re: queries, we are evaluating to use Apache Ignite as caching layer on top of underlying Cassandra database.

2019-03-06 Thread Navneet Kumar
Ilya, Thanks for your quick response. I have gone through the capacity planning link shared by you. 1,000,000,000 Total objects(Records) 1,024 bytes per object (1 KB) 0 backup 4 nodes Total number of objects X object size (only primary copy since back up is set 0. Better remove the back up propert

Re: Re: TPS does not increase even though new server nodes added

2019-03-06 Thread c c
HI , We have provide thread dumps from all client and server. Would you mind look at it ? thanks very much. yu...@toonyoo.net 于2019年3月6日周三 上午9:29写道: > you can see the full thread dump in the attarchment,the filename is > dump.zip > > -- > yu...@toonyoo.net > >