[jira] [Commented] (CASSANDRA-4527) Issue with CQL and ALTER TABLE DROP
[ https://issues.apache.org/jira/browse/CASSANDRA-4527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438591#comment-13438591 ] Victor Penela commented on CASSANDRA-4527: -- Sorry, there was an issue with Jira and it seems that it did post the issue even though it gave me an error :/ Thanks! > Issue with CQL and ALTER TABLE DROP > --- > > Key: CASSANDRA-4527 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4527 > Project: Cassandra > Issue Type: Bug > Components: Core >Affects Versions: 1.1.2 > Environment: Ubuntu 12.04 > java version "1.6.0_33" > Java(TM) SE Runtime Environment (build 1.6.0_33-b04) > Java HotSpot(TM) 64-Bit Server VM (build 20.8-b03, mixed mode) >Reporter: Victor Penela > Labels: cql > > Creating a CF in cqlsh -3 > CREATE COLUMNFAMILY ads_config (c_id uuid, ct_id uuid, pt_id uuid, c_type > int, creat blob, start timestamp, end timestamp, total int, pending int, > PRIMARY KEY ( campaign_id, creat_id, placement_id)); > INSERT INTO works fine. SELECT * works fine. > ALTER TABLE ads_config add cost int; > SELECT * works fine, new field is null. > ALTER TABLE ads_config drop cost; > Gives a: > TSocket read 0 bytes > After that the connection seems to die, giving me the same error a couple of > times and then a broken pipe: > Traceback (most recent call last): > File "/usr/bin/cqlsh", line 1008, in perform_statement > self.cursor.execute(statement, decoder=decoder) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 117, in execute > response = self.handle_cql_execution_errors(doquery, prepared_q, compress) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 132, in handle_cql_execution_errors > return executor(*args, **kwargs) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1583, in execute_cql_query > self.send_execute_cql_query(query, compression) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1593, in send_execute_cql_query > self._oprot.trans.flush() > File > "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TTransport.py", > line 293, in flush > self.__trans.write(buf) > File > "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TSocket.py", > line 117, in write > plus = self.handle.send(buff) > error: [Errno 32] Broken pipe > Closing and reopening cql works fine. The column key exists and can't be > dropped. > Error log: > INFO 12:08:40,632 Enqueuing flush of > Memtable-schema_columnfamilies@445620464(1428/1785 serialized/live bytes, 20 > ops) > INFO 12:08:40,633 Writing Memtable-schema_columnfamilies@445620464(1428/1785 > serialized/live bytes, 20 ops) > INFO 12:08:40,696 Completed flushing > /var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-4-Data.db > (1487 bytes) for commitlog position > ReplayPosition(segmentId=180414134565599, position=11928) > INFO 12:08:40,697 Enqueuing flush of > Memtable-schema_columns@1158801519(222/277 serialized/live bytes, 4 ops) > INFO 12:08:40,697 Writing Memtable-schema_columns@1158801519(222/277 > serialized/live bytes, 4 ops) > INFO 12:08:40,704 Compacting > [SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-1-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-3-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-2-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-4-Data.db')] > INFO 12:08:40,731 Completed flushing > /var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-4-Data.db > (273 bytes) for commitlog position ReplayPosition(segmentId=180414134565599, > position=11928) > INFO 12:08:40,761 Compacted to > [/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-5-Data.db,]. > 5,892 to 2,855 (~48% of original) bytes for 1 keys at 0.050421MB/s. Time: > 54ms. > ERROR 12:08:40,780 Exception in thread Thread[MigrationStage:1,5,main] > java.lang.NullPointerException > at > org.apache.cassandra.utils.ByteBufferUtil.string(ByteBufferUtil.java:167) > at > org.apache.cassandra.utils.ByteBufferUtil.string(ByteBufferUtil.java:124) > at org.apache.cassandra.cql.jdbc.JdbcUTF8.getString(JdbcUTF8.java:77) > at org.apache.cassandra.cql.jdbc.JdbcUTF8.compose(JdbcUTF8.java:97) > at org.apache.ca
[jira] [Commented] (CASSANDRA-4527) Issue with CQL and ALTER TABLE DROP
[ https://issues.apache.org/jira/browse/CASSANDRA-4527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438580#comment-13438580 ] Marcos Dione commented on CASSANDRA-4527: - this is a dupe of CASSANDRA-4526 > Issue with CQL and ALTER TABLE DROP > --- > > Key: CASSANDRA-4527 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4527 > Project: Cassandra > Issue Type: Bug > Components: Core >Affects Versions: 1.1.2 > Environment: Ubuntu 12.04 > java version "1.6.0_33" > Java(TM) SE Runtime Environment (build 1.6.0_33-b04) > Java HotSpot(TM) 64-Bit Server VM (build 20.8-b03, mixed mode) >Reporter: Victor Penela > Labels: cql > > Creating a CF in cqlsh -3 > CREATE COLUMNFAMILY ads_config (c_id uuid, ct_id uuid, pt_id uuid, c_type > int, creat blob, start timestamp, end timestamp, total int, pending int, > PRIMARY KEY ( campaign_id, creat_id, placement_id)); > INSERT INTO works fine. SELECT * works fine. > ALTER TABLE ads_config add cost int; > SELECT * works fine, new field is null. > ALTER TABLE ads_config drop cost; > Gives a: > TSocket read 0 bytes > After that the connection seems to die, giving me the same error a couple of > times and then a broken pipe: > Traceback (most recent call last): > File "/usr/bin/cqlsh", line 1008, in perform_statement > self.cursor.execute(statement, decoder=decoder) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 117, in execute > response = self.handle_cql_execution_errors(doquery, prepared_q, compress) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 132, in handle_cql_execution_errors > return executor(*args, **kwargs) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1583, in execute_cql_query > self.send_execute_cql_query(query, compression) > File > "/usr/share/cassandra/lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1593, in send_execute_cql_query > self._oprot.trans.flush() > File > "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TTransport.py", > line 293, in flush > self.__trans.write(buf) > File > "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TSocket.py", > line 117, in write > plus = self.handle.send(buff) > error: [Errno 32] Broken pipe > Closing and reopening cql works fine. The column key exists and can't be > dropped. > Error log: > INFO 12:08:40,632 Enqueuing flush of > Memtable-schema_columnfamilies@445620464(1428/1785 serialized/live bytes, 20 > ops) > INFO 12:08:40,633 Writing Memtable-schema_columnfamilies@445620464(1428/1785 > serialized/live bytes, 20 ops) > INFO 12:08:40,696 Completed flushing > /var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-4-Data.db > (1487 bytes) for commitlog position > ReplayPosition(segmentId=180414134565599, position=11928) > INFO 12:08:40,697 Enqueuing flush of > Memtable-schema_columns@1158801519(222/277 serialized/live bytes, 4 ops) > INFO 12:08:40,697 Writing Memtable-schema_columns@1158801519(222/277 > serialized/live bytes, 4 ops) > INFO 12:08:40,704 Compacting > [SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-1-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-3-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-2-Data.db'), > > SSTableReader(path='/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-4-Data.db')] > INFO 12:08:40,731 Completed flushing > /var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-4-Data.db > (273 bytes) for commitlog position ReplayPosition(segmentId=180414134565599, > position=11928) > INFO 12:08:40,761 Compacted to > [/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-5-Data.db,]. > 5,892 to 2,855 (~48% of original) bytes for 1 keys at 0.050421MB/s. Time: > 54ms. > ERROR 12:08:40,780 Exception in thread Thread[MigrationStage:1,5,main] > java.lang.NullPointerException > at > org.apache.cassandra.utils.ByteBufferUtil.string(ByteBufferUtil.java:167) > at > org.apache.cassandra.utils.ByteBufferUtil.string(ByteBufferUtil.java:124) > at org.apache.cassandra.cql.jdbc.JdbcUTF8.getString(JdbcUTF8.java:77) > at org.apache.cassandra.cql.jdbc.JdbcUTF8.compose(JdbcUTF8.java:97) > at org.apache.cassandra.db.marshal.UTF8Type.compose(UTF8Type.java:35) > at > org.apache.cassandra.c