cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victor Penela (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-4527) Issue with CQL and ALTER TABLE DROP
Date Tue, 21 Aug 2012 10:41:38 GMT

     [ 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

        

Mime
View raw message