[pkg-bacula-devel] Bug#975970: bacula-director-mysql broken SQL schema for mariadb-server-10.5

[Radoslav Bodó]

Package: bacula-director-mysql
Version: 9.6.6-2
Severity: important


After recent version bump of mariadb-server in Bullseye, the schema in
bacula-director-mysql:
/usr/share/dbconfig-common/data/bacula-director-mysql/install/mysql is
no longer compatible with the database server


```
# /usr/bin/mysql -NB bacula <
/usr/share/dbconfig-common/data/bacula-director-mysql/install/mysql
ERROR 1005 (HY000) at line 35: Can't create table `bacula`.`File`
(errno: 150 "Foreign key constraint is incorrectly formed")
```

Any help or response will be appreciated.

Best regards
bodik



## packages installed
```
ii  bacula-bscan                         9.6.6-2
amd64        network backup service - bscan tool
ii  bacula-common                        9.6.6-2
amd64        network backup service - common support files
ii  bacula-common-mysql                  9.6.6-2
amd64        network backup service - MySQL common files
ii  bacula-console                       9.6.6-2
amd64        network backup service - text console
ii  bacula-director                      9.6.6-2
amd64        network backup service - Director daemon
ii  bacula-director-mysql                9.6.6-2
all          network backup service - MySQL storage for Director
ii  bacula-fd                            9.6.6-2
amd64        network backup service - file daemon
ii  bacula-sd                            9.6.6-2
amd64        network backup service - storage daemon

ii  libdbd-mariadb-perl                  1.21-1+b1
amd64        Perl5 database interface to the MariaDB/MySQL databases
ii  libmariadb3:amd64                    1:10.5.8-3
amd64        MariaDB database client library
ii  mariadb-client-10.5                  1:10.5.8-3
amd64        MariaDB database client binaries
ii  mariadb-client-core-10.5             1:10.5.8-3
amd64        MariaDB database core client binaries
ii  mariadb-common                       1:10.5.8-3
all          MariaDB common configuration files
ii  mariadb-server                       1:10.5.8-3
all          MariaDB database server (metapackage depending on the
latest version)
ii  mariadb-server-10.5                  1:10.5.8-3
amd64        MariaDB database server binaries
ii  mariadb-server-core-10.5             1:10.5.8-3
amd64        MariaDB database core server files
```

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-bacula-devel/attachments/20201127/7a1a7728/attachment.sig>