关关采集器出现错误:

 

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;min