[ https://issues.apache.org/jira/browse/CASSANDRA-15145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16851807#comment-16851807 ]
Pradip Kumar commented on CASSANDRA-15145: ------------------------------------------ Please find my inline comments for the same. 1. you got one node with keyspace replication of one ,right ? Ans: yes 2. you insert some key into c*; Ans: yes 3. you do some load test ? what kind of operations ? Ans: insert & update operations 4. you do some select ,then occurs exception ? i guess you do operation through some srping dao ? give more details ,and does the reproduce every time ? you do this steps ? if does ,i can reproduce by myself . Ans: first bulk records inserted in transaction_dump table and then for processing we fetch the records from the same table and after process update the status in the same table transaction_dump and other tables also. > Error in Cassandra database > --------------------------- > > Key: CASSANDRA-15145 > URL: https://issues.apache.org/jira/browse/CASSANDRA-15145 > Project: Cassandra > Issue Type: Bug > Components: Legacy/Testing > Reporter: Pradip Kumar > Priority: Normal > Fix For: 3.11.x > > > 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 > > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org