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

Jonathan Ellis commented on CASSANDRA-6310:
-------------------------------------------

I hope you followed the advice to snapshot before upgrading then, because 
sstableloader isn't going to migrate your data either.

> 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