[
https://issues.apache.org/jira/browse/CASSANDRA-9960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14661857#comment-14661857
]
Jaroslav Kamenik commented on CASSANDRA-9960:
---------------------------------------------
New info - it seems, that old type data are resurrected after creation few new
types in empty keyspace. Now I have it in those strange state, example from
cqlsh:
cqlsh> drop keyspace woc;
cqlsh> CREATE KEYSPACE woc WITH REPLICATION = {'class': 'SimpleStrategy',
'replication_factor': '1'};
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc' AND
type_name='xxxxxxx';
keyspace_name | type_name | field_names | field_types
---------------+-----------+-------------+-------------
(0 rows)
cqlsh> CREATE TYPE IF NOT EXISTS woc.a(aa int);
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc' AND
type_name='xxxxxxx';
keyspace_name | type_name | field_names | field_types
---------------+-----------+-------------+-------------
(0 rows)
cqlsh> CREATE TYPE IF NOT EXISTS woc.b(bb int) ;
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc' AND
type_name='xxxxxxx';
keyspace_name | type_name | field_names |
field_types
---------------+-----------+-----------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------
woc | xxxxxxx | ['xxxxxxx', 'xxxxxxx', 'xxxxxxx'] |
['org.apache.cassandra.db.marshal.AsciiType',
'org.apache.cassandra.db.marshal.TimeUUIDType',
'org.apache.cassandra.db.marshal.AsciiType']
> UDTs still visible after drop/recreate keyspace
> -----------------------------------------------
>
> Key: CASSANDRA-9960
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9960
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Reporter: Jaroslav Kamenik
> Assignee: Robert Stupp
> Priority: Critical
> Fix For: 2.2.x
>
>
> When deploying my app from the scratch I run sequence - drop keyspaces,
> create keyspaces, create UDTs, create tables, generate lots of data... After
> few cycles, randomly, cassandra ends in state, where I cannot see anything in
> table system.schema_usertypes, when I select all rows, but queries with
> specified keyspace_name and type_name return old values. Usually it helps to
> restart C* and old data disapear, sometimes it needs to delete all C* data.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
