It is trying to update MediaId=0, which is wrong (MediaId should be > 0).
I suspect the problem is that the bootstrap file makes bscan skip over the volume label at the start of the volume (it says "Forward spacing Volume..."), so it never calculates the correct MediaId. The same thing happens with the VolumeName=''. __Martin >>>>> On Tue, 2 Jun 2026 18:27:24 +0200, Pierre Bernhardt said: > > 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 > _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
