December 17, 20169 yr Image has been rebased to alpine linux and the webui fixed. Thanks. Merry Christmas! Sent from my Nexus 6P using Tapatalk
December 17, 20169 yr 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!
December 18, 20169 yr Image has been rebased to alpine linux and the webui fixed. Thank you! Works great!
December 19, 20169 yr 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
December 19, 20169 yr 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.
December 26, 20169 yr 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.
December 29, 20169 yr Image has been rebased to alpine linux and the webui fixed. All appears to be working now! thanks so much!
February 6, 20179 yr 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
February 24, 20179 yr 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
February 27, 20179 yr 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 February 27, 20179 yr by threldor
February 27, 20179 yr 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
March 1, 20179 yr 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...
March 4, 20179 yr Author 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 March 4, 20179 yr by linuxserver.io
May 18, 20179 yr Author With the update to schema24, please remove the contents of your /config and /data folders, pull the latest image and reinitialise the database.
May 19, 20179 yr 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 May 19, 20179 yr by Keanu
May 26, 20179 yr 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 May 26, 20179 yr by Stuke00
May 26, 20179 yr 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.
May 26, 20179 yr 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
May 26, 20179 yr 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 May 26, 20179 yr by sparklyballs
May 26, 20179 yr 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!!!
May 26, 20179 yr ok @Stuke00 try pulling the latest image of musicbrainz and it should hopefully now be fixed.
May 27, 20179 yr 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
May 31, 20179 yr 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 May 31, 20179 yr by bonzi
Archived
This topic is now archived and is closed to further replies.