Your message dated Tue, 31 Jan 2017 05:02:59 +0000
with message-id <[email protected]>
and subject line Bug#853139: Removed package(s) from unstable
has caused the Debian Bug report #805828,
regarding mysql-server-5.6: upgrade didn't work, package unusable, mysql does
not start
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.)
--
805828: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=805828
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mysql-server-5.6
Version: 5.6.27-2
Severity: critical
Justification: causes serious data loss
Hello,
I am using the "unstable" release and after the previous update Mysql is
unusable.
The configuration files where updated and the result is an unusable database.
Mysql won't start giving me stranges messages.
The /var/lib/mysql is a symlinj to another location on another disk.
I saw that some configuration options where not ok :
innodb_data_home_dir =
innodb_data_file_path =
/var/lib/mysql/ibdata1:1024M;/var/lib/mysql/ibdata2:1024M:autoextend
No directory for innodb_data_home_dir ?
The "bind address" which was "0.0.0.0" has disapeared.
I try some workaround. If I use :
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M:autoextend
I get messages complaining on system error reading files.
After a while I delete all "ib...." files and relaunch the service with no
success,
the "ib..." files were recreated but the error.log mentionned that it can bind
to this
address (127.0.0.1) and asking if another mysql process was running (this is
not the case).
I try to use a specific address "bind 192.168.2.8" and mysql does not start
with messages :
2015-11-22 21:53:53 4936 [Note] InnoDB: Waiting for purge to start
2015-11-22 21:53:53 4936 [Note] InnoDB: 5.6.27 started; log sequence number
1600618
2015-11-22 21:53:53 4936 [Note] Recovering after a crash using /var/log/mysql
/mysql-bin
2015-11-22 21:53:53 4936 [Note] Starting crash recovery...
2015-11-22 21:53:53 4936 [Note] Crash recovery finished.
2015-11-22 21:53:53 4936 [Note] Server hostname (bind-address): '192.168.2.8';
port: 3306
2015-11-22 21:53:53 4936 [Note] - '192.168.2.8' resolves to '192.168.2.8';
2015-11-22 21:53:53 4936 [Note] Server socket created on IP: '192.168.2.8'.
2015-11-22 21:53:53 4936 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.user' doesn't exist
The upgrade was not successful and I get a fully crashed database.
Regards
JP P
PS : I save some distinct error logs.
-- System Information:
Debian Release: stretch/sid
APT prefers testing-updates
APT policy: (500, 'testing-updates'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.3.0-x (SMP w/8 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages mysql-server-5.6 depends on:
ii adduser 3.113+nmu3
ii debconf [debconf-2.0] 1.5.58
ii init-system-helpers 1.24
ii initscripts 2.88dsf-59.2
ii libaio1 0.3.110-2
ii libc6 2.19-22
ii libdbi-perl 1.634-1
ii libgcc1 1:5.2.1-23
ii libstdc++6 5.2.1-23
ii libwrap0 7.6.q-25
ii lsb-base 9.20150917
ii mysql-client-5.6 5.6.27-2
ii mysql-common 5.6.27-2
ii mysql-server-core-5.6 5.6.27-2
ii passwd 1:4.2-3.1
ii perl 5.20.2-6
ii psmisc 22.21-2.1
ii zlib1g 1:1.2.8.dfsg-2+b1
Versions of packages mysql-server-5.6 recommends:
ii libhtml-template-perl 2.95-2
Versions of packages mysql-server-5.6 suggests:
ii bsd-mailx [mailx] 8.1.2-0.20150408cvs-1
pn tinyca <none>
-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mysql-server-5_6 [Errno 13] Permission denied:
u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_6'
/etc/logcheck/ignore.d.server/mysql-server-5_6 [Errno 13] Permission denied:
u'/etc/logcheck/ignore.d.server/mysql-server-5_6'
/etc/logcheck/ignore.d.workstation/mysql-server-5_6 [Errno 13] Permission
denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_6'
/etc/mysql/mysql.cnf [Errno 2] No such file or directory:
u'/etc/mysql/mysql.cnf'
/etc/mysql/mysql.conf.d/mysqld.cnf changed:
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
port = 3306
bind-address = 192.168.2.8
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 16
query_cache_limit = 1M
query_cache_size = 16M
general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_error = /var/log/mysql/error.log
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M:autoextend
innodb_log_file_size = 128M
innodb_log_group_home_dir=/var/lib/mysql
-- debconf information excluded
--- End Message ---
--- Begin Message ---
Version: 5.6.35-1+rm
Dear submitter,
as the package mysql-5.6 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 https://bugs.debian.org/853139
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.
Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
