You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Brandon Williams (Jira)" <ji...@apache.org> on 2020/03/17 15:23:00 UTC

[jira] [Updated] (CASSANDRA-15648) Observed "ERROR site.ycsb.db.CassandraCQLClient - Error inserting key" when run YCSB benchmark

     [ https://issues.apache.org/jira/browse/CASSANDRA-15648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams updated CASSANDRA-15648:
-----------------------------------------
    Resolution: Invalid
        Status: Resolved  (was: Triage Needed)

You should contact the YCSB community for assistance with this.

> Observed "ERROR site.ycsb.db.CassandraCQLClient - Error inserting key" when run YCSB benchmark
> ----------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-15648
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15648
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Boopalan 
>            Priority: Normal
>
> Steps to recreate:
>  
>  # Install cassandra on ubuntu 18.04.3
>  # Install YCSB 
>  # cqlsh> create keyspace ycsb
> cqlsh> create keyspace ycsb
> cqlsh:ycsb> create table usertable (
>         ... y_id varchar primary key,
>         ... field0 varchar,
>         ... field1 varchar,
>         ... field2 varchar,
>         ... field3 varchar);
>  # Run benchmarking
> root@node-master:~/ycsb-0.17.0# ./bin/ycsb load cassandra-cql -p hosts="127.0.0.1" -P workloads/workloada -s > workloada_load_res.txt
> {noformat}
> root@node-master:~/ycsb-0.17.0# ./bin/ycsb load cassandra-cql -p hosts="127.0.0.1" -P workloads/workloada -s > workloada_load_res.txt
> java -cp /root/ycsb-0.17.0/cassandra-binding/conf:/root/ycsb-0.17.0/conf:/root/ycsb-0.17.0/lib/jackson-core-asl-1.9.4.jar:/root/ycsb-0.17.0/lib/HdrHistogram-2.1.4.jar:/root/ycsb-0.17.0/lib/jackson-mapper-asl-1.9.4.jar:/root/ycsb-0.17.0/lib/slf4j-api-2.0.0-alpha1.jar:/root/ycsb-0.17.0/lib/htrace-core4-4.1.0-incubating.jar:/root/ycsb-0.17.0/lib/slf4j-simple-2.0.0-alpha1.jar:/root/ycsb-0.17.0/lib/core-0.17.0.jar:/root/ycsb-0.17.0/cassandra-binding/lib/cassandra-binding-0.17.0.jar:/root/ycsb-0.17.0/cassandra-binding/lib/cassandra-driver-core-3.0.0.jar:/root/ycsb-0.17.0/cassandra-binding/lib/netty-buffer-4.0.33.Final.jar:/root/ycsb-0.17.0/cassandra-binding/lib/guava-16.0.1.jar:/root/ycsb-0.17.0/cassandra-binding/lib/metrics-core-3.1.2.jar:/root/ycsb-0.17.0/cassandra-binding/lib/slf4j-api-1.7.25.jar:/root/ycsb-0.17.0/cassandra-binding/lib/netty-codec-4.0.33.Final.jar:/root/ycsb-0.17.0/cassandra-binding/lib/netty-common-4.0.33.Final.jar:/root/ycsb-0.17.0/cassandra-binding/lib/netty-transport-4.0.33.Final.jar:/root/ycsb-0.17.0/cassandra-binding/lib/netty-handler-4.0.33.Final.jar site.ycsb.Client -db site.ycsb.db.CassandraCQLClient -p hosts=127.0.0.1 -P workloads/workloada -s -load
> Command line: -db site.ycsb.db.CassandraCQLClient -p hosts=127.0.0.1 -P workloads/workloada -s -load
> YCSB Client 0.17.0
> Loading workload...
> Starting test.
> 2020-03-17 14:03:56:513 0 sec: 0 operations; est completion in 0 second 
> [Thread-3] INFO com.datastax.driver.core.NettyUtil - Did not find Netty's native epoll transport in the classpath, defaulting to NIO.
> [Thread-3] INFO com.datastax.driver.core.policies.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
> [Thread-3] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
> [Thread-3] INFO site.ycsb.db.CassandraCQLClient - Connected to cluster: OpenFlex Cluster
> [Thread-3] INFO site.ycsb.db.CassandraCQLClient - Datacenter: datacenter1; Host: /127.0.0.1; Rack: rack1
> DBWrapper: report latency for each error is false and specific error codes to track for latency are: []
> [Thread-3] ERROR site.ycsb.db.CassandraCQLClient - Error inserting key: user6284781860667377211
> com.datastax.driver.core.exceptions.InvalidQueryException: Undefined column name field7
> 	at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)
> 	at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
> 	at com.datastax.driver.core.AbstractSession.prepare(AbstractSession.java:110)
> 	at site.ycsb.db.CassandraCQLClient.insert(CassandraCQLClient.java:557)
> 	at site.ycsb.DBWrapper.insert(DBWrapper.java:221)
> 	at site.ycsb.workloads.CoreWorkload.doInsert(CoreWorkload.java:601)
> 	at site.ycsb.ClientThread.run(ClientThread.java:135)
> 	at java.lang.Thread.run(Thread.java:748)
> Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: Undefined column name field7
> 	at com.datastax.driver.core.Responses$Error.asException(Responses.java:136)
> 	at com.datastax.driver.core.SessionManager$4.apply(SessionManager.java:220)
> 	at com.datastax.driver.core.SessionManager$4.apply(SessionManager.java:196)
> 	at com.google.common.util.concurrent.Futures$ChainingListenableFuture.run(Futures.java:861)
> 	at com.google.common.util.concurrent.MoreExecutors$SameThreadExecutorService.execute(MoreExecutors.java:297)
> 	at com.google.common.util.concurrent.ExecutionList.executeListener(ExecutionList.java:156)
> 	at com.google.common.util.concurrent.ExecutionList.execute(ExecutionList.java:145)
> 	at com.google.common.util.concurrent.AbstractFuture.set(AbstractFuture.java:185)
> 	at com.datastax.driver.core.Connection$Future.onSet(Connection.java:1174)
> 	at com.datastax.driver.core.Connection$Future.onSet(Connection.java:1168)
> 	at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:184)
> 	at com.datastax.driver.core.RequestHandler.access$2500(RequestHandler.java:43)
> 	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:798)
> 	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:617)
> 	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1005)
> 	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:928)
> 	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
> 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318)
> 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304)
> 	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266)
> 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318)
> 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304)
> 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
> 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318)
> 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304)
> 	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:276)
> 	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:263)
> 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318)
> 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304)
> 	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846)
> 	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
> 	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> 	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> 	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> 	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> 	at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> 	... 1 more
> Error inserting, not retrying any more. number of attempts: 1Insertion Retry Limit: 0
> 2020-03-17 14:03:59:476 2 sec: 0 operations; est completion in 106751991167300 days 15 hours [CLEANUP: Count=1, Max=2242559, Min=2240512, Avg=2241536, 90=2242559, 99=2242559, 99.9=2242559, 99.99=2242559] [INSERT: Count=0, Max=0, Min=9223372036854775807, Avg=, 90=0, 99=0, 99.9=0, 99.99=0] [INSERT-FAILED: Count=1, Max=15919, Min=15912, Avg=15916, 90=15919, 99=15919, 99.9=15919, 99.99=15919]  {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org