holland-coredev team mailing list archive

[sriramrajan <732825@xxxxxxxxxxxxxxxxxx>]

This is on a fresh install of 5.5 and so wasn't an upgrade issue.
But your comment made me look deeper and it turned out be a permissions issue datadir/performance_schema was owned by root.

All good now. Sorry for wasting your time,

-- 
You received this bug notification because you are a member of Holland
Discuss, which is subscribed to holland-backup.
https://bugs.launchpad.net/bugs/732825

Title:
  Errors with performance schema in MySQL 5.5

Status in Holland Backup Framework:
  Incomplete

Bug description:
  I know that this was fixed in 1.0.6. Backups work and so it does not
  fail to run.

  But I do see this in /var/spool/holland/slave2/<bkup
  dir>/holland_lvm.log. Not sure if this a bug but might be worth
  changing the messages logged. In any case worth pointing it out as it
  might lead to other things. Let me know if you want to review the
  server that is showing this

  Logs :-

  110310 20:14:17 [Warning] /usr/libexec/mysqld: unknown option '--loose-skip-ndbcluster'
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_current.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_history.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_history_long.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_consumers.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_instruments.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_timers.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/performance_timers.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/threads.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_by_thread_by_event_name.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_by_instance.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_global_by_event_name.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_summary_by_event_name.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_summary_by_instance.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/mutex_instances.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/rwlock_instances.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/cond_instances.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
  110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_instances.frm' (errno: 13)
  110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure

  
  Version Info :-

  # holland --version

  Holland Backup v1.0.6
  Copyright (c) 2008-2010 Rackspace US, Inc.
  More info available at http://hollandbackup.org

  [[[[[[[]]]]]]] [[[[[[[]]]]]]]
  [[[[[[[]]]]]]]       [[[[[[[]]]]]]]
  [[[[[[[]]]]]]] [[[[[[[]]]]]]]
  [[[[[[[]]]]]]] [[[[[[[]]]]]]]

  
  # rpm -qa |grep -i holland
  holland-commvault-1.0-2.rs.el5.noarch
  holland-mysqldump-1.0.6-3.el5.noarch
  holland-common-1.0.6-3.el5.noarch
  holland-mysqllvm-1.0.6-3.el5.noarch
  holland-1.0.6-3.el5.noarch

  Mysql
  mysql55-server-5.5.9-1.ius.el5.x86_64