redis之org.springframework.data.redis.RedisSystemException: Error in execution

合集 - 报错(63)

1.MySQL 8.0 java.sql.SQLException Unknown system variable 'query_cache_size'2021-06-092.yarn : 无法将“yarn”项识别为 cmdlet、函数、脚本文件或可运行程序的名称2022-03-133.idea中文乱码解决四种方法2024-01-194.elasticsearch安装问题记录2022-04-175.Swagger之Failed to start bean ‘documentationPluginsBootstrapper‘； nested exception is java.lang2022-03-096.switchHosts应用时，没有写入 Hosts 文件的权限2022-01-247.IDEA 控制台中文乱码2024-01-198.java.lang.IllegalArgumentException: Base64-encoded key bytes may only be specified for HMAC2023-12-289.git之kex_exchange_identification: Connection closed by remote host2023-12-1410.Oracle之ORA-29275: 部分多字节字符2023-12-0211.maven之‘settings.xml‘ has syntax errors2023-12-0212.vue项目本地映射到外网访问时出现 Invalid Host header2023-11-1913.vue之Error: Unknown option: .devServer.2023-11-1914.Nacos之Injection of @DubboReference dependencies is failed；2023-11-15

15.redis之org.springframework.data.redis.RedisSystemException: Error in execution2023-11-13

16.reduce the indexing time and cpu load with pre-build jdk shared indexes2023-09-2317.docker安装xxl-job连接数据库时显示无法连接问题2023-09-1118.解决时间戳问题2023-06-0519.使用 mysql 统计日期范围的数据条数2023-06-0420.error An unexpected error occurred: https://registry.npmmirror.com2023-06-0221.Visual Studio 2022 2022 不支持 .NET Framework 4.0项目解决办法2023-05-2722.webpack的使用2023-05-2723.node.js运行项目时提示digital envelope routines::unsupported2023-05-2724.Typora图片路径问题之相对路径前没有点斜杠2023-03-1125.Personal access tokens (classic)与Fine-grained personal access tokens Beta区别2023-02-1626.GitHub Action: The process ‘/usr/bin/git‘ failed with exit code 128 解决方案2023-02-1627.Android Studio 中模拟器无法打开，提示Error launching emulator2022-11-0228.AndroidStudio中Android模拟器没网解决办法2022-11-0229.C#中System.ArgumentOutOfRangeException:“提供的行索引超出范围。2022-09-0930.VisualStudio运行程序，点击应用程序时，弹出多个个窗体问题2022-09-0931.C#中无法将文件“obj\x86\Debug\xxx.exe”复制到“bin\Debug\xxx.exe”。文件“bin\Debug\xxx.exe”正由另一进程使用，因此该进程无法访问此文件.2022-09-0932.ssm之Error creating bean with name ‘bookServiceImpl‘: Injection of resource dependencies failed；2022-08-0833.Node.js之npm ERR code EPERM npm ERR syscall open npm ERR2022-05-3134.Cookie报错: An invalid character [32] was present in the Cookie value2022-05-3135.Android之Installed Build Tools revision 32.0.0 is corrupted.2022-05-0336.安装node.js需要注意的问题2022-04-1737.RabbitMQ-错误：Failed to download metadata for repo ‘base‘: Cannot download repomd.xml2022-04-1738.centos8.2安装rabbitMQ遇到的问题2022-04-1739.‘Starting Tomcat v8.5 Server at localhost‘ has encountered a problem.2022-04-0240.Eclipse运行报Could not launch external web browser for ..2022-03-2641.docker之Error response from daemon: driver failed programming external connectivity on endpoint2022-03-1742.VisualStudioCode终端出现-＞在此系统上禁止运行脚本2022-03-1243.java.lang.IllegalStateException: Failed to register dubbo://139.224.33.130:208812022-02-2544.springCloud之Cloud not autowire.No beans of ‘‘ type found2022-02-2245.springCloud之This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver‘.2022-02-2246.Spring Cloud Config 客户端报错：No spring.config.import property has been defined2022-02-2247.rg.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name2022-01-2648.org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘‘2022-01-2649.SpringBoot之Invalid bound statement (not found): com.nxg.mapper.UserMapper.selectUserByPage2022-01-1250.SpringBoot之Failed to load ApplicationContext2022-01-1051.Maven之导入thymeleaf依赖飘红问题2022-01-0952.SpringBoot之Establishing SSL connection without server‘s identity verification is not recommended.2022-01-0953.SpringBoot之 Failed to load ApplicationContext2022-01-0954.Eclipse报错-Description Resource Path Location Type Unbound classpath container: ‘JRE System Library2021-10-1855.sqlServer2019附加出现的问题整理2021-09-2356.ssm中的中Failed to load resource: the server responded with a status of 404 ()2021-08-3157.Maven之IDEA创建XML Configuration File时没有Spring Config的选项2021-08-0458.MVC之Error:java: 不再支持源选项 5。请使用 6 或更高版本。2021-08-0459.Maven之Failed to execute goal org.apache.maven.plugins:maven-install-plugin:2.4:install (default-cli)2021-07-2660.在安装Maven检查版本时出现Please set the JAVA_HOME variable in your environment to match the locat2021-07-2561.在linux下 wget 下载报错 http request sent,awaiting response... 404 not found2021-07-2462.异常之java.lang.nullpointerexception 怎么解决及出现原因？2021-07-1663.JavaWeb之MVC---数据库连接问题2021-06-10

收起

背景

在运行某系统时，在测试类向redis中存入某值，然后取出。

一、遇到的问题

报错：

org.springframework.data.redis.RedisSystemException: Error in execution; nested exception is io.lettuce.core.RedisCommandExecutionException: MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error.
	at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:54)
	at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:52)

原因：

因为强制把redis快照关闭了导致不能持久化的问题，通过stop-writes-on-bgsave-error值设置为no即可避免这种问题。

二、解决方法

方法1：命令行方式

通过远程连接redis，然后使用命令行工具进行配置

 config set stop-writes-on-bgsave-error no

方法2：修改redis.conf文件

vim打开redis-server配置的redis.conf文件，然后使用快捷匹配模式：/stop-writes-on-bgsave-error定位到stop-writes-on-bgsave-error字符串所在位置，接着把后面的yes设置为no即可。

使用docker安装的redis也是类似的。

效果如下：

附件

详细报错：

org.springframework.data.redis.RedisSystemException: Error in execution; nested exception is io.lettuce.core.RedisCommandExecutionException: MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error.
	at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:54)
	at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:52)
	at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:41)
	at org.springframework.data.redis.PassThroughExceptionTranslationStrategy.translate(PassThroughExceptionTranslationStrategy.java:44)
	at org.springframework.data.redis.FallbackExceptionTranslationStrategy.translate(FallbackExceptionTranslationStrategy.java:42)
	at org.springframework.data.redis.connection.lettuce.LettuceConnection.convertLettuceAccessException(LettuceConnection.java:272)
	at org.springframework.data.redis.connection.lettuce.LettuceConnection.await(LettuceConnection.java:1063)
	at org.springframework.data.redis.connection.lettuce.LettuceConnection.lambda$doInvoke$4(LettuceConnection.java:920)
	at org.springframework.data.redis.connection.lettuce.LettuceInvoker$Synchronizer.invoke(LettuceInvoker.java:673)
	at org.springframework.data.redis.connection.lettuce.LettuceInvoker$DefaultSingleInvocationSpec.get(LettuceInvoker.java:589)
	at org.springframework.data.redis.connection.lettuce.LettuceStringCommands.set(LettuceStringCommands.java:123)
	at org.springframework.data.redis.connection.DefaultedRedisConnection.set(DefaultedRedisConnection.java:313)
	at org.springframework.data.redis.core.DefaultValueOperations$7.inRedis(DefaultValueOperations.java:309)
	at org.springframework.data.redis.core.AbstractOperations$ValueDeserializingRedisCallback.doInRedis(AbstractOperations.java:61)
	at org.springframework.data.redis.core.RedisTemplate.execute(RedisTemplate.java:223)
	at org.springframework.data.redis.core.RedisTemplate.execute(RedisTemplate.java:190)
	at org.springframework.data.redis.core.AbstractOperations.execute(AbstractOperations.java:97)
	at org.springframework.data.redis.core.DefaultValueOperations.set(DefaultValueOperations.java:305)
	at com.nxg.lottery.infrastructure.util.RedisUtil.set(RedisUtil.java:113)
	at com.nxg.lottery.test.infrastructure.RedisUtilTest.test_set(RedisUtilTest.java:31)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
	at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
	at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
	at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: io.lettuce.core.RedisCommandExecutionException: MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error.
	at io.lettuce.core.internal.ExceptionFactory.createExecutionException(ExceptionFactory.java:137)
	at io.lettuce.core.internal.ExceptionFactory.createExecutionException(ExceptionFactory.java:110)
	at io.lettuce.core.protocol.AsyncCommand.completeResult(AsyncCommand.java:120)
	at io.lettuce.core.protocol.AsyncCommand.complete(AsyncCommand.java:111)
	at io.lettuce.core.protocol.CommandHandler.complete(CommandHandler.java:746)
	at io.lettuce.core.protocol.CommandHandler.decode(CommandHandler.java:681)
	at io.lettuce.core.protocol.CommandHandler.channelRead(CommandHandler.java:598)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:748)