On Tuesday 06 September 2005 08:49, Masopust Christian wrote:
> Hello all,
>
> my configuration is as follows:
>
> - Director and Storage at FedoraCore 3 system, Database Mysql 4.1.12,
> Backup to Disk (2 RAIDs with 2.6TB)
> - Clients are Linux, SUNs, Windows
>
> Bacula run fine till last weekend. Since Sunday every job fails with
> messages that entries to database ("INSERT INTO FILE (......") could not be
> made because of "Duplicate entries"....
>
> First i thought that i caused this problem myself as i run a "mysqldump" of
> the whole bacual-db last week and after that i reloaded id (maybe dumb, but
> i heard that this could decrease size of db a little as mine is above 8GB).
>
> But i couldn't imagine that this causes my problems now because backup runs
> fine after the dump-reload for 2 days...
>
> so, any idea what happening here?
Hmmm. It looks like MySQL may have changed the behavior of their dump/restore,
which used to delete everything before doing a restore. If you did not
explicitly delete your database before doing the restore, you probably
unknowingly duplicated all the records -- not very good.
Your best bet is probably to make a copy of what you currently have (just as a
safeguard) and then delete the database and re-create it with the mysqldump
you have. Hopefully that should get things working again with the least
effort and loss of data.
>
> thanks a lot,
> chris
>
> P.S.: btw, would it be better to have more catalogs when size of 1 catalog
> is as big is mine is?
It is hard to say if it would be better or not to have multiple databases.
Bacula should handle it quite fine -- with the one caveat that when you use
bconsole, you will have to explicitly tell it what database you want to work
with -- this can be a bit more to remember. You also need to be careful to
back all the databases up. Whether or not the extra administrative effort is
justified by possibly faster access, I don't know. If you do this, I
recommend starting with one small second database and experiment with backup,
restore, and queries until you are really sure you know what you are getting
into.
Kern
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
