[mythtv-users] MythBE1 Backend Faile

[Peter Bennett]

On 07/15/2016 04:13 PM, Barry Martin wrote:
>
> Hi Bill!
>
>> > barry at MythBE1:~$ systemctl restart mysql.service
>> > Job for mysql.service failed because the control process exited with
>> > error code. See "systemctl status mysql.service" and "journalctl -xe"
>> > for details.
>>
>> Do (only) these 4 commands, to get the most recent cause
>> of mysql failing to start:
>>
>>   sudo systemctl stop mysql.service
>>   sudo mv /var/log/mysql/error.log /var/log/mysql/error.remove.me.later
>>   sudo systemctl start mysql.service
>>   sudo cat /var/log/mysql/error.log
>>
>> Since the lines from the last command are likely to
>> be long (and get folded in email) copy/paste its
>> output to pastebin.com and put the link to the
>> paste here. Folks who know mysql may be able to
>> spot the cause.
>
> 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.)
>
> The Error log has been posted as
> barry at Lenovo-M58 <mailto:barry at Lenovo-M58>:~$ pastebinit
> '/media/barry/ADATA UFD/MythBE1 - 15/error,log'
> http://paste.ubuntu.com/19537423/
>
> Hopefully someone can figure out what happened.  And thanks for your
> reply and whomever helps figure out the problem.
>
> Barry
>
>
>
It looks like this may be the problem

2016-07-15T19:54:53.773209Z 0 [ERROR] unknown variable 'table_cache=128'
2016-07-15T19:54:53.773236Z 0 [ERROR] Aborting

Edit the configuration file, normally here but could be somewhere else
/etc/mysql/mysql.conf.d/mysqld.cnf
If there is a line "table_cache=128" then comment it.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160715/269a9049/attachment.html>