Details
-
Bug
-
Status: Resolved
-
Normal
-
Resolution: Fixed
-
None
-
None
-
None
-
All
-
None
Description
I have a table like this: key1, key2, key3, column1, column2.
When I delete a row with keys 1, 2, 3. and then insert a new row almost immediately with the same keys, cassandra does not store the new row even though the query executes successfully.
How can I force Cassandra to store the new row, or do I have to change my data model?
EDIT:
I'm running Cassandra 3.11.6 in Docker, a single instance for development purposes.
This has happen already with 3 tables.
// CREATE TABLE my_keyspace.my_chat ( country text, user_id timeuuid, chat_id bigint, email text, first_name text, last_name text, username text, PRIMARY KEY (country, user_id, chat_id));
// CREATE TABLE my_keyspace.my_profile (CREATE TABLE my_keyspace.my_profile ( country text, user_id timeuuid, profile_code text, id_doc text, id_doc_type text, user_email text, user_name text, PRIMARY KEY (country, user_id)) WITH CLUSTERING ORDER BY ( user_id DESC );
// CREATE TABLE my_keyspace.role ( realm text, business_id timeuuid, user_id timeuuid, owner_id timeuuid, name text, status text, icon text, url text, description text, owner_email text, owner_name text, scope_id timeuuid, scope_name text, scopes SET<text>, authorization boolean, user_email text, user_name text, views SET<FROZEN<my_dt>>, PRIMARY KEY (realm, business_id, user_id, owner_id, name, status)) WITH CLUSTERING ORDER BY ( business_id DESC, user_id DESC, owner_id DESC, name DESC, status DESC);
The value of the keys for this tables come from other tables or outside immutable data.
I'm also using the Datastax OSS Java Driver v4.7.0 for comunications with Cassandra, but the problem have also presented using cqlsh.
The queries I use are standard read by partition key, insert the whole row and delete by full partiion key.