Re: [Bacula-users] Restore issue on Bacula 1.38.11 on Solaris 10.

Sorry i forgot the DB.

I use Mysql version: 5.0.27-standard on another Solaris 10 server.

When the Bacula is busy building the list; the Database is almost not working ( 1% to 3% ) and the Bacula server is busy 100%. But when Bacula does a list for a smaller job , about 400,000 files, the build takes 2 minutes and the DB is busy at 90%.

Do you think a dump and relaod would help in this case ?

Is it possible to tell the Director to take more memory to work?

Thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Louis-Andre Larose wrote:
>
> Hi,
>
> I have a strange error when I try to restore a job on Bacula 1.38.11
> on Solaris 10 ( i know this is old, but it has been running for 18
> months without a glitch ) .
>
> I have to restore part of a fileset from a Bacula job that is 55GB
> and contains 2,828,311 files.
> The file list creation takes about 4h hours to process and the list
> is missing a lot of files in the list. The restore inserted only 443,973
> files of the 2,828,311 .
>
> I suspect the process does not have enough memory to process the
> whole list.
> Is there something I can do to give the director more memory to work
> with?
>
> Is there another way to restore the files?
>
> below is a log of my session:
>
> *restore
>
> First you select one or more JobIds that contain files
>
> to be restored. You will be presented several methods
>
> of specifying the JobIds. Then you will be allowed to
>
> select which files from those JobIds are to be restored.
>
>
>
> To select the JobIds, you have the following choices:
>
> 1: List last 20 Jobs run
>
> 2: List Jobs where a given File is saved
>
> 3: Enter list of comma separated JobIds to select
>
> 4: Enter SQL list command
>
> 5: Select the most recent backup for a client
>
> 6: Select backup for a client before a specified time
>
> 7: Enter a list of files to restore
>
> 8: Enter a list of files to restore before a specified time
>
> 9: Find the JobIds of the most recent backup for a client
>
> 10: Find the JobIds for a backup for a client before a specified
> time
>
> 11: Enter a list of directories to restore for found JobIds
>
> 12: Cancel
>
> Select item: (1-12): 3
>
> Enter JobId(s), comma separated, to restore: 16435
>
> You have selected the following JobId: 16435
>
>
>
> Building directory tree for JobId 16435 ... +++++++
>
> 1 Job, 443,973 files inserted into the tree.
>
>
> You are now entering file selection mode where you add (mark) and
>
> remove (unmark) files to be restored. No files are initially added,
> unless
>
> you used the "all" keyword on the command line.
>
> Enter "done" to leave this mode.
> .......
>
> Thank you for any help you can provide.

You've said absolutely nothing about your database, not even what type.
I forget whether this is one of those cases, but in many cases how that
is configured makes a major difference.

- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II
|$&| |__| | | |__/ | \| _| |novosirj@um... - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJHbWDmb+gadEcsb4RAnnJAJ9KMMpl6Tm6btv3Pm4rYWDrW/S/LACeMWjH
oYPKSNPqbMAxm/8Q6TghdyY=
=PYqT
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users