[jira] [Resolved] (CASSANDRA-7312) sstable2json fails with FSReadError
[ https://issues.apache.org/jira/browse/CASSANDRA-7312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Charles Sibbald resolved CASSANDRA-7312. Resolution: Cannot Reproduce We were unable to reproduce this after a subsequent import sstable2json fails with FSReadError --- Key: CASSANDRA-7312 URL: https://issues.apache.org/jira/browse/CASSANDRA-7312 Project: Cassandra Issue Type: Bug Components: Core Reporter: Charles Sibbald {code} /apps/cassandra/bin/sstable2json /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Data.db /tmp/test1.json ERROR 13:08:07,047 Error in ThreadPoolExecutor FSReadError in /apps/data/cassandra/data/mykeyspace/householdparentalcontrol/mykeyspace-householdparentalcontrol-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 10 more Exception in thread main FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:147) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:139) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:422) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:435) at org.apache.cassandra.tools.SSTableExport.main(SSTableExport.java:517) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 9 more {code} {code} FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 10 more Exception in thread main
[jira] [Commented] (CASSANDRA-7312) sstable2json fails with FSReadError
[ https://issues.apache.org/jira/browse/CASSANDRA-7312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14073306#comment-14073306 ] Charles Sibbald commented on CASSANDRA-7312: Scrub did not address the issue, and deleted all the 'bad rows' in the file and effectively outputted and empty file. However restoring same sstable files to a newly built cluster works, and they are ingested without issues. sstable2json fails with FSReadError --- Key: CASSANDRA-7312 URL: https://issues.apache.org/jira/browse/CASSANDRA-7312 Project: Cassandra Issue Type: Bug Components: Core Reporter: Charles Sibbald {code} /apps/cassandra/bin/sstable2json /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Data.db /tmp/test1.json ERROR 13:08:07,047 Error in ThreadPoolExecutor FSReadError in /apps/data/cassandra/data/mykeyspace/householdparentalcontrol/mykeyspace-householdparentalcontrol-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 10 more Exception in thread main FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:147) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:139) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:422) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:435) at org.apache.cassandra.tools.SSTableExport.main(SSTableExport.java:517) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 9 more {code} {code} FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at
[jira] [Created] (CASSANDRA-7312) sstable2json fails with FSReadError
Charles Sibbald created CASSANDRA-7312: -- Summary: sstable2json fails with FSReadError Key: CASSANDRA-7312 URL: https://issues.apache.org/jira/browse/CASSANDRA-7312 Project: Cassandra Issue Type: Bug Components: Core Reporter: Charles Sibbald {code} /apps/cassandra/bin/sstable2json /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Data.db /tmp/test1.json ERROR 13:08:07,047 Error in ThreadPoolExecutor FSReadError in /apps/data/cassandra/data/mykeyspace/householdparentalcontrol/mykeyspace-householdparentalcontrol-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 10 more Exception in thread main FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:147) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:139) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:422) at org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:435) at org.apache.cassandra.tools.SSTableExport.main(SSTableExport.java:517) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 9 more {code} {code} FSReadError in /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-32-Index.db at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:200) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.complete(MmappedSegmentedFile.java:168) at org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:417) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:209) at org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:157) at org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:273) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Channel not open for writing - cannot extend file to required size at sun.nio.ch.FileChannelImpl.map(FileChannelImpl.java:851) at org.apache.cassandra.io.util.MmappedSegmentedFile$Builder.createSegments(MmappedSegmentedFile.java:192) ... 10 more Exception in thread main java.lang.RuntimeException: java.io.FileNotFoundException: /apps/data/cassandra/data/mykeyspace/mycolumnfamily/mykeyspace-mycolumnfamily-ic-330-Index.db (No such file or directory) at