[arch-general] upgrading mysql to mariadb
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I had managed not to see this: https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ But it turned up on one of my feeds today, so I went to work. All went well until the final step, the upgrade: Phase 3/3: Running 'mysql_fix_privilege_tables'... ERROR 1064 (42000) at line 87: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, thread_id INTEGER NOT NULL, server_' at line 1 ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 89: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 95: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, query_time TIME(6) NOT NULL, lock_t' at line 1 ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 97: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 343: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1064 (42000) at line 354: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1548 (HY000) at line 1136: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1137: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1150: Cannot load from mysql.proc. The table is probably corrupted FATAL ERROR: Upgrade failed I haven't checked thoroughly, but it appears my sites are all up. So I really don't know what to make of this. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJRVhBJAAoJELJhbl/uPb4S7bwQAJHMeHYNO1I1PLD6/C9zvj+4 tNT7Z2qYAHyodnTY7ZzPs0726PX4OPPztPT4k28Bstl3CW4GSMyi9m2zliDJiJk+ q2mhfxNKkP3lAMH5Yq1Nzku86DEuibJtuzfSNm0HkNLGh9MnL/rL32nQRwaYT+XZ 1A8tBQtqNPUOvNLG6m1GoHqptwfuaWud72QWQ+iI3o8sqi2+rBeS9t0Lje3C3RVY 8R7XPk0ilOOwzItgC27zYWTJ8BuK//UsJ/cF4ZS1pcFk2+WvB9X7kwjKvFj0PP97 qqEjfnWwf6zspoCzKBg7rJQulh2VB4dGHaWljxWrDXyUn8DSoQ1Oyfz3GYHch0+l vetXks11NhVDEzxiJ1rtBQsAtPrXjOunTXAU2b9kuIt5aMbQVgUrfyavqSBFUa6j 6LZVAT7dkmCYVZIHwDkuwBRmc02x1TrigzpUlv8sqNEnd/MDsgX0IvhXBhJAF5j0 DueF8m7TGl8wl1UgVvpNNmJ/cfiJWC3+k3cmKLG+ldvoHzPVgBSbR1zeFKsqD5N3 lcU8VOGosxf2GpBNAIyXT8LYMdwg1FXvX8zkf3wyyUc+LhgbxWhRpGsUM2Kc5m+K X9UenI/SXJjrFBfRU31S+/voWQPCVPHb9RzHDM6oJyAsb7lDc6I/nRITDjXCu9U2 bzg/liGHVI39/2CYQpeO =4+EX -----END PGP SIGNATURE-----
Phase 3/3: Running 'mysql_fix_privilege_tables'...
Hi On 3/29/13, David Benfell <benfell@parts-unknown.org> wrote: [...] this.
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, thread_id INTEGER NOT NULL, server_' at line 1 and this.
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 89: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 95: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, query_time TIME(6) NOT NULL, lock_t' at line 1 ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 97: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 343: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1064 (42000) at line 354: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1548 (HY000) at line 1136: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1137: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1150: Cannot load from mysql.proc. The table is probably corrupted FATAL ERROR: Upgrade failed
Your sites are up. You'll want to check if database users are unable to log in. Expect that not all privilege tables look like they should including triggers and all, so you'll either have to look into said script, attempt to fix it and rerun on a backup (which includes the internal schema)... But then, as it's not really a given to be sure what the sum of what went wrong there is, you might be better off migrating your dbs to a new working directory from dumps. The easiest road would probably be downgrading to mysql for now (and grabbing backups) and fixing the issues calmly with upstream. Sorry to hear it didn't work. cheers! mar77i
participants (2)
-
David Benfell
-
Martti Kühne