Re: [Bacula-users] very slow backups, around 5mb/sec

2016-06-21 Thread Randy Katz
I would really like to know how much speed gain you get when you switch to Mysql or Postgres, please post it here, thanks. On 6/21/2016 1:36 PM, fgd9329g wrote: > This might be a dumb question, but I can't figure it out. > > Debian 8 > Bacula Version: 5.2.6 > sqlite3 -version 3.8.7.1 > Backing

Re: [Bacula-users] very slow backups, around 5mb/sec

2016-06-21 Thread Wanderlei Huttel
Hello, have you tried to change the bacula database for MySQL or Postgres? Best regards Wanderlei Hüttel Enviado de Motorola Moto X2 Em 21 de jun de 2016 11:21 PM, "fgd9329g" escreveu: > This might be a dumb question, but I can't figure it out. > > Debian 8 > Bacula Version: 5.2.6 > sqlite3 -ve

[Bacula-users] very slow backups, around 5mb/sec

2016-06-21 Thread fgd9329g
This might be a dumb question, but I can't figure it out. Debian 8 Bacula Version: 5.2.6 sqlite3 -version 3.8.7.1 Backing up to disks, not tape. I have two bacula systems, both have this same slowness issue. Here's what the final output of our largest job looks like: Elapsed time: 4

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
ok, fixed Somehow the bacula-dir startup file was old Pulled a copy, I am running now Thanks for all help Phil +-- |This was sent by p...@isone.biz via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
ok, tried a restore: [root@bkpcentos6 mysql]# mysql -u root -D bacula -p < /root/bacula/bin/working/bacula.sql Enter password: [root@bkpcentos6 mysql]# cp /dev/null /var/log/bacula/bacula.log cp: overwrite `/var/log/bacula/bacula.log'? y [root@bkpcentos6 mysql]# /etc/init.d/bacula-dir start Star

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
>I think its the other way around: sometimes between reboots MySQL got >upgraded to version 15, but not restarted, so the old version of MySQL >was still running. Then after the reboot new version of MySQL was >loaded in the memory, causing bacula to emit this error. Ok, I stopped mysql, and start

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
So after a bit more reading. The dtabase is v15, why would bacula-dir look for v12? It is the same date as the bacula-fd, -sd, and bconsole bconsole -v shows 7.2 +-- |This was sent by p...@isone.biz via Backup Central. |Forward

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
hi The actual version is 7.2 I did the upgrade way back in January, and have run 400+ jobs since then. I did a new install of 7.2 and started over back then I run bconsole -v, it does show v7.2 I run bconsole -l and it does show the bacula-dir that is defined Is the catalog dump you talk of,

Re: [Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread Vanush
On Tue, Jun 21, 2016 at 11:41:18AM -0300, Heitor Faria wrote: > > Hello > > > You can try stop mysql, and move the directory /var/lib/mysql/bacula to > > another > > safe directory. > > > Then you can try run mysql and see if it works. > > > If you have a dump of mysql you just mysql -u root <

Re: [Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread Heitor Faria
> Hello > You can try stop mysql, and move the directory /var/lib/mysql/bacula to > another > safe directory. > Then you can try run mysql and see if it works. > If you have a dump of mysql you just mysql -u root < catalog.dump, or you need > to use BLS and BEXTRACT to get catalog.dump from vol

Re: [Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread Wanderlei Huttel
Hello You can try stop mysql, and move the directory /var/lib/mysql/bacula to another safe directory. Then you can try run mysql and see if it works. If you have a dump of mysql you just mysql -u root < catalog.dump, or you need to use BLS and BEXTRACT to get catalog.dump from volumes. Best Re

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
More info Bacula 7.0.5 Mysqld is running I can get into database using credentials and mysql command Question. How do I restore the catalog if the db is hosed (If that is the problem)? Any way to debug this would be appreciated. +--

Re: [Bacula-users] bacula-dir dies with db version error - "Wanted 12, got 15"

2016-06-21 Thread Wanderlei Huttel
Hello You said you just reboot the server. You didn't restore the mysql database? It seems you have an newer version of catalog and restored an older one. Atenciosamente *Wanderlei Hüttel* http://www.huttel.com.br 2016-06-21 10:56 GMT-03:00 philhu : > Hi, > > I was backing up an NFS volume fr

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got

2016-06-21 Thread philhu
More info Bacula 7.0.5 +-- |This was sent by p...@isone.biz via Backup Central. |Forward SPAM to ab...@backupcentral.com. +--

[Bacula-users] bacula-dir dies with db version error - "Wanted 12, got 15"

2016-06-21 Thread philhu
Hi, I was backing up an NFS volume from a NAS, when the NAS crashed, and the backup aborted. The next backup got a database error, so I reboot, and started up bacula-fd, bacula-sd without problem, but starting up bacula-dir, it dies with: [root@bkpcentos6 bacula]# cat /var/log/bacula/bacula.lo

Re: [Bacula-users] Best backup strategy on short disk capacity

2016-06-21 Thread Kern Sibbald
Hello, You are sort of in an impossible situation. With the large amount of data you have and the small backup space, it will be hard to make Bacula work as it should. My very strong conviction is that any single backup job that last more than 10 hours is too long. If it takes 7 days to back