cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jaroslav Kamenik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-9960) UDTs still visible after drop/recreate keyspace
Date Fri, 07 Aug 2015 14:00:50 GMT

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

Mime
View raw message