<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 07/15/2016 04:13 PM, Barry Martin
wrote:<br>
</div>
<blockquote cite="mid:1468613594.6420.7.camel@Lenovo-M58"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="GtkHTML/4.6.6">
<br>
Hi Bill!<br>
<br>
<blockquote type="CITE"> <font size="2"><font color="#000000">>
barry@MythBE1:~$ systemctl restart mysql.service</font></font><br>
<font size="2"><font color="#000000">> Job for mysql.service
failed because the control process exited with</font></font><br>
<font size="2"><font color="#000000">> error code. See
"systemctl status mysql.service" and "journalctl -xe"</font></font><br>
<font size="2"><font color="#000000">> for details.</font></font><br>
<br>
<font color="#3c3c3c">Do (only) these 4 commands, to get the
most recent cause</font><br>
<font color="#3c3c3c">of mysql failing to start:</font><br>
<br>
<font color="#3c3c3c"> sudo systemctl stop mysql.service</font><br>
<font size="2"><font color="#3c3c3c"> sudo mv
/var/log/mysql/error.log
/var/log/mysql/error.remove.me.later</font></font><br>
<font color="#3c3c3c"> sudo systemctl start mysql.service</font><br>
<font color="#3c3c3c"> sudo cat /var/log/mysql/error.log</font><br>
<br>
<font color="#3c3c3c">Since the lines from the last command are
likely to</font><br>
<font color="#3c3c3c">be long (and get folded in email)
copy/paste its</font><br>
<font color="#3c3c3c">output to pastebin.com and put the link to
the</font><br>
<font color="#3c3c3c">paste here. Folks who know mysql may be
able to</font><br>
<font color="#3c3c3c">spot the cause.</font><br>
</blockquote>
<br>
Y'mean I'm not supposed to be posting 500 lines of error.log?!
(And sorry about that folks - realized after-the-fact I had posted
a couple of too-huge replies. Frankly I had forgotten about
PostBinIt at the time.)<br>
<br>
The Error log has been posted as <br>
<a moz-do-not-send="true" href="mailto:barry@Lenovo-M58">barry@Lenovo-M58</a>:~$
pastebinit '/media/barry/ADATA UFD/MythBE1 - 15/error,log' <br>
<a moz-do-not-send="true" href="http://paste.ubuntu.com/19537423/">http://paste.ubuntu.com/19537423/</a><br>
<br>
Hopefully someone can figure out what happened. And thanks for
your reply and whomever helps figure out the problem.<br>
<br>
Barry<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
It looks like this may be the problem<br>
<pre>2016-07-15T19:54:53.773209Z 0 [ERROR] unknown variable 'table_cache=128'
2016-07-15T19:54:53.773236Z 0 [ERROR] Aborting
</pre>
Edit the configuration file, normally here but could be somewhere
else<br>
/etc/mysql/mysql.conf.d/mysqld.cnf<br>
If there is a line "table_cache=128" then comment it.<br>
<br>
</body>
</html>