[SOLVED] Restoration of Aegir database - urgent #administration

Troubleshooting
1

#Administration

Summary

Dropped Aegir database, failed restoration

Steps to reproduce

Miscommunication caused dropping key database, we tried restoring it from mysql binlog and didn’t work quite right.

Expected behavior

We expected that this would help is restore it, but it didn’t work. Problem is that the server is in testing stage so mistakes were made, thus no backups were made. We need a solution that will solve current problem and restore Aegir to its glory.

Observed behavior

Here is error we are currently getting on aegir:

PDOException: SQLSTATE[HY000] [1049] Unknown database ‘civingbalkanscat’ in lock_may_be_available() (line 167 of /var/aegir/hostmaster-7.x-3.11/includes/lock.inc).

When we add mysql binlog, this is the error we are getting from the drupal website:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘civingbalkanscat.semaphore’ doesn’t exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /var/aegir/hostmaster-7.x-3.11/includes/lock.inc).

List of tables in database we need:
SYS_COLUMNS
SYS_FIELDS
SYS_INDEXES
SYS_TABLES
semaphore

Anything needed can be provided, just let me know
TIA

2

Update:
This is issue as of now when I added the db needed:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘civingbalkanscat.variable’ doesn’t exist: SELECT name, value FROM {variable}; Array ( ) in variable_initialize() (line 1184 of /var/aegir/hostmaster-7.x-3.11/includes/bootstrap.inc).

Line 1146:
// Proceed with variable rebuild.
$variables = array_map(‘unserialize’, db_query(‘SELECT name, value FROM {variable}’)->fetchAllKeyed());
cache_set(‘variables’, $variables, ‘cache_bootstrap’);
lock_release($name);

3

Hi @shwele,

Thanks for your report,

Having chatted to our devs, they’re of the opinion that what you’re experiencing is not a Mattermost problem. Perhaps you could log a support issue with Aegir to see whether they have any suggestions?