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