[debian-mysql] Bug#663968: mysql-server-5.1: Error 1064 logged restarting MySQL server after upgrade from 5.1.49-4 to 5.1.61-0

Simon Waters simon at technocool.net
Wed Mar 14 11:34:46 UTC 2012 

Package: mysql-server-5.1
Version: 5.1.61-0+squeeze1
Severity: normal


During the recent update of MySQL in Debian Squeeze I noted a couple of errors in the log
file on our test server. Since it is fairly clean install of MySQL I
wondered if it is useful to report them.

Subsequent attempts to restart MySQL produce no errors.

No problems in operation have been noted, but MySQL on this box is used 
only occasionally when bug fixed client websites that use MySQL backend.

Mar 12 12:19:42 disraeli mysqld_safe[22450]: 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

Mar 12 12:19:53 disraeli mysqld_safe[22483]: ERROR: 1050  Table 'plugin'
already exists

A Show_view_priv column with similar attributes exists in the users
table.

According the dpkg log these are 20 seconds after dpkg had configured the MySQL
updates so I presume restarting of the services after that upgrade.

Here is a list of upgrades applied on that day from dpkg.log

2012-03-12 12:18:44 upgrade mysql-common 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:18:45 upgrade mysql-server 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:18:45 upgrade mysql-client 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:18:46 upgrade libmysqlclient-dev 5.1.49-3
5.1.61-0+squeeze1
2012-03-12 12:18:50 upgrade libmysqlclient16 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:18:51 upgrade mysql-client-5.1 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:19:07 upgrade mysql-server-5.1 5.1.49-3 5.1.61-0+squeeze1
2012-03-12 12:19:18 upgrade mysql-server-core-5.1 5.1.49-3
5.1.61-0+squeeze1
2012-03-12 12:19:20 upgrade libdbd-pg-perl 2.17.1-2 2.17.1-2+squeeze1
2012-03-12 12:19:22 upgrade libfreetype6-dev 2.4.2-2.1+squeeze3
2.4.2-2.1+squeeze4
2012-03-12 12:19:24 upgrade libfreetype6 2.4.2-2.1+squeeze3
2.4.2-2.1+squeeze4

Mar 12 12:19:08 disraeli mysqld: 120312 12:19:08 [Note]
/usr/sbin/mysqld: Normal shutdown
Mar 12 12:19:08 disraeli mysqld:
Mar 12 12:19:08 disraeli mysqld: 120312 12:19:08 [Note] Event Scheduler:
Purging the queue. 0 events
Mar 12 12:19:08 disraeli mysqld: 120312 12:19:08  InnoDB: Starting
shutdown...
Mar 12 12:19:11 disraeli mysqld: 120312 12:19:11  InnoDB: Shutdown
completed; log sequence number 0 203165
Mar 12 12:19:11 disraeli mysqld: 120312 12:19:11 [Note]
/usr/sbin/mysqld: Shutdown complete
Mar 12 12:19:11 disraeli mysqld:
Mar 12 12:19:11 disraeli mysqld_safe: mysqld from pid file
/var/run/mysqld/mysqld.pid ended
Mar 12 12:19:36 disraeli mysqld_safe[22378]: /usr/bin/mysqladmin -u root
-h disraeli password 'new-password'
Mar 12 12:19:36 disraeli mysqld_safe[22378]: Alternatively you can run:
Mar 12 12:19:36 disraeli mysqld_safe[22378]:
/usr/bin/mysql_secure_installation
Mar 12 12:19:36 disraeli mysqld_safe[22378]: which will also give you
the option of removing the test
Mar 12 12:19:36 disraeli mysqld_safe[22378]: databases and anonymous
user created by default.  This is
Mar 12 12:19:36 disraeli mysqld_safe[22378]: strongly recommended for
production servers.
Mar 12 12:19:36 disraeli mysqld_safe[22378]: Please report any problems
with the /usr/scripts/mysqlbug script!
Mar 12 12:19:36 disraeli mysqld_safe[22426]: 120312 12:19:36 [Note]
Plugin 'FEDERATED' is disabled.
Mar 12 12:19:36 disraeli mysqld_safe[22426]: 120312 12:19:36  InnoDB:
Initializing buffer pool, size = 8.0M
Mar 12 12:19:36 disraeli mysqld_safe[22426]: 120312 12:19:36  InnoDB:
Completed initialization of buffer pool
Mar 12 12:19:36 disraeli mysqld_safe[22426]: 120312 12:19:36  InnoDB:
Started; log sequence number 0 203165
Mar 12 12:19:36 disraeli mysqld_safe[22426]: 120312 12:19:36  InnoDB:
Starting shutdown...
Mar 12 12:19:42 disraeli mysqld_safe[22426]: 120312 12:19:42  InnoDB:
Shutdown completed; log sequence number 0 203165
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42 [Note]
Plugin 'FEDERATED' is disabled.
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42  InnoDB:
Initializing buffer pool, size = 8.0M
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42  InnoDB:
Completed initialization of buffer pool
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42  InnoDB:
Started; log sequence number 0 203165
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 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
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42 [ERROR]
Aborting
Mar 12 12:19:42 disraeli mysqld_safe[22450]: 120312 12:19:42  InnoDB:
Starting shutdown...
Mar 12 12:19:47 disraeli mysqld_safe[22450]: 120312 12:19:47  InnoDB:
Shutdown completed; log sequence number 0 203165
Mar 12 12:19:47 disraeli mysqld_safe[22450]: 120312 12:19:47 [Note]
/usr/sbin/mysqld: Shutdown complete
Mar 12 12:19:47 disraeli mysqld_safe[22467]: 120312 12:19:47 [Note]
Plugin 'FEDERATED' is disabled.
Mar 12 12:19:47 disraeli mysqld_safe[22467]: 120312 12:19:47  InnoDB:
Initializing buffer pool, size = 8.0M
Mar 12 12:19:48 disraeli mysqld_safe[22467]: 120312 12:19:48  InnoDB:
Completed initialization of buffer pool
Mar 12 12:19:48 disraeli mysqld_safe[22467]: 120312 12:19:48  InnoDB:
Started; log sequence number 0 203165
Mar 12 12:19:48 disraeli mysqld_safe[22467]: 120312 12:19:48  InnoDB:
Starting shutdown...
Mar 12 12:19:53 disraeli mysqld_safe[22467]: 120312 12:19:53  InnoDB:
Shutdown completed; log sequence number 0 203165
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53 [Note]
Plugin 'FEDERATED' is disabled.
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53  InnoDB:
Initializing buffer pool, size = 8.0M
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53  InnoDB:
Completed initialization of buffer pool
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53  InnoDB:
Started; log sequence number 0 203165
Mar 12 12:19:53 disraeli mysqld_safe[22483]: ERROR: 1050  Table 'plugin'
already exists
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53 [ERROR]
Aborting
Mar 12 12:19:53 disraeli mysqld_safe[22483]: 120312 12:19:53  InnoDB:
Starting shutdown...
Mar 12 12:19:58 disraeli mysqld_safe[22483]: 120312 12:19:58  InnoDB:
Shutdown completed; log sequence number 0 203165
Mar 12 12:19:58 disraeli mysqld_safe[22483]: 120312 12:19:58 [Note]
/usr/sbin/mysqld: Shutdown complete
Mar 12 12:20:00 disraeli mysqld_safe: Starting mysqld daemon with
databases from /var/lib/mysql



-- System Information:
Debian Release: 6.0.4
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-25-hvmflexiant (SMP w/1 CPU core)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.1 depends on:
ii  adduser     3.112+nmu2                   add and remove users and groups
ii  debconf [de 1.5.36.1                     Debian configuration management sy
ii  libc6       2.11.3-2                     Embedded GNU C Library: Shared lib
ii  libdbi-perl 1.612-1                      Perl Database Interface (DBI)
ii  libgcc1     1:4.4.5-8                    GCC support library
ii  libmysqlcli 5.1.61-0+squeeze1            MySQL database client library
ii  libstdc++6  4.4.5-8                      The GNU Standard C++ Library v3
ii  lsb-base    3.2-23.2squeeze1             Linux Standard Base 3.2 init scrip
ii  mysql-clien 5.1.61-0+squeeze1            MySQL database client binaries
ii  mysql-commo 5.1.61-0+squeeze1            MySQL database common files, e.g. 
ii  mysql-serve 5.1.61-0+squeeze1            MySQL database server binaries
ii  passwd      1:4.1.4.2+svn3283-2+squeeze1 change and administer password and
ii  perl        5.10.1-17squeeze3            Larry Wall's Practical Extraction 
ii  psmisc      22.11-1                      utilities that use the proc file s
ii  zlib1g      1:1.2.3.4.dfsg-3             compression library - runtime

Versions of packages mysql-server-5.1 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20100314cvs-1 simple mail user agent
ii  heirloom-mailx [ma 12.4-2                feature-rich BSD mail(1)
ii  libhtml-template-p 2.9-2                 module for using HTML Templates wi

Versions of packages mysql-server-5.1 suggests:
pn  tinyca                        <none>     (no description available)

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_1'
/etc/logcheck/ignore.d.server/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_1'
/etc/logcheck/ignore.d.workstation/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_1'

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

More information about the pkg-mysql-maint mailing list