一、日志报错

11月21号下午4点20左右查看43.148的weblogic 日志报如下错误，

16:20 weblogic报如下错误，16：20-17:05一直报，无其他报错。

####<2023-11-21 下午04 时20 分27 秒 CST> <Info> <Common> <bssapp5> <ctcrmServer> <[ACTIVE] ExecuteThread: '102' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1385022027125> <BEA-000627> <Reached maximum capacity of pool "JDBC Data Source-ctcrm", making "0" new resource instances instead of "1".>

在查看连接业务数据库时当时有大量的43.148发过来的连接，

如下：

lsqldev.exe)(HOST=PC-201203121625)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.47)(PORT=2682)) * establish * bsscrm * 0

21-NOV-2023 16:17:39 * service_update * bsscrm1 * 0

21-NOV-2023 16:17:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=jcfapp))(SERVICE_NAME=bsscrm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.148)

(PORT=51936)) * establish * bsscrm * 0

21-NOV-2023 16:17:42 * service_update * bsscrm1 * 0

21-NOV-2023 16:17:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(FAILOVER_MODE=(TYPE=select)(METHOD=basic))(SERVICE_NAME=bsscrm)) * (ADDRE

SS=(PROTOCOL=tcp)(HOST=137.64.25.216)(PORT=38928)) * establish * bsscrm * 0

21-NOV-2023 16:17:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=jcfapp))(SERVICE_NAME=bsscrm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.148)

(PORT=51938)) * establish * bsscrm * 0

21-NOV-2023 16:17:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=jcfapp))(SERVICE_NAME=bsscrm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.148)

(PORT=51939)) * establish * bsscrm * 0

21-NOV-2023 16:17:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(FAILOVER_MODE=(TYPE=select)(METHOD=basic))(SERVICE_NAME=bsscrm)) * (ADDRE

SS=(PROTOCOL=tcp)(HOST=137.64.25.216)(PORT=37752)) * establish * bsscrm * 0

21-NOV-2023 16:17:57 * service_update * bsscrm1 * 0

21-NOV-2023 16:18:02 * (CONNECT_DATA=(SID=bsscrm1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.165)(PORT=41797))

* establish * bsscrm1 * 0

21-NOV-2023 16:18:02 * (CONNECT_DATA=(SID=bsscrm1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.165)(PORT=41798))

* establish * bsscrm1 * 0

21-NOV-2023 16:18:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(FAILOVER_MODE=(TYPE=select)(METHOD=basic))(SERVICE_NAME=bsscrm)) * (ADDRE

SS=(PROTOCOL=tcp)(HOST=137.64.25.216)(PORT=34383)) * establish * bsscrm * 0

21-NOV-2023 16:18:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=jcfapp))(SERVICE_NAME=bsscrm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=137.64.43.148)

(PORT=51942)) * establish * bsscrm * 0

二、原因分析

从上边的中间件报错和crm连接情况初步分析如下：

由于应用大量的请求连接，导致中间的连接池资源被占满，其他应用在请求时，无法申请资源导致weblogic报Reached maximum capacity of pool "JDBC Data Source-ctcrm"错误。

三、处理办法：

1.     尽量释放不活动的会话。（修改weblogic参数非活动连接超时:）

2.     会话完成尽快colse。