Pt-archiver is truncating a TEXT column when "--bulk-insert" is used

Hello everyone,

while running the “pt-archiver” tool to archive some data, we are experiencing some truncation on a TEXT column on target table, when we add the flag “–bulk-insert”. This is resulting in wrong data being archived. If we remove the “–bulk-insert” flag, there is no truncation but the process takes a lot more time, which makes the archival process not suitable for our needs.

Is this a limitation with the tool or LOAD FILE used by the tool, or something else? Also, is there a workaround for this?


Version: pt-archiver 3.5.4