When I was testing TiDB, I bumped into the 9001 error. I didn't figure out the cause. How to deal with it?
`ERROR 9001 (HY000): PD server timeoutstart timestamp may fall behind safepoint` in TiDB
308 Views Asked by Lilian Lee At
1
There are 1 best solutions below
Related Questions in DISTRIBUTED-DATABASE
- Accessing data on distributed database on OrientDB
- How to shard using OrientDB
- Making backup from database to another server
- Communication link failure: JDBC
- Distributed C++ game server which use database
- Understanding of hBase data storage (webpage) for Nutch
- Setting up a distributed database with TimescaleDB
- Looking for a lightweight-ish distributed DB/cache
- Bigtable secondary indexes : Best practices/Recommended-ways
- Do cross-partition queries break infinite CosmosDB horizontal scalability?
- Does 1 phase commit make sense in distributed systems?
- Strong consistency and replication factor
- Writes to geographically distributed database
- How to model "dimension" tables in TiDB?
- How to support GUID in Windows Azure Mobile services
Related Questions in TIDB
- How to set tidb global system variables in filesystem
- In TiDB how do you work around the issue where even for indexes, you can't write continuous values to avoid hotspots?
- For TiDB, does incremental value in secondary index cause hotspots too?
- Does TiDB's range based sharding nature have actual read workload benefits?
- In TiDB, how to use snowflake style uuid without causing hot spot by doing bit reverse?
- How to work around TiCDC atomic transactional limitations?
- How does the tide-operator start a pd cluster?
- Error P1001: Unable to reach database server when following Prisma's Start from Scratch guide for relational databases with Node.js and MySQL
- Flink: binlog transformation to multiple DTO and transformation method in flink
- What are the effects of rolling updates TiDB？
- What are the semantics of not using "FTWL to guarantee that the dump file is consistent with metadata"?
- tidb - how to solve node_exporter up timeout
- Error GC life time is shorter than transaction duration while writing to TiDB using Spark
- How to model "dimension" tables in TiDB?
- Why reverseSeek not supported in tikv?
Related Questions in TIDB-PD
- How does the tide-operator start a pd cluster?
- Is the number of replicas in each Region configurable? If yes, how to configure it?
- Why the `etcd cluster ID mismatch` message is displayed when starting PD?
- How to check the health status of the whole TiDB cluster?
- TIKV java client on MacOS: Failed to init client for PD cluster
- Increased replication in TiKV cluster, but storage use did not increase after applying
- `ERROR 9001 (HY000): PD server timeoutstart timestamp may fall behind safepoint` in TiDB
- Why the modified `toml` configuration for TiKV/PD does not take effect?
- How to delete the monitoring data of a cluster node that is offline?
- Couldn't connect to the PD Server using `127.0.0.1` in TiDB
- How precise does the time synchronization of a PD cluster need to be? What happens if the time in the PD servers is not consistent?
- About the number of machines in rolling update of TiDB
- Is it safe to restart servers for maintenance in tikv cluster?
- how to remove ghost peers from a failed TiDB scale-in operation
- How do I connect existing TiKV nodes to a new cluster of PDs in TiDB?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Generally, this error occurs when TiDB fails to access PD. There is a “worker” in the background of TiDB that continuously queries the safepoint from PD. If the query is not successful within 100s, this error is reported.
Possible causes: PD failure or the network issue between TiDB and PD. Solution: Check the state/monitor/log of the PD server and the network between the TiDB server and the PD server.