[debian-mysql] Bug#810024: mysql-server: Starting MySQL database server: mysqld ........<snip> ..... FAILED

[Berni Elbourn]

Package: mysql-server
Version: 5.5.46-0+deb8u1
Severity: minor
Tags: patch

Dear Maintainer,

*** Reporter, please consider answering these questions, where appropriate ***

   * What led up to the situation?

	wheezy to jessie upgrade

   * What exactly did you do (or not do) that was effective (or
     ineffective)?

	learn about systemd

   * What was the outcome of this action?

	systemd's extream parallelism delays the startup of mysql server
	beyound that expected previosuly
	
   * What outcome did you expect instead?

	for mysql to wait until started, or to report a proper error code.
	
*** End of the template - remove these template lines ***

The patch which works for here is to extend the wait for mysql start to 90 seconds as follows:

/etc/init.d/mysql from line 111:-

	    # 6s was reported in #352070 to be too few when using ndbcluster
            # 14s was reported in #736452 to be too few with large installs
            # 30 is far to short in the jessie systemd rush Berni 3/1/15
            for i in $(seq 1 90); do
                sleep 1
                if mysqld_status check_alive nowarn ; then break; fi
                log_progress_msg "."
            done

Perhap instead there should be some serialisation introduced into the systemd startup to maximise the resources available to a critical service such as a database startup. If I find out how I will follow up.  Meantime please feel free to close the bug.


-- System Information:
Debian Release: 8.2
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mysql-server depends on:
ii  mysql-server-5.5  5.5.46-0+deb8u1

mysql-server recommends no packages.

mysql-server suggests no packages.

-- no debconf information