search

sourcegraph / app

Issue tracker for the Sourcegraph app - a lightweight single-binary version of Sourcegraph for your local machine
27 stars 2 forks source link

mac: unable to set up PostgreSQL #17

Open joacim-boive opened 1 year ago

joacim-boive commented 1 year ago

Running latest MacOS Ventura 13.4 on Intel Mac. Downloaded the latest binary från here: Sourcegraph_2023.6.13+1311.1af08ae774_x64.dmg

Installed the extension in VSCode and trying to start the app after installation - getting this: [2023-06-16][12:18:26][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG* environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to connect to https://repo1.maven.org/maven2

I can browse to https://repo1.maven.org/maven

And if I do the below it seems to work from the terminal. curl -IL https://repo1.maven.org/maven2 HTTP/1.1 200 Connection established

HTTP/2 302 x-amz-error-code: Found x-amz-error-message: Resource Found location: /maven2/ content-type: text/html; charset=utf-8 via: 1.1 varnish, 1.1 varnish accept-ranges: bytes date: Fri, 16 Jun 2023 12:29:11 GMT age: 44614 x-served-by: cache-iad-kcgs7200065-IAD, cache-bma1648-BMA x-cache: HIT, HIT x-cache-hits: 18265, 1 x-timer: S1686918551.054699,VS0,VE1 vary: Fastly-SSL, content-length: 313

HTTP/2 200 last-modified: Thu, 08 Jun 2023 07:20:36 GMT etag: "623f7e0426d5aa1e2bc515092908b493" content-type: text/html via: 1.1 varnish, 1.1 varnish accept-ranges: bytes date: Fri, 16 Jun 2023 12:29:11 GMT age: 647747 x-served-by: cache-iad-kcgs7200026-IAD, cache-bma1648-BMA x-cache: HIT, HIT x-cache-hits: 2116, 4 x-timer: S1686918551.058011,VS0,VE0 content-length: 125185

However - we do have a company proxy that I suspect here anyway. Because this does work on my home M1 Mac.

Tips on how to solve this? Can I provide he proxy information or debug it somehow?

Thanks,

/J

slimsag commented 1 year ago

Hi @joacim-boive - sorry for the delay in responding to you. I am eager to figure out what's going on here. Could you try the following for me?

  1. Download the latest version here: https://sourcegraph.com/get-cody
  2. Start it, if an error occurs upload a copy of the logs
  3. Use the Clear all data and restart option (or via system tray -> Cody -> Troubleshoot -> Clear all data)

Does it start up after that?

roey-navina commented 1 year ago

Happens to me as well, here's a copy of the logs

[2023-06-30][18:18:35][ERROR][app] ✱ Sourcegraph App version: 2023.6.28+1331.1867679b11 [2023-06-30][18:18:48][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to init database using '/Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/bin/bin/initdb -A trust -U sourcegraph -D /Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/data': exit status 1 [2023-06-30][18:18:48][ERROR][app] Cody app backend terminated with exit code 1 [2023-06-30][18:19:09][ERROR][app] ✱ Sourcegraph App version: 2023.6.28+1331.1867679b11 [2023-06-30][18:19:10][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to init database using '/Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/bin/bin/initdb -A trust -U sourcegraph -D /Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/data': exit status 1 [2023-06-30][18:19:10][ERROR][app] Cody app backend terminated with exit code 1 [2023-06-30][18:20:11][ERROR][app::common] No such file or directory (os error 2) [2023-06-30][18:20:13][ERROR][app] ✱ Sourcegraph App version: 2023.6.28+1331.1867679b11 [2023-06-30][18:20:19][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG* environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to init database using '/Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/bin/bin/initdb -A trust -U sourcegraph -D /Users/XXX/Library/Application Support/com.sourcegraph.cody/postgresql/data': exit status 1 [2023-06-30][18:20:19][ERROR][app] Cody app backend terminated with exit code 1

JoshJarabek7 commented 1 year ago

Me too. The .sourcegraph-psql folder was completely empty. I ended up not going for the delete data route after I tried that a bunch of times. I ended up moving the Cody DMG over to applications and choosing to "keep both". I quit out of the original one, and clicked "Cody 2" and it ended up working and the postgresql file is there now. I also installed Sourcegraph-cli, which might have been the fix. Not sure. The logs had said that that was one of the first things it was doing.

Cody_2023.7.11+1384.7d20a90ce7_aarch64.dmg on a MacBook Pro M1 2020.

joacim-boive commented 1 year ago

@slimsag Made no difference unfortunately.

I also installed the CLI using brew.

[2023-07-27][08:27:15][ERROR][app] ✱ Sourcegraph App version: 2023.7.11+1384.7d20a90ce7 darwin amd64 [2023-07-27][08:27:45][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to connect to https://repo1.maven.org/maven2 [2023-07-27][08:27:45][ERROR][app] Cody app backend terminated with exit code 1 [2023-07-27][08:27:52][ERROR][app::common] No such file or directory (os error 2) [2023-07-27][08:27:53][ERROR][app] ✱ Sourcegraph App version: 2023.7.11+1384.7d20a90ce7 darwin amd64 [2023-07-27][08:28:23][ERROR][app] unable to set up PostgreSQL: Failed to download or start embedded postgresql. Please start your own postgres instance then configure the PG environment variables to connect to it as well as setting USE_EMBEDDED_POSTGRESQL=0: unable to connect to https://repo1.maven.org/maven2 [2023-07-27][08:28:23][ERROR][app] Cody app backend terminated with exit code 1

nilsreichardt commented 9 months ago

Same issue.

What I already tried: