knalbone Posted December 17, 2016 Share Posted December 17, 2016 Image has been rebased to alpine linux and the webui fixed. Thanks. Merry Christmas! Sent from my Nexus 6P using Tapatalk Link to comment
evan Posted December 17, 2016 Share Posted December 17, 2016 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! Link to comment
DeadDjembe Posted December 18, 2016 Share Posted December 18, 2016 Image has been rebased to alpine linux and the webui fixed. Thank you! Works great! Link to comment
zybron Posted December 19, 2016 Share Posted December 19, 2016 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
sparklyballs Posted December 19, 2016 Share Posted December 19, 2016 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
Alexandro Posted December 26, 2016 Share Posted December 26, 2016 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
BurlyOaf Posted December 29, 2016 Share Posted December 29, 2016 Image has been rebased to alpine linux and the webui fixed. All appears to be working now! thanks so much! Link to comment
daemon9th Posted February 6, 2017 Share Posted February 6, 2017 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
Outlet6957 Posted February 22, 2017 Share Posted February 22, 2017 Is there a way to set a username and password ? Link to comment
skunkworx Posted February 24, 2017 Share Posted February 24, 2017 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
threldor Posted February 27, 2017 Share Posted February 27, 2017 (edited) 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, 2017 by threldor Link to comment
skunkworx Posted February 27, 2017 Share Posted February 27, 2017 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
mason Posted March 1, 2017 Share Posted March 1, 2017 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
linuxserver.io Posted March 4, 2017 Author Share Posted March 4, 2017 (edited) 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, 2017 by linuxserver.io Link to comment
Naldinho Posted April 12, 2017 Share Posted April 12, 2017 (edited) Deleted Post Edited April 12, 2017 by Naldinho Link to comment
linuxserver.io Posted May 18, 2017 Author Share Posted May 18, 2017 With the update to schema24, please remove the contents of your /config and /data folders, pull the latest image and reinitialise the database. Link to comment
Keanu Posted May 19, 2017 Share Posted May 19, 2017 (edited) 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, 2017 by Keanu Link to comment
Stuke00 Posted May 26, 2017 Share Posted May 26, 2017 (edited) 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, 2017 by Stuke00 Link to comment
sparklyballs Posted May 26, 2017 Share Posted May 26, 2017 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. 1 Link to comment
Stuke00 Posted May 26, 2017 Share Posted May 26, 2017 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
sparklyballs Posted May 26, 2017 Share Posted May 26, 2017 (edited) 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, 2017 by sparklyballs 1 Link to comment
Stuke00 Posted May 26, 2017 Share Posted May 26, 2017 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
sparklyballs Posted May 26, 2017 Share Posted May 26, 2017 ok @Stuke00 try pulling the latest image of musicbrainz and it should hopefully now be fixed. 1 Link to comment
Stuke00 Posted May 27, 2017 Share Posted May 27, 2017 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
bonzi Posted May 31, 2017 Share Posted May 31, 2017 (edited) 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, 2017 by bonzi Link to comment
Recommended Posts