[Support] Linuxserver.io - Musicbrainz


Recommended Posts

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

Link to comment

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.

Link to comment

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.

Link to comment
  • 1 month later...

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

Link to comment
  • 3 weeks later...
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

Link to comment
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
Link to comment
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

Link to comment

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...

Link to comment
  • 1 month later...

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
Link to comment

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
Link to comment
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.

  • Upvote 1
Link to comment
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

 

Link to comment
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
  • Upvote 1
Link to comment
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!!! 

Link to comment
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

Link to comment
Guest
This topic is now closed to further replies.