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

See all 9 Articles

FAQ

• 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
• Locking database user account in SingleStore

See all 33 Articles

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

See all 29 Articles

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?

See all 8 Articles

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

See all 25 Articles

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

See all 43 Articles

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

See all 15 Articles

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

See all 7 Articles

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

See all 19 Articles

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

See all 8 Articles

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

See all 19 Articles

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

See all 11 Articles

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

See all 19 Articles

SQL

• Filter on an outer join