多租户druid特殊配置无效

[ghuan]

线上频繁报数据库僵尸连接错误，所以打算配置test-on-borrow

经本地测试，只有主数据源才有效，切换租户之后无效

spring:
  flyway:
    validate-on-migrate: false
    baseline-on-migrate: true
    table: def_schema_history
  autoconfigure:
    exclude: org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration
  datasource:
    dynamic:
      enabled: true
      # 从这里开始(dynamic)，中间的这段配置用于 heal.database.multiTenantType == DATASOURCE 时
      p6spy: ${heal.database.p6spy:false}
      seata: ${heal.database.isSeata:false}
      primary: "0"
      datasource:
        "0":
          <<: *db-mysql
          druid:
            <<: *druid-mysql
    #        <<: *druid-oracle        
      druid:
        filters: stat,slf4j
        initial-size: 0
        min-idle: 0
        max-active: 200
        max-wait: 60000
        keep-alive: true
        pool-prepared-statements: false
        test-on-borrow: true
        test-on-return: false
        test-while-idle: true
        # 空闲连接管理
        time-between-eviction-runs-millis: 30000   # 30秒运行一次驱逐线程
        min-evictable-idle-time-millis: 600000      # 10分钟，空闲10分钟以上的连接会被移除
        max-evictable-idle-time-millis: 1800000     # 30分钟，最大空闲时间
        stat:
          slow-sql-millis: 3000
          log-slow-sql: true
        wall:
          enabled: false
          log-violation: true
          multi-statement-allow: true
 

    # 从这里结束(dynamic)，中间的这段配置用于 heal.database.multiTenantType == DATASOURCE 时
    druid:
      filters: stat,slf4j
      enable: true
      test-on-borrow: true
      test-on-return: false
      test-while-idle: true

[zuihou]

http://localhost:15500/druid/datasource.html

看监控，那个数据源生效了，都在这里写着的

[ghuan]

我debug了，其实是在这一步，用了properties的最外层的druid配置，这里线上没配置testOnBorrow <img width="1038" height="724" alt="image" src="https://github.com/user-attachments/assets/899ea135-d2d5-418d-9fd7-4bcc9d49bf4b" /> 感谢回复~ G-happy ***@***.*** 原始邮件 发件人：最后 ***@***.***&gt; 发件时间：2025年9月26日 09:24 收件人：dromara/lamp-cloud ***@***.***&gt; 抄送：Huan Gao ***@***.***&gt;, Author ***@***.***&gt; 主题：Re: [dromara/lamp-cloud] 多租户druid特殊配置无效 (Discussion #394) b7c5a4ea81fc1f54b01a5c4b7d9e89ce.png (view on web) http://localhost:15500/druid/datasource.html 看监控，那个数据源生效了，都在这里写着的 — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.