[jira] [Created] (CASSANDRA-12880) setInt/setShort/setFlaot throwing exception from CassandraPreparedStatement
Raghavendra Pinninti created CASSANDRA-12880: Summary: setInt/setShort/setFlaot throwing exception from CassandraPreparedStatement Key: CASSANDRA-12880 URL: https://issues.apache.org/jira/browse/CASSANDRA-12880 Project: Cassandra Issue Type: Test Components: Core Environment: Cassandra JDBC Reporter: Raghavendra Pinninti Priority: Trivial Fix For: 2.1.17 Getting Exception as for ps.setInt/ps.setFloat methods Exception in thread "main" java.lang.NoSuchMethodError: org.apache.cassandra.cql.jdbc.JdbcInteger.decompose(Ljava/math/BigInteger;)Ljava/nio/ByteBuffer; at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.setShort(CassandraPreparedStatement.java:381) at com.jdbc.cassandra.CassandraJdbc.Insert(CassandraJdbc.java:63) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) How to refer internal table values in cassandra UDF
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Description: How can I refer column values in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value of the column in a table. Do I need to write a separate java code as text file to hold the values in the result set object? (was: How can I refer a column values in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value of the column in a table. Do I need to write a separate java code as text file to hold the values in the result set object?) > How to refer internal table values in cassandra UDF > --- > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer column values in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value of the column > in a table. Do I need to write a separate java code as text file to hold the > values in the result set object? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) How to refer internal table values in cassandra UDF
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Summary: How to refer internal table values in cassandra UDF (was: Cassandra udf's calling in java code) > How to refer internal table values in cassandra UDF > --- > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer a column values in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value of the column > in a table. Do I need to write a separate java code as text file to hold the > values in the result set object? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Description: How can I refer a column values in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value of the column in a table. Do I need to write a separate java code as text file to hold the values in the result set object? (was: How can I refer a column values in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value in the column family. Do I need to write a separate java code as text file to hold the values in the result set object? ) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer a column values in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value of the column > in a table. Do I need to write a separate java code as text file to hold the > values in the result set object? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Description: How can I refer a column values in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value in the column family. Do I need to write a separate java code as text file to hold the values in the result set object? was: How can I refer a column value in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value in the table > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer a column values in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value in the column > family. Do I need to write a separate java code as text file to hold the > values in the result set object? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15374472#comment-15374472 ] Raghavendra Pinninti commented on CASSANDRA-12110: -- I changed the question now. Please have a look. > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer a column value in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value in the table -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Description: How can I refer a column value in UDF's? For example Return boolean (True/False) for a given UserID provided it matches the value in the table was:I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check existed udf's and triggers in cassandra? How can I call them through datastax java driver in java code? > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > How can I refer a column value in UDF's? For example Return boolean > (True/False) for a given UserID provided it matches the value in the table -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[
https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15374464#comment-15374464
]
Raghavendra Pinninti commented on CASSANDRA-12045:
--
Thanks Tyler Hobbs :)
> Cassandra failure during write query at consistency LOCAL_QUORUM
> --
>
> Key: CASSANDRA-12045
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12045
> Project: Cassandra
> Issue Type: Bug
> Components: CQL, Local Write-Read Paths
> Environment: Eclipse java environment
>Reporter: Raghavendra Pinninti
> Fix For: 3.x
>
> Original Estimate: 12h
> Remaining Estimate: 12h
>
> While I am writing xml file into Cassandra table column I am facing following
> exception.Its a 3 node cluster and All nodes are up.
> {noformat}
> com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure
> during write query at consistency LOCAL_QUORUM (2 responses were required but
> only 0 replica responded, 1 failed) at
> com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80)
> 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:55)
> at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39)
> at DBConnection.oracle2Cassandra(DBConnection.java:267) at
> DBConnection.main(DBConnection.java:292) Caused by:
> com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure
> during write query at consistency LOCAL_QUORUM (2 responses were required but
> only 0 replica responded, 1 failed) at
> com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91)
> at com.datastax.driver.core.Responses$Error.asException(Responses.java:119)
> at
> com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180)
> at
> com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186)
> at
> com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44)
> at
> com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754)
> at
> com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576)
> {noformat}
> It would be great if someone helps me out from this situation. Thanks
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15370619#comment-15370619 ] Raghavendra Pinninti commented on CASSANDRA-12045: -- Thanks a lot Sylvain Lebresne for clear answer.. Please accept one quick doubt is as per the casssandra docs we can store upto 2 GB in text column.. while I am trying to store 20mb file it gave the above error? What is the max size of text file we can store in text column with out compressing..? > Cassandra failure during write query at consistency LOCAL_QUORUM > -- > > Key: CASSANDRA-12045 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12045 > Project: Cassandra > Issue Type: Bug > Components: CQL, Local Write-Read Paths > Environment: Eclipse java environment >Reporter: Raghavendra Pinninti > Fix For: 3.x > > Original Estimate: 12h > Remaining Estimate: 12h > > While I am writing xml file into Cassandra table column I am facing following > exception.Its a 3 node cluster and All nodes are up. > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) > 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:55) > at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) > at DBConnection.oracle2Cassandra(DBConnection.java:267) at > DBConnection.main(DBConnection.java:292) Caused by: > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) > at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) > at > com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) > at > com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) > at > com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576) > It would be great if someone helps me out from this situation. Thanks > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15356562#comment-15356562 ] Raghavendra Pinninti commented on CASSANDRA-12110: -- we can list existing functions with: DESCRIBE FUNCTIONS; and we can get the triggers from the schema table: SELECT * from system_schema.triggers; > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Priority: Minor (was: Major) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Task > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Issue Type: Test (was: Task) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Test > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti >Priority: Minor > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Labels: cassandra cqlsh java triggers udf (was: ) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Task > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Environment: Linux and java (was: linux) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Task > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12110) Cassandra udf's calling in java code
[ https://issues.apache.org/jira/browse/CASSANDRA-12110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12110: - Issue Type: Task (was: New Feature) > Cassandra udf's calling in java code > > > Key: CASSANDRA-12110 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 > Project: Cassandra > Issue Type: Task > Components: CQL > Environment: Linux and java >Reporter: Raghavendra Pinninti > Labels: cassandra, cqlsh, java, triggers, udf > Fix For: 3.0.8 > > > I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check > existed udf's and triggers in cassandra? How can I call them through datastax > java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CASSANDRA-12110) Cassandra udf's calling in java code
Raghavendra Pinninti created CASSANDRA-12110: Summary: Cassandra udf's calling in java code Key: CASSANDRA-12110 URL: https://issues.apache.org/jira/browse/CASSANDRA-12110 Project: Cassandra Issue Type: New Feature Components: CQL Environment: linux Reporter: Raghavendra Pinninti Fix For: 3.0.8 I created two udf's and one trigger in Cassandra(3.2) cqlsh.How to check existed udf's and triggers in cassandra? How can I call them through datastax java driver in java code? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15347873#comment-15347873 ] Raghavendra Pinninti commented on CASSANDRA-12045: -- I followed this link : https://support.datastax.com/hc/en-us/articles/207267063-Mutation-of-x-bytes-is-too-large-for-the-maxiumum-size-of-y- by setting commitlog_segment_size_in_mb: 64 in one node out of 3 nodes and restarted but no luck :( > Cassandra failure during write query at consistency LOCAL_QUORUM > -- > > Key: CASSANDRA-12045 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12045 > Project: Cassandra > Issue Type: Bug > Components: CQL, Local Write-Read Paths > Environment: Eclipse java environment >Reporter: Raghavendra Pinninti > Fix For: 3.x > > Original Estimate: 12h > Remaining Estimate: 12h > > While I am writing xml file into Cassandra table column I am facing following > exception.Its a 3 node cluster and All nodes are up. > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) > 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:55) > at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) > at DBConnection.oracle2Cassandra(DBConnection.java:267) at > DBConnection.main(DBConnection.java:292) Caused by: > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) > at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) > at > com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) > at > com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) > at > com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576) > It would be great if someone helps me out from this situation. Thanks > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[
https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15347846#comment-15347846
]
Raghavendra Pinninti commented on CASSANDRA-12045:
--
hey thanks again.. I am using Cassandra 3.2.1
I found the following exceptions in log
java.lang.IllegalArgumentException: Mutation of 18550552 bytes is too large for
the maxiumum size of 16777216
at org.apache.cassandra.db.commitlog.CommitLog.add(CommitLog.java:264)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:461)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:384)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Mutation.apply(Mutation.java:202)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.db.MutationVerbHandler.doVerb(MutationVerbHandler.java:54)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:64)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[na:1.8.0_71]
at
org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105)
[apache-cassandra-3.2.1.jar:3.2.1]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_71]
WARN [SharedPool-Worker-1] 2016-06-24 02:20:07,204
AbstractTracingAwareExecutorService.java:169 - Uncaught exception on thread
Thread[SharedPool-Worker-1,5,main]: {}
java.lang.IllegalArgumentException: Mutation of 18550552 bytes is too large for
the maxiumum size of 16777216
at org.apache.cassandra.db.commitlog.CommitLog.add(CommitLog.java:264)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:461)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:384)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Mutation.apply(Mutation.java:202)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.db.MutationVerbHandler.doVerb(MutationVerbHandler.java:54)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:64)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[na:1.8.0_71]
at
org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105)
[apache-cassandra-3.2.1.jar:3.2.1]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_71]
INFO [HANDSHAKE-/10.10.22.98] 2016-06-24 02:20:39,805
OutboundTcpConnection.java:503 - Handshaking version with /10.10.22.98
INFO [HANDSHAKE-/10.10.22.99] 2016-06-24 02:20:39,805
OutboundTcpConnection.java:503 - Handshaking version with /10.10.22.99
ERROR [SharedPool-Worker-2] 2016-06-24 02:20:39,806 StorageProxy.java:1282 -
Failed to apply mutation locally : {}
java.lang.IllegalArgumentException: Mutation of 18550554 bytes is too large for
the maxiumum size of 16777216
at org.apache.cassandra.db.commitlog.CommitLog.add(CommitLog.java:264)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:461)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:384)
~[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.db.Mutation.apply(Mutation.java:202)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.service.StorageProxy$7.runMayThrow(StorageProxy.java:1276)
~[apache-cassandra-3.2.1.jar:3.2.1]
at
org.apache.cassandra.service.StorageProxy$LocalMutationRunnable.run(StorageProxy.java:2433)
[apache-cassandra-3.2.1.jar:3.2.1]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[na:1.8.0_71]
at
org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164)
[apache-cassandra-3.2.1.jar:3.2.1]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105)
[apache-cassandra-3.2.1.jar:3.2.1]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_71]
> Cassandra failure during write query at consistency LOCAL_QUORUM
> --
>
> Key: CASSANDRA-12045
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12045
> Project: Cassandra
> Issue Type: Bug
>
[jira] [Commented] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15343723#comment-15343723 ] Raghavendra Pinninti commented on CASSANDRA-12045: -- Hi Hobbs, Thanks much for the response. I am loading a xmlfile of size 20 mb into text column of Cassandra table through Cassandra JDBC driver. I didn't find any logs in Cassandra installation log directory. > Cassandra failure during write query at consistency LOCAL_QUORUM > -- > > Key: CASSANDRA-12045 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12045 > Project: Cassandra > Issue Type: Bug > Components: CQL, Local Write-Read Paths > Environment: Eclipse java environment >Reporter: Raghavendra Pinninti > Fix For: 3.x > > Original Estimate: 12h > Remaining Estimate: 12h > > While I am writing xml file into Cassandra table column I am facing following > exception.Its a 3 node cluster and All nodes are up. > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) > 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:55) > at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) > at DBConnection.oracle2Cassandra(DBConnection.java:267) at > DBConnection.main(DBConnection.java:292) Caused by: > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure > during write query at consistency LOCAL_QUORUM (2 responses were required but > only 0 replica responded, 1 failed) at > com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) > at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) > at > com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) > at > com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) > at > com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576) > It would be great if someone helps me out from this situation. Thanks > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
[ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghavendra Pinninti updated CASSANDRA-12045: - Description: While I am writing xml file into Cassandra table column I am facing following exception.Its a 3 node cluster and All nodes are up. com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) 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:55) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) at DBConnection.oracle2Cassandra(DBConnection.java:267) at DBConnection.main(DBConnection.java:292) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) at com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576) It would be great if someone helps me out from this situation. Thanks was: While I am writing large column into Cassandra table I am facing following exception.Even All nodes are up. com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) 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:55) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) at DBConnection.oracle2Cassandra(DBConnection.java:267) at DBConnection.main(DBConnection.java:292) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1008) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:931) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) at com.datastax.shaded.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at java.lang.Thread.run(Unknown Source) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write
[jira] [Created] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM
Raghavendra Pinninti created CASSANDRA-12045: Summary: Cassandra failure during write query at consistency LOCAL_QUORUM Key: CASSANDRA-12045 URL: https://issues.apache.org/jira/browse/CASSANDRA-12045 Project: Cassandra Issue Type: Bug Components: CQL, Local Write-Read Paths Environment: Eclipse java environment Reporter: Raghavendra Pinninti Fix For: 3.x While I am writing large column into Cassandra table I am facing following exception.Even All nodes are up. com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) 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:55) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) at DBConnection.oracle2Cassandra(DBConnection.java:267) at DBConnection.main(DBConnection.java:292) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1008) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:931) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at com.datastax.shaded.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at com.datastax.shaded.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) at com.datastax.shaded.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at java.lang.Thread.run(Unknown Source) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 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:40)c at com.datastax.driver.core.Message$ProtocolDecoder.decode(Message.java:243) at com.datastax.driver.core.Message$ProtocolDecoder.decode(Message.java:225) at com.datastax.shaded.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) ... 13 more Would someone please help me out from this situation -- This message was sent by Atlassian JIRA (v6.3.4#6332)
