topic Re: Memory error in Talend Studio

Memory error

modara — Fri, 15 Nov 2024 23:10:56 GMT

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"

Re: Memory error

Anonymous — Thu, 24 Feb 2022 07:32:04 GMT

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

Re: Memory error

modara — Thu, 24 Feb 2022 08:14:56 GMT

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.

Re: Memory error

modara — Thu, 24 Feb 2022 10:09:13 GMT

please close this issue. it resolved. thx

Re: Memory error

Anonymous — Thu, 24 Feb 2022 11:02:49 GMT

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.