cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Herbert Kruitbosch (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8487) system.schema_columns sometimes missing for 'system' keyspace
Date Thu, 04 Jun 2015 11:58:38 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-8487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14572633#comment-14572633
] 

Herbert Kruitbosch commented on CASSANDRA-8487:
-----------------------------------------------

I reproduced this for a 4-node with cassandra version **2.1.2**:

    [herbert.kruitbosch@xyz ~]$ cqlsh zyx
    Connected to Cassandra productie at zyx:9160.
    [cqlsh 4.1.1 | Cassandra 2.1.2 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
    Use HELP for help.
    cqlsh> select * from system.schema_columns where keyspace_name='system';
    
    (0 rows)
    
    cqlsh> 

But not on a similar 4-node system with cassandra version **2.0.9**:

    [herbert.kruitbosch@zyx ~]$ cqlsh xyz
    Connected to Cassandra development at xyz
    [cqlsh 4.1.1 | Cassandra 2.0.9 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
    Use HELP for help.
    cqlsh> select * from system.schema_columns where keyspace_name='system';

     keyspace_name | columnfamily_name       | column_name                 | component_index
| index_name | index_options | index_type | type           | validator
    ---------------+-------------------------+-----------------------------+-----------------+------------+---------------+------------+----------------+-----------------------------------------------------------------------------------------------------------------------------
            system |               IndexInfo |                             |            null
|       null |          null |       null |  compact_value |                             
                                                     org.apache.cassandra.db.marshal.BytesType
    
    ...
    
    (110 rows)



> system.schema_columns sometimes missing for 'system' keyspace
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-8487
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8487
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Adam Holmberg
>            Assignee: Aleksey Yeschenko
>            Priority: Minor
>             Fix For: 2.1.x, 2.2.x
>
>
> Occasionally a Cassandra node will have missing schema_columns information where keyspace_name='system'.
> {code}
> cqlsh> select * from system.schema_columns where keyspace_name='system';
>  keyspace_name | columnfamily_name | column_name
> ---------------+-------------------+-------------
> (0 rows)
> {code}
> All keyspace and column family schema info is present for 'system' -- it's only the column
information missing.
> This can occur on an existing cluster following node restart. The data usually appears
again after bouncing the node.
> This is impactful to client drivers that expect column meta for configured tables.
> Reproducible in 2.1.2. Have not seen it crop up in 2.0.11.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message