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 10.4?
The question in the email was "How do I debug this?" and I tried to answer it. My reply might help to find the statement that causes the error, aborting the upgrade. Then we could look at why it fails, whether it's something in 10.4, in mysql_upgrade, or some local change that the user did, or may be something caused by FreeBSD patches. > > On Jul 16, Erik Cederstrand wrote: > >> 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.transaction_registry OK > >> Phase 2/7: Installing used storage engines... Skipped > >> Phase 3/7: Fixing views > >> mysql.user OK > >> Phase 4/7: Running 'mysql_fix_privilege_tables' > >> ERROR 1071 (42000) at line 437: Specified key was too long; max key length > >> is 1000 bytes > >> FATAL ERROR: Upgrade failed > >> > >> Adding verbose option does not give more hints, and the failing SQL > >> statement doesn't seem to be logged with full query logging turned on. > >> > >> How do I debug this? I can't even see which table or column it's > >> complaining about. I don't remember fiddling with collation or > >> character sets on system tables. > Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
