INSERT INTO ... SELECT kills server nodes

[Alberto Mancini]

Hi,
we are developing a poc using Ignite and we faced a scaring problem
that i suppose is due to some naive misconfiguration.

Long story short, we use persistence on a cluster on AWS and to speedup
test data loading we attempted a simple sql query:

INSERT INTO MyTable (
ID
PARTITION_KEY,
...
)
SELECT
 ID,
 'another_partition_key',
...
)

With enough rows this end up killing nodes.
With the default failureDetectionTimeout the server nodes
end up offline, tuning the timeout we get OOM.

Obviously the query is used only for testing but the fact that the server
nodes stop is actually scaring.

Do we missed some obvious configuration that may keep healthy the cluster?

Thanks,
   A.

System cache's DataRegion size is configured to 40 MB.

[Alberto Mancini]

Hello,
do i miss something or the message at
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/IgniteKernal.java#L2461
is incorrect ?
I think it should refer to
DataStorageConfiguration.*systemRegionInitialSize*
and not to
DataStorageConfiguration.*systemCacheMemorySize*
I'm i wrong ?

Thanks.
   Alberto.