MySQL Forums
Forum List  »  Install & Repo

Re: problems upgrading 5.7 -> 8.0.15
Posted by: Susan Koerner
Date: May 23, 2019 12:10PM

Hi Hans -

This check is provided currently in the 'Issues reported by 'check table x for upgrade' command'. Since that check uses a 5.7 mysqlcheck utility, it is reported as a warning, because it is a warning in 5.7

16) Issues reported by 'check table x for upgrade' command
Warning : Table (test.tabmyisampart) - The partition engine, used by table
'test.tabmyisampart', is deprecated and will be removed in a future release.
Please use native partitioning instead.
[...]


A change was put into the next release (8.0.17 shell) that will remove this warning from the 'check table x for upgrade' check, and put into a new check that reports an error.


Check in 8.0.17 with error:

5) Partitioned tables using engines with non native partitioning
Error: In MySQL 8.0 storage engine is responsible for providing its own
partitioning handler, and the MySQL server no longer provides generic
partitioning support. InnoDB and NDB are the only storage engines that
provide a native partitioning handler that is supported in MySQL 8.0. A
partitioned table using any other storage engine must be altered—either to
convert it to InnoDB or NDB, or to remove its partitioning—before upgrading
the server, else it cannot be used afterwards.
More information:
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-configuration-changes

test.tabmyisampart - MyISAM engine does not support native partitioning



Thanks -

Susan

Options: ReplyQuote


Subject
Written By
Posted
Re: problems upgrading 5.7 -> 8.0.15
May 23, 2019 12:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.