hecao100
hecao100
Modify the method of establishing SSL encrypted communication
` insert into ${tableName} USING bike_rec TAGS (#{list[0].a0}) values ( #{item.ts}, #{item.a1}, #{item.a2}, #{item.a3}, #{item.a4}, #{item.a5}, #{item.a6}, #{item.a7}, #{item.a8}, #{item.a9}, #{item.a10}, #{item.a11}, #{item.a12}, #{item.a13}, #{item.a14}, #{item.a15}, #{item.a16}, #{item.a17}, #{item.a18}, #{item.a19},...
这个是我们的配置参数，按照这个参数还是无法获得监控数据 numOfThreadsPerCore 2 numOfCommitThreads 40 ratioOfQueryCores 2 keepColumnName 1 numOfMnodes 3 balance 0 offlineThreshold 86400 maxVgroupsPerDb 30 blocks 60 quorum 2 wallevel 1 maxSQLLength 1048576 timezone Asia/Shanghai(CST, +0800) locale enUS.UTF-8...
1433 root 20 0 9003392 6.0g 1872 R 25.1 81.6 177:08.94 vnode-stream 1434 root 20 0 9003392 6.0g 1872 R 25.0 81.6 181:23.87 vnode-stream 1350 root 20 0 9003392 6.0g...
 
11/09 10:30:01.699822 00020987 VND ERROR vgId:8, msg:0x7fe8a80062f0 failed to process since restore not finished, gtid:0xdb7514391542fa4e:0x764405a3915db643 11/09 10:30:01.703617 00020987 VND ERROR vgId:8, msg:0x7fe8a80062f0 failed to propose since Database not ready, code:0x80000014,...
我升级了3.0.1.5版本到3.0.1.6版本，第三个节点（原启动失败的节点），还是无法启动，错误日志如下 11/10 14:02:24.629497 00010534 WAL ERROR vgId:6, WAL log entries incomplete in range [4105563, 4106043], aligned with snaphotVer:4105562 11/10 14:02:24.630383 00010534 WAL ERROR vgId:6, cannot open wal since repair meta...
3015-3016 没有遇到过这个问题，升级到 3017 后，连接会偶发性的报错： java.sql.SQLTransientConnectionException: iot - Connection is not available, request timed out after 30000ms.导致数据写入失败。 JNI 内网连接并发 50 左右，jdbc驱动版本 3012 ，客户端和服务端均已升级到 3.0.1.7 。
使用的是hikari连接池，通过mybatis，使用jdbc驱动写入数据 hikari: maximumPoolSize: 100 minimumIdle: 10 idleTimeout: 600000 connectionTimeout: 30000 maxLifetime: 1800000
批量写入的代码如下 ` insert into ${tableName} USING bike_rec TAGS (#{list[0].a0}) values ( #{item.ts}, #{item.a1}, #{item.a2}, #{item.a3}, #{item.a4}, #{item.a5}, #{item.a6}, #{item.a7}, #{item.a8}, #{item.a9}, #{item.a10}, #{item.a11}, #{item.a12}, #{item.a13}, #{item.a14}, #{item.a15}, #{item.a16}, #{item.a17}, #{item.a18},...