Waiting for Temporal server to start.. with scylla DB

Hi guys i am trying to connect Cassandra db (Scylla dB https://cloud.scylladb.com/) and the connection is established but the temporal server is not starting. The same when the Cassandra db is in local it was working as expected. The strange thing is it the not showing and errors except waiting temporal server to start.
Below is the configuration of docker compose


version: “3.5”
services:
elasticsearch:
container_name: temporal-elasticsearch
environment:
- cluster.routing.allocation.disk.threshold_enabled=true
- cluster.routing.allocation.disk.watermark.low=512mb
- cluster.routing.allocation.disk.watermark.high=256mb
- cluster.routing.allocation.disk.watermark.flood_stage=128mb
- discovery.type=single-node
- ES_JAVA_OPTS=-Xms256m -Xmx256m
- xpack.security.enabled=false
image: elasticsearch:${ELASTICSEARCH_VERSION}
networks:
- temporal-network
expose:
- 9200
temporal:
container_name: temporal
depends_on:
- elasticsearch
environment:
- DB=cassandra
- CASSANDRA_SEEDS=44.xxxx.26
- KEYSPACE=temporal
- CASSANDRA_USER=scylla
- CASSANDRA_PORT=9042
- CASSANDRA_ENABLE_TLS=false
- CASSANDRA_PASSWORD=l63ixxxxxxxxxxwXuy
- SKIP_DB_CREATE=true
- VISIBILITY_CASSANDRA_SEEDS=44.xxxxxxx.26
- VISIBILITY_KEYSPACE=temporal_visibility
- VISIBILITY_CASSANDRA_USER=scylla
- VISIBILITY_CASSANDRA_PORT=9042
- VISIBILITY_CASSANDRA_PASSWORD=l63xxxxxwXuy
- ENABLE_ES=true
- ES_SEEDS=elasticsearch
- ES_VERSION=v7
image: temporalio/auto-setup:${TEMPORAL_VERSION}
networks:
- temporal-network
ports:
- 7233:7233
labels:
kompose.volume.type: configMap
temporal-admin-tools:
container_name: temporal-admin-tools
depends_on:
- temporal
environment:
- TEMPORAL_CLI_ADDRESS=temporal:7233
image: temporalio/admin-tools:${TEMPORAL_VERSION}
networks:
- temporal-network
stdin_open: true
tty: true
temporal-ui:
container_name: temporal-ui
depends_on:
- temporal
environment:
- TEMPORAL_ADDRESS=temporal:7233
- TEMPORAL_CORS_ORIGINS=http://localhost:3000
image: temporalio/ui:${TEMPORAL_UI_VERSION}
networks:
- temporal-network
ports:
- 8080:8080
temporal-web:
container_name: temporal-web
depends_on:
- temporal
environment:
- TEMPORAL_GRPC_ENDPOINT=temporal:7233
- TEMPORAL_PERMIT_WRITE_API=true
image: temporalio/web:${TEMPORAL_WEB_VERSION}
networks:
- temporal-network
ports:
- 8088:8088
networks:
temporal-network:
driver: bridge
name: temporal-network


Below are the screen shots.Anyone knows the issue?

Here is the another screen shot

Hello @kiran

I have tested the docker-compose you have provided (against sclylladb) and worked for me. It takes around 1 minute to start on my machine until I see this message

{"level":"info","ts":"2022-09-14T11:41:33.473Z","msg":"Starting server for services","value":{"frontend":{},"history":{},"matching":{},"worker":{}},"logging-call-at":"server_impl.go:99"}

Do you see any other messages than Waiting for Temporal server to start.?

After your message, I waited for 15 mins but the server is not started. And I am not getting other errors also.

Did you run the database in the cloud or in a container?

And can you provide your docker-compose file?

I have tested it by connecting to https://cloud.scylladb.com/, my docker-compose is similar to yours, I have copied it and added my credentials to it. The only difference is that I had the flag SKIP_DB_CREATE=true

Can you see the tables (from both temporal and temporal_visibility) created in your cluster?

Please note that multiple users tried ScyllaDB with Temporal and ran into various corruption issues. Temporal doesn’t officially support ScyllaDB binding.

1 Like

I tried with the flag and deleted the databases and schemas which I manually created. But still, I am getting the same error “Waiting for Temporal server to start…”.

Just to add regarding:

“Waiting for Temporal server to start…”

I assume you are using auto-setup image and this message comes from here

You can try to bash into your “temporal” container and try to run
/etc/temporal/auto-setup.sh
manually see if it throws any errors (see here for the arg just fyi)

The only difference is that I had the flag SKIP_DB_CREATE=true

In this case (when you set this to true) you skip the creation of the “temporal” and “temporal_visibility” keyspaces, my guess is there is issue with that if it has to be skipped

YA, Now we have shifted to Aurora Postgres SQL. With that, it is working fine. Thanks for your suggestion

Hi @kiran you might want to try Cassandra or Astra DB as both are supported.

@kiran

here’s how to setup OSS Temporal for Astra DB, which is built on Cassandra

and I believe this is the reference for setup with OSS Cassandra: