关关采集出现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错误
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 尤其重要,如还有报错, 可继续加大.

保存后重启关关即可。

 

①本站所有CMS源码、杰奇CMS模板、PTCMS源码模板、YGBOOK源码模板、帝国CMS源码模板等仅用于学习和交流,勿用于商业。
②本站资源有安装及使用文档,安装使用请自行探索,如您对购买的程序或是模板无法胜任安装工作,请点击付费安装。
③本站资源来源网络或者用户投稿,切勿私自传播于网络,否则将追究法律责任。且仅供学习交流之用,如有侵权请联系删除。
④如果资源失效或下载链接错误请联系站长。
蓝大富博客 » 关关采集出现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

发表评论