Memory error

[modara]

Hi,

I am having memory error when copying data from mssql to mysql

I have increase memory size of JVM to 8GB but still have error. the table i am trying to take data from got only 7,00,000 data

but before I have taken even more than 20,00,000 data.

i don't know whats wrong. some time it works some time not. is there any

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "Thread-0"

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "mysql-cj-abandoned-connection-cleanup"

[Anonymous]

Hi

Please provide the following information for us to be more better evaluate the issue:

- studio version (such as Talend Cloud Real-Time Big Data Platform (7.3.120200219_1130)

- Mysql verion and Mysql driver version

- Java version (such as Oracle JDK build 1.8.0_201)

Regards

Shong

[modara]

TOS 8.0

MYSQL workbench version 8.0.28 (64bit)

Java jdk-11.0.12

i dont know why, using same above 3 version I can get more than 20,00,000 data from mssql to mysql but for only 7,00,000 data its giving me error. and ask for memory shot. please help me out. i need to make report. from these data.

[modara]

please close this issue. it resolved. thx

[Anonymous]

Did you find what had caused this? Your job doesn't look like it should struggle from what you have shown. I'd be interested to learn what it was that caused it.