[
https://issues.apache.org/jira/browse/CASSANDRA-9960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14661869#comment-14661869
]
Jaroslav Kamenik commented on CASSANDRA-9960:
---------------------------------------------
Tried to restart C*
FIRST RESTART
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc';
keyspace_name | type_name | field_names | field_types
---------------+-----------+-------------+-----------------------------------------------
woc | a | ['aa'] |
['org.apache.cassandra.db.marshal.Int32Type']
woc | b | ['bb'] |
['org.apache.cassandra.db.marshal.Int32Type']
(2 rows)
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']
(1 rows)
zombie still there..
SECOND RESTART
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc';
keyspace_name | type_name | field_names | field_types
---------------+-----------+-------------+-----------------------------------------------
woc | a | ['aa'] |
['org.apache.cassandra.db.marshal.Int32Type']
woc | b | ['bb'] |
['org.apache.cassandra.db.marshal.Int32Type']
(2 rows)
cqlsh> select * FROM system.schema_usertypes WHERE keyspace_name='woc' AND
type_name='xxxxxxx';
keyspace_name | type_name | field_names | field_types
---------------+-----------+-------------+-------------
(0 rows)
Zombie disapeared.
> 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)
