[
https://issues.apache.org/jira/browse/CASSANDRA-15145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16851670#comment-16851670
]
Pradip Kumar commented on CASSANDRA-15145:
------------------------------------------
Hi Maxwell,
1- We are running Cassandra on standalone server only and there is only one
node.
2- Previously the application was running fine but at the time of Load Testing
the issue was occurred,
And even not getting the output of count the records of the big table "SELECT
COUNT (*) FROM transaction_dump;" , Table "transaction_dump" having around 2
millions records only.
But the query getting the output with limit 100000 like "SELECT * FROM
transaction_dump LIMIT 100000;"
Please Suggest for for the issue?
Regards,
Pradip
> 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: [email protected]
For additional commands, e-mail: [email protected]
