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
- SingleStoreDB 9.1 Release Announcement
- 2025-12-17 Version 8.9.43
- 2025-12-17 Version 9.0.16
- Alternatives to SingleStore Studio for Monitoring and SQL Access
- SingleStoreDB 9.0 Release Announcement
- SingleStoreDB 8.9 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
- Best Practices for Configuring Load Balancers in SingleStore Clusters
- 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
SECURITY
- Unauthorized File System Access in Undocumented SingleStoreDB Feature (via Pipeline Transform)
- FluentBit vulnerabilities (CVE-2025-12972, CVE-2025-12970, CVE-2025-12978, CVE-2025-12977, and CVE-2025-12969)
- LangGrinch (CVE-2025-68664): Critical LangChain Core serialization injection bug
- Shai-Hulud Worm 2.0
- React2Shell / Critical RCE Vulnerability in React Server Components and Next.JS (CVE-2025-55182 & CVE-2025-66478)
- Upgrading from SingleStore 8.5 to Receive Patches Faster
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
- OBSERVE
- Handling BOOLEAN values during Data Load
- 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
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
- spoof.dns configuration for Kafka pipelines
- 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
- SKIP a specific file in S3 Pipelines
- Skip errors due to invalid JSON or Geospatial values during ingestion
BACKUP and RESTORE
- Troubleshooting Slow RESTORE from NFS
- 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
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
- Creating a Linked Server Between SingleStoreDB Self-Managed (Linux) and SQL Server (Windows)
- Using \watch in MySQL Shell to Monitor Query Output Repeatedly
- 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
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
- Point-in-Time Recovery Capabilities: Standard vs Enterprise Editions
- Resolving the Firewall Allowlist Error for the Helios Management API
- Set retention period for Continuous Backups on Helios
- Scheduled Workspace Resizing via Management API
- Continuous Backups on Helios Workspace
- Understanding difference between memory usage in Portal and Monitoring Dashborads
We've got your solution
Resolve common errors with our troubleshooting guide.