singlestoredb-dev-image icon indicating copy to clipboard operation
singlestoredb-dev-image copied to clipboard

Changing the thread_stack variable value

Open msal-twingo opened this issue 1 year ago • 0 comments

Is your feature request related to a problem? Please describe. The following was tested on the latest image currently available (8.7.16). We would like be able to change the thread_stack variable. As described in documentation the variable is a "start up" variable:

You can only set this variable while the node is offline. The changes to this variable will take effect on the next start of the node.

When trying to change the variable using the proposed way of setting global variables values in "docker run command": -e SINGLESTORE_SET_GLOBAL_THREAD_STACK=4194304

The change fails (see in screenshot):

image

Describe the solution you'd like A way of changing the "start up" variables values without modifying the image itself via -e parameter or similar way.

Describe alternatives you've considered Manual workaround considered: Login to the docker shell of a running dev image instance (after it finished startup and you can connect to singlestore) In the sh shell run (without global keyword): sdb-admin update-config --key "thread_stack" --value "4194304" --all -y You should see output as in screenshot. After the command finished need to press restart near the delete button on the right or do "docker restart " in your host cli. After the restart you should see the value changed both for master + leaf. This way is problematic and cannot be used efficiently with automation:

image

Additional context Used on Docker Desktop 4.34.0 (165256) running on Mac Pro M1 (15.0.1). Docker command used:

docker run \
    -d --name singlestoredb-dev \
    -e ROOT_PASSWORD="****" \
    -e SINGLESTORE_SET_GLOBAL_THREAD_STACK=4194304 \
    --platform linux/amd64 \
    -p 3306:3306 -p 8080:8080 -p 9000:9000 \
    ghcr.io/singlestore-labs/singlestoredb-dev:latest

msal-twingo avatar Oct 10 '24 09:10 msal-twingo