在SpringBoot程序中执行耗时的sql报连接超时的情况 (conn=304418) Communications link failure with primary host 127.0.0.1:2883. Connection timed out

OceanBase 技术问题
,
#1

在执行耗时的sql经常报这个错误
Error querying database. Cause: java.sql.SQLInvalidAuthorizationSpecException: (conn=304418) Communications link failure with primary host 127.0.0.1:2883. Connection timed out
on LoadBalanceHostAddress{weight=0, host=‘127.0.0.1’, port=2883, type=‘master’},master=true. Driver has reconnect connection

Cause: java.sql.SQLInvalidAuthorizationSpecException: (conn=304418) Communications link failure with primary host 127.0.0.1:2883. Connection timed out

on LoadBalanceHostAddress{weight=0, host=‘127.0.0.1’, port=2883, type=‘master’},master=true. Driver has reconnect connection
; (conn=304418) Communications link failure with primary host 127.0.0.1:2883. Connection timed out
on LoadBalanceHostAddress{weight=0, host=‘127.0.0.1’, port=2883, type=‘master’},master=true. Driver has reconnect connection; nested exception is java.sql.SQLInvalidAuthorizationSpecException: (conn=304418) Communications link failure with primary host 127.0.0.1:2883. Connection timed out
on LoadBalanceHostAddress{weight=0, host=‘127.0.0.1’, port=2883, type=‘master’},master=true. Driver has reconnect connection

使用数据库客户端连接工具执行sql 虽然有一点慢但是正常执行，jdbc连接参数 connection-timeout 和 socket-timeout都增到了几分钟，还是报这个错误

#3

ob的超时时间有扩容么 ob_query_timeout

#4

我在客户端连接查看这个变量是2个多小时，当前会话的也是这么长的时间
SHOW GLOBAL VARIABLES LIKE ‘ob_query_timeout’;

±-----------------±---------+
| Variable_name | Value |
±-----------------±---------+
| ob_query_timeout | 8640000000 |
±-----------------±---------+

#5

麻烦提供一份jdbc连接参数看下

#6 
dynamic:
  primary: master
  strict: true
  hikari: 
    minimum-idle: 5
    maximum-pool-size: 15
    #connection-timeout: 30000 旧配置
    connection-timeout: 120000
    socket-timeout: 300000
    auto-commit: true
    #idle-timeout: 30000 旧配置
    idle-timeout: 600000        
    max-lifetime: 1800000
    keepalive-time: 300000 
    connection-test-query: SELECT 1
  datasource:
    master:
      driver-class-name: com.oceanbase.jdbc.Driver
      url: jdbc:oceanbase:loadbalance//127.0.0.22:2883,127.0.0.23:2883,1270.0.24:2883/base?loadBalanceStrategy=RANDOM

我添加了超时时间，但是有的sql执行很快会报超时了，好像是主动断开的感觉

#7

报错的是127.0.0.1’, port=2883。
你下面连接串使用的22 23 24哪一个是本地127.1节点

#8

这个是购买的云服务器，我把地址更换了

#9

好像是购买的三台组成的集群，路由到每一台服务的时候会报过这个错误，这个sql在客户端执行 不到20s

#10

image
这里有个ip存在书写错误，是复制导致的么

#11

这个ip是我手动改的，多改了一个，正确的ip是云服务的ip地址，通过复制这个ip到nativate 是可以连接