http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108 Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 15:04:25 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1465 Thu, 29 Mar 2012 20:30:36 +0000 joaquin 1465@http://www.datastax.com/support-forums/ <p>Glad to hear! </p> http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1464 Thu, 29 Mar 2012 20:28:25 +0000 Anonymous 1464@http://www.datastax.com/support-forums/ <p>Thanks a lot, Joaquin.<br /> It was indeed a permission issue. I chowned files and cassandra started successfully.</p> <p>Thanks again.<br /> Nare. </p> http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1463 Thu, 29 Mar 2012 18:44:54 +0000 joaquin 1463@http://www.datastax.com/support-forums/ <p>IOExceptions in Cassandra mean that the file couldn't be accessed. Could you ensure that the permissions are set accordingly?</p> <p>Were both installed via packages? Could you ensure that all the files under 1.0.8's /var/lib/cassandra directory are chown'd to cassandra:cassandra?</p> <p>Thanks,<br /> Joaquin </p> http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1448 Wed, 28 Mar 2012 21:05:02 +0000 Anonymous 1448@http://www.datastax.com/support-forums/ <p>Thanks for the reply, jbellis.</p> <p>Once on my test severs I succeeded to move data using first method. But when I tried it on my live server I got the following exception in cassandra's output.log.</p> <p> INFO 21:00:44,367 Loading schema version 7ad324f0-7909-11e1-0000-242d50cf1fff<br /> java.lang.reflect.InvocationTargetException<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:616)<br /> at org.apache.commons.daemon.support.DaemonLoader.load(DaemonLoader.java:160)<br /> Caused by: java.io.IOError: java.io.IOException: Failed to delete /var/lib/cassandra/data/Monitis/AdditionalResults-2576-Data.db<br /> at org.apache.cassandra.db.ColumnFamilyStore.scrubDataDirectories(ColumnFamilyStore.java:371)<br /> at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:193)<br /> at org.apache.cassandra.service.AbstractCassandraDaemon.init(AbstractCassandraDaemon.java:257)<br /> ... 5 more<br /> Caused by: java.io.IOException: Failed to delete /var/lib/cassandra/data/Monitis/AdditionalResults-2576-Data.db<br /> at org.apache.cassandra.io.util.FileUtils.deleteWithConfirm(FileUtils.java:54)<br /> at org.apache.cassandra.io.util.FileUtils.deleteWithConfirm(FileUtils.java:44)<br /> at org.apache.cassandra.io.sstable.SSTable.delete(SSTable.java:135)<br /> at org.apache.cassandra.db.ColumnFamilyStore.scrubDataDirectories(ColumnFamilyStore.java:367)<br /> ... 7 more<br /> Cannot load daemon<br /> Service exit with a return value of 3 </p> http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1440 Wed, 28 Mar 2012 01:32:09 +0000 jbellis 1440@http://www.datastax.com/support-forums/ <p>Approach 1 is going to be your best bet. (sstable2json changed its format between 0.6 and 1.0; it's intended to be a debugging tool, not a migration assistant.)</p> <p>You need all the sstable files, not just the Data ones. </p> http://www.datastax.com/support-forums/topic/data-migration-from-cassandra-061-to-108#post-1438 Tue, 27 Mar 2012 22:06:07 +0000 Anonymous 1438@http://www.datastax.com/support-forums/ <p>Hi.<br /> We've got some technical issues with cassandra data migration from version 0.6.1 to 1.0.8 and I would appreciate very much if someone helps me.</p> <p>I tried to migrate data in 2 ways and both failed.</p> <p>1. I stopped cassandra 1.0.8 server, deleted commitlog files, added *.Data files from cassandra 0.6.1 server and stared cassandra 1.0.8. I didn't get any error but neither I got the results I wanted.<br /> 2. I used sstables2json tool to export data from cassandra 0.6.1. For big sstables I got ouofmemory error, for small ones I succeeded to export data as json and store it in a file. I tried to import data from these json files on cassandra 1.0.8 using json2stable tool but I got exception like this:</p> <p>java.lang.NumberFormatException: Non-hex characters in 8abbdda0-8141-11e0-9e5c-0019d10404cb<br /> at org.apache.cassandra.utils.Hex.hexToBytes(Hex.java:59)<br /> at org.apache.cassandra.utils.ByteBufferUtil.hexToBytes(ByteBufferUtil.java:492)<br /> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:279)<br /> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:255)<br /> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:479)<br /> ERROR: Non-hex characters in 8abbdda0-8141-11e0-9e5c-0019d10404cb</p> <p>The columnfamily on 0.6.1 is declared in storage-conf.xml as follows:</p> <p>&lt;ColumnFamily Name="MonitorResults" ColumnType="Super" CompareWith="UTF8Type" CompareSubcolumnsWith="UTF8Type"/&gt;</p> <p>On 1.0.8 I created the columnfamily from command-line client using the following command:</p> <p>create column family MonitorResults with column_type=Super and comparator=UTF8Type and subcomparator=UTF8Type; </p>