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@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: -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org