Upgrading HVR Hub on Linux

This section describes the requirements and step-by-step instructions on how to upgrade the HVR Hub System to a new version on Linux.

For upgrading the HVR Agent, see Upgrading HVR Agent.

In the case of a distributed setup, along with the HVR Hub System installation, there may be one or more HVR Agent installations on the source and target machines. Since HVR versions 6.1.0 and higher are fully compatible with each other, upgrading all installations may not be required.

Each HVR release contains new features and/or fixes for certain bugs. Each feature or fix is only effective if the correct machine is upgraded. Typically, the release notes (also available in HVR_HOME/hvr.rel directory and on the downloads page) contain information about which features and fixes have been added and which machines must be upgraded for each feature and fix to be effective. New features should not be used until all machines that are specified for that feature are upgraded; otherwise, errors may occur.

For example, if a new release fixes an Integrate bug, then that release must be installed on the HVR Agent machine(s) that performs Integrate. There will be no benefit if only the HVR Hub System is upgraded using that release.

Requirements

Following are the prerequisites for upgrading the HVR Hub System on Linux:

Installation file
New version of the HVR Hub System installation file for Linux (e.g., fivetran-6.1.0_21-hub_and_agent-linux_glibc2.12-x64-64bit_ga_patch.tar.gz). The installation file can be downloaded from the Downloads tab in the Fivetran dashboard. For more information, see Downloading HVR.
Create backup
Before upgrading the HVR Hub System, it is recommended to take a full backup of the following:
- the HVR_HOME and HVR_CONFIG directories.
- the repository database by using the DBMS's native backup option. Alternatively, you can save the hub snapshot to create a backup of the repository database. This can be done using the UI option Save Hub Snapshot or command hvrsnapshotsave.

Upgrade Steps

Perform the following steps to upgrade the HVR Hub System:

Perform steps 1 - 3 for all active channels.

Suspend the capture job running in a channel.
Run the command hvrsuspend.
```
hvrsuspend hub channel-cap
```
Ensure that the integrate job finishes integrating all the changes. This can be verified as follows:
1. No transaction (.tx) files are left in the router directory ($HVR_CONFIG/hubs/hub/channels/channel/locs/src_loc/router/loc_tgt_loc/).
2. The integrate job has status Waiting... in the channel-integ-location.out log file located at $HVR_CONFIG/hubs/hub/logs/.
Suspend the integrate job.
Run the command hvrsuspend.
```
hvrsuspend hub channel-integ
```
Stop the HVR Hub Server.
- If the Hub Server is configured with systemd, use the command systemctl to terminate the process.
```
systemctl stop hvrhubserver
```
- If the Hub Server is NOT configured with systemd, use the command hvrhubserver to terminate the process.
```
hvrhubserver -k
```
Ensure that all HVR processes have stopped. To verify whether any HVR processes are still running, use a command like the following:
ps -ef | grep hvr
If any HVR processes are running, use the kill command to terminate the process.
Install the new version of the HVR Hub System; uncompress the installation file (e.g., fivetran-6.1.0_21-hub_and_agent-linux_glibc2.12-x64-64bit_ga_patch.tar.gz) into the HVR_HOME directory.
```
cd $HVR_HOME
```
```
tar xzf /tmp/fivetran-6.1.0_21-hub_and_agent-linux_glibc2.12-x64-64bit_ga_patch.tar.gz
```
Start the HVR Hub Server by using the command hvrhubserver.
```
hvrhubserver -d
```
Activate replication in the channel to capture changes from the beginning of the oldest current (not closed) transaction, regenerate jobs and enroll information for tables.
Perform this step for all the channels.
In some cases, other replication components should also be reactivated depending on the type of changes contained in the version being installed.
Run the hvractivate command with options -J and -oje. This will update the job scripts, scheduler jobs, job groups and extend the enrollment details for tables.
```
hvractivate -J cap -J integ -oje hub channel
```
Alternatively, run the hvractivate command with options -J and -ojE. This will update the job scripts, scheduler jobs, job groups and recreate the enroll file for all tables in the channel.
```
hvractivate -J cap -J integ -ojE hub channel
```