[debian-mysql] Bug#688792: syntax error

[Noah Meyerhans]

Hi. I've just experienced this problem on a fresh wheezy install using
the beta3 installer. The installation was performed using the netboot
image (that is, PXE and downloading the installer components from a TFTP
server) on a physical, non-virtual host.

I haven't put in a lot of time to investigate, but one thing I have
observed is that if I try to install mysql-server-5.5 on a freshly
installed system that has the 'desktop' task installed, the installation
fails. However, if I build a similar system but leave off the 'desktop'
task, the mysql installation is successful. Obviously there are a lot of
packages involved in the desktop task, so I'm not sure how much this
help to narrow things down. It definitely appears repeatable, however.

Since this problem does impact the ability to install the mysql server
packages on a common system configuration, I think a severity of at
least 'important' is warranted. Honestly I think 'grave' would be
appropriate, as I don't think it'd be reasonable to release wheezy with
this bug in place.

Relevant section of the log file:
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: The InnoDB memory heap is disabled
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: Compressed tables use zlib 1.2.7
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: Using Linux native AIO
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: Initializing buffer pool, size = 128.0M
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: Completed initialization of buffer pool
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07 InnoDB: highest supported file format is Barracuda.
Oct 21 23:11:07 dhcp204 mysqld_safe[4610]: 121021 23:11:07  InnoDB: Waiting for the background threads to start
Oct 21 23:11:08 dhcp204 mysqld_safe[4610]: 121021 23:11:08 InnoDB: 1.1.8 started; log sequence number 1595675
Oct 21 23:11:08 dhcp204 mysqld_safe[4610]: 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
Oct 21 23:11:08 dhcp204 mysqld_safe[4610]: 121021 23:11:08 [ERROR] Aborting
Oct 21 23:11:08 dhcp204 mysqld_safe[4610]:
Oct 21 23:11:08 dhcp204 mysqld_safe[4610]: 121021 23:11:08  InnoDB: Starting shutdown...
Oct 21 23:11:09 dhcp204 mysqld_safe[4610]: 121021 23:11:09  InnoDB: Shutdown completed; log sequence number 1595675
Oct 21 23:11:09 dhcp204 mysqld_safe[4610]: 121021 23:11:09 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 23:11:09 dhcp204 mysqld_safe[4610]:

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 190 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20121021/1683cf1b/attachment.pgp>