[mythtv-users] Backend can't connect (it was all working fine!) - mysql strangeness

Sun Apr 10 19:40:40 UTC 2016

On 10/04/2016 19:55, Noah Beck wrote:
> Your mysql server isn't running, which is why mythbackend isn't running.
>
> On Sun, Apr 10, 2016 at 2:43 PM, Damian <myth at surr.co.uk> wrote:
>> ...
>> mysqld_safe[6826]: 160410 19:33:36 mysqld_safe Logging to
>> '/var/log/mysql/error.log'.
>
> Looks like /var/log/mysql/error.log would have something useful in it
> to tell you what's going on with mysqld.
>
> Noah
>

Hi Noah,

Thanks. I assumed that mysql was wither not loading at all, or there was 
some permission problem going on.

I don't know why it's suddenly stopped working. It was all fine.

Here's a chunk of what's in that log file. There's loads of it, but 
hopefully this is enough to shed some light ...

160410 20:23:40 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
160410 20:33:38 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
2016-04-10 20:33:39 0 [Warning] option 'net_buffer_length': unsigned 
value 8388608 adjusted to 1048576
2016-04-10 20:33:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is 
deprecated. Please use --explicit_defaults_for_timestamp server option 
(see documentation for more details).
2016-04-10 20:33:39 0 [Note] /usr/sbin/mysqld (mysqld 
5.6.28-0ubuntu0.15.10.1) starting as process 21635 ...
2016-04-10 20:33:39 21635 [Warning] Buffered warning: Changed limits: 
max_open_files: 1024 (requested 5000)

2016-04-10 20:33:39 21635 [Warning] Buffered warning: Changed limits: 
table_open_cache: 457 (requested 2000)

2016-04-10 20:33:39 21635 [Warning] Using unique option prefix 
myisam-recover instead of myisam-recover-options is deprecated and will 
be removed in a future release. Please use the full name instead.
2016-04-10 20:33:39 21635 [Note] Plugin 'FEDERATED' is disabled.
2016-04-10 20:33:39 21635 [ERROR] Function 'innodb' already exists
2016-04-10 20:33:39 21635 [Warning] Couldn't load plugin named 'innodb' 
with soname 'ha_innodb.so'.
2016-04-10 20:33:39 21635 [ERROR] Function 'federated' already exists
2016-04-10 20:33:39 21635 [Warning] Couldn't load plugin named 
'federated' with soname 'ha_federated.so'.
2016-04-10 20:33:39 21635 [ERROR] Function 'blackhole' already exists
2016-04-10 20:33:39 21635 [Warning] Couldn't load plugin named 
'blackhole' with soname 'ha_blackhole.so'.
2016-04-10 20:33:39 21635 [ERROR] Function 'archive' already exists
2016-04-10 20:33:39 21635 [Warning] Couldn't load plugin named 'archive' 
with soname 'ha_archive.so'.
2016-04-10 20:33:39 21635 [Note] InnoDB: Using atomics to ref count 
buffer pool pages
2016-04-10 20:33:39 21635 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-10 20:33:39 21635 [Note] InnoDB: Mutexes and rw_locks use GCC 
atomic builtins
2016-04-10 20:33:39 21635 [Note] InnoDB: Memory barrier is not used
2016-04-10 20:33:39 21635 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-10 20:33:39 21635 [Note] InnoDB: Using Linux native AIO
2016-04-10 20:33:39 21635 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-10 20:33:39 21635 [Note] InnoDB: Initializing buffer pool, size 
= 128.0M
2016-04-10 20:33:39 21635 [Note] InnoDB: Completed initialization of 
buffer pool
2016-04-10 20:33:39 21635 [Note] InnoDB: Highest supported file format 
is Barracuda.
2016-04-10 20:33:39 21635 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-10 20:33:39 21635 [Note] InnoDB: Waiting for purge to start
2016-04-10 20:33:39 21635 [Note] InnoDB: 5.6.28 started; log sequence 
number 1743354
2016-04-10 20:33:39 21635 [ERROR] /usr/sbin/mysqld: unknown variable 
'table_cache=128'
2016-04-10 20:33:39 21635 [ERROR] Aborting

2016-04-10 20:33:39 21635 [Note] Binlog end
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'partition'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_SYS_TABLESPACES'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_SYS_FOREIGN_COLS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_SYS_TABLESTATS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_FT_INDEX_TABLE'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_FT_INDEX_CACHE'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_FT_BEING_DELETED'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_FT_DEFAULT_STOPWORD'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_BUFFER_POOL_STATS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_BUFFER_PAGE_LRU'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 
'INNODB_CMP_PER_INDEX_RESET'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-10 20:33:39 21635 [Note] Shutting down plugin 'InnoDB'
2016-04-10 20:33:39 21635 [Note] InnoDB: FTS optimize thread exiting.
2016-04-10 20:33:39 21635 [Note] InnoDB: Starting shutdown...
2016-04-10 20:33:41 21635 [Note] InnoDB: Shutdown completed; log 
sequence number 1743380
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'ARCHIVE'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'MyISAM'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'CSV'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'MEMORY'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'sha256_password'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'mysql_old_password'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 
'mysql_native_password'
2016-04-10 20:33:41 21635 [Note] Shutting down plugin 'binlog'
2016-04-10 20:33:41 21635 [Note] /usr/sbin/mysqld: Shutdown complete

160410 20:33:41 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended

Does that point to the source of the problem?

Thanks again,
Damian