External Articles
Includes all customer-facing articles
ANNOUNCEMENTS
- SingleStoreDB 8.5 Release Announcement
- SingleStoreDB 8.0 Release Announcement
- SingleStore 7.8 Release Announcement
- Apache Log4j2 (CVE-2021-44228) Security Alert
- SingleStore 7.6 Release Announcement
- SingleStore 7.5 release announcement
FAQ
- Large Data in SingleStore ERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet' bytes
- Granting REQUIRE SSL privilege to set of users
- Disable SSL in a SingleStore cluster
- Migrating database from one cluster to another cluster
- DATABASE REPLICATION - ERROR 1037 (HY001): Out of memory; please try the operation again
- Recommended Linux Distributions
CLUSTER
- How do I enable SSL upon deployment?
- Change entire Cluster Port
- Identifying the number of successful query executions in a given time span
- YAML file for cluster migration
- A "distributed" user
- Default password for root user when SingleStore cluster is installed
REPLICATION
- 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
- Snapshots and Transaction logs used in replication
- What Is Reprovisioning?
ENGINE
- Receiving Segfault on node startup
- Error received when performing REBALANCE: Illegal mix of collations
- READ COMMITTED in SingleStore
- Assigning Resource Pool to a group of users
- Connect securely to SingleStore
- Disk space got exhausted - the "logs" directory is taking too much space
SQL
- "Table 'db_8._MV_PROCESSLIST' doesn't exist" error is received when attempting to create a new table from an Information Schema view
- Hash indexes memory usage in ROWSTORE tables
- Row locking mechanisms in SingleStore
- Illegal command warning for group by
- ON DUPLICATE KEY UPDATE
- Data sorting using GROUP_CONCAT in subquery
STORAGE
- 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
- Understanding Disk Usage
PIPELINE
- SKIP a specific file in S3 Pipelines
- Skip errors due to invalid JSON or Geospatial values during ingestion
- Investigating Pipeline Lag
- Loading pipeline in order
- Using information_schema tables to investigate pipeline issues
- Pipeline decompressing compressed file
BACKUP and RESTORE
- How can I clone or copy a self-managed cluster?
- 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
- SQL Error [2298] [HY000]: Leaf Error (x.x.x.x:3306): Could not perform remote backup. MissingAuthenticationToken: Request is missing Authentication Token
- Verifying Integrity of the FULL Backup
DRIVERS
- 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
- Creating and Calling Stored Procedure from Java
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
- 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"
- How to use XML output from SAML Chrome Panel to troubleshoot SingleStoreDB Cloud SSO Connections
K8S & OPERATOR
- License Update on SingleStore K8's Deployment
- Custom "Height" With SingleStore Operator
- Kubernetes Service Ingress Error
- Connecting to your Kubernetes SingleStoreDB cluster
- View Node (and Exporter) Logs in a Kubernetes Environment (SingleStore Operator)
- Use of SingleStore Tools with the Kubernetes Operator
SingleStoreDB Cloud
- Using SSL Certificate Authority (CA) verification when connecting to SingleStoreDB Cloud over a Private Connection
- Historical Workload Monitoring on SingleStore Cloud
- Updating Maintenance Window Schedule for SingleStore CloudDB Deployments
- Supend/Resume behaviour in a workspace group cluster
- Workspace Group ID or Cluster ID
- Rename Workspace Group