-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
James Harper wrote:
>>> But the records do not appear to be there to restore from. I
> increased
>>> the volume retention period to 6 months and ran bscan again, but
> still
>>> no records...
>> Is that no records according to restore or nothing found using raw
> select
>> commands?
>
> Hmmm.... didn't think of trying a raw select...
>
>> What kind of catalog database are you using? Do you have more than
> one
>> catalog?
>
> It was sqlite3 (see below)
>
>>> I have since used bextract to get the data I wanted, and apart from
>>> saying "Error: Unknown stream=15 ignored" several hundred thousand
>>> times, it did successfully restore the data, and quite quickly. I
> would
>>> like to make the process work the way it is supposed to though.
>> FWIW, the Unknown stream=15 error means that it will not have restored
> the
>> ACLs.
>
> Ah. Thanks for that. It makes me a lot more comfortable about trusting
> the restored data (no ACL's on the stuff I was restoring!)
>
> In order to try and reduce the turnaround time on a bscan, I converted
> over to mysql, which cut the bscan time down from several hours to just
> under an hour. It also worked. I suspect that in the first place I
> should have completely deleted the volume from the database, and then a
> bscan would probably have worked under sqlite3 too.
>
> Oh well... if nothing else I'm a little wiser for the experience!
Definitely NOT recommended that you use SQLite in production, either,
for this reason (speed) and others. A wise move, IMO, unless this a home
setup (switching to a real database, that is).
- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III
|$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 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
iD8DBQFGmsehmb+gadEcsb4RAhI2AJwOReC87Z69t2wabzt7VHBusQjOJACfaeVH
moXYZ4Fxfgg3a7iEb76Ryd8=
=X7w2
-----END PGP SIGNATURE-----
begin:vcard
fn:Ryan Novosielski
n:Novosielski;Ryan
org:UMDNJ;IST/AST
adr;dom:MSB C630;;185 South Orange Avenue;Newark;NJ;07103
email;internet:[EMAIL PROTECTED]
title:Systems Programmer III
tel;work:(973) 972-0922
tel;fax:(973) 972-7412
tel;pager:(866) 20-UMDNJ
x-mozilla-html:FALSE
version:2.1
end:vcard
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
