github / github/gh-ost

Error current heartbeatlag (9223372036.85s) is too high

Open
#1,444 3 comments 1 reaction 0 assignees View on GitHub
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

Hi all, I want to ask about gh-ost migration.
When I run gh-ost migration on my virtual machine and the progress reached 100%, it got error log `current heartbeatlag 9223372036.85s is too high, it needs to be less than both --max-lag-millis (1.50s) and --cut-over-lock-timeout-seconds (3.00) to continue`.
Here is the current specification:
1. gh-ost version is 1.1.6
2. using MariaDB version 11.4

What I have done are:
1. Upgrading the gh-ost version from 1.1.5 into 1.1.6
2. Running the gh-ost command without `--max-lag-millis`
3. Reseting the master database to refresh the replica
4. Run `ANALYZE TABLE` to refresh the performance schema
5. Also I have set the timezone setting into UTC+7 to comply with my current timezone in Indonesia by running this SQL: `SET GLOBAL time_zone = '+07:00';` and `SET time_zone = '+07:00';`

So I'm curious about the printed value of `TimeSinceLastHeartbeatOnChangelog()`, I decide to debug it on my local by print its value, but it shows `0001-01-01 00:00:00 +0000 UTC`, hence the heartbeat lag value become extremely huge.

Do you have any idea why this happens? Will appreciate any help given for this issue.
Thanks in advance!

Attachments:
![Screen Shot 2024-08-19 at 12 53 59](https://github.com/user-attachments/assets/c3541cff-84da-40b7-9e5f-51533fd52fae)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.