[Bug]: Temporary table full when adding files to the TS

[chaen]

Search before creating an issue

• I have searched existing issues and confirmed this is not a duplicate

Bug Description

Adding a big number of files to a transformation often spits error like

ERROR: Failed to add 43245 lfns to transformation MySQL Error ( 1131 : Execution failed.: ( 1114: The table 'to_query_LFNs' is full ))

This is due to the temporary table getting full in TransformationDB.__getFileIDsForLfns

Steps to Reproduce

No response

Expected Behavior

No response

Actual Behavior

No response

Environment

No response

Relevant Log Output

ERROR: Failed to add 43245 lfns to transformation MySQL Error ( 1131 : Execution failed.: ( 1114: The table 'to_query_LFNs' is full ))

Additional Context

No response