[mythtv-users] MythBE1 Backend Failed

Wed Jul 13 18:46:36 UTC 2016

Hi Mark!

(Hmmm: interesting: system updates include mysql stuff: client core,
common, server. Did my whinings and problems cause the Powers That
Create to correct something?!) 

(Myth Backend, Myth Frontend, Everything??!!) (Wonder what 'whoopsie'
is/does?!)

(Waiting for the software update to complete before responding.....)

Hmmm: didn't install correctly ...11.4 MB, running Software Updater
again and seems very slow. ...Suppose if the servers are busy would be..
Installing – top three or four something about incorrect admin password.
Remainder seem to be installing OK......

<back from lunch>

Great: “Package operation failed” ...Try the Software Updater
again.... ...“The software on this computer is up to date”. Okey-dokey.
(Have seen that failed-and-OK combination before.)

> Ok MySQL is crashed so need to fix that first. First just to confirm
> are you on mythbuntu 16.04?

Yes, though I was trying to double-check myself...   lsb_release -a
gives "Ubuntu 16.04 LTS".  Whew!  Just because the install DVD says....!

> To get the full log output try this command:
> sudo journalctl -umysql | more

Looks like just looping:

barry at MythBE1:~$ sudo journalctl -umysql | more

[sudo] password for barry: 

-- Logs begin at Wed 2016-07-13 11:38:01 CDT, end at Wed 2016-07-13
13:17:28 CDT

. --

Jul 13 11:38:16 MythBE1 systemd[1]: Starting MySQL Community Server...

Jul 13 11:38:29 MythBE1 systemd[1]: mysql.service: Main process exited,
code=exi

ted, status=1/FAILURE

Jul 13 11:38:45 MythBE1 systemd[1]: Failed to start MySQL Community
Server.

Jul 13 11:38:45 MythBE1 systemd[1]: mysql.service: Unit entered failed
state.

Jul 13 11:38:45 MythBE1 systemd[1]: mysql.service: Failed with result
'exit-code

'.

Jul 13 11:38:45 MythBE1 systemd[1]: mysql.service: Service hold-off time
over, s

cheduling restart.

Jul 13 11:38:45 MythBE1 systemd[1]: Stopped MySQL Community Server.

Jul 13 11:38:45 MythBE1 systemd[1]: Starting MySQL Community Server...

Jul 13 11:38:47 MythBE1 systemd[1]: mysql.service: Main process exited,
code=exi

ted, status=1/FAILURE

Jul 13 11:39:16 MythBE1 systemd[1]: Failed to start MySQL Community
Server.

Jul 13 11:39:16 MythBE1 systemd[1]: mysql.service: Unit entered failed
state.

Jul 13 11:39:16 MythBE1 systemd[1]: mysql.service: Failed with result
'exit-code

'.

Jul 13 11:39:16 MythBE1 systemd[1]: mysql.service: Service hold-off time
over, s

cheduling restart.

Jul 13 11:39:16 MythBE1 systemd[1]: Stopped MySQL Community Server.

Hmm: the log time is 11:38 and just noticed the system time is 13:23,
and the system time was noticed after I did Sneakernet and copied in the
file. Mentioning because from my DOS says I know a time mismatch can
cause problems.

> Otherwise try this command and post the last 20 or so lines of the
> output:
> sudo cat /var/log/mysql/error.log

Probably more than you need but appears this is a 'compete section' as
saw “Binlog end” repeated a few times; this is the last section:

2016-07-13T18:25:54.596201Z 0 [Note] Binlog end

2016-07-13T18:25:54.596298Z 0 [Note] Shutting down plugin 'ngram'

2016-07-13T18:25:54.596311Z 0 [Note] Shutting down plugin 'ARCHIVE'

2016-07-13T18:25:54.596317Z 0 [Note] Shutting down plugin 'partition'

2016-07-13T18:25:54.596323Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2016-07-13T18:25:54.596333Z 0 [Note] Shutting down plugin
'INNODB_SYS_VIRTUAL'

2016-07-13T18:25:54.596341Z 0 [Note] Shutting down plugin
'INNODB_SYS_DATAFILES'

2016-07-13T18:25:54.596347Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLESPACES'

2016-07-13T18:25:54.596352Z 0 [Note] Shutting down plugin
'INNODB_SYS_FOREIGN_COLS'

2016-07-13T18:25:54.596357Z 0 [Note] Shutting down plugin
'INNODB_SYS_FOREIGN'

2016-07-13T18:25:54.596362Z 0 [Note] Shutting down plugin
'INNODB_SYS_FIELDS'

2016-07-13T18:25:54.596368Z 0 [Note] Shutting down plugin
'INNODB_SYS_COLUMNS'

2016-07-13T18:25:54.596373Z 0 [Note] Shutting down plugin
'INNODB_SYS_INDEXES'

2016-07-13T18:25:54.596383Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLESTATS'

2016-07-13T18:25:54.596389Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLES'

2016-07-13T18:25:54.596394Z 0 [Note] Shutting down plugin
'INNODB_FT_INDEX_TABLE'

2016-07-13T18:25:54.596399Z 0 [Note] Shutting down plugin
'INNODB_FT_INDEX_CACHE'

2016-07-13T18:25:54.596404Z 0 [Note] Shutting down plugin
'INNODB_FT_CONFIG'

2016-07-13T18:25:54.596409Z 0 [Note] Shutting down plugin
'INNODB_FT_BEING_DELETED'

2016-07-13T18:25:54.596414Z 0 [Note] Shutting down plugin
'INNODB_FT_DELETED'

2016-07-13T18:25:54.596419Z 0 [Note] Shutting down plugin
'INNODB_FT_DEFAULT_STOPWORD'

2016-07-13T18:25:54.596425Z 0 [Note] Shutting down plugin
'INNODB_METRICS'

2016-07-13T18:25:54.596430Z 0 [Note] Shutting down plugin
'INNODB_TEMP_TABLE_INFO'

2016-07-13T18:25:54.596440Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_POOL_STATS'

2016-07-13T18:25:54.596448Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_PAGE_LRU'

2016-07-13T18:25:54.596453Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_PAGE'

2016-07-13T18:25:54.596458Z 0 [Note] Shutting down plugin
'INNODB_CMP_PER_INDEX_RESET'

2016-07-13T18:25:54.596468Z 0 [Note] Shutting down plugin
'INNODB_CMP_PER_INDEX'

2016-07-13T18:25:54.596474Z 0 [Note] Shutting down plugin
'INNODB_CMPMEM_RESET'

2016-07-13T18:25:54.596479Z 0 [Note] Shutting down plugin
'INNODB_CMPMEM'

2016-07-13T18:25:54.596484Z 0 [Note] Shutting down plugin
'INNODB_CMP_RESET'

2016-07-13T18:25:54.596489Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2016-07-13T18:25:54.596494Z 0 [Note] Shutting down plugin
'INNODB_LOCK_WAITS'

2016-07-13T18:25:54.596499Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2016-07-13T18:25:54.596510Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2016-07-13T18:25:54.596515Z 0 [Note] Shutting down plugin 'InnoDB'

2016-07-13T18:25:54.596596Z 0 [Note] InnoDB: FTS optimize thread
exiting.

2016-07-13T18:25:54.596697Z 0 [Note] InnoDB: Starting shutdown...

2016-07-13T18:25:54.696847Z 0 [Note] InnoDB: Dumping buffer pool(s)
to /var/lib/mysql/ib_buffer_pool

2016-07-13T18:25:54.697221Z 0 [Note] InnoDB: Buffer pool(s) dump
completed at 160713 13:25:54

2016-07-13T18:25:56.219185Z 0 [Note] InnoDB: Shutdown completed; log
sequence number 57279551

2016-07-13T18:25:56.221344Z 0 [Note] InnoDB: Removed temporary
tablespace data file: "ibtmp1"

2016-07-13T18:25:56.221382Z 0 [Note] Shutting down plugin 'MEMORY'

2016-07-13T18:25:56.221388Z 0 [Note] Shutting down plugin
'PERFORMANCE_SCHEMA'

2016-07-13T18:25:56.221520Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2016-07-13T18:25:56.221524Z 0 [Note] Shutting down plugin 'MyISAM'

2016-07-13T18:25:56.221550Z 0 [Note] Shutting down plugin 'CSV'

2016-07-13T18:25:56.221556Z 0 [Note] Shutting down plugin
'sha256_password'

2016-07-13T18:25:56.221559Z 0 [Note] Shutting down plugin
'mysql_native_password'

2016-07-13T18:25:56.221749Z 0 [Note] Shutting down plugin 'binlog'

2016-07-13T18:25:56.222080Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

barry at MythBE1:~$

Hope this means something to you! Thanks again!

Barry

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160713/34c58329/attachment.html>