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
