[
https://issues.apache.org/jira/browse/IGNITE-19488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor updated IGNITE-19488:
--------------------------
Description:
h1. Steps to reproduce
# Create table with 5 columns
# Insert into table rows by batches 1000 rows each batch.
# Repeat previous step untill exception is thrown.
h1. Expected behaviour
Created more than 30 000 rows.
h1. Actual behaviour
An exception after 29 000 rows are inserted:
{code:java}
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)
{code}
Logs are in the attachment.
[^logs.zip]
was:
h1. Steps to reproduce
# Create table with 5 columns
# Insert into table rows by batches 1000 rows each batch.
# Repeat previous step untill exception is thrown.
h1. Expected behaviour
Created more than 30 000 rows.
h1. Actual behaviour
An exception:
{code:java}
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)
{code}
Logs are in the attachment.
[^logs.zip]
> RemoteFragmentExecutionException when inserting more than 30 000 rows into
> one table
> ------------------------------------------------------------------------------------
>
> Key: IGNITE-19488
> URL: https://issues.apache.org/jira/browse/IGNITE-19488
> Project: Ignite
> Issue Type: Bug
> Components: jdbc, sql
> Reporter: Igor
> Priority: Critical
> Attachments: logs.zip
>
>
> h1. Steps to reproduce
> # Create table with 5 columns
> # Insert into table rows by batches 1000 rows each batch.
> # Repeat previous step untill exception is thrown.
> h1. Expected behaviour
> Created more than 30 000 rows.
> h1. Actual behaviour
> An exception after 29 000 rows are inserted:
> {code:java}
> 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)
> {code}
> Logs are in the attachment.
> [^logs.zip]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
