[debian-mysql] Bug#688792: mysql-server-5.5: error in SQL syntax in postinst

Ross Boylan RossBoylan at stanfordalumni.org
Tue Sep 25 16:54:51 UTC 2012 

Package: mysql-server-5.5
Version: 5.5.24+dfsg-8
Severity: normal

Dear Maintainer,

   * What led up to the situation?
An upgrade in aptitude.
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
Nothing.  mysql appears to be running.  However, the failed change looks signficant.
   * What was the outcome of this action?
   * What outcome did you expect instead?
An upgrade without errors.

I am running Debian testing in a chroot.  I did an upgrade inside of aptitude yesterday:
[UPGRADE] mysql-server-5.5:i386 5.5.24+dfsg-7 -> 5.5.24+dfsg-8
and the logs show
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
[ERROR] Aborting

The offending line appears to be from the mysql postinst:
ross at corn:/var/lib/dpkg/info$ grep Show_view_priv *
mysql-server-5.5.postinst:        "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
mysql-server-5.5.postinst:        "ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N'; "\
 \

Note there is another error about "old style --language".  That's probably a separate issue, though it would be good to fix.

In case it helps, here is a fuller log:
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Sep 23 15:08:33 corn mysqld_safe[24690]: To do so, start the server, then issue the following commands:
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: /usr/bin/mysqladmin -u root password 'new-password'
Sep 23 15:08:33 corn mysqld_safe[24690]: /usr/bin/mysqladmin -u root -h corn password 'new-password'
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: Alternatively you can run:
Sep 23 15:08:33 corn mysqld_safe[24690]: /usr/bin/mysql_secure_installation
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: which will also give you the option of removing the test
Sep 23 15:08:33 corn mysqld_safe[24690]: databases and anonymous user created by default.  This is
Sep 23 15:08:33 corn mysqld_safe[24690]: strongly recommended for production servers.
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: See the manual for more instructions.
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24690]: Please report any problems with the /usr/scripts/mysqlbug script!
Sep 23 15:08:33 corn mysqld_safe[24690]: 
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 [ERROR] Use --lc-messages-dir without language specific part instead.
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 [Note] Plugin 'FEDERATED' is disabled.
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: The InnoDB memory heap is disabled
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: Compressed tables use zlib 1.2.3
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: Using Linux native AIO
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: Initializing buffer pool, size = 128.0M
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: Completed initialization of buffer pool
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: highest supported file format is Barracuda.
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33 InnoDB: 1.1.8 started; log sequence number 5257779
Sep 23 15:08:33 corn mysqld_safe[24736]: 120923 15:08:33  InnoDB: Starting shutdown...
Sep 23 15:08:35 corn mysqld_safe[24736]: 120923 15:08:35  InnoDB: Shutdown completed; log sequence number 5257779
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 [ERROR] Use --lc-messages-dir without language specific part instead.
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 [Note] Plugin 'FEDERATED' is disabled.
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: The InnoDB memory heap is disabled
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: Compressed tables use zlib 1.2.3
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: Using Linux native AIO
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: Initializing buffer pool, size = 128.0M
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: Completed initialization of buffer pool
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: highest supported file format is Barracuda.
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 InnoDB: 1.1.8 started; log sequence number 5257779
Sep 23 15:08:35 corn mysqld_safe[24761]: 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
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35 [ERROR] Aborting
Sep 23 15:08:35 corn mysqld_safe[24761]: 
Sep 23 15:08:35 corn mysqld_safe[24761]: 120923 15:08:35  InnoDB: Starting shutdown...
Sep 23 15:08:37 corn mysqld_safe[24761]: 120923 15:08:37  InnoDB: Shutdown completed; log sequence number 5257779
Sep 23 15:08:37 corn mysqld_safe[24761]: 120923 15:08:37 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 23 15:08:37 corn mysqld_safe[24761]: 
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 [ERROR] Use --lc-messages-dir without language specific part instead.
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 [Note] Plugin 'FEDERATED' is disabled.
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: The InnoDB memory heap is disabled
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: Compressed tables use zlib 1.2.3
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: Using Linux native AIO
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: Initializing buffer pool, size = 128.0M
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: Completed initialization of buffer pool
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37 InnoDB: highest supported file format is Barracuda.
Sep 23 15:08:37 corn mysqld_safe[24786]: 120923 15:08:37  InnoDB: Waiting for the background threads to start
Sep 23 15:08:38 corn mysqld_safe[24786]: 120923 15:08:38 InnoDB: 1.1.8 started; log sequence number 5257779
Sep 23 15:08:38 corn mysqld_safe[24786]: 120923 15:08:38  InnoDB: Starting shutdown...
Sep 23 15:08:39 corn mysqld_safe[24786]: 120923 15:08:39  InnoDB: Shutdown completed; log sequence number 5257779
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 [ERROR] Use --lc-messages-dir without language specific part instead.
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 [Note] Plugin 'FEDERATED' is disabled.
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: The InnoDB memory heap is disabled
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: Compressed tables use zlib 1.2.3
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: Using Linux native AIO
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: Initializing buffer pool, size = 128.0M
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: Completed initialization of buffer pool
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39 InnoDB: highest supported file format is Barracuda.
Sep 23 15:08:39 corn mysqld_safe[24808]: 120923 15:08:39  InnoDB: Waiting for the background threads to start
Sep 23 15:08:40 corn mysqld_safe[24808]: 120923 15:08:40 InnoDB: 1.1.8 started; log sequence number 5257779
Sep 23 15:08:40 corn mysqld_safe[24808]: ERROR: 1050  Table 'plugin' already exists
Sep 23 15:08:40 corn mysqld_safe[24808]: 120923 15:08:40 [ERROR] Aborting
Sep 23 15:08:40 corn mysqld_safe[24808]: 
Sep 23 15:08:40 corn mysqld_safe[24808]: 120923 15:08:40  InnoDB: Starting shutdown...
Sep 23 15:08:41 corn mysqld_safe[24808]: 120923 15:08:41  InnoDB: Shutdown completed; log sequence number 5257779
Sep 23 15:08:41 corn mysqld_safe[24808]: 120923 15:08:41 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 23 15:08:41 corn mysqld_safe[24808]: 
Sep 23 15:08:41 corn mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Sep 23 15:08:41 corn mysqld: 120923 15:08:41 [ERROR] An old style --ler socket created on IP: '192.168.40.2'.
Sep 23 15:08:42 corn mysqld: 120923 15:08:42 [Note] Event Scheduler: Loaded 0 events
Sep 23 15:08:42 corn mysqld: 120923 15:08:42 [Note] /usr/sbin/mysqld: ready for connections.
Sep 23 15:08:42 corn mysqld: Version: '5.5.24-8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Sep 23 15:08:43 corn /etc/mysql/debian-start[25261]: Upgrading MySQL tables if necessary.
Sep 23 15:08:43 corn /etc/mysql/debian-start[25265]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Sep 23 15:08:43 corn /etc/mysql/debian-start[25265]: Looking for 'mysql' as: /usr/bin/mysql
Sep 23 15:08:43 corn /etc/mysql/debian-start[25265]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 23 15:08:43 corn /etc/mysql/debian-start[25265]: This installation of MySQL is already upgraded to 5.5.24, use --force if you still need to run mysql_upgrade
Sep 23 15:08:43 corn /etc/mysql/debian-start[25276]: Checking for insecure root accounts.
Sep 23 15:08:43 corn /etc/mysql/debian-start[25281]: Triggering myisam-recover for all MyISAM tables
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: Status information:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: Current dir: /var/lib/mysql/
Sep 23 15:08:43 corn mysqld: Running threads: 1  Stack size: 196608
Sep 23 15:08:43 corn mysqld: Current locks:
Sep 23 15:08:43 corn mysqld: lock: 0xb938ee98:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9378fe8:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb934d2e0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9343550:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb932a288:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9336f10:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9325338:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9320c40:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb931bfc8:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb9314048:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6320:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d67a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6720:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d66a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6420:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d63a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d62a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6220:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d61a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6820:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d64a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6620:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d65a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6520:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6120:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d60a0:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: lock: 0xb78d6020:
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: 
Sep 23 15:08:43 corn mysqld: Key caches:
Sep 23 15:08:43 corn mysqld: default
Sep 23 15:08:43 corn mysqld: Buffer_size:      16777216
Sep 23 15:08:43 corn mysqld: Block_size:           1024
Sep 23 15:08:43 corn mysqld: Division_limit:        100
Sep 23 15:08:43 corn mysqld: Age_limit:             300
Sep 23 15:08:43 corn mysqld: blocks used:             0
Sep 23 15:08:43 corn mysqld: not flushed:             0
Sep 23 15:08:43 corn mysqld: w_requests:              0
Sep 23 15:08:43 corn mysqld: writes:                  0
Sep 23 15:08:43 corn mysqld: r_requests:              0
Sep 23 15:08:43 corn mysqld: reads:     

Thanks.
-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.46
ii  initscripts            2.88dsf-32
ii  libc6                  2.13-35
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.1-7
ii  libstdc++6             4.7.1-7
ii  lsb-base               4.1+Debian7
ii  mysql-client-5.5       5.5.24+dfsg-8
ii  mysql-common           5.5.24+dfsg-8
ii  mysql-server-core-5.5  5.5.24+dfsg-8
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.14.2-13
ii  psmisc                 22.19-1

Versions of packages mysql-server-5.5 recommends:
ii  libhtml-template-perl  2.91-1
pn  mailx                  <none>

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- debconf information:
  mysql-server-5.5/start_on_boot: true
  mysql-server-5.5/nis_warning:
  mysql-server/error_setting_password:
  mysql-server-5.5/really_downgrade: false
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb:

More information about the pkg-mysql-maint mailing list