[mythtv-users] MYSQL problems on upgrade to ubuntu 16.04

Jack McGee jack at greendesk.net
Sun Aug 28 20:29:27 UTC 2016 

On 08/28/2016 03:01 PM, Bill Meek wrote:
> On 08/28/2016 01:34 PM, Jack McGee wrote:
>>
>> mythuser at amethi:/usr/share/mythtv$ systemctl status -l -n999 
>> mysqld.service
>> ● mysqld.service
>>    Loaded: not-found (Reason: No such file or directory)
>>    Active: inactive (dead)
>
> Substitute mysql for mysqld in the above, e.g.
>
>     journalctl --unit mysql.service
>     systemctl status -l -n999 mysql.service
>

mythuser at amethi:~$ journalctl --unit mysql.service
-- Logs begin at Sun 2016-08-28 14:43:42 CDT, end at Sun 2016-08-28 
15:20:20 CDT. --
Aug 28 14:43:48 amethi systemd[1]: Starting LSB: Start and stop the 
mysql database server daemon...
Aug 28 14:43:49 amethi mysql[3929]:  * Starting MariaDB database server 
mysqld
Aug 28 14:44:18 amethi mysql[3929]:    ...fail!
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Control process 
exited, code=exited status=1
Aug 28 14:44:18 amethi systemd[1]: Failed to start LSB: Start and stop 
the mysql database server daemon.
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Unit entered failed state.
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Failed with result 
'exit-code'.

mythuser at amethi:~$ systemctl status -l -n999 mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
    Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
    Active: failed (Result: exit-code) since Sun 2016-08-28 14:44:18 
CDT; 38min ago
      Docs: man:systemd-sysv-generator(8)

Aug 28 14:43:48 amethi systemd[1]: Starting LSB: Start and stop the 
mysql database server daemon...
Aug 28 14:43:49 amethi mysql[3929]:  * Starting MariaDB database server 
mysqld
Aug 28 14:44:18 amethi mysql[3929]:    ...fail!
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Control process 
exited, code=exited status=1
Aug 28 14:44:18 amethi systemd[1]: Failed to start LSB: Start and stop 
the mysql database server daemon.
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Unit entered failed state.
Aug 28 14:44:18 amethi systemd[1]: mysql.service: Failed with result 
'exit-code'.


I think I do not have a working MYSQL server installation:

mythuser at amethi:~$ sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer 
required:
   libterm-readkey-perl mariadb-common
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
   mysql-server-5.7
Suggested packages:
   mailx tinyca
The following NEW packages will be installed:
   mysql-server-5.7
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
5 not fully installed or removed.
Need to get 0 B/2,722 kB of archives.
After this operation, 48.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Preconfiguring packages ...
(Reading database ... 656713 files and directories currently installed.)
Preparing to unpack 
.../mysql-server-5.7_5.7.13-0ubuntu0.16.04.2_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Processing triggers for ureadahead (0.100.0-19) ...
ureadahead will be reprofiled on next reboot
Processing triggers for systemd (229-4ubuntu7) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-client-core-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Setting up mysql-client-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Setting up mysql-client (5.7.13-0ubuntu0.16.04.2) ...
Setting up mysql-server-core-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Setting up mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ...
Installing new version of config file /etc/init.d/mysql ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2016-08-28T20:25:53.785441Z 0 [ERROR] unknown variable 'table_cache=128'
2016-08-28T20:25:53.787857Z 0 [ERROR] Aborting
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips 
on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
  subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
  mysql-server depends on mysql-server-5.7; however:
   Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
  dependency problems - leaving unconfigured
No apport report written because the error message indicates its a 
followup error from a previous failure.
Processing triggers for systemd (229-4ubuntu7) ...
Processing triggers for ureadahead (0.100.0-19) ...
Errors were encountered while processing:
  mysql-server-5.7
  mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


mythuser at amethi:~$ sudo apt autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
   libterm-readkey-perl mariadb-common
0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 154 kB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 656793 files and directories currently installed.)
Removing libterm-readkey-perl (2.33-1build1) ...
Removing mariadb-common (10.0.25-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide 
/etc/mysql/my.cnf (my.cnf) in auto mode
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2016-08-28T20:28:09.019262Z 0 [ERROR] unknown variable 'table_cache=128'
2016-08-28T20:28:09.021480Z 0 [ERROR] Aborting
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips 
on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
  subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
  mysql-server depends on mysql-server-5.7; however:
   Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
  dependency problems - leaving unconfigured
No apport report written because the error message indicates its a 
followup error from a previous failure.
Errors were encountered while processing:
  mysql-server-5.7
  mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

More information about the mythtv-users mailing list