How do I troubleshoot SingleStore not being able to open the audit logs?
When a SingleStore node is unable to open the audit logging file, the node will fail to start up, and you may see the following errors:
300015028 2021-04-15 13:19:04.843 ERROR: Failed to open '/your/audit_log/directory/audit.log' for write after 30 attempts. res = 2 strerror=[No such file or directory]
300015084 2021-04-15 13:19:04.844 FATAL: Failed to open auditlog. Aborting MemSQL.
: Failed to connect to MemSQL: process exited: exit status 1
- Confirm that the SingleStore user on the node(s) in question has permission to access the audit logging directory.
- Confirm the node(s) have access to the audit logging directory. If the audit log directory is a network-mounted path, be sure it is mounted on all hosts housing SingleStore nodes.
- For more information on configuring audit logging, follow the Configuring Audit Logging documentation.