Ticket #499 (closed defect: worksforme)

Opened 4 years ago

Last modified 2 years ago

MySQL backup dump error on puffin

Reported by: chris Owned by: chris
Priority: minor Milestone: Maintenance
Component: Live server Keywords:
Cc: ed Estimated Number of Hours: 0.0
Add Hours to Ticket: 0 Billable?: yes
Total Hours: 0.25

Description

Warnings from /etc/backup.d/20.mysql :

Warning: mysqldump: Got error: 1142: "SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'" when using LOCK TABLES
Warning: Failed to dump mysql databases performance_schema

Change History

comment:1 Changed 4 years ago by ed

  • Milestone set to Maintenance

comment:2 Changed 3 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.25
  • Total Hours changed from 0.0 to 0.25

This issue is still to be resolved, the suggestion in a ​thread on mysql.com, "use a replication slave and stop him for consistent backups" seems sensible, this would probably make sense to be combined with a dedicated MySQL server for the existing 3 virtual machines.

Of course there is no need to backup the performance_schema database but since we don't want to list all the databases to be backed up in /etc/backup.d/20.mysql as this would result in new databases not being backed up by default, it's best left as it is, dumping them all each night, with an error each night.

comment:3 Changed 3 years ago by chris

  • Status changed from new to accepted

comment:4 Changed 2 years ago by chris

  • Cc jim removed
  • Status changed from accepted to closed
  • Resolution set to worksforme

This is nolonger an issue, the last backup email:

From: root@puffin.webarch.net (root)
Date: Mon, 02 Jun 2014 01:11:47 +0100
To: root@puffin.webarch.net
Subject: backupninja: puffin.webarch.net


success -- /etc/backup.d/10.sys
success -- /etc/backup.d/20.mysql
Note: See TracTickets for help on using tickets.