3.0.3 jdbc非master节点url带上参数useServerPrepStmts=true执行insert会报错

Viewed 73

3.0.3三台fe节点

  1. jdbc连接master节点url带上useServerPrepStmts=true参数(jdbc:mysql://master:9030/db?useServerPrepStmts=true),执行insert语句是正常的

  2. jdbc连接follower节点url带上useServerPrepStmts=true参数(jdbc:mysql://follower:9030/db?useServerPrepStmts=true),执行insert语句会报错

uncategorized SQLException; SQL state [HY000]; error code [1105]; errCode = 2, detailMessage = Forward master command is not supported for prepare statement

3.0.2应该也是一样问题

1 Answers

目前是符合预期的,因为prepare是在follower做的,forward到master没有prepare好的statement