[ https://issues.apache.org/jira/browse/CASSANDRA-8390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14301558#comment-14301558 ]
Joshua McKenzie commented on CASSANDRA-8390: -------------------------------------------- This piqued my interest - it seems we could write a stand-alone .dll and distribute it with Cassandra, making use of the [Restart Manager|https://msdn.microsoft.com/library/cc948910.aspx] to [grab a list of who has file handles open|http://blogs.msdn.com/b/oldnewthing/archive/2012/02/17/10268840.aspx]. Even then, I'm not sure that would address our case where file system drivers are causing transient failures as I can't guarantee fs hooks show up in the queried [RmGetList results|https://msdn.microsoft.com/en-us/library/windows/desktop/aa373661%28v=vs.85%29.aspx] in the first place and and we'd likely race with that query anyway - but it's worth a shot. I'll put this on my list of things to look into, likely around the 3.1 era. > The process cannot access the file because it is being used by another process > ------------------------------------------------------------------------------ > > Key: CASSANDRA-8390 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8390 > Project: Cassandra > Issue Type: Bug > Reporter: Ilya Komolkin > Assignee: Joshua McKenzie > Fix For: 2.1.3 > > Attachments: CassandraDiedWithDiskAccessModeStandardLogs.7z, FSD.PNG, > NoHostAvailableLogs.zip > > > {code}21:46:27.810 [NonPeriodicTasks:1] ERROR o.a.c.service.CassandraDaemon - > Exception in thread Thread[NonPeriodicTasks:1,5,main] > org.apache.cassandra.io.FSWriteError: java.nio.file.FileSystemException: > E:\Upsource_12391\data\cassandra\data\kernel\filechangehistory_t-a277b560764611e48c8e4915424c75fe\kernel-filechangehistory_t-ka-33-Index.db: > The process cannot access the file because it is being used by another > process. > > at > org.apache.cassandra.io.util.FileUtils.deleteWithConfirm(FileUtils.java:135) > ~[cassandra-all-2.1.1.jar:2.1.1] > at > org.apache.cassandra.io.util.FileUtils.deleteWithConfirm(FileUtils.java:121) > ~[cassandra-all-2.1.1.jar:2.1.1] > at > org.apache.cassandra.io.sstable.SSTable.delete(SSTable.java:113) > ~[cassandra-all-2.1.1.jar:2.1.1] > at > org.apache.cassandra.io.sstable.SSTableDeletingTask.run(SSTableDeletingTask.java:94) > ~[cassandra-all-2.1.1.jar:2.1.1] > at > org.apache.cassandra.io.sstable.SSTableReader$6.run(SSTableReader.java:664) > ~[cassandra-all-2.1.1.jar:2.1.1] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > ~[na:1.7.0_71] > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > ~[na:1.7.0_71] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > ~[na:1.7.0_71] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > ~[na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > ~[na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > Caused by: java.nio.file.FileSystemException: > E:\Upsource_12391\data\cassandra\data\kernel\filechangehistory_t-a277b560764611e48c8e4915424c75fe\kernel-filechangehistory_t-ka-33-Index.db: > The process cannot access the file because it is being used by another > process. > > at > sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:86) > ~[na:1.7.0_71] > at > sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:97) > ~[na:1.7.0_71] > at > sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:102) > ~[na:1.7.0_71] > at > sun.nio.fs.WindowsFileSystemProvider.implDelete(WindowsFileSystemProvider.java:269) > ~[na:1.7.0_71] > at > sun.nio.fs.AbstractFileSystemProvider.delete(AbstractFileSystemProvider.java:103) > ~[na:1.7.0_71] > at java.nio.file.Files.delete(Files.java:1079) ~[na:1.7.0_71] > at > org.apache.cassandra.io.util.FileUtils.deleteWithConfirm(FileUtils.java:131) > ~[cassandra-all-2.1.1.jar:2.1.1] > ... 11 common frames omitted{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)