bareos: master a8b0f67e

Author Committer Branch Timestamp Parent
frank frank master 2019-12-04 18:19 master b6d80536 Pending
Affected Issues  0001061: Tremendous MySQL load
 0001088: Integer out of range when using large amounts of files with Base Jobs
Changeset cats: Update DB schema from 2171 to 2192

- Add an INDEX on Job.JobTDate to improve performance (MySQL only)
- Fix integer out of range error by changing BaseFiles.BaseId to
  BIGINT/BIGSERIAL
- Add new DDL update scripts for each supported DB backend
- Set BDB_VERSION in cats.h
- Remove unnecessary INDEX pathvisibility_jobid
- Collation handling PostgreSQL >= 10
- Update basefiles sequence PostgreSQL >= 10

Fixes 0001088: Integer out of range when using large amounts of files with Base Jobs
Fixes 0001061: Tremendous MySQL load
mod - core/src/cats/cats.h Diff File
mod - core/src/cats/create_bareos_database.in Diff File
mod - core/src/cats/ddl/creates/mysql.sql Diff File
mod - core/src/cats/ddl/creates/postgresql.sql Diff File
mod - core/src/cats/ddl/creates/sqlite3.sql Diff File
add - core/src/cats/ddl/updates/mysql.2171_2192.sql Diff File
add - core/src/cats/ddl/updates/postgresql.2171_2192.sql Diff File
add - core/src/cats/ddl/updates/sqlite3.2171_2192.sql Diff File
mod - core/src/cats/ddl/versions.map.in Diff File
mod - core/src/cats/update_bareos_tables.in Diff File