Pt-archiver archiving data line feed error（include \n）

General

Escalation

General

Escalation

Description

The data line contains \n text, causing pt-archiver to mistake it for a newline character when archiving, and the target data is incorrect，Is there a good solution

#I did a perl code test, maybe this is the problem

[root@iZ2ze0pd59pbghfhou3e6cZ ~]$cat test.pl
my $row = {
id => 1,
name => “Hello\nWorld”,
desc => “This is\na test”,
};

foreach my $key (keys %$row) {
my $value = $row->{$key};
print “$key: $value\n”;
}

[root@iZ2ze0pd59pbghfhou3e6cZ ~]$perl test.pl
desc: This is
a test
name: Hello
World
id: 1

Environment

None

Linked issues

is duplicated by

PT-2208

pt-archiver with bulk-insert will corrupt data with blank line at the end of the data

Activity

Show:

Aaditya Dubey February 3, 2025 at 12:44 PM

Hi @huichao_chen

Thank you for the report.
It is known to us and it is duplicated by https://perconadev.atlassian.net/browse/PT-2208

Matthew Boehm January 7, 2025 at 3:15 PM
Edited

Possible duplicate of https://perconadev.atlassian.net/browse/PT-2208

Duplicate

Details

Security Level Help

None

Assignee

Unassigned

Reporter

huichao_chen

Priority

High

Affects versions

3.2.1

Needs QA

Yes

Planned Version/s