I see this error in each upgrade. Looking in mysql error log while mysql
update his package appears:
tail -F /var/log/mysql/error.log
ERROR: 1064 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 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER
SET utf8 NOT ' at line 1
apt-source mysql-server
Grepping by:
grep -rin Show_view_priv
Shows that:
debian/mysql-server-5.5.postinst
If failing to add new columns because the fix is already done, then we
are getting duplicate error columns messages, That kills the start of
mysql.
replace_query=`echo -e \
"USE mysql\n" \
"REPLACE INTO user SET " \
" host='localhost', user='debian-sys-maint',
password=password('$pass'), " \
" Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y',
" \
" Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y',
" \
" Process_priv='Y', File_priv='Y', Grant_priv='Y',
References_priv='Y', " \
" Index_priv='Y', Alter_priv='Y', Super_priv='Y', Show_db_priv='Y', "\
" Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', "\
" Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
" Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y',
"\
" Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y',
Create_tablespace_priv='Y' "`;
fix_privs=`echo -e \
"USE mysql;\n" \
"ALTER TABLE user ADD column Create_view_priv enum('N','Y') CHARACTER
SET utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET
utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Create_routine_priv enum('N','Y')
CHARACTER SET utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Alter_routine_priv enum('N','Y') CHARACTER
SET utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Create_user_priv enum('N','Y') CHARACTER
SET utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Event_priv enum('N','Y') CHARACTER SET
utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Trigger_priv enum('N','Y') CHARACTER SET
utf8 NOT NULL DEFAULT 'N'; " \
"ALTER TABLE user ADD column Create_tablespace_priv enum('N','Y')
CHARACTER SET utf8 NOT NULL DEFAULT 'N'; " `
After see this. I found this debian upstream bug unresolved
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=708176. So probably
this is a duplicate. This need raise priority to severity, because all
future mysql-server upgrades will fail applying this code if no change.
This is specially important if ubuntu wants market in cloud servers with
mysql.
** Bug watch added: Debian Bug tracker #708176
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=708176
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1208729
Title:
Unable to start mysql after upgrade from repository. It was an upgrade
over the 5.5 version. package mysql-server-5.5 5.5.32-0ubuntu0.12.04.1
failed to install/upgrade: el subproceso instalado el script post-
installation devolvió el código de salida de error 1
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1208729/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
