Question about baseline topology.

Hi,I'm puzzled after testing baseline topology. Here is my experiment: 1.Start a node A with persistence enabled and use it as a database. 2.Add data to a table with replicated template. 3.Start node B to join A. 4.Add B to baseline. 5.Count data from node B by jdbc.The result is correct. 6.Shut

Re: Very slow to execute batch merge into statement .

Thanks for reply.I need to use merge into statement because my write operation contains insert and update both.How can I escape this trap? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Very slow to execute batch merge into statement .

Hello. My scenario is not so complicated.Each key of my data is unique in a batch write(update) operation.I do select operation after write.And these batch operations are serial(write->select->write->select...).So I do not care consistency and only care run time of one batch . I will try your

Re: Very slow to execute batch merge into statement .

Thanks for reply.I need to use merge into statement because my write operation contains insert and update both.How can I escape this trap? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Very slow to execute batch merge into statement .

Hi,I do a test to verify write performance of ignite.My test data set has 6000 records.Each record has 10 columns.It takes 160 seconds to batch write into Ignite table using "merge into" command while it only takes 3 seconds when use "insert into" command.Why merge into statement is so slow?

My cluster can't activate after restart

Hi. I have a cluster which has 2 data nodes of version 2.6.I use it as a database with persistence.It stores tens of millions size data and all data are replicated.I try to recover it after one node failed but I still can not operate on it by jdbc thin connection. So I try to do a full cluster

Re: My cluster can't activate after restart

) at org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body0(GridCachePartitionExchangeManager.java:2419) ... 3 more yangjiajun wrote > Hi. > > I have a cluster which has 2 data nodes of version 2.6.I use it as a > database with persistence.It stores tens of millio

Re: My cluster can't activate after restart

I find an exception message after retries. class org.apache.ignite.IgniteCheckedException: Cannot find metadata for object with compact footer: -1434421210 at org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7307) at

My cluster can't activate after restart

Hi. I have a cluster which has 2 data nodes of version 2.6.I use it as a in-memory database.It stores tens of millions size data and all data are replicated.I try to recover it after one node failed but I still can not operate on it by jdbc thin connection. So I try to do a full cluster restart

Why Ignite use so many heap space?

HI. I have an ignite node which is version 2.6 and has fixed 12GB heap memory and 30GB data region.I use it as a database with persistence.It uses 90%-95% of heap memory when my application is busy(My application uses jdbc thin connection).And it still uses 80%-85% of heap memory after I stop my

Re: My cluster can't activate after restart

Hi, 1)JDBC thin client becomes not work after one node fails.I think the cause is my node uses too many heap space and jvm pause too much time.I was doing write performance test at that time. 2)I use control.sh script to active the cluster,but it does not exit . 3)Yes.I use persistence. 4)I

Re: Why Ignite use so many heap space?

rbage generated, there is not much you can do about that if > it's not your own code that generates the garbage, Ignite is not bad and > with the cache keys and values and even index of heap it should work > fine, but i guess it all depends on what your application do. > > Mikael &

Re: Why Ignite use so many heap space?

d, there is not much you can do about that if > it's not your own code that generates the garbage, Ignite is not bad and > with the cache keys and values and even index of heap it should work > fine, but i guess it all depends on what your application do. > > Mikael > > Den 2018

IgniteSparkSession exception:Ignite instance with provided name doesn't exist. Did you call Ignition.start(..) to start an Ignite instance? [name=null]

I use IgniteSparkSession to excute spark sql but get an exception:org.apache.ignite.IgniteIllegalStateException: Ignite instance with provided name doesn't exist. Did you call Ignition.start(..) to start an Ignite instance? [name=null] My test case runs well when I run spark in local mode,but it

Re: IgniteSparkSession exception:Ignite instance with provided name doesn't exist. Did you call Ignition.start(..) to start an Ignite instance? [name=null]

The configuration is from:https://github.com/apache/ignite/blob/master/examples/config/example-default.xml. The code runs well with spark local[*].But it throws exception when I run it with my spark standalone cluster which has a master node and a worker node.The exception is in the sql

Re: Ouch! Argument is invalid: Cache name must not be null or empty.

> not be null" and that really the problem that you faced, just define cache > name property to resolve this issue. > > Evgenii > > > чт, 27 дек. 2018 г. в 22:28, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I use ignite 2.6 as a d

Re: Strange issue while call ddl

Hello.Community. Any update about this issue?Do you consider it as an issue or not? I may consider this issue as a bug.Because blocked drop table operations can cause many strange issues like this one. I notice that ignite 2.8 is implementing queries management feature.Is that true? Maybe this

Re: Strange issue while call ddl

Hello. I experiment on Ignite 2.7.The issue still appears. Denis Magda-2 wrote > Hello, > > Is the same issue reproduced on Ignite 2.7? There were a lot of > optimizations and fixes pertaining DDL. > > -- > Denis > > > On Sat, Jan 5, 2019 at 8:23 AM yangjia

Re: Concurrent merge into operations cause critical system error on ignite 2.7 node.

o! > > I can see multiple "Failed to process selector key" errors in your log. > Are > you sure that your nodes can communicate via network freely and without > delay? > > Regards, > -- > Ilya Kasnacheev > > > ср, 16 янв. 2019 г. в 10:21, yangjiajun &

Data streamer has been closed.

Hello. I do test on a ignite 2.6 node with persistence enabled and get an exception: Exception in thread "main" java.sql.BatchUpdateException: class org.apache.ignite.IgniteCheckedException: Data streamer has been closed. at

Re: Concurrent merge into operations cause critical system error on ignite 2.7 node.

er project which would reliably show this > behavior? > > Regards, > -- > Ilya Kasnacheev > > > ср, 16 янв. 2019 г. в 15:37, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> Thanks for reply.I think these "Failed to process selector

Re: Data streamer has been closed.

Regards, > -- > Ilya Kasnacheev > > > ср, 16 янв. 2019 г. в 14:14, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I do test on a ignite 2.6 node with persistence enabled and get an >> exception: >> >> Exception in thread

Is there a way to allow overwrite when set streaming on?

Hello. We can set streaming on while insert data to ignite using sql.I want to enable data overwrite in this mode.Is it possible? https://apacheignite-sql.readme.io/docs/set https://apacheignite.readme.io/docs/data-streamers#section-allow-overwrite -- Sent from:

Re: Concurrent merge into operations cause critical system error on ignite 2.7 node.

Hello. Please see the logs. ignite-8bdefd7a.zip <http://apache-ignite-users.70518.x6.nabble.com/file/t2059/ignite-8bdefd7a.zip> ilya.kasnacheev wrote > Hello! > > Can you provide logs? > > Regards, > -- > Ilya Kasnacheev > > > вс, 13 янв. 2019 г.

Re: Data streamer has been closed.

eliably? > > Regards, > -- > Ilya Kasnacheev > > > чт, 17 янв. 2019 г. в 05:18, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> Thanks for reply.Unfortunately,I still get the exception after running my >> test on 2.7 for several times.

Does set streaming off command flush data?

Hello. The ignite's doc says we should close the JDBC/ODBC connection so that all data is flushed to the cluster while use streaming mode.Does set streaming off command do the same so that we can reuse the connection? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Strange issue while call ddl

Hello.Sorry for so late to reply to you. I think I reproduce this issue.Here are my reproduce steps: 1.start a version 2.6 node with persistence enabled. 2.create 2 tables with "template=replicated". 3.Insert data to 2 tables. 4.Open a connection to make a long time query targeting on first

Failed to initialize wal (work directory contains incorrect number of segments) [cur=357, expected=10]

Hello. I want to disable wal archiving by setting WAL path and the WAL archive path to the same value. https://apacheignite.readme.io/docs/write-ahead-log I make this change and then success restart my node first time.But I get an exception when I restart my node second time.Is my change a

Re: Failed to initialize wal (work directory contains incorrect number of segments) [cur=357, expected=10]

aealexsandrov wrote > Hi, > > What is the version of Ignite you use? > > Did you set the walPath to the directory where before was walArchivePath? > > BR, > Andei > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Sent from:

Re: Failed to initialize wal (work directory contains incorrect number of segments) [cur=357, expected=10]

Hello.Thanks for your reply. I use version 2.6. I changed the walArchivePath to the directory where before was walPath. So the correct operation is to set the walPath to the directory where before was walArchivePath? aealexsandrov wrote > Hi, > > What is the version of Ignite you use? > >

Re: Failed to initialize wal (work directory contains incorrect number of segments) [cur=357, expected=10]

Hello. I only started one node. Here is my config file: example-default.xml aealexsandrov wrote > No, > > I just try to get the details and reproduce the issue. Possible there is > an > issue here. I will

Sql join cause memory exhausted

Hello. I do a simple sql join operation on a ignite node which is version 2.6 and has 22GB heap memory and 22 GB off-heap memory.I also enable persistence.The query exhausted ignite's heap memory quickly.How can I overcome this situation. Here is my query: explain SELECT t2.*,

Re: Sql join cause memory exhausted

L Queries. > https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-result-set-lazy-loading > Then, be careful to process data in small batches and avoid holding on to > large subsets of result set. > > Regards, > -- > Ilya Kasnacheev > > >

Re: Ignite can't activate

activate.Then you will see the exception. yangjiajun wrote > Hello. > My ignite can't activate after restart.I only have one node which is ver > 2.6.The exception cause ignite can't activate is : > > [14:18:05,802][SEVERE][exchange-worker-#110][GridCachePartitionExchangeManager] &

Ignite can't activate

Hello. My ignite can't activate after restart.I only have one node which is ver 2.6.The exception cause ignite can't activate is : [14:18:05,802][SEVERE][exchange-worker-#110][GridCachePartitionExchangeManager] Failed to wait for completion of partition map exchange (preloading will not start):

Drop table operation should be first priority?

Hello. I find that long time queries will block drop table operation.In my opinion,drop table operation should be first priority.All operations target on the tables that are going to drop should stop because these operations make no sense. Reproducer: 1.Create a table and put some data to it.

Re: Failed to fetch SQL query result

issue. Hello! Why do you have setQueryTimeout here? What happens if you take it off? Regards, -- Ilya Kasnacheev ср, 5 дек. 2018 г. в 09:17, yangjiajun <1371549332@>: -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Failed to fetch SQL query result

pen every time? If so, which is the # of row on which it will > happen? > > Regards, > -- > Ilya Kasnacheev > > > вт, 27 нояб. 2018 г. в 10:09, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I did a scan query on a table which has 8w r

Re: Failed to fetch SQL query result

rameter to your query, > such > as WHERE id > ?, and pass something like -1 to bind to this parameter, > which should prevent the issue from occurring. > > Regards, > -- > Ilya Kasnacheev > > > ср, 5 дек. 2018 г. в 16:21, yangjiajun < > 1371549332@

Is there any way to speed up delete data or drop table?

Hello. We need to fully sync data from mysql to ignite periodicity.Thus we need to clear data in ignite first.Ignite does not support truncate statement and its drop table statement sometimes takes long time.It's also very slow to delete all data in ignite's tables or caches.Is there any way to

Re: Failed to fetch SQL query result

an you provide logs from your nodes prior to seeing this exceptions? > > Note that in a distributed system, you can expect to see this problem > sometimes, i.e. to see a large lazy result set fail in mid-iteration due > to > some changes in the cluster. I'm not sure if there's nothim

Re: In which case will ignite run following sql?

do you see something like that? > > Evgenii > > чт, 22 нояб. 2018 г. в 15:13, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I found a strange sql in ignite logs.I didn't find such sql in my >> application. The table contains about 7 million data and suc

Re: In which case will ignite run following sql?

u see something like that? > > Evgenii > > чт, 22 нояб. 2018 г. в 15:13, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I found a strange sql in ignite logs.I didn't find such sql in my >> application. The table contains about 7 million d

Re: Does ignite keep loading result when the jdbc thin connection is dead?

? ezhuravlev wrote > Hi, > > What do you mean by "Ignite does not release memory"? What kind of memory > it still consume? Do you mean heap? > > Evgenii > > чт, 22 нояб. 2018 г. в 15:55, yangjiajun < > 1371549332@ >>: > >> Hello. >

Re: Strange issue while call ddl

We can not do update operations either.But select queries are ok. yangjiajun wrote > I have a ignite cluster which is version 2.6 and has two nodes.I can't do > any > ddl operations on it since today.The cluster responses " Table already > exists" when I call create tab

Strange issue while call ddl

I have a ignite cluster which is version 2.6 and has two nodes.I can't do any ddl operations on it since today.The cluster responses " Table already exists" when I call create table statement to create a new table but it response "Table doesn't exist" when I call drop table statement.When I try to

Long activate time with tens of millions data

I have a ignite node which is version 2.6.I use it as a database.It stores tens of millions data in about 150 tables.Every time I try to reactivate after restart,it takes very long time.But the cpu is very low.Is there any way to improve it? -- Sent from:

Re: Strange issue while call ddl

The cluster recovered after I killed a node. yangjiajun wrote > We can not do update operations either.But select queries are ok. > > > yangjiajun wrote >> I have a ignite cluster which is version 2.6 and has two nodes.I can't do >> any >> ddl operations on it sin

Re: JDBC thin: support connection pooling in 2.7?

Hello. We try to use DBCP to support pooling of jdbc thin connection.The problem is the consistency between nodes has delay.And jdbc thin connection randomly chooses endpoint to access ignite cluster when there is multi endpoints.When we use connection pool,we randomly get a connection from the

In which case will ignite run following sql?

Hello. I found a strange sql in ignite logs.I didn't find such sql in my application. The table contains about 7 million data and such table-scan queries can occupy a lot of heap memory. Is this an internal operation? Or is there something wrong in my application?

Does ignite keep loading result when the jdbc thin connection is dead?

Hello. I use jdbc thin connection to access ignite with lazy mode.Ignite does not release memory after my query connection is dead.Does ignite keep loading result when the connection die? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Why drop table operations affect all update operations.

Hello. According to my understanding,drop table command will block all operations on the same table.But in my experiment,all update operations slow down when there is a drop table operation even these operations aren't targeting the same table.I guess drop table statement causes ignite sync all

Failed to fetch SQL query result

Hello. I did a scan query on a table which has 8w records and tried to go through all records in the result set but got following exception: [13:53:31,523][SEVERE][client-connector-#77][JdbcRequestHandler] Failed to fetch SQL query result [reqId=0, req=JdbcQueryFetchRequest [queryId=38106237,

Critical system error detected

Hello. I have a ignite 2.7 node with persistence enabled.I use it as a database.It reported "blocked system-critical thread has been detected" exception in logs.I guess it was blocked by drop table operations.Can someone help me to find what happened to ignite? Here is the logs and config of

Ouch! Argument is invalid: Cache name must not be null or empty.

Hello. I use ignite 2.6 as a database and try to tune data rebalancing according to following doc： https://apacheignite.readme.io/docs/rebalancing#section-rebalance-message-throttling But I get an exception when I set those settings. class org.apache.ignite.IgniteException: Ouch! Argument is

Re: Strange issue while call ddl

Hello. I have created it: https://issues.apache.org/jira/browse/IGNITE-10897 ilya.kasnacheev wrote > Hello! > > Turns out this issue isn't known yet. Can you file a ticket against Apache > Ignite JIRA? > > Regards, > -- > Ilya Kasnacheev > > > вс, 6

Concurrent merge into operations cause critical system error on ignite 2.7 node.

Hello. I have a ignite 2.7 node with persistence enabled.I test concurrent merge into operations on it and find below concurrent operations can cause critical system error: 1.Thread 1 executes "merge INTO city2(id,name,name1) VALUES(1,'1','1'),(2,'1','1'),(3,'1','1')". 2.Thread 2 executes "merge

How to define a cache template?

Hello! I want to make some cache settings global.It means I need to define a cache template and then use it,right?But I did not find any docs related to this. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Question about write speed.

Hello. I use ignite 2.6 as a sql database and enable persistence(full_sync).I only start one node.All tables are replicated.I use streaming while insert data.The write speed is about 5~6k records per table.Is such speed normal?Can I improve it? Here is my config file： example-default.xml

How to add new nodes to a running cluster?

Hello. I try to add a node with persistence enable to a running cluster.I provide the ip address list of the existing cluster to the new node,but it does not communicate with the cluster. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Question about cpu usage and disk read speed on activation stage.

Hello. Ignite takes about 1 hour to activate on my machine.I have only one node and use version 2.6.I also enable persistence and use 22GB heap memory and 22GB off-heap memory.My machine has 16 cores.The cpu usage is very low(<%1) and the disk read speed is about 1M/s~6M/s while ignite is

Re: Question about cpu usage and disk read speed on activation stage.

Hello. Please see the logs and the configuration.Thanks. example-default.xml ignite-b3234010.rar aealexsandrov wrote > Hi, >

Is there a way to restart ignite without data but only table structures.

Hello. I want to clear data after restart ignite.But I also want to keep the table structure which I dynamically created.Is there a way to do this? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cannot create table after I drop it

Hello. I encountered such issue too.And from my experience and tests,you cluster may have blocked drop operations that can cause such strange issues.You can see more details in my previous post: http://apache-ignite-users.70518.x6.nabble.com/Strange-issue-while-call-ddl-td25259.html#a26234

Can we use uuid generator in sql?

Hello! Is there any sql functions to generate uuids? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Get tables from metadata errors.

nnections > properly, end up using same connection from two threads at the same time. > > Regards, > -- > Ilya Kasnacheev > > > вт, 7 мая 2019 г. в 07:03, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> I use jdbc thin connections.I

Too many open files

Hello. Does ignite release open file descriptors after cache destroy?My ignite sometimes crashes because of too many open files.But I always destroy my cache after I use it. I don't think my application need much open file descriptors.I also follow

Re: Too many open files

proc/$ID/fd, share it with us? > > Regards, > -- > Ilya Kasnacheev > > > пн, 27 мая 2019 г. в 06:52, yangjiajun < > 1371549332@ >>: > >> Hello. >> >> Does ignite release open file descriptors after cache destroy?My ignite >> sometimes crash

Get tables from metadata errors.

Hello. I use jdbc thin connections.I also use HikariCP 3.3.1. I use flowing code to check if a table exists: try (ResultSet rs = conn.getMetaData().getTables( null, null, tableName, new String[] {"TABLE"})) { return rs.next();

[data-streamer-stripe-2-#35][] Critical system error detected.

Hello. My ignite crash with following errors. [16:39:31,163][SEVERE][data-streamer-stripe-2-#35][] Critical system error detected. Will be handled accordingly to configured handler [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler

Re: [data-streamer-stripe-2-#35][] Critical system error detected.

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

Re: Data streamer has been closed.

Hello. I forget to add 'ordered' somewhere so that breaks this workaround.I think 'SET STREAMING ON ALLOW_OVERWRITE ON ORDERED;' works for me if I always use it. yangjiajun wrote > Hello. > > How to use this workaround when allow overwrite? > > I try 'SET STREAMING ON

Re: Data streamer has been closed.

Hello. How to use this workaround when allow overwrite? I try 'SET STREAMING ON ALLOW_OVERWRITE ON ORDERED;' and 'SET STREAMING ON ORDERED ALLOW_OVERWRITE ON;' but don't works. Taras Ledkov wrote > Hi, > > Workaround: use ordered streaming: > SET STREAMING ON ORDERED > > There is a bug at

Re: Can we use uuid generator in sql?

Hello.Thanks for reply. It works for me. ilya.kasnacheev wrote > Hello! > > Have you tried RANDOM_UUID()? > > Regards, > -- > Ilya Kasnacheev > > > пн, 15 апр. 2019 г. в 15:02, yangjiajun < > 1371549332@ >>: > >> Hello!

Ignite 2.8 get exception while use batch insert in streaming mode

Hello. I use add bacth method to insert data in streaming mode.It works well in ignite 2.7. But I get following exeception when use ignite 2.8-release-rc1: Exception in thread "main" java.sql.BatchUpdateException: class org.apache.ignite.IgniteCheckedException: null at

Re: Ignite 2.8 get exception while use batch insert in streaming mode

Hello. The following test code also throws the same exception: ps = conn.prepareStatement("SET STREAMING ON ALLOW_OVERWRITE ON"); ps.execute(); ps.close(); String sql = "insert INTO city1(id,name,name1) VALUES(?,?,RANDOM_UUID())"; ps = conn.prepareStatement(sql);

How to set timeout while use data streamer in sql mode.

Hello. I use 'SET STREAMING ON ORDERED;' to use streaming mode.I know that we can set timeout to a data streamer.How can I set this in sql mode? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Found dead lock threads.

Hello,ignite community. I use muiti thred to write data to ignite's same table.The table is in memory.I open streaming mode by using 'SET STREAMING ON ORDERED;' before my write,and use 'SET STREAMING OFF;' to flush data.I found that these threads may all wait on condition and never ends. Here is

java.lang.IllegalMonitorStateException: attempt to unlock read lock, not locked by current thread

Hello. I get a strange exception while test ignite 2.8 in our test env.I get following exception when I set lazy = true to run our tasks.The tasks do jdbc selects and insert the result to others ignite tables.The tasks are async.The exception throws when my code fetches 1024 rows.Such tasks works

java.sql.SQLException: Schema change operation failed: Thread got interrupted while trying to acquire table lock.

Hello. I am testing ignite 2.8.It sometimes throws following exception: java.sql.SQLException: Schema change operation failed: Thread got interrupted while trying to acquire table lock. at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:901) at

Re: java.sql.SQLException: Schema change operation failed: Thread got interrupted while trying to acquire table lock.

Hello.Sorry for so late to reply.I have got a reproducer. Here is the test code.Please run it in a ignite without persistence enabled. public class ConcurrentCreateTable { private static Connection conn; private static Connection conn1; public static void main(String[] args) throws

Re: java.sql.SQLException: Schema change operation failed: Thread got interrupted while trying to acquire table lock.

Hello.Thanks for u reply. Please see this JIRA ticket: https://issues.apache.org/jira/browse/IGNITE-13020 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: java.lang.IllegalMonitorStateException: attempt to unlock read lock, not locked by current thread

Hello. Yes,u are right.Thanks a lot for u reply. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: java.lang.IllegalMonitorStateException: attempt to unlock read lock, not locked by current thread

Hello.Thanks for u reply. Actually I am using Hakaricp connection pool.I think my threads can't use same connection at same time.The threads can only reuse same connection at different time.My code works well in ignite 2.7 and it also works when I set lazy=false in ignite 2.8. -- Sent from:

Create table if not exists does not works in cocurrent case

Hello.I test creating same table in two threads.Here is my test code: public class ConcurrentCreateTable { private static Connection conn; private static Connection conn1; public static void main(String[] args) throws Exception { initialize(); new Thread(new

Data streamer hangs

Hello.I use SET STREAMING ON and SET STREAMING OFF style to flush data to ignite.Ignite sometimes hangs on SET STREAMING OFF. The thread hangs on client side looks like: daemon prio=5 os_prio=0 tid=0x7fdba0003000 nid=0x3c1 waiting on condition [0x7fdf473f1000]

Double add double get wrong result

Hello.I do simple add operation but get wrong result. Here is a reproduce step: CREATE TABLE PUBLIC.TEST ( A DOUBLE, B DOUBLE, K VARCHAR, CONSTRAINT K PRIMARY KEY (K) ); INSERT INTO test(A,B,K)values(-11674.46,11674.67,'1') SELECT to_char(A+B) FROM test The

With as syntax does not work in ignite 2.9.0?

Hello. We use 'with xxx as (select xxx) ',which works vrey fine in 2.8.1 and other past release versions.After we uprade to 2.9.0,such sqls start to throw exception. In the server side,the error looks like: , args=Object[] [], stmtType=SELECT_STATEMENT_TYPE, autoCommit=true, partResReq=false,

Re: With as syntax does not work in ignite 2.9.0?

Hello.Thanks for u reply. Sorry for that I can't post sqls beacuse they contain sensitive bussiness info.I'm also sorry that I can't make a reproducer now. Here is my code to execute query: ResultSet excuteQuery(Connection conn, String sql) throws SQLException { Statement stmt =