关关采集出现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

关关采集器出现错误:

关关采集出现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
关关采集出现200错误
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=gbk;

添加几个参数;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=gbk;pooling=true;min pool size=5;max pool size=1024;connect timeout = 20;

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

保存后重启关关即可。

 

版权申明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。
蓝大富博客 » 关关采集出现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

发表回复