[GraphQL][cherry-pick #18277] Gql cherry pick health endpoint into 2024.4 release

[stefan-mysten]

Description

Adds a checkpoint_timestamp_ms to the watermark task and uses it in a new health check endpoint function. The health endpoint checks for two things

• if there is a DB connection, otherwise it returns code 500
• if the last known checkpoint timestamp is within an acceptable buffer. It subtracts the current timestamp from the checkpoint timestamp, and checks if the value is larger than the provided query param max_checkpoint_lag_ms or a default value, and it returns code 504, GATEWAY TIMEOUT in that case.

How to query this endpoint: curl -X GET "http://127.0.0.1:8000/health" -i Set the check for max checkpoint time lag to 10s. If it returns 503, then the checkpoint is behind. curl -X GET "http://127.0.0.1:8000/health?max_checkpoint_lag_ms=10000" -i

Test plan

Added a new test.

cargo nextest run --features pg_integration -- test_health_check

---

Release notes

Check each box that your changes affect. If none of the boxes relate to your changes, release notes aren't required.

For each box you select, include information after the relevant heading that describes the impact of your changes that a user might notice and any actions they must take to implement updates.

• [ ] Protocol:
• [ ] Nodes (Validators and Full nodes):
• [ ] Indexer:
• [ ] JSON-RPC:
• [ ] GraphQL:
• [ ] CLI:
• [ ] Rust SDK:

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
sui-docs	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jun 25, 2024 2:36am

[vercel[bot]]

@stefan-mysten is attempting to deploy a commit to the Mysten Labs Team on Vercel.

A member of the Team first needs to authorize it.