Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

database not found #282

Open
seabear-2001 opened this issue Jun 29, 2024 · 13 comments
Open

database not found #282

seabear-2001 opened this issue Jun 29, 2024 · 13 comments

Comments

@seabear-2001
Copy link

I use this deployment:
git clone https://github.com/metabrainz/musicbrainz-docker.git
cd musicbrainz-docker
admin/configure add musicbrainz-standalone
sudo docker-compose build
sudo docker-compose run --rm musicbrainz createdb.sh -sample -fetch
sudo docker-compose up -d

Page error:
DBI connect('dbname=musicbrainz_db;host=db;port=5432','musicbrainz',...) failed: connection to server at "db" (172.18.0.2), port 5432 failed: FATAL: database "musicbrainz_db" does not exist at lib/MusicBrainz/Server/Connector.pm line 59
Sql::select_single_value(?, ?) called at lib/MusicBrainz/Server/Data/Replication.pm line 13
MusicBrainz::Server::Data::Replication::last_replication_date(?) called at lib/MusicBrainz/Server/Controller/Root.pm line 469
Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 400
MusicBrainz::Server::ANON at lib/MusicBrainz/Server.pm line 365
MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 401
Class::MOP::Method::Wrapped::ANON(?) called at lib/MusicBrainz/Server.pm line 415
Class::MOP::Method::Wrapped::ANON(?) called at lib/MusicBrainz/Server.pm line 534

@yvanzo
Copy link
Contributor

yvanzo commented Jun 29, 2024

Hi, I just tested the same commands and it works flawlessly.

  • Do you have any other clone of musicbrainz-docker running? Or any other instance of Postgres running?
  • Where does the page error message show up?
  • Which version(s) of Docker (Compose) are you using?
    echo MusicBrainz Docker: `git describe --always --broken --dirty --tags` && \
    echo Docker Compose: `docker-compose version --short` && \
    sudo docker version -f 'Docker Client/Server: {{.Client.Version}}/{{.Server.Version}}'

@seabear-2001
Copy link
Author

seabear-2001 commented Jun 29, 2024

I only run musicbrainz-docker in docker
There is only one Postgres
The previous error is shown here: 2024-06-29 162530
After that, I executed "sudo docker-compose run --rm musicbrainz createdb.sh -fetch" and there was no problem.
But using this method takes a long time and takes up a lot of storage space
Docker is newly installed on the official website, and I deployed it on Windows 11
Docker Client/Server: 26.1.4/26.1.4

@seabear-2001
Copy link
Author

I used "admin/configure add musicbrainz-standalone" and a configure file popped up. What is it for?

@seabear-2001
Copy link
Author

I cleared and redeployed again. That's it.:图像

@yvanzo
Copy link
Contributor

yvanzo commented Jun 29, 2024

The previous error is shown here

Did you wait and retry later on? For its first run, the server takes some more time before being fully available.

deployed it on Windows 11

Windows isn’t officially supported, so that might participate to your issue too.

I cleared and redeployed again. That's it.

Should I understand that you resolved this issue just by trying again? (I cannot see the image after that.)

@seabear-2001
Copy link
Author

seabear-2001 commented Jun 30, 2024

I modified the deployment configuration, opened port 5432, and then checked the database, but it was not created.

@seabear-2001
Copy link
Author

2024-06-30 113445
/usr/local/bin/createdb.sh: Only full data can be loaded in mirror mode

@yvanzo
Copy link
Contributor

yvanzo commented Jul 2, 2024

Apparently you now have a mixed setup. I recommend to remove everything as follows:

# in the musicbrainz-docker repository
docker-compose down --volumes
rm -vf .env

Then you can restart from scratch with the instructions for test setup.

@seabear-2001
Copy link
Author

Clearing everything and trying again didn't work, still the same as before.

@seabear-2001
Copy link
Author

I think the problem is that Windows cannot use "admin/configure add musicbrainz-standalone" to set the standalone mode. How can I set it up?

@yvanzo
Copy link
Contributor

yvanzo commented Jul 5, 2024

You can try using Bash shell with WSL 2 (Windows Subsystem for Linux) support in Windows Terminal.

@wright-benjamin-1701
Copy link

I have the same issue on Pop_OS!

@yvanzo
Copy link
Contributor

yvanzo commented Dec 11, 2024

@wright-benjamin-1701 wrote:

I have the same issue on Pop_OS!

This isn’t the same host OS.
Please open a new issue with versions info, details of your own setup, and the steps that you followed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants