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
