[CASSANDRA-15145] Error in Cassandra database

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Fix Version/s: 3.11.12
• Component/s: Legacy/Testing
• Severity: Normal
• Complexity: Challenging
• Discovered By: Performance Regression Test
• Platform: Linux
• Impacts: Clients
• Since Version: 3.11.3
• Assignee: Unassigned
• Reporter: Pradip Kumar
• Created: 30/May/19 06:02
• Updated: 17/Feb/22 08:13
• Resolved: 29/Sep/21 17:29

Description

Dear Team,

We are facing the problem in the Cassandra database and below the error message and after this error application stopped working.

Please suggest why this issue occurred and what I have to do for resolving the issue?

 Cassandra:- [cqlsh 5.0.1 | Cassandra 3.11.3 | CQL spec 3.4.4 | Native protocol v4]

 

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

2019-05-29 13:58:47.673  INFO 2003 — [ryBean_Worker-1] com.estel.common.MoneyMarkingJob         : Job for Leger Management is  strated at  2019-05-30T00:58:47.671Z time zone

org.springframework.dao.DataAccessResourceFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed); nested exception is com.datastax.driver.core.exceptions.ReadFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)

        at org.springframework.cassandra.support.CassandraExceptionTranslator.translateExceptionIfPossible(CassandraExceptionTranslator.java:163)

        at org.springframework.cassandra.core.CqlTemplate.potentiallyConvertRuntimeException(CqlTemplate.java:946)

        at org.springframework.cassandra.core.CqlTemplate.translateExceptionIfPossible(CqlTemplate.java:930)

        at org.springframework.cassandra.core.CqlTemplate.translateExceptionIfPossible(CqlTemplate.java:912)

        at org.springframework.cassandra.core.CqlTemplate.doExecute(CqlTemplate.java:278)

        at org.springframework.cassandra.core.CqlTemplate.doExecuteQueryReturnResultSet(CqlTemplate.java:283)

        at org.springframework.data.cassandra.core.CassandraTemplate.select(CassandraTemplate.java:594)

        at org.springframework.data.cassandra.core.CassandraTemplate.select(CassandraTemplate.java:376)

        at org.springframework.data.cassandra.repository.query.CassandraQueryExecution$CollectionExecution.execute(CassandraQueryExecution.java:85)

        at org.springframework.data.cassandra.repository.query.CassandraQueryExecution$ResultProcessingExecution.execute(CassandraQueryExecution.java:143)

        at org.springframework.data.cassandra.repository.query.AbstractCassandraQuery.execute(AbstractCassandraQuery.java:113)

        at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483)

        at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

        at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

        at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)

        at com.sun.proxy.$Proxy66.findTransactionByDatenadStatus(Unknown Source)

        at com.estel.common.service.impl.TransactionServiceImpl.fingTransactionByDateAndStatus(TransactionServiceImpl.java:47)

        at com.estel.common.MoneyMarkingJob.execute(MoneyMarkingJob.java:101)

        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

Caused by: com.datastax.driver.core.exceptions.ReadFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)

        at com.datastax.driver.core.exceptions.ReadFailureException.copy(ReadFailureException.java:85)

        at com.datastax.driver.core.exceptions.ReadFailureException.copy(ReadFailureException.java:27)

        at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)

        at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245)

        at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:68)

        at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:43)

        at org.springframework.cassandra.core.CqlTemplate$3.doInSession(CqlTemplate.java:286)

        at org.springframework.cassandra.core.CqlTemplate$3.doInSession(CqlTemplate.java:283)

        at org.springframework.cassandra.core.CqlTemplate.doExecute(CqlTemplate.java:276)

        ... 21 more

Caused by: com.datastax.driver.core.exceptions.ReadFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)

        at com.datastax.driver.core.exceptions.ReadFailureException.copy(ReadFailureException.java:95)

        at com.datastax.driver.core.Responses$Error.asException(Responses.java:128)

        at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:179)

        at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:177)

        at com.datastax.driver.core.RequestHandler.access$2500(RequestHandler.java:46)

        at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:799)

        at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:633)

        at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1070)

        at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:993)

        at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321)

        at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321)

        at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321)

        at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:293)

        at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:267)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321)

        at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1280)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328)

        at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:890)

        at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

        at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:564)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:505)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:419)

        at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:391)

        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)

        at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:145)

        at java.lang.Thread.run(Thread.java:748)

Caused by: com.datastax.driver.core.exceptions.ReadFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)

        at com.datastax.driver.core.Responses$Error$1.decode(Responses.java:76)

        at com.datastax.driver.core.Responses$Error$1.decode(Responses.java:37)

        at com.datastax.driver.core.Message$ProtocolDecoder.decode(Message.java:289)

        at com.datastax.driver.core.Message$ProtocolDecoder.decode(Message.java:269)

        at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88)

        ... 20 more

2019-05-29 13:58:47.802  INFO 2003 — [ryBean_Worker-1] com.estel.common.MoneyMarkingJob         : Transaction Dump is updated  in case of WALLETTOPUP process status!.Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed); nested exception is com.datastax.driver.core.exceptions.ReadFailureException: Cassandra failure during read query at consistency LOCAL_ONE (1 responses were required but only 0 replica responded, 1 failed)

 

 

Regards,

Pradip

Mobile- [phone]