Hi all,
I had a self-managed setup which worked perfectly, I was mass migrating records which crashed SingleStore. However, now I cannot start my node as I get the following errors:
error running sdb-systemd-client: failed to start node A36121EC606A230914EBF7757B1573F8B06AD12B
Latest errors from system logs:
-- Journal begins at Fri 2023-09-15 08:08:47 UTC, ends at Fri 2023-09-15 14:13:13 UTC. --
Sep 15 10:28:59 analyse systemd[1]: Failed to start SingleStore Node A36121EC606A230914EBF7757B1573F8B06AD12B.
Sep 15 14:13:13 analyse systemd[1]: Starting SingleStore Node A36121EC606A230914EBF7757B1573F8B06AD12B...
Sep 15 14:13:13 analyse memsqlctl[2363050]: memsqlctl will perform the following actions:
Sep 15 14:13:13 analyse memsqlctl[2363050]: · Set up runtime environment
Sep 15 14:13:13 analyse memsqlctl[2363050]: · Start node with node ID A36121EC606A230914EBF7757B1573F8B06AD12B on port 3307
Sep 15 14:13:13 analyse memsqlctl[2363050]: Would you like to continue? [Y/n]:
Sep 15 14:13:13 analyse memsqlctl[2363050]: Automatically selected yes, non-interactive mode enabled
Sep 15 14:13:13 analyse memsqlctl[2363050]: Setting up runtime environment
Sep 15 14:13:13 analyse memsqlctl[2363050]: ✘ Attempted to set up runtime environment
Sep 15 14:13:13 analyse memsqlctl[2363050]: WARNING: The NICE limit should be at most -10. This system is currently configured with the limit set to 20.
Sep 15 14:13:13 analyse memsqlctl[2363050]: Please visit https://docs.singlestore.com/memsqlctl-redir/linux-ulimit-settings for more information.
Sep 15 14:13:13 analyse memsqlctl[2363050]: Starting Memsql nodes
Sep 15 14:13:13 analyse memsqlctl[2363050]: ✘ Failed to start node with node ID A36121EC606A230914EBF7757B1573F8B06AD12B (1/1)
Sep 15 14:13:13 analyse memsqlctl[2363050]: Starting nodes
Sep 15 14:13:13 analyse memsqlctl[2363050]: ✓ Started 0 nodes
Sep 15 14:13:13 analyse memsqlctl[2363050]: Failed to get errors from the database's tracelog.
Sep 15 14:13:13 analyse memsqlctl[2363050]: : the database failed to start: process exited: exit status 1
Sep 15 14:13:13 analyse systemd[1]: memsql@A36121EC606A230914EBF7757B1573F8B06AD12B.service: Main process exited, code=exited, status=1/FAILURE
Sep 15 14:13:13 analyse systemd[1]: memsql@A36121EC606A230914EBF7757B1573F8B06AD12B.service: Failed with result 'exit-code'.
Sep 15 14:13:13 analyse systemd[1]: Failed to start SingleStore Node A36121EC606A230914EBF7757B1573F8B06AD12B.
Job for memsql@A36121EC606A230914EBF7757B1573F8B06AD12B.service failed because the control process exited with error code.
See "systemctl status memsql@A36121EC606A230914EBF7757B1573F8B06AD12B.service" and "journalctl -xe" for details.: error running command: `/usr/bin/sdb-systemd-client start A36121EC606A230914EBF7757B1573F8B06AD12B ""`: exit status 1
What do I need to get it up?