{"id":747,"date":"2023-03-30T15:52:06","date_gmt":"2023-03-30T07:52:06","guid":{"rendered":"https:\/\/www.luyouli.com\/?p=747"},"modified":"2023-03-30T15:56:07","modified_gmt":"2023-03-30T07:56:07","slug":"polardb-x%e9%87%8d%e5%90%af%e8%8a%82%e7%82%b9%e5%90%8ecn%ef%bc%88polardbx-sql%ef%bc%89%e6%9c%8d%e5%8a%a1%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8%e5%8e%9f%e5%9b%a0%e6%9f%a5%e6%89%be%e5%8f%8a%e5%a4%84","status":"publish","type":"post","link":"https:\/\/www.luyouli.com\/?p=747","title":{"rendered":"polardb-x\u91cd\u542f\u8282\u70b9\u540eCN\uff08polardbx-sql\uff09\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u539f\u56e0\u67e5\u627e\u53ca\u5904\u7406"},"content":{"rendered":"\n

\u955c\u50cf\uff1a<\/p>\n\n\n\n

PolarDB-X Operator\uff1a1.4.0<\/p>\n\n\n\n

CDC\uff1adocker.io\/polardbx\/polardbx-cdc:5.4.15-20230323180912<\/p>\n\n\n\n

DN\uff1adocker.io\/polardbx\/polardbx-engine:80-8.0.18-20230323180912<\/p>\n\n\n\n

CN\uff1adocker.io\/polardbx\/polardbx-sql:5.4.15-20230328160000<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u6700\u65b0\u7684operator 1.4\u90e8\u7f72\u96c6\u7fa4\uff0c\u6240\u6709\u7684\u955c\u50cf\u90fd\u662f\u9ed8\u8ba4\u7684\uff0c\u5f53\u6211\u91cd\u542f\u5176\u4e2d\u7684\u67d0\u4e00\u4e2a\u8282\u70b9\uff0c\u6211\u53d1\u73b0\u8fd9\u4e2a\u8282\u70b9\u4e0a\u7684CDC\u3001DN\u3001GMS\u8fd9\u4e09\u4e2apod\u90fd\u80fd\u91cd\u5efa\uff0c\u4f46\u662f\u552f\u72ecCN\u7684pod\uff0c\u4e00\u76f4\u662f2\/3<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u539f\u56e0\u67e5\u627e\uff1a<\/p>\n\n\n\n

1\u3001\u5148\u6267\u884c kubectl annotate pod runmode=debug<\/p>\n\n\n\n

\u7136\u540e\u8fdb\u53bb CN \u7684 pod \uff0c\u770b\u4e0b \/home\/admin\/drds-server\/logs\/tddl\/tddl.log \u91cc\u7684\u62a5\u9519\u4fe1\u606f<\/p>\n\n\n\n

kubectl annotate pod polardb-x-9zk9-cn-default-fdd67b679-fmgzh runmode=debug<\/p>\n\n\n\n

kubectl exec -it polardb-x-9zk9-cn-default-fdd67b679-fmgzh — bash<\/p>\n\n\n\n

cd \/home\/admin\/drds-server\/logs\/tddl\/<\/p>\n\n\n\n

grep ERROR *.log<\/p>\n\n\n\n

<\/p>\n\n\n\n

2\u3001\u67e5\u627e\u5230\u62a5\u9519\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n\n\n\n

[ManagerExecutor-16-thread-1] ERROR com.alibaba.polardbx.ClusterSyncManager – [] [TDDL] Failed to SYNC to ‘10.233.100.75:3406’ before check for RefreshNodeSyncAction. Caused by: Communications link failure<\/p>\n\n\n\n

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server., tddl version: 5.4.15-20230328<\/p>\n\n\n\n

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure<\/p>\n\n\n\n

<\/p>\n\n\n\n

3\u3001\u5728\u62a5\u9519\u7684 CN \u7684 pod \u91cc\u9762\uff0csu – admin \u5207\u6362\u6743\u9650\uff0c\u7136\u540e ctmeta \uff0c\u53ef\u4ee5\u767b\u5230 metadb \uff0c\u7136\u540e\u6267\u884c select * from server_info \u770b\u770b<\/p>\n\n\n\n

$ su – admin<\/p>\n\n\n\n

$ ctmeta<\/p>\n\n\n\n

mysql> select * from server_info;<\/p>\n\n\n\n

+—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+ | id | gmt_created | gmt_modified | inst_id | inst_type | ip | port | htap_port | mgr_port | mpp_port | status | region_id | azone_id | idc_id | cpu_core | mem_size | extras | +—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+ | 1 | 2023-03-30 11:20:50 | 2023-03-30 11:20:50 | polardb-x | 0 | 10.233.73.254 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-74824 | | 2 | 2023-03-30 11:20:50 | 2023-03-30 11:20:50 | polardb-x | 0 | 10.233.100.75 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-fmgzh | | 3 | 2023-03-30 11:21:25 | 2023-03-30 11:21:25 | polardb-x | 0 | 10.233.95.217 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-5x2d8 | | 4 | 2023-03-30 12:01:29 | 2023-03-30 12:01:29 | polardb-x | 0 | 10.233.100.97 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-fmgzh | +—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+<\/p>\n\n\n\n

\u53d1\u73b0\u91cc\u9762\u6709\u56db\u6761CN\u4fe1\u606f<\/p>\n\n\n\n

<\/p>\n\n\n\n

4\u3001\u628a\u6ca1\u7528\u7684\u90a3\u6761CN\u7684\u4fe1\u606fdelete\u6389\uff0c\u7136\u540e\u518d\u6267\u884c\u4e0b\u9762\u8fd9\u6761\u8bed\u53e5<\/p>\n\n\n\n

UPDATE config_listener SET op_version = op_version + 1 WHERE data_id =’polardbx.inst.info’<\/p>\n\n\n\n

mysql> delete from server_info where id=2;<\/p>\n\n\n\n

mysql> UPDATE config_listener SET op_version = op_version + 1 WHERE data_id =’polardbx.inst.info’;<\/p>\n\n\n\n

mysql> select * from server_info;<\/p>\n\n\n\n

+—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+ | id | gmt_created | gmt_modified | inst_id | inst_type | ip | port | htap_port | mgr_port | mpp_port | status | region_id | azone_id | idc_id | cpu_core | mem_size | extras | +—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+ | 1 | 2023-03-30 11:20:50 | 2023-03-30 11:20:50 | polardb-x | 0 | 10.233.73.254 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-74824 | | 3 | 2023-03-30 11:21:25 | 2023-03-30 11:21:25 | polardb-x | 0 | 10.233.95.217 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-5x2d8 | | 4 | 2023-03-30 12:01:29 | 2023-03-30 12:01:29 | polardb-x | 0 | 10.233.100.97 | 3306 | 3606 | 3406 | 3506 | 0 | NULL | NULL | NULL | 4 | 2147483647 | polardb-x-9zk9-cn-default-fdd67b679-fmgzh | +—-+———————+———————+———–+———–+—————+——+———–+———-+———-+——–+———–+———-+——–+———-+————+——————————————-+<\/p>\n\n\n\n

<\/p>\n\n\n\n

5\u3001\u6700\u540e\u628a\u76f4\u63a5\u628a\u6709\u95ee\u9898\u7684pod\u5220\u9664\uff0c\u5c31\u6062\u590d\u6b63\u5e38\u4e86<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u6839\u672c\u539f\u56e0\uff1a\u7531\u4e8eserver_info\u91cc\u9762\u7684\u810f\u6570\u636e\u6ca1\u6709\u6e05\u9664\u5bfc\u81f4\u7684<\/p>\n","protected":false},"excerpt":{"rendered":"

\u955c\u50cf\uff1a PolarDB-X Operator\uff1a1.4.0 CDC\uff1adocker.io\/polardbx\/pol […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-747","post","type-post","status-publish","format-standard","hentry","category-mysql"],"blocksy_meta":[],"views":3096,"_links":{"self":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=747"}],"version-history":[{"count":3,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/747\/revisions"}],"predecessor-version":[{"id":752,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/747\/revisions\/752"}],"wp:attachment":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}