On 7 May 2018 at 12:03, Jan Kurik <jkurik@xxxxxxxxxx> wrote: [..] > Update of MySQL ( community-mysql package) in Fedora from 5.7 to 8.0 version. 1) After regular upgrade mysql server is completely not usable because nothing is performing upgrade procedure by execute mysql_upgrade. No warning, nothing is displayed to anyone who will be doing regular upgrade .. just silent trashing. 2) If mysqll_upgrade command will be executed during 5.7 -> 8.0 package upgrade binary format will be changed and downgrade will be not possible. Just in case if it is not obvious: I'm not proposing to add this command to mysql post installation 3) 8.0.11 is just first 8.0 releases and jumping from very stable 5.7.x to deeply changed 8.0 is horrible idea 4) I already found that this upgrade breaks zabbix because in zabbix db schema are used "group" and "function" which are in 8.0 part of the SQL keywords. Any other MySQL client code which will be using such keywords in tables ot tables rows names will be instantly decapitated. Shame that you did not mention that we already discussed this issue in https://bugzilla.redhat.com/show_bug.cgi?id=1573642 zabbix only in 4.0 (probably) wil have MySQL 8.0 support and Alexey Vladyshew already made decision that MySQL 8.0 support will be not backported to any 3.x (https://support.zabbix.com/browse/ZBX-12451) 5) On top of group/function keywords clash definitely any other software which will be querying performance_schema, global_status or global_variables tables will be broken by this upgrade as well. Probably 100% monitoring software which is using MySQL client API 6) In our IRC conversation on #zabbix you told me that working on 5.7->8.0 upgrade you've not done even single test build of any other Fedora package trying to recompile it against MySQL 8.0 client API. I've already told you that I found at least one package which fails during such test build. It is zabbix and quick patch for this issue is in ticket https://support.zabbix.com/browse/ZBX-14311. Looking on list of changes in 8.0 I'm 100% sure that list of the client software will be way longer. 7) Ad1) and Ad2): In the same few days ago public conversation on #zabbix IRC channel you already told me that you never tested 5.7->8.0 upgrade (.. which is kind of odd that you are packaging software which you are not testing/using) 8) After what you've done there is no anymore MySQL 5.7 packages in rawhide IMO all those traps and holes is possible to avoid by leaving 5.7 on community-mysql package and create completely new one community-mysql80. If you are not interested to maintain 5.7 line just split 5.7 and 8.0 and assign 5.7 line package to me (just assign 5.7 git repo line to "kloczek") kloczek -- Tomasz Kłoczko | LinkedIn: http://lnkd.in/FXPWxH _______________________________________________ devel mailing list -- devel@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to devel-leave@xxxxxxxxxxxxxxxxxxxxxxx
