Skip to content
This repository has been archived by the owner on Apr 20, 2023. It is now read-only.

"[08/11/2021] [Restore of mysqldump during ingestion fails with ROW_FORMAT issue]" #8

Open
ranjeeth12 opened this issue Aug 13, 2021 · 0 comments

Comments

@ranjeeth12
Copy link

** Expected Behavior**
dSource creation process should execute seamlessly when the user provides the mysqldump path

** Actual Behavior**
The restore step of dSource creation process failed with incompatible ROW_FORMAT issue

Steps To Reproduce the Problem
On source MySQL create database tables with ROW_FORMAT as 'FIXED'. Its supported in older versions of MySQL so we need to first install MySQL version that supports FIXED and then upgrade same installation to 5.7. Also ensure the stage is 5.7 or later that doesn't support FIXED.

When we create a dSource making the Source as Master and Stage as slave, the restore process fails with incompatible ROW_FORMAT (e.g. FIXED) on Slave

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Screenshots
If applicable, add screenshots to help explain your problem.

Version
MySQL 5.7

Additional Context
We may need to reformat the rows or remove the row_format using sed command and then restore on stage

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Development

No branches or pull requests

1 participant