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

2020-12-07 Thread yangjiajun
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 =

BaselineTopology branching error

2020-12-07 Thread rakshita04
Hi Team, We are using baseline topology concept for our two nodes, running on separate machines. We are getting below error when both of these nodes run together- Caused by: class org.apache.ignite.spi.IgniteSpiException: BaselineTopology of joining node (DSU_B) is not compatible with

[Meetup] I have a cool Ignite user story for you on December 8 (and need more of them!)

2020-12-07 Thread Kseniya Romanova
Hi Igniters! At tomorrows' Meetup, we welcome Mikhail Antonov from Raiffeisen bank. He will share his experience of using Ignite in the core banking system for scaling and reducing backend load. I like this story as it's elegant and simple. Join us at 8 AM PST / 5 PM CET:

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

2020-12-07 Thread Ilya Kasnacheev
Hello! Do you happen to run this query on client or server node? Try running it on a server node for a chance. Clients initialize cached lazily and yield a crop of NPEs. Regards, -- Ilya Kasnacheev пн, 7 дек. 2020 г. в 05:40, yangjiajun <1371549...@qq.com>: > Hello. > > We use 'with xxx as

Re: Using different versions of serializable objects

2020-12-07 Thread Ilya Kasnacheev
Hello! You can try specifying BinaryConfiguration where you would supply a BinaryTypeConfiguration for this type name, specifying a custom BinarySerializer. Then you can try supplying BinaryReflectiveSerializer there. See

[2.9.0]NPE on invoke IgniteCache.destroy()

2020-12-07 Thread 38797715
Hi community, Call IgniteCache.destroy Method, NPE appears,logs are as follows: 2020-12-0717:32:18.870[] [exchange-worker-#54%tradecore%] INFOo.a.i.i.e.time- Started exchange init [topVer=AffinityTopologyVersion [topVer=1, minorTopVer=279], crd=true, evt=DISCOVERY_CUSTOM_EVT,

RE: Could not clear historyMap due to WAL reservation on cp

2020-12-07 Thread shivakumar
Thanks for your reply Alexandr Shapkin The ticket you shared https://issues.apache.org/jira/browse/IGNITE-13373 more related to preloading releaseHistoryForPreloading() But the issue am facing is somehow WAL segments which are not needed for crash recovery after checkpoint are not getting

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

2020-12-07 Thread Pavel Vinokurov
Hi, Could you show the query and the code block with the query execution because query "with p as (select * from person) select * from p" works well on 2.9.0. I suspect that the issue could be related to creating jdbc resources. Could you also show the configuration for the hikari jdbc pool.

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

2020-12-07 Thread Alexandr Shapkin
Hi, I’ve filed a JIRA ticket https://issues.apache.org/jira/browse/IGNITE-13822 to track this issue.Full logs or a simple reproducer would help to debug this more quickly, feel free to share them as well. From: yangjiajunSent: Monday, December 7, 2020 5:40 AMTo: user@ignite.apache.orgSubject: With