[mythtv-users] MythBE1 Backend Failed
Barry Martin
barry3martin at gmail.com
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>
More information about the mythtv-users
mailing list