Upgrade Cumulus from v18.2 to v18.5

[krisstanton]

// Required - Completion or near completion of ticket #384

• Perform Cumulus Upgrade from v18.2.0 to v18.5.1
  • Ref ticket Research Cumulus Upgrade and make stable plan here #384
  • Upgrade from 18.2.0 to 18.3.3 (Requires update to NodeJS 20+)
    • Update Versions (Cumulus, NodeJS)
    • Upgrade Sandbox ---> Smoke Test
    • Upgrade UAT ---> Smoke Test
    • Upgrade PROD (after UAT Smoke Test Passes)
  • Upgrade from 18.3.3 to 18.4.0 (Requires DB Migration Steps)
    • Ref: https://nasa.github.io/cumulus/docs/next/upgrade-notes/upgrade_execution_table_CUMULUS_3320
    • Manual DB Migration Steps for Sandbox DB (creating detailed instructions for UAT and PROD)
      • Upgrade Sandbox ---> Smoke Test
    • Manual DB Migration Steps for UAT DB
      • Upgrade UAT ---> Smoke Test
    • Manual DB Migration Steps for PROD DB
      • Upgrade PROD
  • Upgrade from 18.4.0 to 18.5.0
    • Ref: https://nasa.github.io/cumulus/docs/next/upgrade-notes/serverless-v2-upgrade
    • Manually Update Sandbox Serverless (creating detailed instructions for UAT and PROD)
      • Upgrade Sandbox ---> Smoke Test
    • Manually Update UAT Serverless
      • Upgrade UAT ---> Smoke Test
    • Manually Update PROD Serverless
      • Upgrade PROD
  • Proceed to ticket Upgrade ORCA from v9.0.5 to v10.1.0 #431 to do the Upgrade for ORCA

[krisstanton]

WIP UPDATE:
Due to the nature of all the dependency and Database updates between the cumulus versions, I decided to go with a step-wise upgrade process. (18.2.0 --> 18.3.3 --> 18.4.0 --> 18.5.0)

• Attempted a Sandbox Deploy (a few times)
  • doing additional code changes between each attempt and documenting.
  • Currently tracking down an aws-sdk update as it relates to some of our type script stuff

terraspace up cumulus:  Error: failed to execute "/bin/bash": $ run-s build test lambda:install
terraspace up cumulus:  Error: Cannot find module 'aws-sdk'

[krisstanton]

WIP Update:
I am currently running into a small problem between the way Cumulus DB connections are handled for v18.3.3 and ORCA v9.0.5.
I am working through this problem at this time and may have a solution. Still getting the syntax right for my test.
If you are reading this, I have omitted the detailed description due to this being public and the upgrade being in progress.
If you need more detail on the specific nature of the problem while I'm still working on the upgrade, please let me know. If not, I plan on coming back and describing the approach, and the fix, after it has been implemented.