[IGNITE-19488] RemoteFragmentExecutionException when inserting more than 30 000 rows into one table

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Component/s: jdbc, sql
• Labels: ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Igor
• Created: 16/May/23 17:25
• Updated: 30/May/23 12:16
• Resolved: 30/May/23 12:16

Description

Steps to reproduce

Ignite 3 main branch commit 45380a6c802203dab0d72bd1eb9fb202b2a345b0

1. Create table with 5 columns
2. Insert into table rows by batches 1000 rows each batch.
3. Repeat previous step untill exception is thrown.

Expected behaviour

Created more than 30 000 rows.

Actual behaviour

An exception after 29 000 rows are inserted:

Exception while executing query [query=SELECT COUNT(*) FROM rows_capacity_table]. Error message:IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907 IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907 Query remote fragment execution failed: nodeName=TablesAmountCapacityTest_cluster_0, queryId=ecd14026-5366-4ee2-b73a-f38757d3ba4f, fragmentId=1561, originalMessage=IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907
java.sql.SQLException: Exception while executing query [query=SELECT COUNT(*) FROM rows_capacity_table]. Error message:IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907 IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907 Query remote fragment execution failed: nodeName=TablesAmountCapacityTest_cluster_0, queryId=ecd14026-5366-4ee2-b73a-f38757d3ba4f, fragmentId=1561, originalMessage=IGN-CMN-1 TraceId:24c93463-f078-410a-8831-36b5c549a907
	at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
	at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:149)
	at org.apache.ignite.internal.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:108) 

Logs are in the attachment.

logs.zip

Issue Links

• links to: GitHub Pull Request #2101
• links to: GitHub Pull Request #2101