Jump to content
linuxserver.io

[Support] Linuxserver.io - Musicbrainz

364 posts in this topic Last Reply

Recommended Posts

Image has been rebased to alpine linux and the webui fixed.

Thanks. Merry Christmas!

 

Sent from my Nexus 6P using Tapatalk

 

 

Share this post


Link to post

Image has been rebased to alpine linux and the webui fixed.

 

working for me! took about an hour to first start. thank you so much!

Share this post


Link to post

I'm getting the error messages below repeated about once an hour. Is there something I can tweak or modify to address this? Everything seems to be working correctly, but I wonder if I'm actually getting updates because of this.

 

ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist

STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE
WARNING: SET TRANSACTION can only be used in transaction blocks

WARNING: SET CONSTRAINTS can only be used in transaction blocks

Share this post


Link to post

I'm getting the error messages below repeated about once an hour. Is there something I can tweak or modify to address this? Everything seems to be working correctly, but I wonder if I'm actually getting updates because of this.

 

ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist

STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE
WARNING: SET TRANSACTION can only be used in transaction blocks

WARNING: SET CONSTRAINTS can only be used in transaction blocks

 

if you're getting those messages, you're getting updates.

 

in the webui at the bottom left it tells you the last replication packet.

Share this post


Link to post

please help me with the following error message i get from the web address:

 

Caught exception in MusicBrainz::Server::Controller::Root->begin "stash takes a hash or hashref at /usr/local/share/perl5/site_perl/Catalyst.pm line 599."

As I see I am not the only one with this problem.

 

Please kindly see my log file:

 

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.

[s6-init] ensuring user provided files have correct perms...exited 0.

[fix-attrs.d] applying ownership & permissions fixes...

[fix-attrs.d] done.

[cont-init.d] executing container initialization scripts...

[cont-init.d] 10-adduser: executing...

 

-------------------------------------

_ _ _

| |___| (_) ___

| / __| | |/ _ \

| \__ \ | | (_) |

|_|___/ |_|\___/

|_|

 

Brought to you by linuxserver.io

We gratefully accept donations at:

https://www.linuxserver.io/index.php/donations/

-------------------------------------

GID/UID

-------------------------------------

User uid: 99

User gid: 100

-------------------------------------

 

[cont-init.d] 10-adduser: exited 0.

[cont-init.d] 20-brainzcode: executing...

[cont-init.d] 20-brainzcode: exited 0.

[cont-init.d] 30-initialise-database: executing...

[cont-init.d] 30-initialise-database: exited 0.

[cont-init.d] 40-config: executing...

[cont-init.d] 40-config: exited 0.

[cont-init.d] done.

[services.d] starting services

[services.d] done.

 

Here how I also mounted the needed folders:

 

/config /mnt/cache/.apps/musicbrainz

/data /mnt/disk12/Media/Music-BB/

 

Thanks for your help in advance.

Share this post


Link to post

Hi,

 

Got this version mismatch error after tonights update to the docker

 

FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.5, which is not compatible with this version 9.6.1.

 

Error repeats in a continuous loop.

 

Can I do anything to upgrade or is faster to just pull and create a fresh dB?

 

thanks

 

Edit 08-02-17: I deleted the docker and image, and pulled a new copy; it sorted the problem

Share this post


Link to post
On 06/02/2017 at 10:10 PM, daemon9th said:

Hi,

 

Got this version mismatch error after tonights update to the docker

 

 


FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.5, which is not compatible with this version 9.6.1.
 

 

 

Error repeats in a continuous loop.

 

Can I do anything to upgrade or is faster to just pull and create a fresh dB?

 

thanks

 

Edit 08-02-17: I deleted the docker and image, and pulled a new copy; it sorted the problem

 

I am getting exactly the same error. I tried deleting docker and image and redownloading bust still get same error.

 

Any suggestions.

 

Regards

Skunk

Share this post


Link to post
On 2/24/2017 at 4:18 PM, skunkworx said:

 

I am getting exactly the same error. I tried deleting docker and image and redownloading bust still get same error.

 

Any suggestions.

 

Regards

Skunk

 

The problem is alpine v3.5 has postgresql version 9.6.1 and the database you have is 9.5

I did this to get it working, just install the 9.5.x version

Probably a way to update the postgresql database but i have not done that. pg_update anyone?

 

# ssh into your server
# enter musicbrain container
docker exec -it musicbrainz /bin/bash

# then inside the container at the root@87057f3a1aa1:/$ 
# delete the old postgresql
apk del postgresql
# add the v3.4 repo
echo 'http://dl-cdn.alpinelinux.org/alpine/v3.4/main' >> /etc/apk/repositories
# update
apk update
# install the 9.5.x version
apk add --no-cache postgresql=9.5.6-r0
exit

# restart your musicbrainz docker from webUI

Edit: I still have problems, but not as many. Probably don't follow the guide above.

Edited by threldor

Share this post


Link to post
14 hours ago, threldor said:

 

The problem is alpine v3.5 has postgresql version 9.6.1 and the database you have is 9.5

I did this to get it working, just install the 9.5.x version

Probably a way to update the postgresql database but i have not done that. pg_update anyone?

 

 

I assumed that there was a postgresql version mismatch. Rather than downgrading to 9.5 I decided to remove the config and data directories and force a re-download of database as if it was a fresh install.   This did throw up an error during install (see Below) this error was repeated forever.   Due to the error I still thing there is something wrong with the docker image but since I restarted the docker it seems to be working.   I did find a site where there was a method of upgrading a DB from 9.5 to 9.6.1 but I didn't try this at all.

 

STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE
WARNING: SET TRANSACTION can only be used in transaction blocks

WARNING: SET CONSTRAINTS can only be used in transaction blocks

ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist

 

Skunk

Share this post


Link to post

I just setup this docker, build the db and working fine so far. Mainly I did this to get faster lookups and not hitting any api limits.

Unfortunatly looking up albums with the Picard Tagger is even slower than with the official server, anyone knows what might be wrong there? Weblookups working fine in an instant. But if i throw a handfull albums into Picard it takes minutes...

Share this post


Link to post

Latest changes will require editing a config file with your host ip to allow CSS to display in the webui

this is due to a change in the way musicbrainz serves those files.

 

See OP for details.

Edited by linuxserver.io

Share this post


Link to post

With the update to schema24, please remove the contents of your /config and /data folders, pull the latest image and reinitialise the database.

Share this post


Link to post

Hi there,

 

I'm currently stuck on 

STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE
WARNING: SET TRANSACTION can only be used in transaction blocks

WARNING: SET CONSTRAINTS can only be used in transaction blocks

I saw above that you said it was getting updates, but I wanted to check whether or not it'd be okay to reboot the server during this time? Or if I should just leave it be?

 

Thanks,

Keanu

Edited by Keanu

Share this post


Link to post

Brand new install and I am getting this error

 

postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory

 

I have my /config pointed to /mnt/cache/appdata/musicbrainz/config and /data pointed to /mnt/cache/appdata/musicbrainz/data 

I also addedin the WEBADDRESS variable to my unraid server IP address.  Any idea what this error is or how to fix it?  When I browse /mnt/cache/musicbrainz I do not see a postgresql.conf file. 

Edited by Stuke00

Share this post


Link to post
2 hours ago, Stuke00 said:

Brand new install and I am getting this error

 

postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory

 

I have my /config pointed to /mnt/cache/appdata/musicbrainz/config and /data pointed to /mnt/cache/appdata/musicbrainz/data 

I also addedin the WEBADDRESS variable to my unraid server IP address.  Any idea what this error is or how to fix it?  When I browse /mnt/cache/musicbrainz I do not see a postgresql.conf file. 

 

I've found the issue and have put in a PR to our repo, the later build of postgres in the update is using a different location for the pid file and postgres didn't have permission on it.

Share this post


Link to post
3 minutes ago, sparklyballs said:

 

I've found the issue and have put in a PR to our repo, the later build of postgres in the update is using a different location for the pid file and postgres didn't have permission on it.

Okay thanks, I just tried what you previously suggested and ended up with the same issue.  


Here is the full log after startup

 

Brought to you by linuxserver.io
We gratefully accept donations at:
https://www.linuxserver.io/donations/
-------------------------------------
GID/UID
-------------------------------------
User uid: 99
User gid: 100
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-brainzcode: executing...
[cont-init.d] 20-brainzcode: exited 0.
[cont-init.d] 30-initialise-database: executing...
fetching latest dump from musicbrainz, if this section fails try again later as musicbrainz dump may not be fully uploaded
to their site
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed

% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
initialising empty databases
completed postgres initialise
waiting for server to start....LOG: could not create IPv6 socket: Address family not supported by protocol
FATAL: could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.
stopped waiting
[cont-init.d] 30-initialise-database: exited 1.
[cont-init.d] 35-generate_css: executing...
fatal: Not a git repository (or any of the parent directories): .git
fatal: Not a git repository (or any of the parent directories): .git
fatal: Not a git repository (or any of the parent directories): .git
[21:07:50] Using gulpfile /app/musicbrainz/gulpfile.js
[21:07:50] Starting 'default'...
[21:08:04] Finished 'default' after 14 s
[cont-init.d] 35-generate_css: exited 0.
[cont-init.d] 40-config: executing...
[cont-init.d] 40-config: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory

 

Share this post


Link to post
3 minutes ago, Stuke00 said:

Okay thanks, I just tried what you previously suggested and ended up with the same issue.  


Here is the full log after startup

 


Brought to you by linuxserver.io
We gratefully accept donations at:
https://www.linuxserver.io/donations/
-------------------------------------
GID/UID
-------------------------------------
User uid: 99
User gid: 100
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-brainzcode: executing...
[cont-init.d] 20-brainzcode: exited 0.
[cont-init.d] 30-initialise-database: executing...
fetching latest dump from musicbrainz, if this section fails try again later as musicbrainz dump may not be fully uploaded
to their site
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed

% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
initialising empty databases
completed postgres initialise
waiting for server to start....LOG: could not create IPv6 socket: Address family not supported by protocol
FATAL: could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.
stopped waiting
[cont-init.d] 30-initialise-database: exited 1.
[cont-init.d] 35-generate_css: executing...
fatal: Not a git repository (or any of the parent directories): .git
fatal: Not a git repository (or any of the parent directories): .git
fatal: Not a git repository (or any of the parent directories): .git
[21:07:50] Using gulpfile /app/musicbrainz/gulpfile.js
[21:07:50] Starting 'default'...
[21:08:04] Finished 'default' after 14 s
[cont-init.d] 35-generate_css: exited 0.
[cont-init.d] 40-config: executing...
[cont-init.d] 40-config: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory
postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory

 

 

when the PR is merged you will have to clear the contents of your appdata for musicbrainz or postgres initialisation will fail it if was interrupted. 

Edited by sparklyballs

Share this post


Link to post
Just now, sparklyballs said:

 

when the PR is merged you will have to clear the contents of your appdata or postgres initialisation will fail it if was interrupted. 

Okay thanks, I'll clear the directories again and leave the docker off until then.

 

Thanks for your help!!! 

Share this post


Link to post
15 hours ago, sparklyballs said:

ok @Stuke00 try pulling the latest image of musicbrainz and it should hopefully now be fixed. 

 

I did that last night and let it run.  Still got "postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory" but I restarted the docker again and it appears to be fine now.

 

Thanks again

Share this post


Link to post

I deleted my old image and the data/config directories and reinstalled this docker but it isn't working, see log below.

 

 

musicbrainz_log.txt

Edited by bonzi

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.