Skip to:

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

pt-online-schema-change remove the old and new table

Description

Launchpad: https://bugs.launchpad.net/percona-toolkit/+bug/1697915

Hello.
Today I altered one of my tables (users) with pt-online-schema-change
One table(user_comments) of my database had a foreign key (refer) to users table.
I changed id column from int to bigint
But at the end when it wanted to rename new table to original table, this message was displayed:

I know what is this, and I know firstly I must alter user_comments table or remove Foreign key before alter users table, but I think pt-online-schema-change has bug because it should be kept up new table.

It was full command:

Before running osc:

After getting the error:

MariaDB Version: mariadb-galera-10.0.30
pt-online-schema-change Version: 3.0.3

See attached program to load sample data 

Environment

None

AFFECTED CS IDs

CS0012489, ZEN273254

Attachments

1

Smart Checklist

Activity

Show:

Carlos Salguero October 12, 2020 at 6:36 PM

Thanks.

Sveta Smirnova October 12, 2020 at 12:58 PM

Hi ,

new program works fine for me.

Carlos Salguero October 12, 2020 at 12:37 PM

Hi could you please download the new program from https://raw.githubusercontent.com/percona/percona-toolkit/PT-169/bin/pt-online-schema-change and test it?

The escalation link doesn't work anymore.

Thanks

Juan Arruti September 14, 2020 at 5:46 PM

Hi, please find attached a test case to reproduce this issue. After running pt-osc 3.2.1 using drop_swap method and failing the old and new table are lost.

Carlos Salguero August 25, 2017 at 3:39 PM

Cannot reproduce

Done

Details

Assignee

Reporter

Priority

Affects versions

Fix versions

Labels

Needs QA

Yes

Needs Packaging

Yes

Story Points

Sprint

Smart Checklist

Created June 26, 2017 at 5:27 PM
Updated March 4, 2024 at 5:31 PM
Resolved October 13, 2020 at 3:31 PM