[
https://issues.apache.org/jira/browse/CASSANDRA-8390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14245902#comment-14245902
]
Alexander Radzin commented on CASSANDRA-8390:
---------------------------------------------
Joshua McKenzie, thank you for your efforts.
Today I managed to reproduce the issue on other developer's laptop, however
everything worked well on integration machine. Laptops are running windows 7
and 8, integration machine windows 2002, R2.
I played with sys internals and saw that there are 2 processes that act in
cassandra data directory: windows defender and SVN. I stopped both and ran test
again with process monitor from sysinternals and the problem happened again
although the view of process monitor was clear (i.e. only java.exe) was active
in this directory.
Following your suggestion I ran the test again and executed {{hanle}} while
test was running. And here are the results:
{noformat}
C:\Windows\system32>c:\progs\SysinternalsSuite\handle -a
c:\progs\apache-cassandra-2.1.2\data
Handle v3.51
Copyright (C) 1997-2013 Mark Russinovich
Sysinternals - www.sysinternals.com
java.exe pid: 1852 type: File 658:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 6C8:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 740:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 744:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 958:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-1-Index.db
java.exe pid: 1852 type: File 968:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-1-Data.db
java.exe pid: 1852 type: File 96C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-1-Index.db
java.exe pid: 1852 type: File 970:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-1-Data.db
java.exe pid: 1852 type: File 974:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-1-Index.db
java.exe pid: 1852 type: File 978:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-1-Data.db
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>c:\progs\SysinternalsSuite\handle -a
c:\progs\apache-cassandra-2.1.2\data
Handle v3.51
Copyright (C) 1997-2013 Mark Russinovich
Sysinternals - www.sysinternals.com
java.exe pid: 1852 type: File 658:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 6C8:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 740:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 744:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 958:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-26-Data.db
java.exe pid: 1852 type: File 97C:
C:\progs\apache-cassandra-2.1.2\data\data\system\local-7ad54392bcdd35a684174e047860b377\system-local-ka-5-Data.db
java.exe pid: 1852 type: File B74:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-29-Data.db
java.exe pid: 1852 type: File B7C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-26-Index.db
java.exe pid: 1852 type: File BA0:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-27-Data.db
java.exe pid: 1852 type: File BA4:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-25-Data.db
java.exe pid: 1852 type: File BF8:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-27-Index.db
C:\Windows\system32>c:\progs\SysinternalsSuite\handle -a
c:\progs\apache-cassandra-2.1.2\data
Handle v3.51
Copyright (C) 1997-2013 Mark Russinovich
Sysinternals - www.sysinternals.com
java.exe pid: 1852 type: File 658:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 6C8:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 740:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 744:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 968:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-98-Index.db
java.exe pid: 1852 type: File 97C:
C:\progs\apache-cassandra-2.1.2\data\data\system\local-7ad54392bcdd35a684174e047860b377\system-local-ka-5-Data.db
java.exe pid: 1852 type: File B44:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-102-Index.db
java.exe pid: 1852 type: File B5C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-99-Index.db
java.exe pid: 1852 type: File B60:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-101-Data.db
java.exe pid: 1852 type: File B70:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-98-Data.db
java.exe pid: 1852 type: File B7C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-99-Data.db
java.exe pid: 1852 type: File B88:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-97-Data.db
java.exe pid: 1852 type: File BA4:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-97-Data.db
java.exe pid: 1852 type: File BAC:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-102-Data.db
java.exe pid: 1852 type: File BC8:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-99-Index.db
java.exe pid: 1852 type: File BE0:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-98-Index.db
java.exe pid: 1852 type: File BE4:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-99-Data.db
java.exe pid: 1852 type: File BF0:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-98-Data.db
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>date /t && c:\progs\SysinternalsSuite\handle -a
c:\progs\apache-cassandra-2.1.2\data
Sun 12/14/2014
Handle v3.51
Copyright (C) 1997-2013 Mark Russinovich
Sysinternals - www.sysinternals.com
java.exe pid: 1852 type: File 658:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 6C8:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506027.log
java.exe pid: 1852 type: File 740:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File 744:
C:\progs\apache-cassandra-2.1.2\data\commitlog\CommitLog-4-1418558506028.log
java.exe pid: 1852 type: File B20:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-249-Data.db
java.exe pid: 1852 type: File B24:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-250-Data.db
java.exe pid: 1852 type: File B3C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-250-Data.db
java.exe pid: 1852 type: File B44:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-251-Index.db
java.exe pid: 1852 type: File B70:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-255-Index.db
java.exe pid: 1852 type: File B80:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-249-Data.db
java.exe pid: 1852 type: File B94:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-256-Index.db
java.exe pid: 1852 type: File BAC:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-250-Index.db
java.exe pid: 1852 type: File BB0:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-256-Data.db
java.exe pid: 1852 type: File BBC:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-255-Data.db
java.exe pid: 1852 type: File BD0:
C:\progs\apache-cassandra-2.1.2\data\data\system\local-7ad54392bcdd35a684174e047860b377\system-local-ka-5-Data.db
java.exe pid: 1852 type: File BD8:
C:\progs\apache-cassandra-2.1.2\data\data\system\local-7ad54392bcdd35a684174e047860b377\system-local-ka-5-Data.db
java.exe pid: 1852 type: File C48:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_keyspaces-b0f2235744583cdb9631c43e59ce3676\system-schema_keyspaces-ka-254-Data.db
java.exe pid: 1852 type: File C58:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-250-Index.db
java.exe pid: 1852 type: File C78:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columnfamilies-45f5b36024bc3f83a3631034ea4fa697\system-schema_columnfamilies-ka-251-Data.db
java.exe pid: 1852 type: File C7C:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-251-Index.db
java.exe pid: 1852 type: File C80:
C:\progs\apache-cassandra-2.1.2\data\data\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-251-Data.db
C:\Windows\system32>
{noformat}
The last run is done after exception appeared.
Unfortunately I do not know what I have to pay my attention on. Please let me
know what kind of additional information can help you. BTW if you want we even
can organize online session against one of the machines where the problem
happens.
> 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
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
