小结
Cassandra启动报错：EXCEPTION_ACCESS_VIOLATION，进行了解决。
问题
Cassandra启动报错：
#
# A fatal error has been detected by the Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000010014ed4, pid=1224, tid=0x0000000000004084
#
# JRE version: Java(TM) SE Runtime Environment (8.0_261-b12) (build 1.8.0_261-b12)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.261-b12 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# C [sigar-amd64-winnt.dll+0x14ed4]
#
# Failed to write core dump. Minidumps are not enabled by default on client versions of Windows
#
# If you would like to submit a bug report, please visit:
# http://bugreport.java.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
环境：
- Windows 10 Pro
- Cassandra 3.11.9
- JDK: java version “1.8.0_261”
解决
参考Stackoverflow:Cassandra Windows 10 Access Violation
由于启动过程中加载sigar-amd64-winnt.dll文件出错，到D:\apache-cassandra-3.11.9\lib这个目录下将这个文件改成其它名字，这样Cassandra启动时就不会加载这个文件了。
改完后重新启动成功：
D:\apache-cassandra-3.11.9\bin>cassandra
Detected powershell execution permissions. Running with enhanced startup scripts.
Security warning
Run only scripts that you trust. While scripts from the internet can be useful, this script can potentially harm your computer. If you trust this script, use the
Unblock-File cmdlet to allow the script to run without this warning message. Do you want to run D:\apache-cassandra-3.11.9\bin\cassandra.ps1?
[D] Do not run [R] Run once [S] Suspend [?] Help (default is "D"): R
......
省略
......
用root用户登录：
D:\apache-cassandra-3.11.9\bin>cqlsh.bat -uroot -pxxxxx
WARNING: console codepage must be set to cp65001 to support utf-8 encoding on Windows platforms.
If you experience encoding problems, change your console codepage with 'chcp 65001' before starting cqlsh.
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.9 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
WARNING: pyreadline dependency missing. Install to enable tab completion.
root@cqlsh> use system_auth;
root@cqlsh:system_auth> select * from roles;
role | can_login | is_superuser | member_of | salted_hash
-----------+-----------+--------------+-----------+--------------------------------------------------------------
cassandra | True | True | null | $2a$10$6NGNXcEt26dk7mzqFxcONeuoZcBw2f5gZZwvksw7T1aFTcqd7hiYS
root | True | True | null | $2a$10$dYesaoFDUCeZnEiDIije/ecy1t.23EgclNdFpW/IDo9W.xnnJE0aW
(2 rows)
root@cqlsh:system_auth> exit;
D:\apache-cassandra-3.11.9\bin>