[IGNITE-22727] java.sql.SQLException: null after 400 tables are created

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 3.0
• Component/s: persistence
• Labels: ignite-3

Environment

3 nodes (1 CMG) distributed on 3 hosts with "-Xms4096m", "-Xmx4096m"

• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Igor
• Created: 12/Jul/24 16:58
• Updated: 05/Sep/24 12:48
• Resolved: 05/Sep/24 12:48

Description

Steps to reproduce:

1. Multinode cluster (3 nodes) with arguments 
   "-Xms4096m", "-Xmx4096m"
2. Create 50 tables (all tables in single zone).
3. Insert 1 row into tables created in the previous step.
4. Repeat steps 2 and 3 until 1000 tables are created.

Expected:
1000 tables are created.

Actual:
After 400 tables created and row insertions in tables from 350 to 400 is happen the exception is thrown:

java.sql.SQLException: java.sql.SQLException: nulljava.sql.SQLException: null  at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)  at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:154)  at org.apache.ignite.internal.jdbc.JdbcPreparedStatement.executeWithArguments(JdbcPreparedStatement.java:765)  at org.apache.ignite.internal.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:173)  at org.gridgain.ai3tests.tests.amountcapacity.TablesAmountCapacityBaseTest.lambda$insertRowAndAssertTimeout$2(TablesAmountCapacityBaseTest.java:113)  at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)  at java.base/java.lang.Thread.run(Thread.java:834) 

The servers logs: servers_logs.zip

Comments:
The high probability it is another case of: https://issues.apache.org/jira/browse/IGNITE-22209 

 

 

 

Issue Links

• is caused by: IGNITE-22757 Excessive memory usage in schema-related code in SQL
• is superceded by: IGNITE-22813 Exception `Max retry limit exceeded: 10` while creating 50 tables in 10 threads with replication 3