SOLVED Event: pre-backup-data FAILED

Support
1

NethServer Version: 7.9.2009

Hi all,

With BackupPC, I backuped my main server and did a TAR file of the backup.

On a new hardware with a SSD disk, I restored the TAR file in /, configure the network for the new NICs.and reboot.

All is working properly except the backup:

Nov  2 12:05:12 dorgee esmith::event[9015]: Action: /etc/e-smith/events/pre-backup-data/S20nethserver-backup-config-predatabackup SUCCESS [8.824535]
Nov  2 12:05:12 dorgee esmith::event[9015]: Error: Couldn't read status information for table filestore ()
Nov  2 12:05:12 dorgee esmith::event[9015]: mysqldump: Couldn't execute 'show create table `filestore`': Table 'roundcubemail.filestore' doesn't exist (1146)
Nov  2 12:05:12 dorgee esmith::event[9015]: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 1 [0.2027]
Nov  2 12:05:13 dorgee kernel: perf: interrupt took too long (3925 > 3923), lowering kernel.perf_event_max_sample_rate to 50000
Nov  2 12:05:16 dorgee esmith::event[9015]: Action: /etc/e-smith/events/pre-backup-data/S50rh-mariadb102-dump-tables SUCCESS [3.906235]
Nov  2 12:05:16 dorgee esmith::event[9015]: Event: pre-backup-data FAILED

What is wrong ?

Need help urgently,

Michel-André

2

I TAR the original folder /var/lib/mysql
Copied to new hardware
Extract
Same problem

**SOLUTION:**

https://forum.vestacp.com/viewtopic.php?t=7065&start=20
Under: Code: Select all // – Table structure for table filestore

CREATING NEW TABLE filestore 

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| roundcubemail      |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]>


MariaDB [(none)]> connect roundcubemail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    19
Current database: roundcubemail

MariaDB [(none)]>


MariaDB [roundcubemail]> show tables;
+-------------------------+
| Tables_in_roundcubemail |
+-------------------------+
| cache                   |
| cache_index             |
| cache_messages          |
| cache_shared            |
| cache_thread            |
| contactgroupmembers     |
| contactgroups           |
| contacts                |
| dictionary              |
| filestore               |
| identities              |
| searches                |
| session                 |
| system                  |
| users                   |
+-------------------------+
15 rows in set (0.00 sec)

MariaDB [roundcubemail]>


MariaDB [roundcubemail]> drop table filestore;
ERROR 1051 (42S02): Unknown table 'filestore'   ###### THE PROBLEM IS HERE
MariaDB [roundcubemail]>


MariaDB [roundcubemail]> CREATE TABLE `filestore` (
 `file_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `user_id` int(10) UNSIGNED NOT NULL,
 `filename` varchar(128) NOT NULL,
 `mtime` int(10) NOT NULL,
 `data` longtext NOT NULL,
 PRIMARY KEY (`file_id`),
 CONSTRAINT `user_id_fk_filestore` FOREIGN KEY (`user_id`)
   REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
 UNIQUE `uniqueness` (`user_id`, `filename`)
);
Query OK, 0 rows affected (0.01 sec)

MariaDB [roundcubemail]>


MariaDB [roundcubemail]> select * from  filestore;
Empty set (0.00 sec)

MariaDB [roundcubemail]> exit


#

Now the backup is running.

Michel-André

1 Like
3

@michelandre

Salut Michel-André

Just to know what exactly:

Is that above log comng from a restore (trying to restore the db contents in the newly restored Nethserver) or a new backup?

If you’re trying to do a new backup:

Try removing the backup and data restore modules - and reinstalling them…

Good Luck

My 2 cents
Andy

Sry, saw your solution a bit too late! Glad it’s working again!

1 Like
4

Hi @Andy_Wismer

Thank you for your post.

Those lines were from: LogViewer/Read/var/log/messages

Nov  2 12:05:12 dorgee esmith::event[9015]: mysqldump: Couldn't execute 'show create table `filestore`': Table 'roundcubemail.filestore' doesn't exist (1146)

As it is written: Table 'roundcubemail.filestore' doesn't exist, so I recreated it folllowing the above link recommandation.

The TAR file was 31GB but now all the 4 web sites are running correctly.

I am waiting for the backup to finish, hoping all the other things are still working.

I will keep the old hardware for a few days…

Michel-André.

1 Like
5

Hi

Any specific reason why not moving to virtualization?

1 Like
6

Hi @Andy_Wismer,

That is why I changed to the new hardware.

Next step is the Proxmox one which will be quite a job…

I will start by making a very good config first, I know we can count on your experience if there is a problem…

Michel-André

P.S. The backup is finished but I didn’t recieved an email, I will wait until tomorrow to see…

1 Like