# Operation ListOpenWorkflowExecutions encountered unconfigured table open\_executions

**URL:** <https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628>\
**Category:** Community Support\
**Tags:** helm, cassandra\
**Created:** [May 5, 2022, 5:02pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628 "2022-05-05T17:02:31Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![raghudeshu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/raghudeshu/32/1079_2.png) [@raghudeshu](https://community.temporal.io/u/raghudeshu)\
**Post date:** [May 5, 2022, 5:02pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/1 "2022-05-05T17:02:31Z")

</div>

Hello Team,

I am trying to install temporal and I am getting following errors. I am not sure why open and closed executions tables are not created (Checked in DB and its not created. Did any one faces similar issues?

Commands Used to create schema and Update Version:

1.temporal-cassandra-tool --tls --tls-disable-host-verification -p 9042 --ep XXX -u temporal -pw XXXX -k temporal setup-schema -v 0.0’  
2. temporal-cassandra-tool --tls --tls-disable-host-verification -p 9042 --ep XXXX -u temporal -pw XXXX -k 3.temporal update-schema -d ./schema/cassandra/temporal/versioned’  
temporal-cassandra-tool --tls --tls-disable-host-verification -p 9042 --ep XXX -u temporal\_visibility -pw XXXX -k temporal\_visibility setup-schema -v 0.0’  
4. temporal-cassandra-tool --tls --tls-disable-host-verification -p 9042 --ep XXX -u temporal\_visibility -pw XXXXX -k temporal\_visibility update-schema -d ./schema/cassandra/temporal/versioned’

Errors:

“error”:“operation ListOpenWorkflowExecutions encountered unconfigured table open\_executions”

“error”:“operation ListClosedWorkflowExecutions encountered unconfigured table closed\_executions”

Version Details:

repository: temporalio/server  
tag: 1.16.0

image:  
repository: temporalio/web  
tag: 1.15.0

---

<div class="post-metadata">

**Author:** ![tihomir](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/tihomir/32/6580_2.png) [@tihomir](https://community.temporal.io/u/tihomir)\
**Post date:** [May 5, 2022, 8:43pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/2 "2022-05-05T20:43:47Z")

</div>

Are you setting this up for a new cluster or trying to upgrade existing?  
I think for upgrade you only need to run the update-schema commands (see [here](https://github.com/temporalio/temporal/tree/master/tools/cassandra#update-schema-as-part-of-a-release)).

---

<div class="post-metadata">

**Author:** ![raghudeshu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/raghudeshu/32/1079_2.png) [@raghudeshu](https://community.temporal.io/u/raghudeshu)\
**Post date:** [May 5, 2022, 8:44pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/3 "2022-05-05T20:44:44Z")

</div>

I am trying to set up new cluster

---

<div class="post-metadata">

**Author:** ![tihomir](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/tihomir/32/6580_2.png) [@tihomir](https://community.temporal.io/u/tihomir)\
**Post date:** [May 5, 2022, 9:21pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/4 "2022-05-05T21:21:58Z")

</div>

These tables are created [here](https://github.com/temporalio/temporal/blob/master/schema/cassandra/visibility/schema.cql). Did you get any errors when running the visibility setup?

---

<div class="post-metadata">

**Author:** ![raghudeshu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/raghudeshu/32/1079_2.png) [@raghudeshu](https://community.temporal.io/u/raghudeshu)\
**Post date:** [May 5, 2022, 10:03pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/5 "2022-05-05T22:03:42Z")

</div>

These should be created automatically right? I did not got any errors when running the setup.

---

<div class="post-metadata">

**Author:** ![raghudeshu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/raghudeshu/32/1079_2.png) [@raghudeshu](https://community.temporal.io/u/raghudeshu)\
**Post date:** [May 6, 2022, 2:36pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/6 "2022-05-06T14:36:44Z")

</div>

Hi @tihomir -

Just a FYI when I run a visibility schema I don’t see open and closed executions tables created in logs. do you think is there any bug in the temporal version I am using.

2022-05-06T14:15:36.736Z INFO Validating connection to cassandra cluster. {“logging-call-at”: “cqlclient.go:113”}  
2022-05-06T14:15:36.946Z INFO Connection validation succeeded. {“logging-call-at”: “cqlclient.go:119”}  
2022-05-06T14:15:36.946Z INFO Starting schema setup {“config”: {“SchemaFilePath”:"",“InitialVersion”:“0.0”,“Overwrite”:false,“DisableVersioning”:false}, “logging-call-at”: “setuptask.go:57”}  
2022-05-06T14:15:36.946Z DEBUG Setting up version tables {“logging-call-at”: “setuptask.go:67”}  
2022-05-06T14:15:39.947Z DEBUG Setting initial schema version to 0.0 {“logging-call-at”: “setuptask.go:118”}  
2022-05-06T14:15:39.953Z DEBUG Updating schema update log {“logging-call-at”: “setuptask.go:123”}  
2022-05-06T14:15:39.958Z INFO Schema setup complete {“logging-call-at”: “setuptask.go:131”}

2022-05-06T14:16:02.040Z INFO Validating connection to cassandra cluster. {“logging-call-at”: “cqlclient.go:113”}  
2022-05-06T14:16:02.249Z INFO Connection validation succeeded. {“logging-call-at”: “cqlclient.go:119”}  
2022-05-06T14:16:02.249Z INFO UpdateSchemeTask started {“config”: {“DBName”:"",“TargetVersion”:"",“SchemaDir”:"./schema/cassandra/temporal/versioned",“IsDryRun”:false}, “logging-call-at”: “updatetask.go:97”}  
2022-05-06T14:16:02.253Z DEBUG Schema Dirs: [v1.0 v1.1 v1.2 v1.3 v1.4 v1.5 v1.6 v1.7] {“logging-call-at”: “updatetask.go:186”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.0/schema.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.1/cluster\_metadata.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.2/queue.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.3/visibility.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.4/executions.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.4/cluster\_metadata.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.5/event.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.5/executions.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.6/executions.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.6/cluster\_metadata\_info.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z INFO Processing schema file: ./schema/cassandra/temporal/versioned/v1.7/executions.cql {“logging-call-at”: “updatetask.go:232”}  
2022-05-06T14:16:02.254Z DEBUG ---- Executing updates for version 1.0 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:02.254Z DEBUG CREATE TYPE serialized\_event\_batch (encoding\_type text,version int,data blob); {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:03.989Z DEBUG CREATE TABLE executions (shard\_id int,type int, namespace\_id uuid,workflow\_id text,run\_id uuid,current\_run\_id uuid,visibility\_ts timestamp, task\_id bigint, shard blob,shard\_encoding text,execution blob,execution\_encoding text,execution\_state blob,execution\_state\_encoding text,transfer blob,transfer\_encoding text,replication blob,replication\_encoding text,timer blob,timer\_encoding text,next\_event\_id bigint, range\_id bigint, activity\_map map\<bigint, blob\>,activity\_map\_encoding text,timer\_map map\<text, blob\>,timer\_map\_encoding text,child\_executions\_map map\<bigint, blob\>,child\_executions\_map\_encoding text,request\_cancel\_map map\<bigint, blob\>,request\_cancel\_map\_encoding text,signal\_map map\<bigint, blob\>,signal\_map\_encoding text,signal\_requested set,buffered\_events\_list list\<frozen\<serialized\_event\_batch\>\>,replication\_metadata blob, replication\_metadata\_encoding text,workflow\_last\_write\_version bigint,workflow\_state int,checksum blob,checksum\_encoding text,PRIMARY KEY (shard\_id, type, namespace\_id, workflow\_id, run\_id, visibility\_ts, task\_id)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:05.199Z DEBUG CREATE TABLE history\_node (tree\_id uuid,branch\_id uuid,node\_id bigint, txn\_id bigint, data blob, data\_encoding text, PRIMARY KEY ((tree\_id), branch\_id, node\_id, txn\_id )) WITH CLUSTERING ORDER BY (branch\_id ASC, node\_id ASC, txn\_id DESC)AND COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:06.231Z DEBUG CREATE TABLE history\_tree (tree\_id uuid,branch\_id uuid,branch blob,branch\_encoding text,PRIMARY KEY ((tree\_id), branch\_id )) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:07.614Z DEBUG CREATE TABLE tasks (namespace\_id uuid,task\_queue\_name text,task\_queue\_type int, type int, task\_id bigint, range\_id bigint, task blob,task\_encoding text,task\_queue blob,task\_queue\_encoding text,PRIMARY KEY ((namespace\_id, task\_queue\_name, task\_queue\_type), type, task\_id)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:08.191Z DEBUG CREATE TABLE namespaces\_by\_id (id uuid,name text,PRIMARY KEY (id)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’ }; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:09.594Z DEBUG CREATE TABLE namespaces (namespaces\_partition int,name text,id uuid,detail blob,detail\_encoding text,is\_global\_namespace boolean,notification\_version bigint,PRIMARY KEY (namespaces\_partition, name)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:10.550Z DEBUG CREATE TABLE queue (queue\_type int,message\_id bigint,message\_payload blob,PRIMARY KEY (queue\_type, message\_id)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:11.120Z DEBUG CREATE TABLE queue\_metadata (queue\_type int,cluster\_ack\_level map\<text, bigint\>,version bigint,PRIMARY KEY (queue\_type)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:12.124Z DEBUG CREATE TABLE cluster\_metadata (metadata\_partition int,immutable\_data blob,immutable\_data\_encoding text,PRIMARY KEY (metadata\_partition)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:13.499Z DEBUG CREATE TABLE cluster\_membership(membership\_partition tinyint,host\_id uuid,rpc\_address inet,rpc\_port smallint,role tinyint,session\_start timestamp,last\_heartbeat timestamp,PRIMARY KEY (membership\_partition, role, host\_id)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:14.097Z DEBUG CREATE INDEX cm\_lastheartbeat\_idx on cluster\_membership (last\_heartbeat); {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:15.219Z DEBUG CREATE INDEX cm\_sessionstart\_idx on cluster\_membership (session\_start); {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:16.233Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:16.244Z DEBUG Schema updated from 0.0 to 1.0 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:16.244Z DEBUG ---- Executing updates for version 1.1 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:16.244Z DEBUG ALTER TABLE cluster\_metadata ADD data blob; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:17.636Z DEBUG ALTER TABLE cluster\_metadata ADD data\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:18.050Z DEBUG ALTER TABLE cluster\_metadata ADD version bigint; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:19.209Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:19.214Z DEBUG Schema updated from 1.0 to 1.1 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:19.214Z DEBUG ---- Executing updates for version 1.2 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:19.214Z DEBUG ALTER TABLE queue ADD message\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:20.609Z DEBUG ALTER TABLE queue\_metadata ADD data blob; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:21.215Z DEBUG ALTER TABLE queue\_metadata ADD data\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:22.589Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:22.594Z DEBUG Schema updated from 1.1 to 1.2 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:22.594Z DEBUG ---- Executing updates for version 1.3 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:22.594Z DEBUG ALTER TABLE executions ADD visibility\_task\_data blob; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:23.159Z DEBUG ALTER TABLE executions ADD visibility\_task\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:24.565Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:24.569Z DEBUG Schema updated from 1.2 to 1.3 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:24.569Z DEBUG ---- Executing updates for version 1.4 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:24.569Z DEBUG ALTER TABLE executions DROP replication\_metadata; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:25.998Z DEBUG ALTER TABLE executions DROP replication\_metadata\_encoding; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:27.663Z DEBUG ALTER TABLE cluster\_metadata DROP immutable\_data; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:28.520Z DEBUG ALTER TABLE cluster\_metadata DROP immutable\_data\_encoding; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:29.929Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:29.935Z DEBUG Schema updated from 1.3 to 1.4 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:29.935Z DEBUG ---- Executing updates for version 1.5 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:29.935Z DEBUG ALTER TABLE history\_node ADD prev\_txn\_id bigint; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:30.927Z DEBUG ALTER TABLE executions Add db\_record\_version bigint; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:32.540Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:32.546Z DEBUG Schema updated from 1.4 to 1.5 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:32.546Z DEBUG ---- Executing updates for version 1.6 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:32.546Z DEBUG ALTER TABLE executions ADD tiered\_storage\_task\_data blob; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:33.920Z DEBUG ALTER TABLE executions ADD tiered\_storage\_task\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:35.525Z DEBUG CREATE TABLE cluster\_metadata\_info (metadata\_partition int,cluster\_name text,data blob,data\_encoding text,version bigint,PRIMARY KEY (metadata\_partition, cluster\_name)) WITH COMPACTION = {‘class’: ‘org.apache.cassandra.db.compaction.LeveledCompactionStrategy’}; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:36.147Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:36.152Z DEBUG Schema updated from 1.5 to 1.6 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:36.152Z DEBUG ---- Executing updates for version 1.7 ---- {“logging-call-at”: “updatetask.go:150”}  
2022-05-06T14:16:36.152Z DEBUG ALTER TABLE executions DROP tiered\_storage\_task\_data; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:37.631Z DEBUG ALTER TABLE executions DROP tiered\_storage\_task\_encoding; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:38.659Z DEBUG ALTER TABLE executions ADD task\_data blob; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:39.656Z DEBUG ALTER TABLE executions ADD task\_encoding text; {“logging-call-at”: “updatetask.go:152”}  
2022-05-06T14:16:41.023Z DEBUG ---- Done ---- {“logging-call-at”: “updatetask.go:158”}  
2022-05-06T14:16:41.028Z DEBUG Schema updated from 1.6 to 1.7 {“logging-call-at”: “updatetask.go:142”}  
2022-05-06T14:16:41.028Z INFO UpdateSchemeTask done {“logging-call-at”: “updatetask.go:120”}

---

<div class="post-metadata">

**Author:** ![shabemdadi1](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/shabemdadi1/32/4451_2.png) [@shabemdadi1](https://community.temporal.io/u/shabemdadi1)\
**Post date:** [October 21, 2023, 12:35pm UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/7 "2023-10-21T12:35:27Z")

</div>

I am also experiencing this, was there a resolution?

---

<div class="post-metadata">

**Author:** ![rusty-jules](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/rusty-jules/32/4528_2.png) [@rusty-jules](https://community.temporal.io/u/rusty-jules)\
**Post date:** [November 10, 2023, 1:49am UTC](https://community.temporal.io/t/operation-listopenworkflowexecutions-encountered-unconfigured-table-open-executions/4628/8 "2023-11-10T01:49:02Z")

</div>

I ran into this and see the same issue I had in OP’s comment, which was not running the `temporal-cassandra-tool update-schema` on the `./schema/cassandra/visibility/versioned` directory (indeed, I had been running it on `./schema/cassandra/temporal/versioned` twice).

```sh
# after running create and schema-setup
export CASSANDRA_KEYSPACE=temporal
temporal-cassandra-tool update-schema --schema-dir ./schema/cassandra/temporal/versioned

export CASSANDRA_KEYSPACE=temporal_visibility
temporal-cassandra-tool update-schema --schema-dir ./schema/cassandra/visibility/versioned

```