# Help

**URL:** https://www.singlestore.com/forum/c/support/12.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [About the Help category](https://www.singlestore.com/forum/t/about-the-help-category/28)

<div class="topic-metadata">

**Author:** [@tfly](https://www.singlestore.com/forum/u/tfly)\
**Replies:** 34\
**Last updated:** [September 16, 2025, 4:45pm UTC](https://www.singlestore.com/forum/t/about-the-help-category/28 "2025-09-16T16:45:28Z")

</div>

Have a question? Don’t scratch your head too long about it and use this help category to get quick answers from a team member or fellow community member. We’re here to support and guide; whether about SingleStore managed…

---

## [Queries got queued after disk size/performance increase on k8s (AKS)](https://www.singlestore.com/forum/t/queries-got-queued-after-disk-size-performance-increase-on-k8s-aks/8574)

<div class="topic-metadata">

**Author:** [@roslon.r](https://www.singlestore.com/forum/u/roslon.r)\
**Replies:** 3\
**Last updated:** [June 15, 2026, 9:47pm UTC](https://www.singlestore.com/forum/t/queries-got-queued-after-disk-size-performance-increase-on-k8s-aks/8574 "2026-06-15T21:47:41Z")

</div>

We have increased the disk size for our SingleStoreDB leaves from 4TB to 5TB (azure premium SSD P50 to P60). Cluster is running on AKS with nodepool based on the Standard\_E20s\_v5 VM. After that the queries got queued a…

---

## [Need clarity on how singlestore computes Total CPU percent](https://www.singlestore.com/forum/t/need-clarity-on-how-singlestore-computes-total-cpu-percent/8498)

<div class="topic-metadata">

**Author:** [@shyams](https://www.singlestore.com/forum/u/shyams)\
**Replies:** 0\
**Last updated:** [February 24, 2026, 7:36am UTC](https://www.singlestore.com/forum/t/need-clarity-on-how-singlestore-computes-total-cpu-percent/8498 "2026-02-24T07:36:50Z")

</div>

I recently came across active profiling and I’m trying to understand how does it work. So I read a blog where it mentioned upon initiating manual profiling, Singlestore takes a snapshot of the mv\_activities and after the…

---

## [Crazy disk usage in data/rem](https://www.singlestore.com/forum/t/crazy-disk-usage-in-data-rem/8056)

<div class="topic-metadata">

**Author:** [@nexuscare-lukehebb](https://www.singlestore.com/forum/u/nexuscare-lukehebb)\
**Replies:** 7\
**Last updated:** [January 9, 2026, 3:25pm UTC](https://www.singlestore.com/forum/t/crazy-disk-usage-in-data-rem/8056 "2026-01-09T15:25:57Z")

</div>

For some reason we are collecting massive amounts of data in data/rem with files named like: metrics\_singlestore-leaf-02:3306\_963371508\_50400794.rem We run SingleStore DB Version: 8.9.2, it started after the upgrade …

---

## [Does the docker developer image have any limitations for SELECT ... INTO ... KAFKA?](https://www.singlestore.com/forum/t/does-the-docker-developer-image-have-any-limitations-for-select-into-kafka/8432)

<div class="topic-metadata">

**Author:** [@dwrolfe](https://www.singlestore.com/forum/u/dwrolfe)\
**Replies:** 5\
**Last updated:** [December 9, 2025, 7:55pm UTC](https://www.singlestore.com/forum/t/does-the-docker-developer-image-have-any-limitations-for-select-into-kafka/8432 "2025-12-09T19:55:40Z")

</div>

Folks, I am using the docker developer image and want to write to Kafka: DELIMITER // CREATE OR REPLACE PROCEDURE SendToKafka(p\_userid bigint, p\_txnId TEXT) AS -- BEGIN -- SELECT userid, user\_txn\_id, txn\_time, sessi…

---

## [Docker developer image have limitations on backup commands?](https://www.singlestore.com/forum/t/docker-developer-image-have-limitations-on-backup-commands/8439)

<div class="topic-metadata">

**Author:** [@umar](https://www.singlestore.com/forum/u/umar)\
**Replies:** 1\
**Last updated:** [December 9, 2025, 7:50pm UTC](https://www.singlestore.com/forum/t/docker-developer-image-have-limitations-on-backup-commands/8439 "2025-12-09T19:50:35Z")

</div>

Hello, I am using the developer edition from here and when I attempt to run a simple command like: BACKUP DATABASE POLN TO "/opt/memsql-backups" I get an error that states: ERROR 1727 ER\_COMMUNITY\_EDITION: Feature 'di…

---

## [STRING\_SPLIT and CROSS APPLY](https://www.singlestore.com/forum/t/string-split-and-cross-apply/4792)

<div class="topic-metadata">

**Author:** [@tamara.b](https://www.singlestore.com/forum/u/tamara.b)\
**Replies:** 7\
**Last updated:** [November 21, 2025, 1:08am UTC](https://www.singlestore.com/forum/t/string-split-and-cross-apply/4792 "2025-11-21T01:08:55Z")

</div>

I’m looking for a way to do this in SingleStore: I have a column with coma separated string that I need to split to different rows and the join to the table as a new column sql server script: SELECT id, …

---

## [Increase in query time after I created a sharded key on one of the join columns](https://www.singlestore.com/forum/t/increase-in-query-time-after-i-created-a-sharded-key-on-one-of-the-join-columns/8363)

<div class="topic-metadata">

**Author:** [@shanelobo18](https://www.singlestore.com/forum/u/shanelobo18)\
**Replies:** 4\
**Last updated:** [September 15, 2025, 5:57pm UTC](https://www.singlestore.com/forum/t/increase-in-query-time-after-i-created-a-sharded-key-on-one-of-the-join-columns/8363 "2025-09-15T17:57:10Z")

</div>

Hi team, So I was using sample data from the employees table (from the s3 bucket singlestore-education/datasets/db\_employees/) and was tuning the below query SELECT e.first\_name, e.last\_name, d.dept\_name, t.title, t.fr…

---

## [Pipeline from Kafka (Confluent) gets created but doesn't ingest data](https://www.singlestore.com/forum/t/pipeline-from-kafka-confluent-gets-created-but-doesnt-ingest-data/8362)

<div class="topic-metadata">

**Author:** [@shanelobo18](https://www.singlestore.com/forum/u/shanelobo18)\
**Replies:** 4\
**Last updated:** [September 1, 2025, 11:53am UTC](https://www.singlestore.com/forum/t/pipeline-from-kafka-confluent-gets-created-but-doesnt-ingest-data/8362 "2025-09-01T11:53:33Z")

</div>

CREATE PIPELINE AS LOAD DATA KAFKA ‘host:9092/’ CONFIG ‘{“sasl.username”: “”, “sasl.mechanism”: “PLAIN”, “security.protocol”: “”, “ssl.ca.location”: “/etc/pki/ca-trust/extracted/pem/tls-ca-bundle.pem”}’ CREDENTIALS…

---

## [OOM Crashes in SingleStore on OCP](https://www.singlestore.com/forum/t/oom-crashes-in-singlestore-on-ocp/8304)

<div class="topic-metadata">

**Author:** [@Thao158](https://www.singlestore.com/forum/u/Thao158)\
**Replies:** 1\
**Last updated:** [July 31, 2025, 6:29pm UTC](https://www.singlestore.com/forum/t/oom-crashes-in-singlestore-on-ocp/8304 "2025-07-31T18:29:32Z")

</div>

Hi everyone, I’m currently running a SingleStore deployment on OpenShift (OCP) with the following setup: 6 Aggregators: Total memory per pod: 192G Maximum\_memory: 182G 20 Leaves Total memory per pod: 256G Maximum\_mem…

---

## [Create a computed/PERSISTED column with current date](https://www.singlestore.com/forum/t/create-a-computed-persisted-column-with-current-date/2776)

<div class="topic-metadata">

**Author:** [@vishwajeetdabholkar](https://www.singlestore.com/forum/u/vishwajeetdabholkar)\
**Replies:** 9\
**Last updated:** [July 21, 2025, 7:01pm UTC](https://www.singlestore.com/forum/t/create-a-computed-persisted-column-with-current-date/2776 "2025-07-21T19:01:49Z")

</div>

Hi There, I want to create a table with computed column. I wish to use current\_date as value in one of my columns named ‘l\_date’ but I am getting error. Here is my DDL: create table comp\_col( id varchar(10), name …

---

## [DECLARE TABLE & PRINT statement \[T-SQL\] Equivalent in Singlestore](https://www.singlestore.com/forum/t/declare-table-print-statement-t-sql-equivalent-in-singlestore/8263)

<div class="topic-metadata">

**Author:** [@soufiane.mbk](https://www.singlestore.com/forum/u/soufiane.mbk)\
**Replies:** 2\
**Last updated:** [June 14, 2025, 1:28am UTC](https://www.singlestore.com/forum/t/declare-table-print-statement-t-sql-equivalent-in-singlestore/8263 "2025-06-14T01:28:11Z")

</div>

Hi everybody, I hope you’re well! I’m currently working with SingleStore and I would like to know if there is an equivalent of the PRINT T-SQL statement in SingleStore stored procedure. how can i replace If not, will t…

---

## [The recovery process seems to be stuck](https://www.singlestore.com/forum/t/the-recovery-process-seems-to-be-stuck/8246)

<div class="topic-metadata">

**Author:** [@Thao158](https://www.singlestore.com/forum/u/Thao158)\
**Replies:** 1\
**Last updated:** [June 3, 2025, 11:00pm UTC](https://www.singlestore.com/forum/t/the-recovery-process-seems-to-be-stuck/8246 "2025-06-03T23:00:02Z")

</div>

Hi team, Our singlestore cluster is deployed on OCP environment, using ICOS bucket as bottomless. Recently we have seen the following error: Leaf Error (node-memsql-cluster-leaf-ag2-9.svc-memsql-cluster:3306): Failed …

---

## [Singlestore is queuing most queries, but CPU or Memory is not at maximum usage](https://www.singlestore.com/forum/t/singlestore-is-queuing-most-queries-but-cpu-or-memory-is-not-at-maximum-usage/8234)

<div class="topic-metadata">

**Author:** [@pablo\_at\_neodash](https://www.singlestore.com/forum/u/pablo_at_neodash)\
**Replies:** 1\
**Last updated:** [May 9, 2025, 10:53pm UTC](https://www.singlestore.com/forum/t/singlestore-is-queuing-most-queries-but-cpu-or-memory-is-not-at-maximum-usage/8234 "2025-05-09T22:53:00Z")

</div>

Singlestore is queuing most queries, but CPU or Memory is not at maximum usage I have version 8.9 (self-managed), and it has 5 databases. For example, one database has a table with over 70 million records. This is just …

---

## [Clarification on "OPTIMIZE TABLE" Behavior in SingleStore 5.7.32](https://www.singlestore.com/forum/t/clarification-on-optimize-table-behavior-in-singlestore-5-7-32/8227)

<div class="topic-metadata">

**Author:** [@bruce.chen](https://www.singlestore.com/forum/u/bruce.chen)\
**Replies:** 1\
**Last updated:** [May 6, 2025, 3:52pm UTC](https://www.singlestore.com/forum/t/clarification-on-optimize-table-behavior-in-singlestore-5-7-32/8227 "2025-05-06T15:52:00Z")

</div>

Hi Team, I’m currently running SingleStore version 5.7.32 (Self-Managed) and would like to clarify the behavior of the OPTIMIZE TABLE command. Specifically, I’d like to know: Does running OPTIMIZE TABLE on a rowstore…

---

## [Unusual behaviour with bottomless storage](https://www.singlestore.com/forum/t/unusual-behaviour-with-bottomless-storage/8190)

<div class="topic-metadata">

**Author:** [@buituanh2002](https://www.singlestore.com/forum/u/buituanh2002)\
**Replies:** 1\
**Last updated:** [April 22, 2025, 11:31pm UTC](https://www.singlestore.com/forum/t/unusual-behaviour-with-bottomless-storage/8190 "2025-04-22T23:31:30Z")

</div>

Hi everyone, I am currently using SingleStore Self Managed v8.1 with bottomless storage on S3 buckets. I have encountered an issue where the data volume—including actual data, blob cache, etc.—is abnormally inflated whe…

---

## [Memory Allocation Error in SingleStore for SQL Query with Aggregation](https://www.singlestore.com/forum/t/memory-allocation-error-in-singlestore-for-sql-query-with-aggregation/8178)

<div class="topic-metadata">

**Author:** [@salih.kilic](https://www.singlestore.com/forum/u/salih.kilic)\
**Replies:** 2\
**Last updated:** [April 8, 2025, 8:12am UTC](https://www.singlestore.com/forum/t/memory-allocation-error-in-singlestore-for-sql-query-with-aggregation/8178 "2025-04-08T08:12:50Z")

</div>

Hello There Community, We are encountering a recurring issue with running a specific query on our SingleStore cluster, even after restarting services and increasing the memory capacity. The query in question is as follo…

---

## [Output Parameter support in Stored Procedure](https://www.singlestore.com/forum/t/output-parameter-support-in-stored-procedure/8161)

<div class="topic-metadata">

**Author:** [@askids](https://www.singlestore.com/forum/u/askids)\
**Replies:** 3\
**Last updated:** [March 25, 2025, 1:24am UTC](https://www.singlestore.com/forum/t/output-parameter-support-in-stored-procedure/8161 "2025-03-25T01:24:53Z")

</div>

hi, Is there any plan to support Out and InOut parameters in Singlestore stored procedures? We are assessing use of Singlestore DB for replacing multiple existing applications using DB2 and Oracle, which has thousands o…

---

## [TIMESTAMP with microsecond precision because zero value is outside the scope of the parquet type - error while fetching data from SingleStore to Parquet](https://www.singlestore.com/forum/t/timestamp-with-microsecond-precision-because-zero-value-is-outside-the-scope-of-the-parquet-type-error-while-fetching-data-from-singlestore-to-parquet/8134)

<div class="topic-metadata">

**Author:** [@inshub5](https://www.singlestore.com/forum/u/inshub5)\
**Replies:** 3\
**Last updated:** [March 10, 2025, 9:49pm UTC](https://www.singlestore.com/forum/t/timestamp-with-microsecond-precision-because-zero-value-is-outside-the-scope-of-the-parquet-type-error-while-fetching-data-from-singlestore-to-parquet/8134 "2025-03-10T21:49:47Z")

</div>

I am using SELECT \* FROM … INTO S3 … FORMAT PARQUET query to fetch data out of SingleStore into S3. For one of the tables, I am getting following error: failed to format to PARQUET: failed to convert value “0000-00-00 0…

---

## [Multiple pipelines in the same S3 bucket](https://www.singlestore.com/forum/t/multiple-pipelines-in-the-same-s3-bucket/8116)

<div class="topic-metadata">

**Author:** [@suave180](https://www.singlestore.com/forum/u/suave180)\
**Replies:** 1\
**Last updated:** [February 10, 2025, 2:48pm UTC](https://www.singlestore.com/forum/t/multiple-pipelines-in-the-same-s3-bucket/8116 "2025-02-10T14:48:10Z")

</div>

Hi Team, We are currently deploying Singlestore and Minio. Currently we are setting up each bucket for each category and within the category there are few paths. We are loading files in each path using pipeline to Singl…

---

## [How to create pipeline to get data from iceberg?](https://www.singlestore.com/forum/t/how-to-create-pipeline-to-get-data-from-iceberg/8034)

<div class="topic-metadata">

**Author:** [@duchan30052002](https://www.singlestore.com/forum/u/duchan30052002)\
**Replies:** 3\
**Last updated:** [February 7, 2025, 5:13am UTC](https://www.singlestore.com/forum/t/how-to-create-pipeline-to-get-data-from-iceberg/8034 "2025-02-07T05:13:35Z")

</div>

Hi everyone, I am creating pipeline ingestion of data from iceberg as below and getting error: CREATE PIPELINE addresses\_pipe AS LOAD DATA S3 ‘’ CONFIG ‘{ “catalog\_type”: “HIVE”, “catalog.uri”: “thrift://lakehouse-hi…

---

## [How to get column names while pulling data from Singlestore into a CSV file?](https://www.singlestore.com/forum/t/how-to-get-column-names-while-pulling-data-from-singlestore-into-a-csv-file/8027)

<div class="topic-metadata">

**Author:** [@inshub5](https://www.singlestore.com/forum/u/inshub5)\
**Replies:** 4\
**Last updated:** [January 23, 2025, 5:04pm UTC](https://www.singlestore.com/forum/t/how-to-get-column-names-while-pulling-data-from-singlestore-into-a-csv-file/8027 "2025-01-23T17:04:02Z")

</div>

While pulling data from SingleStore to S3 using SELECT INTO S3, columns names are not included in CSV output files. What is the best way to include column names?

---

## [Unable to delete data before inserting does not work while altering pipeline to earliest](https://www.singlestore.com/forum/t/unable-to-delete-data-before-inserting-does-not-work-while-altering-pipeline-to-earliest/8070)

<div class="topic-metadata">

**Author:** [@Sowmya](https://www.singlestore.com/forum/u/Sowmya)\
**Replies:** 3\
**Last updated:** [January 17, 2025, 10:38am UTC](https://www.singlestore.com/forum/t/unable-to-delete-data-before-inserting-does-not-work-while-altering-pipeline-to-earliest/8070 "2025-01-17T10:38:29Z")

</div>

Dears, We will be loading data to a Singlestore Columnstore table from Kafka through a procedure and pipeline. We have encountered an issue as below: A customer uploads 3 attachments and the details of the attachment i…

---

## [Not enough disk space to create or attach database wrmd on leaf 127.0.0.1:3307](https://www.singlestore.com/forum/t/not-enough-disk-space-to-create-or-attach-database-wrmd-on-leaf-127-0-0-1-3307/8052)

<div class="topic-metadata">

**Author:** [@devin.dombrowski](https://www.singlestore.com/forum/u/devin.dombrowski)\
**Replies:** 1\
**Last updated:** [January 15, 2025, 5:06pm UTC](https://www.singlestore.com/forum/t/not-enough-disk-space-to-create-or-attach-database-wrmd-on-leaf-127-0-0-1-3307/8052 "2025-01-15T17:06:55Z")

</div>

Hello there, I’m using singlestore-labs/singlestoredb-dev-image for local development and after a few weeks of use I started getting errors concerning insufficient storage. This was odd to me since I hardly had any data …

---

## [Pipelines to Stored Procedures](https://www.singlestore.com/forum/t/pipelines-to-stored-procedures/8036)

<div class="topic-metadata">

**Author:** [@aroy](https://www.singlestore.com/forum/u/aroy)\
**Replies:** 4\
**Last updated:** [January 13, 2025, 11:01pm UTC](https://www.singlestore.com/forum/t/pipelines-to-stored-procedures/8036 "2025-01-13T23:01:04Z")

</div>

Hello Team, I have a basic question w/ref to Create Stored Procedures · SingleStore Documentation The batch datasets into the procedures need to be fed ultimately by calling a pipeline. My Question is that we merely lo…

---

## [Is OCI Object storage bucket supported for Singlestore operator backups?](https://www.singlestore.com/forum/t/is-oci-object-storage-bucket-supported-for-singlestore-operator-backups/7700)

<div class="topic-metadata">

**Author:** [@sethu.harish2912](https://www.singlestore.com/forum/u/sethu.harish2912)\
**Replies:** 5\
**Last updated:** [January 13, 2025, 10:58pm UTC](https://www.singlestore.com/forum/t/is-oci-object-storage-bucket-supported-for-singlestore-operator-backups/7700 "2025-01-13T22:58:29Z")

</div>

Hi, I am trying to deploy a backup spec for my running Singlestore k8s cluster and my environment is provisioned on OCI, and I would require the backup to sync to a OCI object storage bucket which is S3 enabled. I foll…

---

## [How to look at prepared statements?](https://www.singlestore.com/forum/t/how-to-look-at-prepared-statements/8040)

<div class="topic-metadata">

**Author:** [@jlevin2](https://www.singlestore.com/forum/u/jlevin2)\
**Replies:** 1\
**Last updated:** [January 13, 2025, 10:24pm UTC](https://www.singlestore.com/forum/t/how-to-look-at-prepared-statements/8040 "2025-01-13T22:24:51Z")

</div>

Hi, we recently hit the max\_prepared\_stmt\_count limit in our environment. We believe we have a work around but while looking at the issue I felt a bit like I was working blind. In particular I was trying to find a way …

---

## [SELECT statement or scalar in UDFs](https://www.singlestore.com/forum/t/select-statement-or-scalar-in-udfs/8075)

<div class="topic-metadata">

**Author:** [@edson.moretti](https://www.singlestore.com/forum/u/edson.moretti)\
**Replies:** 1\
**Last updated:** [January 13, 2025, 10:02pm UTC](https://www.singlestore.com/forum/t/select-statement-or-scalar-in-udfs/8075 "2025-01-13T22:02:55Z")

</div>

Hello, We are trying to create a simple function to handle currency conversion. We have a table that stores the currency conversion rates and all I wanted to do is a scalar function that takes the two currency codes and…

---

## [Unusual Index disk usage](https://www.singlestore.com/forum/t/unusual-index-disk-usage/8047)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 1\
**Last updated:** [January 2, 2025, 7:00pm UTC](https://www.singlestore.com/forum/t/unusual-index-disk-usage/8047 "2025-01-02T19:00:40Z")

</div>

One of my table has 10 GB of Index disk usage while the data disk size of the table is 3 GB. How come it is possible that index disk usage is more than data disk size?

---

## [Problem with Iceberg Catalog and Singlestore deployment on Openshift](https://www.singlestore.com/forum/t/problem-with-iceberg-catalog-and-singlestore-deployment-on-openshift/8058)

<div class="topic-metadata">

**Author:** [@buituanh2002](https://www.singlestore.com/forum/u/buituanh2002)\
**Replies:** 1\
**Last updated:** [January 2, 2025, 6:12am UTC](https://www.singlestore.com/forum/t/problem-with-iceberg-catalog-and-singlestore-deployment-on-openshift/8058 "2025-01-02T06:12:22Z")

</div>

Hi everyone, I’m new to SingleStore, so I might not have as much experience with it. I’m using SingleStore v8.9 on OpenShift, and my S3-compatible storage is exposed through both NodePort and Route in OpenShift (in the…

[Next page](https://www.singlestore.com/forum/c/support/12.md?page=1)
