Ok, last update:
I dropped and recreated the database:
520 db_name=bacula /usr/share/bacula-director/drop_postgresql_database
521 db_name=bacula /usr/share/bacula-director/create_postgresql_database
522 db_name=bacula /usr/share/bacula-director/make_postgresql_tables
523 db_name=bacula db_user=bacula
/usr/share/bacula-director/grant_postgresql_privileges
then I tried again first to insert the job by using den bsr file:
bacula@backup:~$ /usr/sbin/bscan -b BackupCatalog.bsr -m -s -v -V DISK035
DiskStorage1
bscan: butil.c:292-0 Using device: "DiskStorage1" for reading.
02-Jun 18:10 bscan JobId 0: Ready to read from volume "DISK035" on File device
"DiskStorage1" (/media/baculadisk1).
bscan: bscan.c:323-0 Using Database: bacula, User: bacula
02-Jun 18:10 bscan JobId 0: Forward spacing Volume "DISK035" to
addr=1618422790992
bscan: bscan.c:1067-0 Created Client record for Client: backup-fd
bscan: bscan.c:1149-0 Created new JobId=1 record for original JobId=84813
bscan: bscan.c:1093-0 Created FileSet record "Catalog"
bscan: bscan.c:1214-0 Updated Job termination record for JobId=1 Level=Full
TermStat=T
bscan: bscan.c:1299-0 Could not create JobMedia record. ERR=sql_create.c:135
Update Media record UPDATE Media SET EndFile=383, EndBlock=1266266991 WHERE
MediaId=0 failed: ERR=
02-Jun 18:14 bscan JobId 0: End of Volume "DISK035" at addr=1646238741360 on device
"DiskStorage1" (/media/baculadisk1).
bscan: bscan.c:1013-0 Could not update media record. ERR=bdb.h:140 Update
failed: affected_rows=0 for UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=0,VolBytes=27812130636,VolABytes=0,VolHoleBytes=0,VolHoles=0,VolMounts=0,VolErrors=0,VolWrites=0,MaxVolBytes=0,VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0,VolType=0,VolParts=0,VolCloudParts=0,LastPartBytes=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,Recycle=0,ActionOnPurge=0,CacheRetention=0,EndBlock=0
WHERE VolumeName=''
bscan: bscan.c:1013-0 Could not update media record. ERR=bdb.h:140 Update
failed: affected_rows=0 for UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=0,VolBytes=27812130636,VolABytes=0,VolHoleBytes=0,VolHoles=0,VolMounts=1,VolErrors=0,VolWrites=0,MaxVolBytes=0,VolStatus='',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0,VolType=0,VolParts=0,VolCloudParts=0,LastPartBytes=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,Recycle=0,ActionOnPurge=0,CacheRetention=0,EndBlock=0
WHERE VolumeName=''
bscan: bscan.c:669-0 End of all Volumes. VolFiles=0 VolBlocks=0
VolBytes=27,812,130,636
Records added or updated in the catalog:
0 Media
0 Pool
1 Job
2 File
Failed!!!
Then I recreated the database again and used the bcopy job with bsr file to
create a different volume:
bacula@backup:~$ /usr/sbin/bcopy -b BackupCatalog.bsr -i DISK035 -o COPYDISK
/media/baculadisk1 /media/baculadisk3
which runs well.
bscan on COPYDISK runs now without an issue.
*restore
runs also without issues but I must modify the Storage from TempDisk to
DiskStorage3 which is the name
of /media/baculadisk3.
So problem solved here to recover to the newest dump on backups.
Maybe other problems will follow.
After recreating the database with this backup I will try to update the
database with all backups which was
run after the last backup of database included themself.
Long to short:
Maybe faster restore with bsr file was only possible by creating a copy to a
different volume with
bcopy.
Cheers,
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
