[jira] [Commented] (CASSANDRA-6224) CQL3 Column family / tables "disappear", get unconfigured columnfamily errors

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

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

Sylvain Lebresne commented on CASSANDRA-6224:
---------------------------------------------

I'm afraid we'd need a proper way to reproduce to go as that stracktrace dones't really tell us anything.  And as far as I can tell, so far no-one else has reported having table "disappearing" and that's hardly something that would go unoticed if that happened.

In particular, I'd suggest really checking that it's not a client side issue, like some code dropping the table by mistake. Or maybe the client not checking for schema agreement before trying to query (and thus potentially reaching a node that is not up to date on the schema).


> 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.1#6144)