SingleStore DB

Introduction

This guide can be used to troubleshoot system, node, or general query performance issues. Each page is a step with a Next Steps section at the end, which provides recommendations for what the reader can do next based on the information they uncover in their current step. Overall, generating and checking a cluster report is the best place to start your troubleshooting journey.

Collecting and Checking the Cluster Report
  1. Using sdb-report collect, collect a report and write it to a tar file on the host you execute the command from.

    sdb-report collect
    ****
    Toolbox will perform the following actions:
      · Execute 74 collectors
    ✓ Collected report for host 127.0.0.1
    Report written to report-2021-01-08T021531.tar.gz
  2. Use sdb-report check to check the output for issues. Look at all FAIL output, such as this example:

    sdb-report check --report-path your_report_path.tar.gz
    ****
    ✘ transparentHugepage ........................... [FAIL]
    FAIL /sys/kernel/mm/transparent_hugepage/enabled is [always] on 172.17.0.2
    NOTE https://docs.memsql.com/memsql-report-redir/transparent-hugepage
    ✘ leavesNotOnline ........................ [FAIL]
    FAIL leaf node on host 127.0.0.1 and port 3308 is offline
    Some checks failed: 1 FAIL, 1 PASS, 1 UNAVAILABLE
Next Steps
  • If the cluster report does not uncover any FAIL output, move onto Step 1 and be sure to take note of any WARNINGS in the check --report output for future