Hi.
I have a problem with missing file records.
My configuration is as follows:
disk-based backup, full backup run weekly, diff backup run daily,
separate Pool records for Full and Diff backup for each client.
File Retention = 60d
Job Retention = 180d
Diff Pool:
AutoPrune = Yes
Volume Retention = 8d
Recycle = Yes
Full Pool:
AutoPrune = Yes
Volume Retention = 32d
Recycle = Yes
AFAiR during my tests (where periods could be much shorter) everything
was fine, but now for most of my clients I can list files only from
differential pools and sometime from last job using full pool. I
suppose that I screwed something up during final configuration, but
the above values seem to be ok, so.... I'm beginning to dig and debug
;-)
I found the utf-8 problem in database logs, so I converted database to
SQL_ASCII. UTFp roblem does not appear anymore, but I still cannot
list files from pre-last full backup.
I'm trying to bscan my volumes and I'm not sure how to understand
bscan's output:
bscan: butil.c:282 Using device: "arsenic" for reading.
05-Dec 13:02 bscan JobId 0: Ready to read from volume
"arsenic_Full-0002" on device "arsenic" (/backup2/servers/arsenic).
bscan: bscan.c:288 Using Database: bacula2, User: bacula2
05-Dec 13:02 bscan JobId 0: Forward spacing Volume "arsenic_Full-0002"
to file:block 0:213.
bscan: bscan.c:501 SOS_LABEL: Found Job record for JobId: 2764
bscan: bscan.c:683 32,768 file records. At file:blk=0:6,635 bytes=427,737,967
bscan: bscan.c:995 Fileset "arsenic" already exists.
bscan: bscan.c:1116 Updated Job termination record for JobId=2764
Level=Full TermStat=T
bscan: bscan.c:1200 Could not create JobMedia record.
ERR=sql_create.c:156 Update Media record UPDATE Media SET EndFile=0,
EndBlock=3937877039 WHERE MediaId=0 failed: ERR=
05-Dec 13:03 bscan JobId 0: End of file 0 on device "arsenic"
(/backup2/servers/arsenic), Volume "arsenic_Full-0002"
05-Dec 13:03 bscan JobId 0: End of Volume at file 0 on device
"arsenic" (/backup2/servers/arsenic), Volume "arsenic_Full-0002"
bscan: bscan.c:318-0 ========== JobId=0 ========
bscan: bscan.c:933 Could not update media record. ERR=sql_update.c:382
Update failed: affected_rows=0 for UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=0,VolBytes=3935713783,VolMounts=0,VolErrors=0,VolWrites=0,MaxVolBytes=0,VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0,VolParts=0,LabelType=0,StorageId=0,PoolId=0,VolRetention=0,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,Enabled=0,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=0
WHERE VolumeName=''
05-Dec 13:03 bscan JobId 0: End of all volumes.
bscan: bscan.c:933 Could not update media record. ERR=sql_update.c:382
Update failed: affected_rows=0 for UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=0,VolBytes=3935713783,VolMounts=1,VolErrors=0,VolWrites=0,MaxVolBytes=0,VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0,VolParts=0,LabelType=0,StorageId=0,PoolId=0,VolRetention=0,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,Enabled=0,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=0
WHERE VolumeName=''
bscan: bscan.c:632 End of all Volumes. VolFiles=0 VolBlocks=0
VolBytes=3,935,713,783
Records added or updated in the catalog:
0 Media
0 Pool
1 Job
59864 File
Why does it try to update JobMedia where MediaId=0 ?
TIA for any suggestions.
R.
--
"First they ignore you. Then they laugh at you. Then they
fight you. Then you win." - Mohandas Gandhi.
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
