Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread manueltg89
Ok, I will be aware to the new changes. Thank you very much! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread Ilya Kasnacheev
Hello! I think there is indeed a problem with Cache Store here: https://issues.apache.org/jira/browse/IGNITE-13167 I hope it will get fixed, until it isn't I recommend switching that cache to ATOMIC mode, this will help sidestep the issue. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в

Re: Non Distributed Join between tables

2020-06-19 Thread manueltg89
I attach required file SQL. dbaffinity.sql -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread manueltg89
You need to have MySQL Server with schema "bugdb.sql" imported, config your mysql database in "secret.properties", run "ServerNodeCodeStartup" and execute PHP file with inserts to Apache Ignite. Sorry, there was a problem to attach PHP file. I've attached also PHP file now. bug.php

Re: Non Distributed Join between tables

2020-06-19 Thread Ilya Kasnacheev
Hello! Do you have a SQL script to reproduce this issue? Regards, -- Ilya Kasnacheev пт, 12 июн. 2020 г. в 09:48, manueltg89 : > I'm going to explain a bit more. I use Apache Ignite as front cache to my > RDBMS, I've done automatic RDBMS integration. Table A, Table B, Table C is > a example

Re: NPE during printing failure information

2020-06-19 Thread Ilya Kasnacheev
Hello! I suggest filing an issue against Apache Ignite JIRA. Ticket which added this line is IGNITE-11750 Regards, -- Ilya Kasnacheev сб, 13 июн. 2020 г. в 01:37, Andrey Davydov : > Yes, I think that initial problem was with communication and it need to be > tested more on my side. But

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread Ilya Kasnacheev
Hello! What do I need to run to observe the problem? I run ServerNodeCodeStartup but it runs OK. If there should be any images in your message, they're not there. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 11:12, manueltg89 : > Hi. I attach example project. I explain a bit more.

Re: Data Consistency Question

2020-06-19 Thread Ilya Kasnacheev
Hello! I'm not sure what you are trying to do and why you felt the need to over-complicate the solution. Regards, -- Ilya Kasnacheev пн, 15 июн. 2020 г. в 09:10, adipro : > Can you please suggest an efficient solution? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: IgniteCheckedException

2020-06-19 Thread Ilya Kasnacheev
Hello! Such spring XML config cannot be started by ignite.sh, it should be started as part of a Spring application. Regards. -- Ilya Kasnacheev вт, 16 июн. 2020 г. в 10:43, kay bae : > Hello, I start node using command > > ' sh ignite.sh ./config/config.xml & ' > > It worked well before I

Re: primary keys

2020-06-19 Thread Ilya Kasnacheev
Hello! It seems that the index is not used. Please try creating an explicit index over these 3 fields. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 00:38, narges saleh : > Hello Ilya, > Here is the info. In this query only one table is involved. > There are about 4M records in the table

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread manueltg89
Hi. I attach example project. I explain a bit more. Details: - MySQL Server with max connections form example: 151 - Insert with PHP PDO from PHP 7.2: It seems that Apache Ignite with writeBehind enabled open one connection by insert and keeps open every connection over time, this