Hello Meltano community! Having an issue with running

meltano install

in a docker container. @alexander_shea is our product manager and has been working with me on this. Error is as follows:

vscode ➜ /workspaces/pipeline (main) $ meltano install
2023-04-21T21:38:17.317487Z [info     ] DB connection failed. Will retry after 5s. Attempt 1/3
2023-04-21T21:38:22.323117Z [info     ] DB connection failed. Will retry after 5s. Attempt 2/3
2023-04-21T21:38:27.328860Z [info     ] DB connection failed. Will retry after 5s. Attempt 3/3
2023-04-21T21:38:32.328203Z [error    ] Could not connect to the database after 3 attempts. Max retries exceeded.
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

(sqlite3.OperationalError) unable to open database file
(Background on this error at: <https://sqlalche.me/e/14/e3q8>)

We tried starting completely from scratch with a clean container and having deleted the

.meltano

directory. Any help would be appreciated.

In the clean container we went into a new dir and ran meltano init followed by meltano install without error.

Hey folks, I'm glad you figured it out! What probably happened is Meltano can't write to the working directory of the container. So, another possible solution if you want to keep the Meltano project in the original path is to change the location of the

.meltano

directory by setting the

MELTANO_SYS_DIR_ROOT

env var and pointing it to a different path.

@edgar_ramirez_mondragon this is still an issue for us. Thanks.