[jira] [Created] (IGNITE-17665) Ignite node crash(CorruptedTreeException: B+Tree is corrupted) when using JDBC Thin driver

["Alexey Makarevich (Jira)" <ji...@apache.org>]

Alexey Makarevich created IGNITE-17665:
------------------------------------------

             Summary: Ignite node crash(CorruptedTreeException: B+Tree is corrupted) when using JDBC Thin driver
                 Key: IGNITE-17665
                 URL: https://issues.apache.org/jira/browse/IGNITE-17665
             Project: Ignite
          Issue Type: Bug
          Components: jdbc, sql
    Affects Versions: 2.13, 2.12
            Reporter: Alexey Makarevich
         Attachments: ignite-4986b884.0-partitioned-distributedJoins-CRASH-String.log, ignite-e4793913.0-replicated-CRASH-String.log

Create test table
{code:java}
CREATE TABLE `Table1` (
  `tid` INT PRIMARY KEY,
  `descr` VARCHAR NOT NULL
-- )  WITH "template=replicated, CACHE_NAME=Table1";
 )  WITH "CACHE_NAME=Table1";

INSERT INTO Table1 (tid,descr) VALUES (236,'CCCcCcccCc'); {code}
Try to select it with JDBC thin driver (ignite-core-2.13.0.jar for 2.13)
{code:java}
Class.forName("org.apache.ignite.IgniteJdbcThinDriver");
Connection conn = DriverManager.getConnection("jdbc:ignite:thin://192.168.56.101:10800");
PreparedStatement stmt = conn.prepareStatement("select * from TABLE1 WHERE TID=?");
stmt.setString(1, "asdhjhds"); 
ResultSet rs = stmt.executeQuery();{code}
In this case we receive
{code:java}
java.sql.SQLException: class org.apache.ignite.IgniteCheckedException: Data conversion error converting "asdhjhds" [22018-197] {code}
But if we get connection with enabled distributedJoins
{code:java}
Connection conn = DriverManager.getConnection("jdbc:ignite:thin://192.168.56.101:10800;distributedJoins=true"); {code}
there will be crash
{code:java}
[20:00:34,717][FINE][client-connector-#91][ClientListenerNioListener] Client request received [reqId=1, addr=/192.168.56.1:12755, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=select * from TABLE1 WHERE TID=?, args=Object[] [asdhjhds], stmtType=SELECT_STATEMENT_TYPE, autoCommit=true, partResReq=false, explicitTimeout=false, super=JdbcRequest [type=2, reqId=1]]]

[20:00:34,763][SEVERE][client-connector-#91][] Critical system error detected. Will be handled accordingly to configured handler [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler [ignoredFailureTypes=UnmodifiableSet [SYSTEM_WORKER_BLOCKED, SYSTEM_CRITICAL_OPERATION_TIMEOUT]]], failureCtx=FailureContext [type=CRITICAL_ERROR, err=class o.a.i.i.processors.cache.persistence.tree.CorruptedTreeException: B+Tree is corrupted [groupId=-1797510589, pageIds=[844420635164673], cacheId=-1797510589, cacheName=Table1, indexName=_key_PK, msg=Runtime failure on lookup row: IndexSearchRowImpl [rowHnd=o.a.i.i.processors.query.h2.index.QueryIndexRowHandler@2c34fb40]]]]class org.apache.ignite.internal.processors.cache.persistence.tree.CorruptedTreeException: B+Tree is corrupted [groupId=-1797510589, pageIds=[844420635164673], cacheId=-1797510589, cacheName=Table1, indexName=_key_PK, msg=Runtime failure on lookup row: IndexSearchRowImpl [rowHnd=org.apache.ignite.internal.processors.query.h2.index.QueryIndexRowHandler@2c34fb40]] {code}
The same crash will be if we create table in replicated mode "WITH "template=replicated,".

It seems that in crash cases there are no type validations\conversions...



--
This message was sent by Atlassian Jira
(v8.20.10#820010)