In most cases installing new FAB Subtitle Database is simple:
- Run the installation program, which will install and start new version of the FAB Subtitle Database service.
- Close and run FAB Subtitle Database client program(s) on workstations so that they are refreshed from the FAB Subtitle Database server.
There are, however, few special scenarios that require additional care and which are described below.
Master/Standby
In case of a Master/Standby configuration, it is recommended that installation program is first run on one instance (say, Master). Run it on another instance (say, Standby) only when first installation program completes its work and the FAB Subtitle Database service is correctly started. This way, FAB Subtitler BCAST instances will always be able to communicate with one of the FAB Subtitle Database servers.
In case that you are installing a major upgrade it is recommended to install the standby server from the master database which is described here.
Upgrading to version 7
FAB Subtitle Database version 7 uses a new firebird database engine version 5 which is much faster than previous versions. However this requires a new database file STTDB3.FDB5 which is created from the previous file STTDB3.FDB.
Installation instructions for version 7:
- Download the installation file
- Stop FAB Subtitle Database Windows Service
- Run setupserver.exe on the server where FAB Subtitle Database is installed. A message may be displayed that the FAB Subtitle Database Service could not be started which you can ignore because the database first has to be migrated before the Service can start.
- After the installation is finished run Database Config
- Click on Tools / Migrate old database. This will convert the file STTDB3.FDB to STTDB3.FDB5
- When migration is finished, the service “FAB Subtitle Database” will be started automatically, and everything should start working again.
If you have a Standby server then the best is to install the new version also on the standby server and after that create the standby from the master server as described here.
Upgrading from version older than 4.0
If your FAB Subtitle Database has version lower than 4.0, it is required that FAB Subtitle Database 4.0 is installed first. After the installation is successful, you have to wait until the database is fully reindex. Please check the FAB Subtitle Database log occasionally for the following message:
‘‘Background command processor: Completed database reindex’’
After this message appears in the log, you can upgrade the FAB Subtitle Database to the latest version by following the steps in the next section (“Upgrading from version older than 5.0”).
If you are running a Master/Standby configuration, you should follow the next procedure:
- Upgrade the Master instance.
- Wait for the following line to appear in the log: ‘‘Background command processor: Reindexing database’’
- Upgrade the Standby instance.
Wait for the following line to appear in both Master and Standby logs:
‘‘Background command processor: Completed database reindex’’
Finish the upgrade process to upgrade to the latest version by following the steps below.
Upgrading from version older than 5.0
The FAB Subtitle Database introduced new database structure which reduces database size on the disk. If you are upgrading from version lower than 5.0 you should follow the procedure below:
- Upgrade the FAB Subtitle Database service.
- Wait for the following line to appear in the log: ‘‘Background command processor: Completed moving subtitle files’’
- Do the database Backup followed by the database Restore. Both operations are described in the FAB Subtitle Database manual.
If you are running a Master/Standby configuration, you should follow the next procedure:
- Upgrade the Master instance.
- Wait for the following line to appear in the log: ‘‘Background command processor: Moving subtitle files’’
- Upgrade the Standby instance.
Wait for the following line to appear in any log (Master or Standby):
‘‘Background command processor: Completed moving subtitle files’’
- Do the database Backup followed by the database Restore on the appropriate instance.
It is best if only one instance at the time is doing the Backup/Restore, as this will allow FAB Subtitler BCAST instances to always communicate with one of the FAB Subtitle Database servers.
This page was last updated on 2024-09-09