Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Once the table is recreated (or index rebuilded) the issue is fixed. Upgrading from 2.12 to 2.13 (if all indexes having this issue are already rebuilded on 2.12) should be fine. ср, 31 авг. 2022 г. в 23:43, John Smith : > Ok but since I dropped and recreated the table I'm fine? It won't somehow >

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Ok but since I dropped and recreated the table I'm fine? It won't somehow throw that error again? And if I upgrade to 2.13 from 2.12 will I have the same issue? On Wed, Aug 31, 2022 at 3:31 PM Alex Plehanov wrote: > John Smith, > > Thank you. This issue will be fixed in upcoming 2.14. > > ср, 31

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

John Smith, Thank you. This issue will be fixed in upcoming 2.14. ср, 31 авг. 2022 г. в 21:50, John Smith : > Here it is... And yes I recently upgraded to 2.12 from 2.8.1 > > create table if not exists car_code ( > provider_id int, > car_id int, > car_code varchar(16), > primary key (provider_id

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Here it is... And yes I recently upgraded to 2.12 from 2.8.1 create table if not exists car_code ( provider_id int, car_id int, car_code varchar(16), primary key (provider_id, car_id) ) with "template=replicatedTpl, key_type=CarCodeKey, value_type=CarCode"; On Wed, Aug 31, 2022 at 7:25 AM Alex Pl

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

John Smith, Can you please show DDL for the car_code table? Does PK of this table include provider_id or car_code columns? I found a compatibility issue, with the same behaviour, it happens when storage created with Ignite version before 2.11 is used with the newer Ignite version. Have you upgrade

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Let me know if that makes any sense, because the test data is the same and the application code is the same. Only dropped and created the table again using DbEaver. On Wed, Aug 3, 2022 at 11:39 AM John Smith wrote: > Hi, so I dropped the table and simply recreated it. Did NOT restart the > appli

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Hi, so I dropped the table and simply recreated it. Did NOT restart the application. Now it works fine. On Wed, Aug 3, 2022 at 9:58 AM John Smith wrote: > How? The code is 100% the same between production and dev. And it's part > of a bigger application. > > Only dev has the issue. I will drop

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

How? The code is 100% the same between production and dev. And it's part of a bigger application. Only dev has the issue. I will drop and recreate the table if that fixes the issue then what? You are saying mismatch, it's a string period. "select car_id from car_code where provider_id = ? and ca

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Hi John and Don, I guess the root cause in the data types mismatch between table schema and actual data at the store or type of the query parameter. To explore the gap, it would be very handy if you could provide a small reproducer (standalone project or PR somewhere). > In my case I'm not even

Re: Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

tion. > > I am still trying to create a smaller repro case, that’s why I haven’t > described my solution in more detail in my other thread yet. > > > > On 02.08.22 at 23:04, John Smith wrote: > > From: "John Smith" > Date: 2. August 2022 > To: user@ignite

Re: Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

mith wrote: From: "John Smith" Date: 2. August 2022To: user@ignite.apache.orgCc: Subject: Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean? Here it is...[20:58:0

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Here it is... [20:58:03,050][SEVERE][query-#395344%xx%][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.internal.processors.query.IgniteSQLException: General error: "class org.apache.ignite.IgniteCheckedException: Runtime failure on lookup row: IndexSearchRowImpl [

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Hello, John. Provided stack trace not enough to answer your question. Can you, please, provide log from the remote node? > 2 авг. 2022 г., в 17:14, John Smith написал(а): > > Anyone? > > On Fri, Jul 29, 2022 at 8:44 AM John Smith > wrote: > Any thoughts on this?

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Anyone? On Fri, Jul 29, 2022 at 8:44 AM John Smith wrote: > Any thoughts on this? > > On Mon., Jul. 25, 2022, 11:29 a.m. John Smith, > wrote: > >> Hi I have the following code and I get the below exception. The cache >> runs on 3 remote nodes and it is accessed by thick client (client = true) >

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Any thoughts on this? On Mon., Jul. 25, 2022, 11:29 a.m. John Smith, wrote: > Hi I have the following code and I get the below exception. The cache runs > on 3 remote nodes and it is accessed by thick client (client = true) > > String sql = "select car_id from car_code where provider_id = ? and

What does javax.cache.CacheException: Failed to execute map query on remote node mean?

Hi I have the following code and I get the below exception. The cache runs on 3 remote nodes and it is accessed by thick client (client = true) String sql = "select car_id from car_code where provider_id = ? and car_code = ? order by car_id asc limit 1;" Integer providerId = 1; String cardCode = "