`supabase db start --debug` fails with a timeout about cli

[jonsherrard]

Hello there.

I also have this issue. Macbook Pro M2 on OSX.

1. Install Supabase from Brew
2. supabase login worked properly
3. supabase init worked properly
4. supabase start --debug ends up with failed to connect to postgres: failed to connect to 'host=127.0.0.1 user=postgres database=postgres': dial error (timeout: dial tcp 127.0.0.1:54322: i/o timeout)

I generally can't inspect docker because container closes when postgres fails

I tried npx method and the @beta version too.

[sweatybridge]

What does docker inspect say after running db start? See if you can grab the output from the following steps

1. start supabase db in background

supabase db start &

2. run docker inspect

docker inspect supabase_db_<project_id>

[ric2z]

I ran only supabase db start & and it worked somehow! Not sure if this was the fix or something else I did inadvertently

[peperunas]

I am having the same issue.

It randomly "works" after a while if supabase start is spammed over and over again. Can we please re-open the issue and investigate this more?

@sweatybridge

This is the log of the spawned container:

PostgreSQL init process complete; ready for start up.

 2024-01-14 10:37:23.792 UTC [10] LOG:  pgaudit extension initialized
 2024-01-14 10:37:23.796 UTC [10] LOG:  pgsodium primary server secret key loaded
 2024-01-14 10:37:23.815 UTC [10] LOG:  starting PostgreSQL 15.1 (Ubuntu 15.1-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
 2024-01-14 10:37:23.815 UTC [10] LOG:  listening on IPv4 address "0.0.0.0", port 5432
 2024-01-14 10:37:23.815 UTC [10] LOG:  listening on IPv6 address "::", port 5432
 2024-01-14 10:37:23.817 UTC [10] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
 2024-01-14 10:37:23.819 UTC [157] LOG:  database system was shut down at 2024-01-14 10:37:23 UTC
 2024-01-14 10:37:23.823 UTC [10] LOG:  database system is ready to accept connections
 2024-01-14 10:37:23.823 UTC [160] LOG:  TimescaleDB background worker launcher connected to shared catalogs
 2024-01-14 10:37:23.825 UTC [162] LOG:  pg_cron scheduler started

[0xhank]

I am also running into this issue with a Macbook Pro M2 on OSX.

failed to connect to postgres: failed to connect to `host=127.0.0.1 user=postgres database=postgres`: dial error (timeout: dial tcp 127.0.0.1:54322: i/o timeout)

[0xhank]

It started working fine when I restarted my machine... very odd