快捷導(dǎo)航

redis中Could not get a resource from the pool異常及解決方案

更新時(shí)間：2022年12月12日 09:45:00 作者：yujkss

這篇文章主要介紹了redis中Could not get a resource from the pool異常及解決方案，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教

描述

這個(gè)錯(cuò)誤產(chǎn)生的前提是這樣的，將數(shù)據(jù)存入redis（新安裝的）中，在通過(guò)連接池獲取jedis實(shí)例時(shí)，產(chǎn)生如下錯(cuò)誤（ Could not get a resource from the pool）。

分析

由于是新安裝的redis，配置文件沒(méi)有更改，低級(jí)的錯(cuò)誤浪費(fèi)不少時(shí)間，寫一篇文章，讓同樣犯這種錯(cuò)誤的朋友別再浪費(fèi)時(shí)間。

解決

更改配置文件 redis.conf 中兩處

1.將 bind 127.0.0.1 注釋掉

2.將 protected-mode 改為 no

bind 127.0.0.1	protected-mode
默認(rèn)情況bind=127.0.0.1只能接受本機(jī)的訪問(wèn)請(qǐng)求不寫的情況下，無(wú)限制接受任何ip地址的訪問(wèn)	如果開啟了protected-mode，那么在沒(méi)有設(shè)定bind ip且沒(méi)有設(shè)密碼的情況下，Redis只允許接受本機(jī)的相應(yīng)

運(yùn)行代碼

//創(chuàng)建jedis配置文件對(duì)象
val jedisPoolConfig = new JedisPoolConfig()
//添加配置信息
jedisPoolConfig.setMaxTotal(100)
jedisPoolConfig.setMaxIdle(20)
jedisPoolConfig.setMinIdle(0)
jedisPoolConfig.setBlockWhenExhausted(true)
jedisPoolConfig.setMaxWaitMillis(500)
jedisPoolConfig.setTestOnBorrow(true)
//創(chuàng)建連接池對(duì)象
var jedisPool：JedisPool = new JedisPool(jedisPoolConfig,"linux1",6379)
//獲取實(shí)例
jedisPool.getResource

報(bào)錯(cuò)內(nèi)容

ERROR --- [ Executor task launch worker for task 15] org.apache.spark.executor.Executor (line: 91) : Exception in task 7.0 in stage 2.0 (TID 15)
redis.clients.jedis.exceptions.JedisConnectionException: Could not get a resource from the pool
   at redis.clients.util.Pool.getResource(Pool.java:53)
   at redis.clients.jedis.JedisPool.getResource(JedisPool.java:226)
   at com.atguigu.bigdata.sparkmall.common.RedisUtil$.getJedisClient(RedisUtil.scala:26)
   at com.atguigu.bigdata.sparkmall.realtime.Req7TimeAdvertClickTrendApplication$$anonfun$main$1$$anonfun$apply$2.apply(Req7TimeAdvertClickTrendApplication.scala:54)
   at com.atguigu.bigdata.sparkmall.realtime.Req7TimeAdvertClickTrendApplication$$anonfun$main$1$$anonfun$apply$2.apply(Req7TimeAdvertClickTrendApplication.scala:53)
   at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926)
   at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:926)
   at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951)
   at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1951)
   at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
   at org.apache.spark.scheduler.Task.run(Task.scala:99)
   at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   at java.lang.Thread.run(Thread.java:748)
Caused by: redis.clients.jedis.exceptions.JedisConnectionException: java.net.ConnectException: Connection refused: connect
   at redis.clients.jedis.Connection.connect(Connection.java:207)
   at redis.clients.jedis.BinaryClient.connect(BinaryClient.java:93)
   at redis.clients.jedis.BinaryJedis.connect(BinaryJedis.java:1767)
   at redis.clients.jedis.JedisFactory.makeObject(JedisFactory.java:106)
   at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:868)
   at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)
   at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)
   at redis.clients.util.Pool.getResource(Pool.java:49)
   ... 14 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:589)
   at redis.clients.jedis.Connection.connect(Connection.java:184)
   ... 21 more