[
https://issues.apache.org/jira/browse/GOBBLIN-1798?focusedWorklogId=849935&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-849935
]
ASF GitHub Bot logged work on GOBBLIN-1798:
-------------------------------------------
Author: ASF GitHub Bot
Created on: 09/Mar/23 00:45
Start Date: 09/Mar/23 00:45
Worklog Time Spent: 10m
Work Description: ZihanLi58 opened a new pull request, #3658:
URL: https://github.com/apache/gobblin/pull/3658
Dear Gobblin maintainers,
Please accept this PR. I understand that it will not be reviewed until I
have checked off all the steps below!
### JIRA
- [ ] My PR addresses the following [Gobblin
JIRA](https://issues.apache.org/jira/browse/GOBBLIN/) issues and references
them in the PR title. For example, "[GOBBLIN-XXX] My Gobblin PR"
- https://issues.apache.org/jira/browse/GOBBLIN-1798
### Description
- [ ] Here are some details about my PR, including screenshots (if
applicable)
**Problem:**
Now with warm standby mode, we will write to mysql and read from mysql on
separate hosts. Since we turn on the read replica for mysql databases, we do
see read after write return null value and miss the processing for random flow
request.
Sample error log:
> "The URI gobblin-flow:/gobblin-test discovered in SpecStore is missing in
FlowCatalog, suspecting current modification on SpecStore"
**Solutions**
We want to add a backoff retry logic when we try to read from MySQL
databases.
### Tests
- [ ] My PR adds the following unit tests __OR__ does not need testing for
this extremely good reason:
Unit test
### Commits
- [ ] My commits all reference JIRA issues in their subject lines, and I
have squashed multiple commits if they address the same issue. In addition, my
commits follow the guidelines from "[How to write a good git commit
message](http://chris.beams.io/posts/git-commit/)":
1. Subject is separated from body by a blank line
2. Subject is limited to 50 characters
3. Subject does not end with a period
4. Subject uses the imperative mood ("add", not "adding")
5. Body wraps at 72 characters
6. Body explains "what" and "why", not "how"
Issue Time Tracking
-------------------
Worklog Id: (was: 849935)
Remaining Estimate: 0h
Time Spent: 10m
> Add backoff retry when we access mysql db for flow spec or dag action
> ---------------------------------------------------------------------
>
> Key: GOBBLIN-1798
> URL: https://issues.apache.org/jira/browse/GOBBLIN-1798
> Project: Apache Gobblin
> Issue Type: Improvement
> Reporter: Zihan Li
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Now with warm standby mode, we will write to mysql and read from mysql on
> separate hosts. Since we turn on the read replica for mysql databases, we do
> see read after write return null value and miss the processing for random
> flow request. So we want to add a backoff retry logic when we try to read
> from MySQL databases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
