Preflight Checklist

• I could not find a solution in the documentation, the existing issues or discussions
• I have joined the ZITADEL chat

Environment

Self-hosted

Version

v2.39.1

Describe the problem caused by this bug

Whenever I go to http://localhost:8080/ui/console, I get "ID=QUERY-1kIjX Message=Instance not found".
I am not able to login to Zitadel console.

To reproduce

1. Download the docker compose example configuration.
   wget https://raw.githubusercontent.com/zitadel/zitadel/main/docs/docs/self-hosting/deploy/docker-compose.yaml

2. Run the database and application containers.
   docker compose up --detach

3. Check if Zitadel version is v2.39.1 and CRDB image is v22.2.2

4. Visit
   http://localhost:8080/ui/console

Screenshots

Expected behavior

It was working fine on my windows 11, but not properly working on Ubuntu 20.04

Operating System

Ubuntu 20.04
Docker version 24.0.6, build ed223bc

Relevant Configuration

No response

Additional Context

This was the line in the log

zitadel-zitadel-1 | time="2023-10-26T04:43:53Z" level=info msg="query failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/repository/sql/query.go:113" error="ERROR: only users with the admin role are allowed to read crdb_internal.cluster_transactions (SQLSTATE 42501)"