Hello, I run 2 systems with Debian 8 and 9 and Bareos 18.2.5.
Both systems use Mariadb as a DB backend, but otherwise differ in both the data to be backed up and the hardware (XEON with traditional hard disks, Raid1, 32 Gbyte RAM, low load by the value of 1 ), Core i7 with SSD, Database on SSD. If I use the command "restore" in bconsole and then select option 5, it happens on both systems that bconsole reports: Building directory tree for JobId(s) x,y,z, but then it doesn't go on, the following "++++++" don't appear and the prompt to select the files to recover doesn't appear. I get dropped on the shell without any further message I can see that on both systems the Maria DB systems create some load (without stressing the system), it makes the impression that the database just takes too long. On one system I exported and re-imported the database (to prevent fragmentation), the dump file was about 2 Gbyte, in PhpMyAdmin the DB is almost 4 Gbyte, also the system was rebooted. Didnt help. I started bconsole with the option: -u <nn> set command execution timeout to <nn> second and a high movement in seconds, but that didn't do any good. To counteract this problem, I'm now building new catalogs, and I've put them in Postgresql, since I noticed some performance improvements when using Postgresql in Mysql's time. I hoped, that this topic was solved with MariaDB. Now I'm afraid, that the problem will occur again with a correspondingly large catalog (storage time 3 months, ~ 17, or 13 million entries in the files table). Does anyone know the problem and has an idea? Many thanks and many greetings Translated with www.DeepL.com/Translator -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/0a8f785e-c1cf-471a-92f7-aea8243fd238%40googlegroups.com.
