<div dir="ltr">Hi JP,<div><br></div><div>thank you for your bugreport.</div><div>Have you tried setting your datadir to the absolute folder (without any symlinks?)</div><div><br></div><div>The log msg you reported states that your mysql database is missing.</div><div>Can you provide older log messages?</div><div><br></div><div>Cheers</div><div>B</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-22 22:02 GMT+01:00 jpp <span dir="ltr"><<a href="mailto:jp.pozzi@izzop.net" target="_blank">jp.pozzi@izzop.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Package: mysql-server-5.6<br>
Version: 5.6.27-2<br>
Severity: critical<br>
Justification: causes serious data loss<br>
<br>
Hello,<br>
<br>
I am using the "unstable" release and after the previous update Mysql is<br>
unusable.<br>
The configuration files where updated and the result is an unusable database.<br>
Mysql won't start giving me stranges messages.<br>
The /var/lib/mysql is a symlinj to another location on another disk.<br>
I saw that some configuration options where not ok :<br>
innodb_data_home_dir =<br>
innodb_data_file_path =<br>
/var/lib/mysql/ibdata1:1024M;/var/lib/mysql/ibdata2:1024M:autoextend<br>
No directory for innodb_data_home_dir ?<br>
The "bind address" which was "0.0.0.0" has disapeared.<br>
I try some workaround. If I use :<br>
innodb_data_home_dir = /var/lib/mysql/<br>
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M:autoextend<br>
I get messages complaining on system error reading files.<br>
<br>
After a while I delete all "ib...." files and relaunch the service with no<br>
success,<br>
the "ib..." files were recreated but the error.log mentionned that it can bind<br>
to this<br>
address (127.0.0.1) and asking if another mysql process was running (this is<br>
not the case).<br>
<br>
I try to use a specific address "bind 192.168.2.8" and mysql does not start<br>
with messages :<br>
<br>
2015-11-22 21:53:53 4936 [Note] InnoDB: Waiting for purge to start<br>
2015-11-22 21:53:53 4936 [Note] InnoDB: 5.6.27 started; log sequence number<br>
1600618<br>
2015-11-22 21:53:53 4936 [Note] Recovering after a crash using /var/log/mysql<br>
/mysql-bin<br>
2015-11-22 21:53:53 4936 [Note] Starting crash recovery...<br>
2015-11-22 21:53:53 4936 [Note] Crash recovery finished.<br>
2015-11-22 21:53:53 4936 [Note] Server hostname (bind-address): '192.168.2.8';<br>
port: 3306<br>
2015-11-22 21:53:53 4936 [Note] - '192.168.2.8' resolves to '192.168.2.8';<br>
2015-11-22 21:53:53 4936 [Note] Server socket created on IP: '192.168.2.8'.<br>
2015-11-22 21:53:53 4936 [ERROR] Fatal error: Can't open and lock privilege<br>
tables: Table 'mysql.user' doesn't exist<br>
<br>
The upgrade was not successful and I get a fully crashed database.<br>
<br>
Regards<br>
<br>
JP P<br>
<br>
PS : I save some distinct error logs.<br>
<br>
<br>
<br>
<br>
<br>
-- System Information:<br>
Debian Release: stretch/sid<br>
APT prefers testing-updates<br>
APT policy: (500, 'testing-updates'), (500, 'testing')<br>
Architecture: amd64 (x86_64)<br>
<br>
Kernel: Linux 4.3.0-x (SMP w/8 CPU cores)<br>
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)<br>
Shell: /bin/sh linked to /bin/dash<br>
Init: systemd (via /run/systemd/system)<br>
<br>
Versions of packages mysql-server-5.6 depends on:<br>
ii adduser 3.113+nmu3<br>
ii debconf [debconf-2.0] 1.5.58<br>
ii init-system-helpers 1.24<br>
ii initscripts 2.88dsf-59.2<br>
ii libaio1 0.3.110-2<br>
ii libc6 2.19-22<br>
ii libdbi-perl 1.634-1<br>
ii libgcc1 1:5.2.1-23<br>
ii libstdc++6 5.2.1-23<br>
ii libwrap0 7.6.q-25<br>
ii lsb-base 9.20150917<br>
ii mysql-client-5.6 5.6.27-2<br>
ii mysql-common 5.6.27-2<br>
ii mysql-server-core-5.6 5.6.27-2<br>
ii passwd 1:4.2-3.1<br>
ii perl 5.20.2-6<br>
ii psmisc 22.21-2.1<br>
ii zlib1g 1:1.2.8.dfsg-2+b1<br>
<br>
Versions of packages mysql-server-5.6 recommends:<br>
ii libhtml-template-perl 2.95-2<br>
<br>
Versions of packages mysql-server-5.6 suggests:<br>
ii bsd-mailx [mailx] 8.1.2-0.20150408cvs-1<br>
pn tinyca <none><br>
<br>
-- Configuration Files:<br>
/etc/logcheck/ignore.d.paranoid/mysql-server-5_6 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_6'<br>
/etc/logcheck/ignore.d.server/mysql-server-5_6 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_6'<br>
/etc/logcheck/ignore.d.workstation/mysql-server-5_6 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_6'<br>
/etc/mysql/mysql.cnf [Errno 2] No such file or directory: u'/etc/mysql/mysql.cnf'<br>
/etc/mysql/mysql.conf.d/mysqld.cnf changed:<br>
[mysqld_safe]<br>
socket = /var/run/mysqld/mysqld.sock<br>
nice = 0<br>
[mysqld]<br>
user = mysql<br>
pid-file = /var/run/mysqld/mysqld.pid<br>
socket = /var/run/mysqld/mysqld.sock<br>
basedir = /usr<br>
datadir = /var/lib/mysql<br>
tmpdir = /tmp<br>
lc-messages-dir = /usr/share/mysql<br>
skip-external-locking<br>
port = 3306<br>
bind-address = 192.168.2.8<br>
key_buffer_size = 16M<br>
max_allowed_packet = 16M<br>
thread_stack = 192K<br>
thread_cache_size = 8<br>
myisam-recover = BACKUP<br>
max_connections = 16<br>
query_cache_limit = 1M<br>
query_cache_size = 16M<br>
general_log_file = /var/log/mysql/mysql.log<br>
general_log = 1<br>
log_error = /var/log/mysql/error.log<br>
server-id = 1<br>
log_bin = /var/log/mysql/mysql-bin.log<br>
expire_logs_days = 10<br>
max_binlog_size = 100M<br>
innodb_data_home_dir = /var/lib/mysql<br>
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M:autoextend<br>
innodb_log_file_size = 128M<br>
innodb_log_group_home_dir=/var/lib/mysql<br>
<br>
<br>
-- debconf information excluded<br>
<br>
_______________________________________________<br>
pkg-mysql-maint mailing list<br>
<a href="mailto:pkg-mysql-maint@lists.alioth.debian.org">pkg-mysql-maint@lists.alioth.debian.org</a><br>
<a href="http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint" rel="noreferrer" target="_blank">http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Mit freundlich Grüßen / Kind regards<br><br>Björn Boschman</div>
</div>