Page MenuHomePhabricator

investigate which civi job is creating/deleting tables right during the nightly database backups
Closed, ResolvedPublic

Description

Date: Sat, 1 Jun 2019 13:22:59 +0000 (UTC)
From: fr-tech-ops@wikimedia.org
To: fr-tech-ops@wikimedia.org
Subject: FAILURE: frdb2001 dump_database dump had errors

purge files in /srv/archive/database_dumps older than 7 days
dump smashpig to /srv/archive/database_dumps/smashpig.20190601-090003.frdb2001.sql.gz
dump civicrm to /srv/archive/database_dumps/civicrm.20190601-090006.frdb2001.sql.gz
Error: Couldn't read status information for table civicrm_tmp_d_export_0d99b76b85325f3563ab733091df8f55 ()
mysqldump: Couldn't execute 'show create table civicrm_tmp_d_export_0d99b76b85325f3563ab733091df8f55': Table
'civicrm.civicrm_tmp_d_export_0d99b76b85325f3563ab733091df8f55' doesn't exist (1146)
dump pgehres to /srv/archive/database_dumps/pgehres.20190601-115035.frdb2001.sql.gz
dump fredge to /srv/archive/database_dumps/fredge.20190601-124232.frdb2001.sql.gz
dump geonames to /srv/archive/database_dumps/geonames.20190601-125025.frdb2001.sql.gz
dump drupal to /srv/archive/database_dumps/drupal.20190601-125119.frdb2001.sql.gz

Event Timeline

Something got adjusted (?) because the problem has ceased.