[pkg-bacula-devel] Status/The database update

[Sven Hartge]

On 08.02.24 15:37, Carsten Leonhardt wrote:

> I upgraded another installation.

I upgraded my main-work installation.

The File table contains ~1 billion entries and the whole migration took 
about 27 hours with a peak at 600GB, settling down to 350GB in the end.

I needed to move the database directory for MariaDB over to our Netapp 
AFF400 (luckily my DB server has dual 10G NICs) to have enough space for 
this, as the server itself only has 440GiB for /var/lib/mysql.

I had one error during the upgrade:

mysql said: ERROR 1060 (42S21) at line 1: Duplicate column name 
'FileMediaId'

That is from the 13.0.0 upgrade file, but the rest of the changes went 
in without a problem, I manually checked. And this error was also 
inconsequential because the added column was already exactly in the 
format it would have been added.

Grüße,
Sven.