[jira] [Resolved] (CASSANDRA-6693) cqlsh fails to insert row with huge blob

["Brandon Williams (JIRA)" <ji...@apache.org>]

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

Brandon Williams resolved CASSANDRA-6693.
-----------------------------------------

    Resolution: Invalid

You're probably exceeding your thrift_framed_transport_size_in_mb setting which defaults to 15MB.  The java driver isn't using thrift, which is why it works.

> cqlsh fails to insert row with huge blob
> ----------------------------------------
>
>                 Key: CASSANDRA-6693
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6693
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Linux x64, cassandra 2.0.5 python 2.7
>            Reporter: Aleksander Stasiak
>
> cqlsh throws: 
> Traceback (most recent call last):
>   File "/usr/bin/cqlsh", line 903, in perform_statement_untraced
>     self.cursor.execute(statement, decoder=decoder)
>   File "/usr/share/cassandra/lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/cursor.py", line 80, in execute
>     response = self.get_response(prepared_q, cl)
>   File "/usr/share/cassandra/lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/thrifteries.py", line 77, in get_response
>     return self.handle_cql_execution_errors(doquery, compressed_q, compress, cl)
>   File "/usr/share/cassandra/lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/thrifteries.py", line 96, in handle_cql_execution_errors
>     return executor(*args, **kwargs)
>   File "/usr/share/cassandra/lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/cassandra/Cassandra.py", line 1830, in execute_cql3_query
>     self.send_execute_cql3_query(query, compression, consistency)
>   File "/usr/share/cassandra/lib/cql-internal-only-1.4.1.zip/cql-1.4.1/cql/cassandra/Cassandra.py", line 1841, in send_execute_cql3_query
>     self._oprot.trans.flush()
>   File "/usr/share/cassandra/lib/thrift-python-internal-only-0.9.1.zip/thrift/transport/TTransport.py", line 292, in flush
>     self.__trans.write(buf)
>   File "/usr/share/cassandra/lib/thrift-python-internal-only-0.9.1.zip/thrift/transport/TSocket.py", line 128, in write
>     plus = self.handle.send(buff)
> error: [Errno 104] Connection reset by peer
> while inserting row with blob of size ca 30M. cqlsh then disconnects and prevents from sending any other query until not restarted. 
> I haven't tested what is minimal blob size, that brakes connection. The same cql can be easily executed with java driver:
> session.execute(cql)
> of version 2.0.0-rc2



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)