[mythtv-users] Mysql errors on MythTV 0.27 Fedora 18

[John Pilkington]

On 29/12/13 22:02, Paul Wilson wrote:
> I originally noticed some defunct mysqld process then I also noticed
> two mysqld process so I'm wondering if these are related
>
> mythtv    1362  1332  0 08:46 ?        00:00:00 [mysqlcheck] <defunct>
>
> the MythTV instance of mysqld is showing errors.
>
> eg
>
> 131230  8:46:27 [Note] Plugin 'FEDERATED' is disabled.
> 131230  8:46:27 InnoDB: The InnoDB memory heap is disabled
> 131230  8:46:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 131230  8:46:27 InnoDB: Compressed tables use zlib 1.2.7
> 131230  8:46:27 InnoDB: Using Linux native AIO
> 131230  8:46:27 InnoDB: Initializing buffer pool, size = 8.0M
> 131230  8:46:27 InnoDB: Completed initialization of buffer pool
> 131230  8:46:27 InnoDB: highest supported file format is Barracuda.
> 131230  8:46:27  InnoDB: Waiting for the background threads to start
> 131230  8:46:28 InnoDB: 5.5.34 started; log sequence number 3154660
> 131230  8:46:28 [Warning] Can't open and lock time zone table: Table
> 'mysql.time_zone_leap_second' doesn't exist trying to live without
> them
> 131230  8:46:28 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_current' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_history' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_history_long' has the wrong
> structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'setup_consumers' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'setup_instruments' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'setup_timers' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'performance_timers' has the wrong structure
> 131230  8:46:28 [ERROR] Native table 'performance_schema'.'threads'
> has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_summary_by_thread_by_event_name'
> has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_summary_by_instance' has the wrong
> structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'events_waits_summary_global_by_event_name' has
> the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'file_summary_by_event_name' has the wrong
> structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'file_summary_by_instance' has the wrong
> structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'mutex_instances' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'rwlock_instances' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'cond_instances' has the wrong structure
> 131230  8:46:28 [ERROR] Native table
> 'performance_schema'.'file_instances' has the wrong structure
> 131230  8:46:28 [Note] /usr/libexec/mysqld: ready for connections.
> Version: '5.5.34'  socket: '/tmp/akonadi-mythtv.3wBlXS/mysql.socket'
> port: 0  MySQL Community Server (GPL)
>
> is this normal??
> thanks
> Paul

Here's my equivalent, f18 x86_64, as found now.  Have you run

perl /usr/share/doc/mythtv-docs-0.27/contrib/maintenance/optimize_mythdb.pl

recently?

131222 10:34:51 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
131222 10:37:20 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
131222 10:37:21 [Note] Plugin 'FEDERATED' is disabled.
131222 10:37:22 InnoDB: The InnoDB memory heap is disabled
131222 10:37:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131222 10:37:22 InnoDB: Compressed tables use zlib 1.2.7
131222 10:37:22 InnoDB: Using Linux native AIO
131222 10:37:22 InnoDB: Initializing buffer pool, size = 128.0M
131222 10:37:22 InnoDB: Completed initialization of buffer pool
131222 10:37:22 InnoDB: highest supported file format is Barracuda.
131222 10:37:24  InnoDB: Waiting for the background threads to start
131222 10:37:25 InnoDB: 5.5.35 started; log sequence number 202862943
131222 10:37:25 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131222 10:37:25 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
131222 10:37:25 [Note] Server socket created on IP: '0.0.0.0'.
131222 10:37:25 [Note] Event Scheduler: Loaded 0 events
131222 10:37:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.35'  socket: '/var/lib/mysql/mysql.sock'  port: 3306 
MySQL Community Server (GPL)