[Bacula-bugs] [bacula 0000706]: Bacula fail to restore a backup that spans over two DVDs

[<bac...@li...>]

A BUGNOTE has been added to this bug.

======================================================================

http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000706

======================================================================

Reported By:                skjelten

Assigned To:                

======================================================================

Project:                    bacula

Bug ID:                     706

Category:                   Storage Daemon

Reproducibility:            always

Severity:                   major

Priority:                   normal

Status:                     new

======================================================================

Date Submitted:             11-02-2006 04:33 EST

Last Modified:              11-13-2006 19:18 EST

======================================================================

Summary:                    Bacula fail to restore a backup that spans over two DVDs

Description: 

Bacula fails to restore a backup that spans over two DVDs. 



When creating backups that spans over two DVDs while using the

MaximumPartSize = 800M my DVD looks like:



-rw-r----- 1 root root       184 2006-10-29 20:31 sfd

-rw-r----- 1 root root 838849515 2006-10-29 20:36 sfd.2

-rw-r----- 1 root root 838849525 2006-10-29 20:40 sfd.3

-rw-r----- 1 root root 838849514 2006-10-29 20:43 sfd.4

-rw-r----- 1 root root 838849504 2006-10-29 20:47 sfd.5

-rw-r----- 1 root root 838849519 2006-10-29 20:50 sfd.6

-rw-r----- 1 root root 468228096 2006-10-29 20:53 sfd.7



where sfd is the volume name. But when I try to restore my backups bacula

fails at the end of the DVD. Instead of asking my to mount the next

volume, bacula tries to open the file sfd.8 and terminates in an

file-not-found error. As you can se from the console output below bacula

is aware that two volumes are needed... it just doesn't know when to ask

for the next volume.

======================================================================



----------------------------------------------------------------------

 oldelvet - 11-13-2006 19:18 EST 

----------------------------------------------------------------------

It looks like either the restore just forgot to stop at the end of the DVD

or

that it thought that the volume parameters are different to what they are.

A

read of the DVD should not attempt to look on the spool.



I would like to find out what the catalog data says.

Can you get a listing of the appropriate row in the Media table for the

two Media records of the DVDs in the failed restore. You can get the

MediaId

from the first column of the bconsole update -> volume parameters ->

Volume 

Status -> Pool 'xxx'  volume listing. Type a period '.' to quit the

update

command. The issue an 'sqlquery' command and run the following query

    select * from Media where MediaId = zz;

where zz is the media id that you found earlier.

We need the VolBytes and VolParts values in particular but having the

full

rows would be good.



Bug History

Date Modified  Username       Field                    Change              

======================================================================

11-02-06 04:33 skjelten       New Bug                                      

11-13-06 19:18 oldelvet       Bugnote Added: 0001995                       

======================================================================