Cockroach failing on fresh docker pull of latest Directus about directus HOT 7 OPEN

Worked through those errors, dropped the tables many times, ran into continous issues, its not working, it is definitely not working as intended as just connecting a cockroachdb instance fails consistently and I am unable to get things working following base documentation.

from directus.

Could you share your configuration?
What version of CockroachDB are you using?
Could it be a network problem, i.e. can you make sure that the DB is accessible from the Directus container?

from directus.

Could you share your configuration? What version of CockroachDB are you using? Could it be a network problem, i.e. can you make sure that the DB is accessible from the Directus container?

Hey mate, sure, thanks for picking this up :)

ADMIN_EMAIL=(hidden)
ADMIN_PASSWORD=(hidden)
CACHE_AUTO_PURGE=true
CACHE_ENABLED=true
CACHE_STORE=redis
DB_CLIENT=cockroachdb
DB_CONNECTION_STRING=postgresql://<user>:<password>@longstreath-1799.j77.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full
KEY=(hidden)
PUBLIC_URL=https://longstreath-crm-zemili-group.koyeb.app.
REDIS=rediss://default:(hidden)@fond-stud-49374.upstash.io:6379
SECRET=(hidden)
STORAGE_LOCATIONS=s3
STORAGE_S3_BUCKET=longstreath
STORAGE_S3_DRIVER=s3
STORAGE_S3_ENDPOINT=https://fly.storage.tigris.dev
STORAGE_S3_KEY=(hidden)
STORAGE_S3_REGION=auto
STORAGE_S3_SECRET=(hidden)
WEBSOCKETS_ENABLED=true

Using the current Cockroach Cloud clusters, using the standard CC connection strings from the dashboard. I am able to create migrations, I see migrations apearing but somewhere along the way they fail.

[23:56:52.482] WARN: Experimental alter column in use, see issue: https://github.com/cockroachdb/cockroach/issues/49329
[23:57:09.488] WARN: Experimental alter column in use, see issue: https://github.com/cockroachdb/cockroach/issues/49329
[23:57:09.488] WARN: Experimental alter column in use, see issue: https://github.com/cockroachdb/cockroach/issues/49329
Instance is stopping
[23:57:34.989] INFO: Applying Change Useragent Type...
[23:57:46.770] INFO: Applying Deprecate Webhooks...
Instance stopped

from directus.

You can see the migrations here, they are populating but the deployment fails and then I need to drop all tables and try again, but fails everytime.

from directus.

@paescuj The DB is accessible as we are creating the Directus tables but it always fails somewhere, then when the container restarts because of the failure, it fails again as tables and data already exist from the first run. See above screenshots and logs for further information.

from directus.

@paescuj Its definitely not working, did you have any luck replicating and getting it working with cockroach I've supplied everything you've asked for, do you need anything else?

from directus.

Well I guess this was the support and cry for help not answered.

from directus.