Flink CDC Issue Import created FLINK-34755:
----------------------------------------------

             Summary: Encountered a problem reading tidb data
                 Key: FLINK-34755
                 URL: https://issues.apache.org/jira/browse/FLINK-34755
             Project: Flink
          Issue Type: Bug
          Components: Flink CDC
            Reporter: Flink CDC Issue Import


**Describe the bug(Please use English)**
The console has been updated as follows when reading tidb, using print.sink, 
but the console has no data printing.

**Environment :**
 - Flink version : 1.14.5
 - Flink CDC version: 2.3.0
 - Database and version: tidb-v6.1.0

**To Reproduce**
Steps to reproduce the behavior:
1. The test code to connect to tidb :
```
            "     ) WITH (    " +
            "    'connector' = 'tidb-cdc'," +
            "    'scan.startup.mode' = 'latest-offset'," +
            "     'tikv.grpc.timeout_in_ms' = '20000', " +
            "     'pd-addresses' = '192.168.100.10:2379'," +
            "     'database-name' = 'device'," +
            "     'table-name' = 'real_time_record'" +
            "     )";
```
1. The error :
```
[pool-24-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-20-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-26-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.71:20160] is not reachable
[pool-27-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.71:20160] is not reachable
[pool-23-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.71:20160] is not reachable
[pool-22-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-25-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.64:20160] is not reachable
[pool-21-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.71:20160] is not reachable
[pool-26-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.64:20160] is not reachable
[pool-23-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-27-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-25-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.71:20160] is not reachable
[pool-21-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.234:20160] is not reachable
[pool-22-thread-1] WARN org.tikv.common.region.StoreHealthyChecker - store 
[172.16.0.64:20160] is not reachable
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(2/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(2/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(7/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862555353140, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(7/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453862817497106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(2/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(2/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(7/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863079641102, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(7/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(2/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863341785118, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(1/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(5/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(8/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(6/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(4/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863603929106, regionId: 213496
[Legacy Source Thread - Source: TableSourceScan(table=[[default_catalog, 
default_database, time_record]], fields=[id, employee_id, date, fence_status]) 
(3/8)([#0|https://github.com/apache/flink-cdc/issues/0] | 
[FLINK-0|https://issues.apache.org/jira/browse/FLINK-0])] INFO 
org.tikv.cdc.CDCClient - handle resolvedTs: 437453863879180289, regionId: 213496
[PDClient-update-leader-pool-0] WARN org.tikv.common.PDClient - failed to get 
member from pd server.
org.tikv.shade.io.grpc.StatusRuntimeException: UNAVAILABLE: Keepalive failed. 
The connection is likely gone
        at 
org.tikv.shade.io.grpc.stub.ClientCalls.toStatusRuntimeException(ClientCalls.java:287)
        at 
org.tikv.shade.io.grpc.stub.ClientCalls.getUnchecked(ClientCalls.java:268)
        at 
org.tikv.shade.io.grpc.stub.ClientCalls.blockingUnaryCall(ClientCalls.java:175)
        at org.tikv.kvproto.PDGrpc$PDBlockingStub.getMembers(PDGrpc.java:1868)
        at org.tikv.common.PDClient.getMembers(PDClient.java:443)
        at org.tikv.common.PDClient.tryUpdateLeader(PDClient.java:565)
        at org.tikv.common.PDClient.lambda$initCluster$15(PDClient.java:730)
        at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
        at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
        at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:750)
[PDClient-update-leader-pool-0] WARN org.tikv.common.PDClient - failed to get 
member from pd server.
```

**Additional Description**
If applicable, add screenshots to help explain your problem.


---------------- Imported from GitHub ----------------
Url: https://github.com/apache/flink-cdc/issues/1761
Created by: [dadong-13|https://github.com/dadong-13]
Labels: bug, 
Created at: Fri Nov 18 16:57:15 CST 2022
State: open




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to