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

Constance Eustace commented on CASSANDRA-6224:
----------------------------------------------

I'm assuming this was a node synchronization problem of the schema, or it may 
have been a very spotty AWS instance.

We haven't encountered this since.

> CQL3 Column family / tables "disappear", get unconfigured columnfamily errors
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6224
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6224
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API, Core
>         Environment: Cassandra 2.0.1 Amazon AWS Ubuntu Single-node
>            Reporter: Constance Eustace
>
> We're seeing CQL3 tables seemingly arbitrarily disappear. Need to repair for 
> prod meant we reconstructed the affected schema before nodetool repairs or 
> similar attempts were done. 
> It seems to take a few days to appear. Volumes are not tremendously high 
> yet...
> Caused by: java.sql.SQLSyntaxErrorException: 
> InvalidRequestException(why:unconfigured columnfamily entity_hierarchydef)
>       at 
> org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:103)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:388)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:372)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:50)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>  ~[commons-dbcp-1.3.jar:1.3]
>       at 
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>  ~[commons-dbcp-1.3.jar:1.3]
>       at 
> com.bestbuy.contentsystems.cupcake.storage.cassandra.cqlentity.CQL.tool.CassPSC.createPreparedStatement(CassPSC.java:61)
>  ~[ingest-storage-QA-SNAPSHOT.jar:QA-SNAPSHOT]
>       at 
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:583) 
> ~[spring-jdbc-3.2.4.RELEASE.jar:3.2.4.RELEASE]
>       ... 148 common frames omitted
> Caused by: org.apache.cassandra.thrift.InvalidRequestException: null
>       at 
> org.apache.cassandra.thrift.Cassandra$prepare_cql3_query_result.read(Cassandra.java:39567)
>  ~[cassandra-thrift-1.2.8.jar:1.2.8]
>       at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) 
> ~[libthrift-0.7.0.jar:0.7.0]
>       at 
> org.apache.cassandra.thrift.Cassandra$Client.recv_prepare_cql3_query(Cassandra.java:1625)
>  ~[cassandra-thrift-1.2.8.jar:1.2.8]
>       at 
> org.apache.cassandra.thrift.Cassandra$Client.prepare_cql3_query(Cassandra.java:1611)
>  ~[cassandra-thrift-1.2.8.jar:1.2.8]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraConnection.prepare(CassandraConnection.java:517)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraConnection.prepare(CassandraConnection.java:532)
>  ~[cassandra-jdbc-1.2.5.jar:na]
>       at 
> org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.<init>(CassandraPreparedStatement.java:96)
>  ~[cassandra-jdbc-1.2.5.jar:na]



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to