Updates, Security Patches, and Bugfixes

Make sure you have read Update Considerations before you start your system update.

This section explains the procedure required to update an Exasol installation for new updates, bug fixes, and the security patches.

Prerequisites

  • You should have administrator privileges to install the update, security patch or the bugfixes.
  • EXAoperation should be running on the license server.
  • Make sure that no service is running in the background (Background Backup or Restore).
  • Make sure all the nodes and storage are online.
  • Make sure you sort out the errors and warnings in the monitoring logs before updating the application.
  • Download the update package from Exasol Download Portal. The package name for the application update and bug fixes is EXAClusterOS-<version>_LS-Update.pkg. The package name for the CentOS security updates is EXASOL-<version>CentOS-7-CumulativeUpdate-<release_date>.pkg.

Procedure

  1. Log in to EXAoperation as an administrator.
  2. Shutdown all databases:
    1. Go to Services > EXASolution and select all (running) EXASolution instances.
    2. Click Shutdown.

    1. Reload the page till the database instance are changed from Running to Created.
  3. Shutdown EXAStorage.
    1. Go to Services > EXAStorage.
    2. Click Shutdown Storage Service button and confirm the prompt.

  4. Suspend Nodes:
    1. Go to Configuration > Nodes.
    2. Select all the nodes in the tab Cluster Nodes.
    3. Select Stop cluster services from actions drop-down.
    4. Click Execute button.

    1. Reload the page till the node state is changed to Suspended.
  5. Go to Configuration > Software and click the Versions tab.



  6. Click the Software Update File button and locate the package that you have downloaded from Exasol Download portal.

    If you are updating Exasol with an update file and a security patch at the same time, upload both files one after another to avoid multiple reboots of the database nodes.

    1. Click Submit to upload the database package and wait for the message on the EXAoperation interface.

    2. Reboot the license server.

    1. Click Submit to upload the OS security patch and wait for the message on the EXAoperation interface.

    2. Reboot the license server.

  7. Select Services > Monitoring and enable a log service.
  8. Check the software version from the Versions tab in Configuration > Software.
  9. Reboot the database nodes:
    1. Go to Configuration > Nodes.
    2. In the Cluster Nodes tab, select all nodes.

    1. Select Reboot from the actions drop-down.
    2. Click Execute button.
    3. Wait for the nodes to finish reboot.
    4. Reload the nodes page until the State/Op. column changes from booting to running for all nodes
  10. Start up EXAStorage:
    1. Go to Services > EXAStorage.
    2. Click Startup Storage Service and confirm the prompt.

    1. After the EXAStorage page reloaded, check the status of all nodes, disks, and volumes.
  11. Update and start all databases:
    1. Go to Services > EXASolution .
    2. Click an EXASolution instance name to open the properties page.

    1. Click Edit to open the Edit Database form.
    2. Select the database version from the drop-down and click Apply.


    1. On the EXASolution instance properties page, select Startup from Actions drop-down, and click Submit.



    1. On Services > EXASolution. page, refresh the page till the database's status is changed to Running.
  12. Start EXAoperation plug-ins.