Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-474

Howto install cumulative OS patchlevel for EXASuite 5

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASolution 5.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Solution:
      Hide

      Synopsis

      This article describes all required steps to apply a cumulative OS security patchlevel on EXASuite 5. Cumulative OS patchlevels may be applied on all EXASuite 5 versions (minimum required version 5.0). Cumulative OS patchlevels may be applied on all OS security patchlevels.

      The update requires a maintenance window of about one hour and will be performed in one step:

      1. Update to Cumulative Patch 20 (~ 35 minutes)

      Please note that

      1. Tasks performed in EXAoperation require a user with at least "Administrator" privileges and
      2. It is vital to wait for uploads and reboots to finish completely!


      Prerequisites

      Please download the following package from the EXASOL customer portal:

      Package Description Size (MiB) MD5 Checksum URL
      EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg EXASuite security updates 322.32 5298f84c9acc22c2ea14f3c5532ee107 https://www.exasol.com/support/secure/attachment/45040/EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg


      Installation instructions

      1. Check Software Versions
      • Open Configuration > Software in EXAoperation and click on the tab "Versions"
      • EXAClusterOS 5.0 is required as the minimum version for CentOS 6.5 cumulative patchlevels.

        (In this example Version 5.0.6)
      2. EXAoperation master node
      • The cumulative patchlevel must be applied to the license server since it is the only node that boots from the local hard drive.
        • In EXAoperation, please navigate to Configuration > Network
        • Open the tab "System"
        • Ensure that the license server (usually node n0010) is listed as "License Server Node"
      • Move EXAoperation if the license server is not the master node:
        • Open the Page Services > EXAoperation
        • Select "n0010" from dropdown list
        • Confirm with click on the button "Move to specified Node"
      3. Check database operation
      • Navigate to the EXAoperation page Services > EXASolution
      • Review the database list and check if the column "Background Restore" indicates "None" on all instances
      4. Shutdown all databases
      • Open the Services > EXASolution page
      • Select all (running) EXASolution instances
      • Click on the button "Shutdown"
      • Reload the page until all instances change their status from "Running" to "Created"
      • Again, you may follow the procedure in an appropriate logservice:

        System marked as stopped.
        Successfully send retry shutdown event to system partition 64.
        EXASolution DEMO is rejecting connections
        controller-st(0.0): Shutdown called.
        User 0 requests shutdown of system.

      5. Shutdown EXAStorage
      • Navigate to the EXAoperation page Services > EXAStorage
      • Click on the button "Shutdown Storage Service" and confirm your choice when prompted. When the storage service is down, it looks like:
      6. Upload cumulative CentOS 6.5 Patchlevel 20
      • Open the Configuration > Software page in EXAoperation
      • In the tab "Versions" please find the input box labeled "Software Update File:"
      • Click on the button "Browse" (label depends on browser, language and operating system)
      • Choose "EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg" in the newly opened file manager view
      • Confirm with click on the button "Submit"
      • Upload and installation will take approximately 15 minutes. The following message will appear:

        Kernel has been updated. Please shutdown databases, Storage, nodes and restart license server to finish update.

      7. Suspend cluster nodes
      • Open the Configuration > Nodes page in EXAoperation
      • In the tab "Cluster Nodes", please select all nodes
      • Select "Stop cluster services" from actions dropdown menu
      • Confirm with click on the button "Execute"
      • Reload the page and until all nodes indicate the State/Op. "Suspended"
      • The state of every node has to be "Active".
      8. Reboot the license server
      • Open the Configuration > Nodes page in EXAoperation
      • Navigate down to the fieldset "License Nodes"
      • Click on the button "Reboot" next to the license server (usually node n0010)
      • If reboot is not possible, you may open the license server console (e.g. in iDRAC or vSphere) and send the key sequence CTRL + ALT + DEL.
      • Wait for the license server to finish startup procedure (about 15 minutes) and log into EXAoperation again
      9. Reboot the database nodes
      • Navigate to the Configuration > Nodes page
      • Select all nodes in the tab "Cluster Nodes"
      • Choose "Reboot" from actions dropdown menu and confirm with click on button "Execute"
      • Wait for the nodes to finish reboot (about 5 to 10 minutes)
      • Reload the nodes page until the State/Op. column changes from "booting" to "running" for all nodes (takes about 10 minutes)
      • Again, you may watch the boot process in an appropriately configured logservice (Please ignore the error message "failed to install kernel package on client node." if you encounter it during the first boot after the update)

      Do not start EXAStorage or any EXASolution instance until the patchlevel is applied.

      10. Check Software Versions

      Open Configuration > Software in EXAoperation and click on the tab "Versions"
      The field labelled EXAClusterOS must now present behind version "(+ OS Patchlevel 20)".

      11. Review the installation history
      • Open the Configuration > Software page in EXAoperation
      • In the tab "Versions" please click on the button "Show Installation History"
      • The following items will appear:
      Updated to operating system patchlevel 20
      12. Startup EXAStorage
      • Navigate to the EXAoperation page Services > EXAStorage
      • Ensure that all database nodes (n11 upwards) indicate the State "Running"
      • Click on the button "Startup Storage Service" and confirm your choice when prompted
      • After the EXAStorage page reloaded, check the status of all nodes, disks and volumes
      13. Start the databases
      • Open the Services > EXASolution page and repeat the following steps for all instances:
      • Click on an EXASolution instance name to open instance details
      • From the "Actions" dropdown menu please select "Startup" and confirm with click on the button "Submit"
      • Navigate back to the Services > EXASolution page and reload until the database indicates the status "Running"
      • You may follow the procedure in an appropriate logservice:

      EXASolution DEMO is accepting connections
      System is ready to receive client connections.
      System started successfully in partition 44.
      User 0 requests startup of system.
      User 0 requests new system setup.

      14. Start EXAoperation plugins

      If required, you may now start services delivered through EXAoperaton plugins (XML-RPC).

      Show
      Synopsis This article describes all required steps to apply a cumulative OS security patchlevel on EXASuite 5. Cumulative OS patchlevels may be applied on all EXASuite 5 versions (minimum required version 5.0). Cumulative OS patchlevels may be applied on all OS security patchlevels. The update requires a maintenance window of about one hour and will be performed in one step: Update to Cumulative Patch 20 (~ 35 minutes) Please note that Tasks performed in EXAoperation require a user with at least "Administrator" privileges and It is vital to wait for uploads and reboots to finish completely! Prerequisites Please download the following package from the EXASOL customer portal : Package Description Size (MiB) MD5 Checksum URL EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg EXASuite security updates 322.32 5298f84c9acc22c2ea14f3c5532ee107 https://www.exasol.com/support/secure/attachment/45040/EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg Installation instructions 1. Check Software Versions Open Configuration > Software in EXAoperation and click on the tab "Versions" EXAClusterOS 5.0 is required as the minimum version for CentOS 6.5 cumulative patchlevels. (In this example Version 5.0.6) 2. EXAoperation master node The cumulative patchlevel must be applied to the license server since it is the only node that boots from the local hard drive. In EXAoperation, please navigate to Configuration > Network Open the tab "System" Ensure that the license server (usually node n0010) is listed as "License Server Node" Move EXAoperation if the license server is not the master node: Open the Page Services > EXAoperation Select "n0010" from dropdown list Confirm with click on the button "Move to specified Node" 3. Check database operation Navigate to the EXAoperation page Services > EXASolution Review the database list and check if the column "Background Restore" indicates "None" on all instances 4. Shutdown all databases Open the Services > EXASolution page Select all (running) EXASolution instances Click on the button "Shutdown" Reload the page until all instances change their status from "Running" to "Created" Again, you may follow the procedure in an appropriate logservice: System marked as stopped. Successfully send retry shutdown event to system partition 64. EXASolution DEMO is rejecting connections controller-st(0.0): Shutdown called. User 0 requests shutdown of system. 5. Shutdown EXAStorage Navigate to the EXAoperation page Services > EXAStorage Click on the button "Shutdown Storage Service" and confirm your choice when prompted. When the storage service is down, it looks like: 6. Upload cumulative CentOS 6.5 Patchlevel 20 Open the Configuration > Software page in EXAoperation In the tab "Versions" please find the input box labeled "Software Update File:" Click on the button "Browse" (label depends on browser, language and operating system) Choose "EXAClusterOS-CentOS-6.5_CumulativePatch-20.pkg" in the newly opened file manager view Confirm with click on the button "Submit" Upload and installation will take approximately 15 minutes. The following message will appear: Kernel has been updated. Please shutdown databases, Storage, nodes and restart license server to finish update. 7. Suspend cluster nodes Open the Configuration > Nodes page in EXAoperation In the tab "Cluster Nodes", please select all nodes Select "Stop cluster services" from actions dropdown menu Confirm with click on the button "Execute" Reload the page and until all nodes indicate the State/Op. "Suspended" The state of every node has to be "Active". 8. Reboot the license server Open the Configuration > Nodes page in EXAoperation Navigate down to the fieldset "License Nodes" Click on the button "Reboot" next to the license server (usually node n0010) If reboot is not possible, you may open the license server console (e.g. in iDRAC or vSphere) and send the key sequence CTRL + ALT + DEL. Wait for the license server to finish startup procedure (about 15 minutes) and log into EXAoperation again 9. Reboot the database nodes Navigate to the Configuration > Nodes page Select all nodes in the tab "Cluster Nodes" Choose "Reboot" from actions dropdown menu and confirm with click on button "Execute" Wait for the nodes to finish reboot (about 5 to 10 minutes) Reload the nodes page until the State/Op. column changes from "booting" to "running" for all nodes (takes about 10 minutes) Again, you may watch the boot process in an appropriately configured logservice (Please ignore the error message "failed to install kernel package on client node." if you encounter it during the first boot after the update) Do not start EXAStorage or any EXASolution instance until the patchlevel is applied. 10. Check Software Versions Open Configuration > Software in EXAoperation and click on the tab "Versions" The field labelled EXAClusterOS must now present behind version "(+ OS Patchlevel 20)". 11. Review the installation history Open the Configuration > Software page in EXAoperation In the tab "Versions" please click on the button "Show Installation History" The following items will appear: Updated to operating system patchlevel 20 12. Startup EXAStorage Navigate to the EXAoperation page Services > EXAStorage Ensure that all database nodes (n11 upwards) indicate the State "Running" Click on the button "Startup Storage Service" and confirm your choice when prompted After the EXAStorage page reloaded, check the status of all nodes, disks and volumes 13. Start the databases Open the Services > EXASolution page and repeat the following steps for all instances: Click on an EXASolution instance name to open instance details From the "Actions" dropdown menu please select "Startup" and confirm with click on the button "Submit" Navigate back to the Services > EXASolution page and reload until the database indicates the status "Running" You may follow the procedure in an appropriate logservice: EXASolution DEMO is accepting connections System is ready to receive client connections. System started successfully in partition 44. User 0 requests startup of system. User 0 requests new system setup. 14. Start EXAoperation plugins If required, you may now start services delivered through EXAoperaton plugins (XML-RPC).
    • Category 1:
      Cluster Administration - Update

      Attachments

        Issue Links

        1. 1_check_software_versions.png
          70 kB
        2. 10_check_patchlevel_number.png
          68 kB
        3. 10_reboot_database_nodes.png
          125 kB
        4. 14_open_database_properties.png
          53 kB
        5. 14_start_database.png
          30 kB
        6. 2_check_exaoperation_master.png
          83 kB
        7. 2_move_exaoperation_master.png
          46 kB
        8. 3_check_database_operation.png
          58 kB
        9. 4_shutdown_all_databases-1.png
          62 kB
        10. 4_shutdown_all_databases-2.png
          54 kB
        11. 4_upload_exasuite-507.png
          74 kB
        12. 5_shutdown_exastorage-1.png
          104 kB
        13. 5_shutdown_exastorage-2.png
          58 kB
        14. 6_2_done_patchlevel1.png
          75 kB
        15. 6_2_submit_patchlevel1.png
          68 kB
        16. 7_suspend_nodes-1.png
          94 kB
        17. 7_suspend_nodes-2.png
          129 kB
        18. 8_reboot_licenseserver_exaoperation.png
          78 kB

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: