topic Error when running the job: (conn=2274) The table 'Table_estadisticas' is full in Talend Studio

Error when running the job: (conn=2274) The table 'Table_estadisticas' is full

FGuijarro — Sat, 16 Nov 2024 01:13:05 GMT

Hi,

After running a job in Talend 7.3 (MariaDB, MySQL) trying to UNION 10 tables one after the previous one from Server_1 and creating a new Table in server_2 with the UNION of those 10 tables, I receive the message:

(conn=2274) The table 'Table_estadisticas' is full

Does anybody know what´s the problem on the design? Every INPUT table (the 10 of them), has around 20.000.000 rows

Thank you for your help!!

Re: Error when running the job: (conn=2274) The table 'Table_estadisticas' is full

Anonymous — Fri, 30 Oct 2020 03:48:22 GMT

Hello,

What's Mysql DB version are you using? If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.

Let us know if this documentation helps?

https://dev.mysql.com/doc/refman/5.6/en/table-size-limit.html

Best regards

Sabrina

Re: Error when running the job: (conn=2274) The table 'Table_estadisticas' is full

FGuijarro — Fri, 30 Oct 2020 09:50:33 GMT

Hi!

Thanks for your answer! I finally fix it. The problem was there were no enough space on the server to finish creation of the output (mysql file). Thakns!!

Re: Error when running the job: (conn=2274) The table 'Table_estadisticas' is full

Anonymous — Mon, 02 Nov 2020 06:45:58 GMT

Hello,

Great it is fixed. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina