技术宅

当前位置:首页 > 网站教程 > 其他教程

其他教程

关关采集出现200|error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connect

时间:07-26 作者:
关关采集器出现错误:200|error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred bec

关关采集器出现错误:

200|error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

200 |连接错误:超时。从池中获取连接之前经过的超时时间。这可能是因为所有池连接都在使用中,并且已达到最大池大小。

解决办法:

关关采集器 - 系统设置 - 数据库连接参数默认大概是这个样子的:

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;

添加几个参数pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;,完成后大概是这个样子的:

Data Source=localhost;Database=jieqi;User ID=root;Password=root;port=3306;charset=utf8;pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;

其中的 max pool size 尤其重要,如还有报错, 可继续加大.