{"type":"doc","content":[{"type":"table","attrs":{"layout":"default","localId":"86df9a21-e03c-45fe-9447-a2ea7e4818dc"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"neDate","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[692.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Authors","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[692.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"},{"type":"mention","attrs":{"id":"5f80958595fe8e0069b63573","text":"@Reuben Roberts"}},{"text":" ","type":"text"},{"type":"mention","attrs":{"id":"5c3c758d05d0812fde076343","text":"@Andy Dingley"}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#abf5d1","rowspan":1,"colwidth":[692.0]},"content":[{"type":"paragraph","content":[{"text":"Done","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Summary","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[692.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://hee-tis.atlassian.net/browse/TIS21-2191"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Impact","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[692.0]},"content":[{"type":"paragraph","content":[{"text":"NDW downstream processes compromised, including Hicom Leave Manager data transfer","type":"text"}]}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"62b7a711-a6f4-45ed-8be4-1b1a7f8d34b5"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"ee25e71d-e368-4ab6-ba6e-54491d2ee7f2"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Non-technical Description","type":"text"}]},{"type":"paragraph","content":[{"text":"The overnight job to transfer data to the NDW for the TIS production, staging and NIMDTA environments failed. This in turn triggered the failure of the NDW ETL process, and consequently the data transfer to Hicom Leave Manager. Due to further oversight, the same issue recurred the following night. In both instances, the TIS and NDW jobs were rerun, but Hicom only imports data once a day, so this system would have been left with data two days stale. The following graphic indicates the downstream effects, particularly the ‘Hicom Leave Manager Server’ swimlane: ","type":"text"},{"type":"inlineCard","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"ETLs on Swim-lane","versionAtSave":"1"},"url":"https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/3118235649"}},{"text":" . ","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Trigger","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Breaking change in third-party component, and subsequent misunderstanding that the initial job rerun was not a fix to the underlying problem ","type":"text"},{"text":"per se","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Detection","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Slack monitoring alert.","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Resolution","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Reran the NDW-ETL processes using the last known-good version.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Investigation into the root cause discovered the breaking-change in the 3rd party image builder for the component","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Pending a roll-out of a patch, upgrading the TIS-NDW-ETL from Java 8 to Java 11 resolved the issue","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Timeline","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" 03:00 - 03:40 BST #monitoring-ndw Slack channel alert that the first of three overnight jobs failed.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" 07:53 BST Those jobs were restarted.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" 09:11 BST All jobs had completed successfully.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" 09:13 BST Pavel at NDW notified","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632873600000"}},{"text":" 12:00 BST Pavel indicates that the NDW ETL has been run successfully","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 03:00 - 03:40 BST #monitoring-ndw Slack channel alert that the first of three overnight jobs failed (unfortunately the broken task images were still ‘live’ for the services)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 06:30 BST These jobs were restarted.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 07:30 BST All jobs had completed successfully.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 07:40 BST Pavel at NDW notified","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 09:06 BST The revised component deployed successfully, and tested on staging","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1632960000000"}},{"text":" 11:04 BST Pavel indicates that the NDW ETL has been run successfully","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Root Cause(s)","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"A new release of the TIS-NDW_ETL component was deployed the previous afternoon","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Two assumptions triggered the subsequent failure of the ETL jobs:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"That merging the pull request would only deploy the revised component to the staging environment","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"That no breaking-changes in 3rd party component would cause the Docker images to be invalid","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In fact, the new version of the component is deployed to all three environments (staging, production and NIMDTA). In general this should be acceptable, since the job is only run at 2am, so there should be scope to test the new deployment on staging by force-running the task, with time to roll back if necessary before the nightly scheduled run.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"A breaking change to the Paketo image builder rendered the new component images invalid, throwing the following error on startup:","type":"text"},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.620Z # JRE version: (8.0_302-b08) (build )","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.621Z # Java VM: OpenJDK 64-Bit Server VM (25.302-b08 mixed mode linux-amd64 compressed oops)","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.621Z # Problematic frame:","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.623Z # V [libjvm.so+0xb2a2f7] VirtualMemoryTracker::add_reserved_region(unsigned char*, unsigned long, NativeCallStack const&, MemoryType, bool)+0x77","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.623Z #","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"2021-09-29T02:40:40.623Z # Core dump written. Default location: /workspace/core or core.1","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" The fix is documented here: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://github.com/paketo-buildpacks/libjvm/pull/105"}},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Workarounds to (a) temporarily force the specific (older) version of the builder or (b) to migrate the component to Java 11 were explored. ","type":"text"},{"type":"hardBreak"},{"text":"(a) Amending the pom.xml file as per:","type":"text"},{"type":"hardBreak"},{"text":"\n org.springframework.boot\n spring-boot-maven-plugin\n \n \n gcr.io/paketo-buildpacks/builder:0.1.174-base\n \n ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"was successful, but would need to be reverted once a new working version of the 3rd party component was released.","type":"text"},{"type":"hardBreak"},{"text":"(b) With concomitant version changes for groovy etc., this was successful, and was the preferred method. This was implemented and a revised functional image of the component deployed 2021-09-30 8:30 AM BST","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Action Items","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"a8f7114b-6c04-4ef7-9772-08f52980c25a"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[232.0]},"content":[{"type":"paragraph","content":[{"text":"Action Items","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"Owner","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.0]},"content":[{"type":"paragraph","content":[{"text":"Status","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[232.0]},"content":[{"type":"paragraph","content":[{"text":"Rebuild tis-ndw-etl using Java 11","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"type":"mention","attrs":{"id":"5f80958595fe8e0069b63573","text":"@Reuben Roberts"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.0]},"content":[{"type":"paragraph","content":[{"text":"Done","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[232.0]},"content":[{"type":"paragraph","content":[{"text":"Possibly update component documentation to flag-up deployment process (to mitigate against future assumptions causing this sort of issue)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"type":"mention","attrs":{"id":"5f80958595fe8e0069b63573","text":"@Reuben Roberts"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.0]},"content":[{"type":"paragraph","content":[{"text":"Done","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[232.0]},"content":[{"type":"paragraph","content":[{"text":"Review previous NDW-ETL failures to highlight in particular partial-runs, since these cause most disruption in downstream systems (which interpret missing data as having been deleted)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"type":"mention","attrs":{"id":"5f80958595fe8e0069b63573","text":"@Reuben Roberts"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.0]},"content":[{"type":"paragraph","content":[{"text":"Done: Text is as follows:","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is a quick summary of the NDW ETL failures. This year, we have had 5 failures (if you count the latest one as a single failure spread over two days). Last year there were 6. Of the failures this year, only one appears to have been a partial failure: 2021-03-10: ","type":"text"},{"type":"inlineCard","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"2021-03-10 The NDW ETL failed and didn't recover for PROD & STAGE","versionAtSave":"8"},"url":"https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/2614919201"}},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"This seems to have been triggered by an outage on the NDW side.","type":"text"}]},{"type":"paragraph","content":[{"text":"I guess this suggests a few things to me:","type":"text"}]},{"type":"paragraph","content":[{"text":"Failures of the existing NDW ETL are not particularly rare, but partial failures are.","type":"text"}]},{"type":"paragraph","content":[{"text":"The incidence of failures has not dropped much since last year, so the various actions/interventions in response to the failures have not (yet) had much impact. Possibly there is simply quite a diverse range of situations that can cause failure.","type":"text"}]},{"type":"paragraph","content":[{"text":"Mitigating against complete failures, e.g. by better notifications to downstream parties and/or automated retrying of the jobs, would be likely to see active service, but as the 'cost' of data that is one day stale is not so high, the benefit might be marginal.","type":"text"}]},{"type":"paragraph","content":[{"text":"Ensuring that the job either completes successfully or fails entirely (or prevents downstream processes from reading the partially populated database by e.g. removing the credentials whereby their process connects to the database at the start and recreating them only at the successful completion of the job) might be more valuable, even though it covers a less likely scenario.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[232.0]},"content":[{"type":"paragraph","content":[{"text":"Further planning / ticketing work to mitigate against this in future","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.0]},"content":[{"type":"paragraph","content":[{"text":"Questions exist over NDW capacity to implement their end of a revised queue / stream of changes that we send, instead of the existing monolithic process. However, TIS could modernise our side with a new-to-old interface of sorts, as per the ESR BiDi project.","type":"text"}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Lessons Learned","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assumptions as to the CI/CD pathway for a specific component can be problematic.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"It would be useful to flag-up non-standard deployment paths in component documentation ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"As Hicom is an external company, there is potentially less flexibility in rescheduling jobs, and general negotiations would need to occur within a contractual framework. This also underlines the need for a consistent reliable service from the TIS side.","type":"text"}]}]}]}],"version":1}

Browser not supported