Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
> Den 17. jul. 2019 kl. 11.48 skrev Erik Cederstrand : > > Thanks, Jocelyn! > >> Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier >> : >> It seems this table should be in InnoDB format, not MyISAM (same for >> innodb_table_stats). > > I tried altering the engine to InnoDB but was not allo

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
Thanks, Jocelyn! > Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier > : > It seems this table should be in InnoDB format, not MyISAM (same for > innodb_table_stats). I tried altering the engine to InnoDB but was not allowed. Hmm. Then I decided to just drop the table to have mysql_upgrade cr

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread jocelyn fournier
Le 17 juil. 2019 à 11:22, Erik Cederstrand a écrit : > > Thanks! > > I couldn't find the mysql_fix_privilege_tables.sql installed anywhere on my > system, so I ended up patching mysql_upgrade to print the SQL commands it's > executing. There are ca. 200 commands executed at once, so it took a

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
Thanks! I couldn't find the mysql_fix_privilege_tables.sql installed anywhere on my system, so I ended up patching mysql_upgrade to print the SQL commands it's executing. There are ca. 200 commands executed at once, so it took a while to pinpoint the failing statement. It would be cool if tripl

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Sergei Golubchik
Hi, Reindl! On Jul 16, Reindl Harald wrote: > > > Am 16.07.19 um 21:13 schrieb Sergei Golubchik: > > you can run mysql_fix_privilege_tables.sql manually. Like with > > mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql > > how would that solve the issue of a obviously incompatible change in

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Reindl Harald
Am 16.07.19 um 21:13 schrieb Sergei Golubchik: > you can run mysql_fix_privilege_tables.sql manually. Like with > mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql how would that solve the issue of a obviously incompatible change in 10.4? > On Jul 16, Erik Cederstrand wrote: >> Hi, >> >> I

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Sergei Golubchik
Hi, Erik! you can run mysql_fix_privilege_tables.sql manually. Like with mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql Presuming FreeBSD installs this file somewhere. If it doesn't, you can extract it from mysql_upgrade with strings, I suppose. On Jul 16, Erik Cederstrand wrote: > Hi, >

[Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Erik Cederstrand
Hi, I'm trying to upgrade a MariaDB 10.2 server to 10.4.6 on FreeBSD. When running the mysql_update command, it dies with: $ mysql_upgrade Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv