关关采集出现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
尤其重要,如还有报错, 可继续加大.
-
上一篇
船说cms升级到 MySQL5.7+后进入MySQL后台 #1055错误的解决办法
错误原因:在MySQL5.7之后,sql_mode 默认会有 ONLY_FULL_GROUP_BYSQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错此参数 ( ONLY_FULL_GROUP_BY ) 要求select, insert,update
- 下一篇
网页/全站黑白(灰色)代码
放在页面(模板)底部如需整站黑白色,加在公共的footer模板里面即可.<script>document.getElementsByTagName('html')[0].style.filter = 'grayscale(100%)';