Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pt-archiver shifts the colums

Description

Hello,

We loaded a table via the pt-archiver tool on MySQL env 8.0.18 version and toolkit version 3.2.0.1, command like: /usr/bin/pt-archiver --source h=localhost,u=root,p=***,D=test,t=test,b=1 --dest h=server01,u=root,p=***,D=test,t=test,b=1 --no-check-charset --why-quit --progress 10000 --header --bulk-insert --commit-each --limit 500000 --sleep 1 --statistics --no-delete --where "1=1";

But for some records two columns became one , both columns text type (using json array as well):

`boards` text COMMENT 'The player selections',
`multiplier` text COMMENT 'The wager multiplier'

And CHARSET=utf8mb4 .

On source we have: 

boards: [{"btp":1,"id":1,"mlt":[1],"pnl":[{"qp":false,"req":5,"sel":[1,2,3,4,5]}],"sts":[{"bt":1,"cl":1}]}]

multiplier: [1]

And on target we get:

boards: [{"btp":1,"id":1,"mlt":[1],"pnl":[{"qp":false,"req":5,"sel":[1,2,3,4,5]}],"sts":[{"bt":1,"cl":1}]}] [1]

multiplier: [752973, 752974] – this should be in the next column

Environment

None

Attachments

2

is cloned by

Smart Checklist

Activity

Lalit Choudhary November 3, 2020 at 6:58 AM

Hi

Apologies, for some reason status not changed and it got closed.

I will continue the test with new details, will update https://jira.percona.com/browse/PT-1904

Thank you for follow-up bug and details. 

 

 

 

Αναστασία Παπαχριστοπούλου October 30, 2020 at 2:04 PM

Sorry? What just happened? I posted an update a week ago and attached some files. Ok probably you do not know how to solve the bug, just say it.

Jira Bot October 30, 2020 at 1:57 PM

Hello ,
It's been 52 days since this issue went into Incomplete and we haven't heard
from you on this.

At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Αναστασία Παπαχριστοπούλου October 22, 2020 at 2:51 PM

Hello,

Sorry for the late reply, please check the second file that I have uploaded : 

The data here are rectified by using mysqldump

Thank you!

Jira Bot October 22, 2020 at 12:57 PM

Hello ,
It's jira-bot again. Your bug report is important to us, but we haven't heard
from you since the previous notification. If we don't hear from you on
this in 7 days, the issue will be automatically closed.

Duplicate

Details

Assignee

Reporter

Priority

Smart Checklist

Created August 24, 2020 at 9:04 PM
Updated February 29, 2024 at 8:57 PM
Resolved November 10, 2020 at 12:23 PM