search

delphix / mysqllinux

MySQLVirtualization Plugin for Delphix
Apache License 2.0
1 stars 9 forks source link

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

Open ranjeeth12 opened 3 years ago

ranjeeth12 commented 3 years ago

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