Knowledge Base Articles
From basic FAQs to in-depth techdocs
Read docsGet input from the SingleStore community
Visit forumsOur support team is available for Enterprise licensed customers
Contact support
ANNOUNCEMENTS
- Alternatives to SingleStore Studio for Monitoring and SQL Access
- SingleStoreDB 9.0 Release Announcement
- SingleStoreDB 8.9 Release Announcement
- SingleStoreDB 8.5 Release Announcement
- SingleStoreDB 8.0 Release Announcement
- SingleStore 7.8 Release Announcement
FAQ
- Downloading Older Versions of SingleStore
- Stack Overflow During Query Execution – Increasing thread_stack
- Preventing Proactive Tickets from Being Assigned to Former Employees
- Generating and Reviewing a Cluster Report in SingleStore Self-Managed
- Collecting mv_processlist and mv_bt for Real-Time Cluster Diagnostics
- Locating core dumps and adjusting core file size limits when using systemd-coredump
CLUSTER
- Customizing SingleStore prompt
- Understanding Run Count, Success Count, and Failure Count in SingleStore Workload Monitoring
- Getting a Granular View of Memory Consumption in SingleStore
- How do I enable SSL upon deployment?
- Change entire Cluster Port
- Identifying the number of successful query executions in a given time span
SECURITY
- Accessing SingleStore’s Security Certifications and Policies
- Reporting a Security Vulnerability in SingleStore
- Penetration Testing on SingleStore Products
- Linguistic Lumberjack (CVE-2024-4323)
- IngressNightmare (CVE-2025-1097, CVE-2025-1098, CVE-2025-1974, CVE-2025-24514, CVE-2025-24513)
- Critical RCE Vulnerability in Apache Parquet (CVE-2025-30065)
ENGINE
- SHOW TABLE STATUS show double the row count after OPTIMIZE TABLE
- Receiving Segfault on node startup
- Error received when performing REBALANCE: Illegal mix of collations
- READ COMMITTED in SingleStore
- Connect securely to SingleStore
- Disk space got exhausted - the "logs" directory is taking too much space
REPLICATION
- Impact of frequent TRUNCATE TABLE statements on DR cluster Re-Provisioning
- Replicating MongoDB® Collections via AWS PrivateLink complete guide
- Leaf Error (127.0.0.1:3307): Unknown database 'testdb_2'
- Lag in database replication
- Paired leaf replication in High Availability vs. Load Balanced leaf replication
- Replication between clusters is not healthy
SQL
- Filtering Running Queries by Workspace Using mv_processlist
- Conditions Requiring Plan Invalidation in Plancache
- Understanding High Row Counts in Joins Involving Reference Tables
- Understanding the Impact of columnstore_segment_rows on Columnstore Table Performance
- Understanding Run Count Calculation in Workload Monitoring
- Collecting Debug Profiles for DML and SELECT Statements in Stored Procedures
STORAGE
- Preventing Disk Space Issues Due to Query Spilling
- Fragmentation on Rowstore table
- AD Authentication Error: Cannot find key for HTTP/account@DOMAIN.LOCAL kvno 4 in keytab
- Estimating size for MySQL tables when migrating to SingleStore
- When to use reference tables
- Storage in SingleStore
PIPELINE
- HDFS Pipeline ERROR: proto: hadoop_hdfs.BlockOpResponseProto: illegal tag 0 (wire type 0)
- Resolving Kafka Pipeline Batch Failures: When and How to Use the operation.timeout.ms Parameter
- Ingest data from MySQL to SingleStore (CDC-IN) using Aggregator Pipeline Syntax
- Workaround to Resolve ER_WARN_DATA_OUT_OF_RANGE (1264) for batch_id in Metrics Pipeline
- SKIP a specific file in S3 Pipelines
- Skip errors due to invalid JSON or Geospatial values during ingestion
BACKUP and RESTORE
- Using mysqldump for Backup and Restore in a Kubernetes-Based SingleStore Deployment
- How can I clone or copy a self-managed cluster?
- Best Practices for Inserting Large Volumes of Data from One Table to Another in SingleStore
- Creating a Backup in Digital Ocean Spaces
- Backup and Restore completeion
- BACKUP/RESTORE ERROR: Remote connection timed out waiting for a response from the external endpoint
DRIVERS
- Enabling Trace Logging for the SingleStore JDBC Connector
- Configuring Terraform Provider for SingleStore
- Connect ODBC for Linux using Kerberos
- Connect ODBC for Windows using Kerberos
- SingleStoreDB Spark Connector: Using a Spark job to merge a large dataset fails due to a table lock
- How to collect Power BI Logging
UPGRADE
- Troubleshooting "This node is not managed by a supported tool. Please use a toolbox version at least as new as 1.14.0" Toolbox error during a SingleStore DB Upgrade
- Downgrade SingleStore version
- I need to downgrade version of Singlestore database
- Check the status of an upgrade
- Upgrade to 7.5 with memsql-ops is failing
- Upgrading SingleStore Toolbox
MISCELLANEOUS
- Configuring query scraping for singlestore exporter
- Datagrip: Missing Source Code Error with Stored Procedure's DDL
- Error "Received HTTP/0.9 when not allowed" when using Data API
- ERROR 1045 (28000): GSS Major Error: Unspecified GSS failure. Minor code may provide more information. GSS Minor Error: Cannot find key for HTTP/memsql.s2.local@S2.LOCAL kvno 14 in keytab
- error encountered while attempting to log in with a GSSAPI user
- Unable to see the Child Aggregator node in the output of "sdb-admin list-nodes"
K8S & OPERATOR
- Permissions Required for using Unlimited Storage Databases
- License Update on SingleStore K8's Deployment
- Sync Variables with the Operator
- Custom "Height" With SingleStore Operator
- Kubernetes Service Ingress Error
- Connecting to your Kubernetes SingleStoreDB cluster
SingleStoreDB Cloud
- Understanding and resolving High Cache Utilization scenarios in your Helios Workspace Group
- Difference between Resizing, Scaling and Auto-scaling
- Modifying Organization's Name and Contact Information
- Switching between Organizations on SingleStore Helios
- Using SSL Certificate Authority (CA) verification when connecting to SingleStoreDB Cloud over a Private Connection
- Historical Workload Monitoring on SingleStore Cloud
We've got your solution
Resolve common errors with our troubleshooting guide.