Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15145

Error in Cassandra database

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Triage Needed
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: 3.11.x
    • Component/s: Legacy/Testing
    • Labels:
      None
    • Bug Category:
      Correctness - Test Failure
    • Severity:
      Normal
    • Complexity:
      Challenging
    • Discovered By:
      Performance Regression Test
    • Platform:
      Linux
    • Impacts:
      Clients
    • Since Version:

      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- +91 9873902729

       

       

       

       

        Attachments

          Activity

            People

              Dates

              • Created:
                Updated:

                Issue deployment