在滚动部署过程中, 会触发竞争选举 leader, 有密码的实例会给 zk 目录加密导致无密码的实例不可访问, 最终导致整体选举阻塞。 例如: 通过日志可以发现会抛出‐102 异常: xxxx-07-27 22:33:55.224 [DEBUG] [localhost-startStop-1-EventThread] [] [] [] - o.a. c.f.r.c.TreeCache : processResult: 在此期间先将实例全部 停止, 然后将带密码的版本全部部署上线。 10.12. 在多网卡的情况下无法获取到合适的 IP 92 11 博客 • 2020‐07 InfoQ 文章：ElasticJob 的产品定位与新版本设计理念 • 2020‐07 开源中国：GitHub 上持续冲榜，ElasticJob 重启 • 2020‐05 官微快讯：分布式调度项目 ElasticJob 即将重新起航 •

Apache ShardingSphere document Apache ShardingSphere 2024 年 07 月 10 日 Contents 1 什么是 ShardingSphere 1 1.1 介绍 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ----------------+ 9.2. ShardingSphere-Proxy 320 Apache ShardingSphere document | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------ logic table is ‘%s’, other actual table is ‘%s’. 2 00 06 4 40 00 Actual tables ‘%s’are in use. 2 00 07 4 2S 01 Index ‘%s’already exists. 2 00 08 4 2S 02 Index ‘%s’does not exist. 2 00 09 4 2S 01 View

t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_12 ├── t_order_13 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4.3. 数据分片 32 Apache ShardingSphere char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); Create indexes alter

t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_12 ├── t_order_13 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4.3. 数据分片 32 Apache ShardingSphere char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); Create indexes alter

-------+----------------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------ logic table is ‘%s’, other actual table is ‘%s’. 2 00 06 4 40 00 Actual tables ‘%s’are in use. 2 00 07 4 2S 01 Index ‘%s’already exists. 2 00 08 4 2S 02 Index ‘%s’does not exist. continues on next page char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); Create indexes alter

t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_12 ├── t_order_13 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4.3. 数据分片 32 Apache ShardingSphere char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); Create indexes alter

-------+----------------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------ char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); Create indexes alter SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = ? AND s_i_id = ? FOR UPDATE

Continuously output “Elastic job: IP:PORT has leadership” 93 Apache ShardingSphere ElasticJob document xxxx-07-27 22:33:55.224 [DEBUG] [localhost-startStop-1-EventThread] [] [] [] - o.a. c.f.r.c.TreeCache : processResult:

-------+----------------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------ char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), 11.5. 性能测试 443 Apache ShardingSphere document s_dist_09 char(24) SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = ? AND s_i_id = ? FOR UPDATE

-------+----------------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------ char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) ); 11.5. 性能测试 422 Apache SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = ? AND s_i_id = ? FOR UPDATE