[debian-mysql] Bug#805828: Bug#805828: mysql-server-5.6: upgrade didn't work, package unusable, mysql does not start
Bjoern Boschman
bjoern at boschman.de
Mon Nov 23 08:43:49 UTC 2015
Hi JP,
thank you for your bugreport.
Have you tried setting your datadir to the absolute folder (without any
symlinks?)
The log msg you reported states that your mysql database is missing.
Can you provide older log messages?
Cheers
B
2015-11-22 22:02 GMT+01:00 jpp <jp.pozzi at izzop.net>:
> 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
>
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint
>
--
Mit freundlich Grüßen / Kind regards
Björn Boschman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20151123/df1a3db8/attachment-0001.html>
More information about the pkg-mysql-maint
mailing list