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

[FGuijarro]

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!!

[Anonymous]

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

[FGuijarro · Accepted solution]

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!!

[Anonymous]

Hello,

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

Best regards

Sabrina