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

Nigel Jewell nigel.jewell at grufty.co.uk
Tue Dec 31 12:05:17 UTC 2013


On 29/12/2013 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

Hi,

Is this an install that has been upgraded from a previous build of 
Fedora?  Have you run mysql_upgrade?

Nige.



More information about the mythtv-users mailing list