Your message dated Thu, 05 Jul 2012 15:53:12 +0000
with message-id <[email protected]>
and subject line Bug#680362: Removed package(s) from unstable
has caused the Debian Bug report #663968,
regarding mysql-server-5.1: Error 1064 logged restarting MySQL server after
upgrade from 5.1.49-4 to 5.1.61-0
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
663968: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=663968
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
Version: 5.1.62-1+rm
Dear submitter,
as the package mysql-5.1 has just been removed from the Debian archive
unstable we hereby close the associated bug reports. We are sorry
that we couldn't deal with your issue properly.
For details on the removal, please see http://bugs.debian.org/680362
The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.
This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].
Debian distribution maintenance software
pp.
Alexander Reichle-Schmehl (the ftpmaster behind the curtain)
--- End Message ---
