Failed to commit transaction. Error: sql: transaction has already been committed or rolled back"
I think this indicates issues with your DB, possibly having too small size, or network latencies of its replies/issues with query parsers (dialect).
Also, does Yugabyte support the Cassandra protocol? Might be worth trying to use temporal cassandra config for persistence instead of what you defined in your initial post, for example: https://github.com/temporalio/temporal/blob/master/config/development.yaml#L1