Spring Cloud Alibaba这个报错,是有20个链接,都在执行着同一个SQL吗?
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 120000, active 20, maxActive 20, creating 0, runningSqlCount 20 : SELECT h.po_id
FROM pur_purorder_head h
LEFT JOIN pur_purorder_headz h2 ON h2.po_id = h.po_id
INNER JOIN pur_purorder_item i
ON i.po_id = h.po_id
AND h.document_type = ?
LEFT JOIN pur_purorder_itemz i2 ON i2.po_id = h.po_id
LEFT JOIN pur_request_headz rh ON rh.pr_id = h2.pr_id
LEFT JOIN pur_purorder_add a ON a.po_id = h.po_id
LEFT JOIN pur_bidresult_head bh ON i2.bid_win_id = bh.bid_win_id
LEFT JOIN pur_purorder_text t ON h.po_id = t.po_id
WHERE h.CREATETIME >= ?
AND h.CREATETIME <= ?
AND h.company_id IN (?)
AND (locate(?, i.delete_flag) = ?
OR i.delete_flag IS NULL)
GROUP BY h.poid
ORDER BY h.ID DESC
LIMIT ?
数据库连接池被占满了,拿不到连接,不是都在执行同一个sql的意思。此回答整理自钉群“群5 Spring Cloud Alibaba”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。