[
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)
