国内外VPS
主机测评与优惠

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

关关采集器出现错误:

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

赞(0)
未经允许不得转载:知网部落 » 关关采集出现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
分享到: 更多 (0)

评论 抢沙发

评论前必须登录!

 

'); })();