You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Victor Penela (JIRA)" <ji...@apache.org> on 2012/08/21 12:41:38 UTC
[jira] [Resolved] (CASSANDRA-4527) Issue with CQL and ALTER TABLE
DROP
[ https://issues.apache.org/jira/browse/CASSANDRA-4527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victor Penela resolved CASSANDRA-4527.
--------------------------------------
Resolution: Duplicate
There was an issue with with Jira when creating the issue. Sorry for the dupe!
> 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.cql3.UntypedResultSet$Row.getString(UntypedResultSet.java:87)
> at org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:256)
> at org.apache.cassandra.config.CFMetaData.addColumnDefinitionSchema(CFMetaData.java:1293)
> at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1225)
> at org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:294)
> at org.apache.cassandra.db.DefsTable.mergeColumnFamilies(DefsTable.java:396)
> at org.apache.cassandra.db.DefsTable.mergeSchema(DefsTable.java:271)
> at org.apache.cassandra.service.MigrationManager$1.call(MigrationManager.java:211)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> ERROR 12:08:40,779 Error occurred during processing of message.
> java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.NullPointerException
> at org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:373)
> at org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:188)
> at org.apache.cassandra.service.MigrationManager.announceColumnFamilyUpdate(MigrationManager.java:161)
> at org.apache.cassandra.cql3.statements.AlterTableStatement.announceMigration(AlterTableStatement.java:148)
> at org.apache.cassandra.cql3.statements.SchemaAlteringStatement.execute(SchemaAlteringStatement.java:99)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1237)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException
> at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
> at java.util.concurrent.FutureTask.get(FutureTask.java:83)
> at org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:369)
> ... 15 more
> Caused by: 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.cql3.UntypedResultSet$Row.getString(UntypedResultSet.java:87)
> at org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:256)
> at org.apache.cassandra.config.CFMetaData.addColumnDefinitionSchema(CFMetaData.java:1293)
> at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1225)
> at org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:294)
> at org.apache.cassandra.db.DefsTable.mergeColumnFamilies(DefsTable.java:396)
> at org.apache.cassandra.db.DefsTable.mergeSchema(DefsTable.java:271)
> at org.apache.cassandra.service.MigrationManager$1.call(MigrationManager.java:211)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> ... 3 more
> INFO 12:08:40,791 Compacting [SSTableReader(path='/var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-2-Data.db'), SSTableReader(path='/var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-1-Data.db'), SSTableReader(path='/var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-3-Data.db'), SSTableReader(path='/var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-4-Data.db')]
> INFO 12:08:40,856 Compacted to [/var/lib/cassandra/data/system/schema_columns/system-schema_columns-hd-5-Data.db,]. 2,973 to 2,537 (~85% of original) bytes for 1 keys at 0.037223MB/s. Time: 65ms.
> (It's my first issue reported, so please, let me know if I'm missing any relevant data :)).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira