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

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

Thank you for the responses. This is actually not the same bug as 5852 as we 
are hitting it even before an sstable is actually read (during system schema 
load). I have also tried 1.2.10 and 1.2.11 with the same result. We are trying 
to downgrade from 2.0.0 back to 1.2.9 as 2.0.0 contains some serious bugs 
preventing us from running in production.

 As the data format changed, the only option we were aware was to use the 
from/to json utilities. I will try the loader, thx for the tip.

> 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