[ 
https://issues.apache.org/jira/browse/CASSANDRA-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13817093#comment-13817093
 ] 

Jiri Horky commented on CASSANDRA-6310:
---------------------------------------

Jeremiah, actually yes I did try. We have 3 datacenters, each one with 8 nodes, 
half of the nodes running 2.0.0 and  the other half 1.2.9. Since we hit 6284, I 
tried to patch the 2.0.2 version and deploy it on one of the 2.0.0 node. But 
for some reason, it started to cause the system tables to be continuously 
flushed on all the servers so I reverted it back to 2.0.0 after like 
~10minutes. But since the 2.0.2 version already started to compact some of the 
tables and it has incompatible data format, I needed to do "nodetool repair". 
That's when we hit another (probably) bug (yet to be fired), when after 
completing computing of merkle trees (which itself required backporting a patch 
from 2.0.x trunk as well) and finishing the streaming, all sstables on all 
three nodes responsible for the given token range were marked as in L0, causing 
extensive compaction ( 9000 pending) which is practically never going to 
finish...so this was the last drop when we realized that going back to 1.2.9. 
may actually be better.

> MarshalException: cannot parse 'column1' as hex bytes when inserting data 
> exported from 2.0.0 to 1.2.9 using json2sstable 
> --------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6310
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6310
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Jiri Horky
>
> Hi,
> we are getting the exception below when we try to insert data using 
> json2sstable from 1.2.9 which were created using sstable2json from C2.0.0:
> Exception in thread "main" org.apache.cassandra.db.marshal.MarshalException: 
> cannot parse 'column1' as hex bytes
>         at 
> org.apache.cassandra.db.marshal.BytesType.fromString(BytesType.java:69)
>         at 
> org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:230)
>         at 
> org.apache.cassandra.config.CFMetaData.addColumnDefinitionSchema(CFMetaData.java:1522)
>         at 
> org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1454)
>         at 
> org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:306)
>         at 
> org.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:287)
>         at org.apache.cassandra.db.DefsTable.loadFromTable(DefsTable.java:154)
>         at 
> org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:563)
>         at 
> org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:527)
> Caused by: java.lang.NumberFormatException: An hex string representing bytes 
> must have an even length
>         at org.apache.cassandra.utils.Hex.hexToBytes(Hex.java:52)
>         at 
> org.apache.cassandra.db.marshal.BytesType.fromString(BytesType.java:65)
> This information may be valuable as well: (got from 1.2.9 node):
> cqlsh> select * from system.schema_columns;
>                                                                               
>                                                                               
>                                                                               
>                                      
>  keyspace_name | columnfamily_name     | column_name                 | 
> component_index | index_name | index_options | index_type | validator         
>                                                                               
>                                             
> ---------------+-----------------------+-----------------------------+-----------------+------------+---------------+------------+-----------------------------------------------------------------------------------------------------------------------------
>            frs |                   snx |                     column1 |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>            frs |                   snx |                         key |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>            frs |                   snx |                       value |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>            frs |                 stats |                         KEY |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>            frs |                 stats |                     column1 |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>            frs |                 stats |                       value |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                  meta |                     column1 |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                  meta |                         key |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                  meta |                       value |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                   sha |                         KEY |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                   sha |                     column1 |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |                   sha |                       value |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |          sha_counters |                         KEY |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |          sha_counters |                     column1 |        
>     null |       null |          null |       null |                          
>                                                          
> org.apache.cassandra.db.marshal.BytesType
>             fr |          sha_counters |                       value |        
>     null |       null |          null |       null |                          
>                                                  
> org.apache.cassandra.db.marshal.CounterColumnType
> Any hints would be greatly appriciated.
> Jiri Horky



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Reply via email to