Hello Ulrich, I know this problem. I found and reported it a year ago. You can read about it here:
https://gitlab.bacula.org/bacula-community-edition/bacula-community/-/issues/2684 Best regards, Marcin Haba (gani) On Sat, 18 May 2024 at 10:18, Ulrich Leodolter <ulrich.leodol...@obvsg.at> wrote: > hi, > > after upgrading to verions 15.0.2 our nightly update stats job failed: > > 18-May 06:15 vlbackup.obvsg.at-dir JobId 0: Fatal error: bdb.h:146 > bdb.h:146 query INSERT INTO JobHisto (JobId, Job, Name, Type, > Level,ClientId, JobStatus,SchedTime, StartTime, EndTime, RealEndTime, > RealStartTime, JobTDate,VolSessionId, VolSessionTime, JobFiles, JobBytes, > ReadBytes,JobErrors, JobMissingFiles, PoolId, FileSetId, PriorJobId, > PriorJob, PurgedFiles, HasBase, HasCache, Reviewed, Comment, FileTable, > isVirtualFull,CompressRatio,Rate,LastReadStorageId,WriteStorageId,LastReadDevice,WriteDevice,StatusInfo,Encrypted)SELECT > JobId, Job, Name, Type, Level, ClientId, JobStatus,SchedTime, StartTime, > EndTime, RealEndTime, RealStartTime, JobTDate,VolSessionId, VolSessionTime, > JobFiles, JobBytes, ReadBytes,JobErrors, JobMissingFiles, PoolId, > FileSetId, PriorJobId, PriorJob, PurgedFiles, HasBase, HasCache, Reviewed, > Comment, FileTable, > isVirtualFull,CompressRatio,Rate,LastReadStorageId,WriteStorageId,LastReadDevice,WriteDevice,StatusInfo,Encrypted > FROM Job WHERE JobStatus IN ('T','W','f > ,'A','E')AND NOT EXISTS (SELECT JobHisto.JobId FROM JobHisto WHERE > JobHisto.Jobid=Job.JobId)AND JobTDate < 1715746502 failed: > Unknown column 'FileTable' in 'field list' > > after upgrading to version 15.0.2 i have updated the database using the > update_mysql_tables which is installed into scripts directory. > > the source code of this script is bacula/src/cats/update_mysql_tables.in, > but there are also scripts to upgrade between specific versions in > bacula/updatedb. > > it seems these update scripts are not in sync because only > bacula/src/cats/update_mysql_tables.in contains the FileTable update: > > ALTER TABLE Job ADD COLUMN FileTable CHAR(20) default 'File'; > ALTER TABLE JobHisto ADD COLUMN FileTable CHAR(20) default 'File'; > > there is no such alter FileTable in any of the bacula/updatedb scripts. > > it seems it is not a good idea to use scripts from bacula/updatedb after > version upgrade because of missing changes, is that correct? > > i have now added the columns manually und update stats job runs with > problems, but i need now the check the complete schema because i am unsure > which scripts i used in the past. > > Best regards > Ulrich > _______________________________________________ > Bacula-devel mailing list > Bacula-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-devel > -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus
_______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
