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.

Sign up for GitHub

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

Jump to bottom

Problem with the development setup #161

Open
christian-heusel opened this issue Mar 25, 2022 · 0 comments
Open

Problem with the development setup #161

christian-heusel opened this issue Mar 25, 2022 · 0 comments

Comments

@christian-heusel
Copy link
Collaborator

Currently there is a problem with the initial setup for a development environment.
I assume this problem was introduced in b7ca6d7

Startup log (Click to expand) 
chris@pioneer shared_projects/muesli (master) » sudo docker-compose up             
[+] Running 6/5
 ⠿ Network muesli_default          Created                                                                                                                                                                    ⠿ Volume "muesli_db-data"         Created                                                                                                                                                                    ⠿ Container muesli-mailcatcher-1  Created                                                                                                                                                                   
 ⠿ Container muesli-postgres-1     Created                                                                                                                                                                   
 ⠿ Container muesli-redis-1        Created                                                                                                                                                                   
 ⠿ Container muesli-muesli-1       Created                                                                                                                                                                   
Attaching to muesli-mailcatcher-1, muesli-muesli-1, muesli-postgres-1, muesli-redis-1
muesli-redis-1        | 1:C 25 Mar 2022 08:47:45.287 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
muesli-redis-1        | 1:C 25 Mar 2022 08:47:45.287 # Redis version=6.2.6, bits=64, commit=00000000, modified=0, pid=1, just started
muesli-redis-1        | 1:C 25 Mar 2022 08:47:45.287 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
muesli-redis-1        | 1:M 25 Mar 2022 08:47:45.287 * monotonic clock: POSIX clock_gettime
muesli-redis-1        | 1:M 25 Mar 2022 08:47:45.288 * Running mode=standalone, port=6379.
muesli-redis-1        | 1:M 25 Mar 2022 08:47:45.288 # Server initialized
muesli-redis-1        | 1:M 25 Mar 2022 08:47:45.288 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
muesli-redis-1        | 1:M 25 Mar 2022 08:47:45.288 * Ready to accept connections
muesli-postgres-1     | The files belonging to this database system will be owned by user "postgres".
muesli-postgres-1     | This user must also own the server process.
muesli-postgres-1     | 
muesli-postgres-1     | The database cluster will be initialized with locale "en_US.utf8".
muesli-postgres-1     | The default database encoding has accordingly been set to "UTF8".
muesli-postgres-1     | The default text search configuration will be set to "english".
muesli-postgres-1     | 
muesli-postgres-1     | Data page checksums are disabled.
muesli-postgres-1     | 
muesli-postgres-1     | fixing permissions on existing directory /var/lib/postgresql/data ... ok
muesli-postgres-1     | creating subdirectories ... ok
muesli-postgres-1     | selecting default max_connections ... 100
muesli-postgres-1     | selecting default shared_buffers ... 128MB
muesli-postgres-1     | selecting default timezone ... Etc/UTC
muesli-postgres-1     | selecting dynamic shared memory implementation ... posix
muesli-postgres-1     | creating configuration files ... ok
muesli-mailcatcher-1  | Starting MailCatcher
muesli-mailcatcher-1  | ==> smtp://0.0.0.0:1025
muesli-mailcatcher-1  | /usr/local/bundle/gems/thin-1.5.1/lib/thin/server.rb:104: warning: constant ::Fixnum is deprecated
muesli-mailcatcher-1  | ==> http://0.0.0.0:1080
muesli-postgres-1     | running bootstrap script ... ok
muesli-muesli-1       | Deploying JS and CSS libs
muesli-muesli-1       | sending incremental file list
muesli-muesli-1       | css/bootstrap.min.css
muesli-muesli-1       | css/fancybox.css
muesli-muesli-1       | css/select2.min.css
muesli-muesli-1       | css/toast.min.css
muesli-muesli-1       | js/bootstrap.min.js
muesli-muesli-1       | js/captcha.min.js
muesli-muesli-1       | js/fancybox.umd.js
muesli-muesli-1       | js/jquery.min.js
muesli-muesli-1       | js/jquery.tablesorter.min.js
muesli-muesli-1       | js/popper.min.js
muesli-muesli-1       | js/select2.min.js
muesli-muesli-1       | js/toast.min.js
muesli-muesli-1       | 
muesli-muesli-1       | sent 615,680 bytes  received 250 bytes  1,231,860.00 bytes/sec
muesli-muesli-1       | total size is 614,716  speedup is 1.00
muesli-muesli-1       | Running database upgrade ... 
muesli-postgres-1     | performing post-bootstrap initialization ... ok
muesli-postgres-1     | syncing data to disk ... 
muesli-postgres-1     | WARNING: enabling "trust" authentication for local connections
muesli-postgres-1     | You can change this by editing pg_hba.conf or using the option -A, or
muesli-postgres-1     | --auth-local and --auth-host, the next time you run initdb.
muesli-postgres-1     | ok
muesli-postgres-1     | 
muesli-postgres-1     | Success. You can now start the database server using:
muesli-postgres-1     | 
muesli-postgres-1     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
muesli-postgres-1     | 
muesli-postgres-1     | waiting for server to start....2022-03-25 08:47:46.077 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
muesli-postgres-1     | 2022-03-25 08:47:46.092 UTC [49] LOG:  database system was shut down at 2022-03-25 08:47:45 UTC
muesli-postgres-1     | 2022-03-25 08:47:46.096 UTC [48] LOG:  database system is ready to accept connections
muesli-postgres-1     |  done
muesli-postgres-1     | server started
muesli-postgres-1     | 
muesli-postgres-1     | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-db.sh
muesli-postgres-1     | CREATE ROLE
muesli-postgres-1     | CREATE ROLE
muesli-postgres-1     | CREATE DATABASE
muesli-postgres-1     | CREATE DATABASE
muesli-postgres-1     | GRANT
muesli-postgres-1     | GRANT
muesli-postgres-1     | GRANT
muesli-postgres-1     | GRANT
muesli-postgres-1     | ALTER DEFAULT PRIVILEGES
muesli-postgres-1     | ALTER DEFAULT PRIVILEGES
muesli-postgres-1     | ALTER DEFAULT PRIVILEGES
muesli-postgres-1     | ALTER DEFAULT PRIVILEGES
muesli-postgres-1     | Loading development database dump
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     |  set_config 
muesli-postgres-1     | ------------
muesli-postgres-1     |  
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | SET
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.812 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.812 UTC [92] STATEMENT:  ALTER TABLE public.alembic_version OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:31: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | psql:/muesli.sql:45: ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.817 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.817 UTC [92] STATEMENT:  ALTER TABLE public.beaker_cache OWNER TO postgres;
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | psql:/muesli.sql:64: 2022-03-25 08:47:46.820 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.820 UTC [92] STATEMENT:  ALTER TABLE public.bearertokens OWNER TO postgres;
muesli-postgres-1     | ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.822 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.822 UTC [92] STATEMENT:  ALTER TABLE public.bearertokens_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:79: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.827 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.827 UTC [92] STATEMENT:  ALTER TABLE public.confirmations OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:101: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.828 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.828 UTC [92] STATEMENT:  ALTER TABLE public.email_preferences OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:114: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.829 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.829 UTC [92] STATEMENT:  ALTER TABLE public.exam_admissions OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:129: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.833 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.833 UTC [92] STATEMENT:  ALTER TABLE public.exams OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:148: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.835 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.835 UTC [92] STATEMENT:  ALTER TABLE public.exams_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:162: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.837 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.837 UTC [92] STATEMENT:  ALTER TABLE public.exercise_students OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:182: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.838 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.838 UTC [92] STATEMENT:  ALTER TABLE public.exercises OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:196: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.839 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.839 UTC [92] STATEMENT:  ALTER TABLE public.exercises_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:210: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.842 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.842 UTC [92] STATEMENT:  ALTER TABLE public.grading_exams OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:229: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.845 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.845 UTC [92] STATEMENT:  ALTER TABLE public.gradings OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:246: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.847 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.847 UTC [92] STATEMENT:  ALTER TABLE public.gradings_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:260: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.850 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.850 UTC [92] STATEMENT:  ALTER TABLE public.lecture_assistants OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:279: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.851 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.851 UTC [92] STATEMENT:  ALTER TABLE public.lecture_removed_students OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:292: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | psql:/muesli.sql:305: ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.852 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.852 UTC [92] STATEMENT:  ALTER TABLE public.lecture_students OWNER TO postgres;
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.854 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.854 UTC [92] STATEMENT:  ALTER TABLE public.lecture_tutors OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:317: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.857 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.857 UTC [92] STATEMENT:  ALTER TABLE public.lectures OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:340: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.859 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.859 UTC [92] STATEMENT:  ALTER TABLE public.lectures_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:354: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.861 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.861 UTC [92] STATEMENT:  ALTER TABLE public.student_grades OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:375: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.863 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.863 UTC [92] STATEMENT:  ALTER TABLE public.time_preferences OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:389: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.864 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.864 UTC [92] STATEMENT:  ALTER TABLE public.tutorial_preferences OWNER TO postgres;
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.870 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.870 UTC [92] STATEMENT:  ALTER TABLE public.tutorials OWNER TO postgres;
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.871 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.871 UTC [92] STATEMENT:  ALTER TABLE public.tutorials_id_seq OWNER TO postgres;
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.876 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.876 UTC [92] STATEMENT:  ALTER TABLE public.user_has_updated OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:403: ERROR:  must be member of role "postgres"
muesli-postgres-1     | psql:/muesli.sql:422: ERROR:  must be member of role "postgres"
muesli-postgres-1     | psql:/muesli.sql:436: ERROR:  must be member of role "postgres"
muesli-postgres-1     | psql:/muesli.sql:455: ERROR:  must be member of role "postgres"
muesli-postgres-1     | psql:/muesli.sql:478: ERROR:  must be member of role "postgres"
muesli-postgres-1     | CREATE TABLE
muesli-postgres-1     | 2022-03-25 08:47:46.880 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.880 UTC [92] STATEMENT:  ALTER TABLE public.users OWNER TO postgres;
muesli-postgres-1     | CREATE SEQUENCE
muesli-postgres-1     | 2022-03-25 08:47:46.882 UTC [92] ERROR:  must be member of role "postgres"
muesli-postgres-1     | 2022-03-25 08:47:46.882 UTC [92] STATEMENT:  ALTER TABLE public.users_id_seq OWNER TO postgres;
muesli-postgres-1     | psql:/muesli.sql:492: ERROR:  must be member of role "postgres"
muesli-postgres-1     | ALTER SEQUENCE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 6
muesli-postgres-1     | COPY 0
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 0
muesli-postgres-1     | COPY 2
muesli-postgres-1     | COPY 2
muesli-postgres-1     | COPY 2
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 3
muesli-postgres-1     | COPY 0
muesli-postgres-1     | COPY 3
muesli-postgres-1     | COPY 2
muesli-postgres-1     | COPY 3
muesli-postgres-1     | COPY 0
muesli-postgres-1     | COPY 1
muesli-postgres-1     | COPY 0
muesli-postgres-1     | COPY 7
muesli-postgres-1     | COPY 2
muesli-postgres-1     | COPY 12
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |       1
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |   13416
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |    6723
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |    6692
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |   20111
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |   46844
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     |  setval 
muesli-postgres-1     | --------
muesli-postgres-1     |   67209
muesli-postgres-1     | (1 row)
muesli-postgres-1     | 
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | ALTER TABLE
muesli-postgres-1     | 
muesli-postgres-1     | 2022-03-25 08:47:47.050 UTC [48] LOG:  received fast shutdown request
muesli-postgres-1     | waiting for server to shut down....2022-03-25 08:47:47.053 UTC [48] LOG:  aborting any active transactions
muesli-postgres-1     | 2022-03-25 08:47:47.055 UTC [48] LOG:  worker process: logical replication launcher (PID 55) exited with exit code 1
muesli-postgres-1     | 2022-03-25 08:47:47.055 UTC [50] LOG:  shutting down
muesli-postgres-1     | 2022-03-25 08:47:47.081 UTC [48] LOG:  database system is shut down
muesli-postgres-1     |  done
muesli-postgres-1     | server stopped
muesli-postgres-1     | 
muesli-postgres-1     | PostgreSQL init process complete; ready for start up.
muesli-postgres-1     | 
muesli-postgres-1     | 2022-03-25 08:47:47.160 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
muesli-postgres-1     | 2022-03-25 08:47:47.160 UTC [1] LOG:  listening on IPv6 address "::", port 5432
muesli-postgres-1     | 2022-03-25 08:47:47.164 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
muesli-postgres-1     | 2022-03-25 08:47:47.177 UTC [94] LOG:  database system was shut down at 2022-03-25 08:47:47 UTC
muesli-postgres-1     | 2022-03-25 08:47:47.182 UTC [1] LOG:  database system is ready to accept connections
muesli-muesli-1       | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
muesli-muesli-1       | INFO  [alembic.runtime.migration] Will assume transactional DDL.
muesli-muesli-1       | INFO  [alembic.runtime.migration] Running upgrade d3d8e4c5a116 -> 5205d0ef9d62, Add table for allocations
muesli-postgres-1     | 2022-03-25 08:47:47.270 UTC [101] ERROR:  permission denied for relation users
muesli-postgres-1     | 2022-03-25 08:47:47.270 UTC [101] STATEMENT:  
muesli-postgres-1     | 	CREATE TABLE allocation_time_preferences (
muesli-postgres-1     | 		allocation INTEGER NOT NULL, 
muesli-postgres-1     | 		student INTEGER NOT NULL, 
muesli-postgres-1     | 		time VARCHAR(7) NOT NULL, 
muesli-postgres-1     | 		penalty INTEGER NOT NULL, 
muesli-postgres-1     | 		PRIMARY KEY (allocation, student, time), 
muesli-postgres-1     | 		FOREIGN KEY(allocation) REFERENCES allocations (id) ON DELETE CASCADE, 
muesli-postgres-1     | 		FOREIGN KEY(student) REFERENCES users (id) ON DELETE CASCADE
muesli-postgres-1     | 	)
muesli-postgres-1     | 	
muesli-postgres-1     | 	
muesli-muesli-1       | Traceback (most recent call last):
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
muesli-muesli-1       |     self.dialect.do_execute(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute
muesli-muesli-1       |     cursor.execute(statement, parameters)
muesli-muesli-1       | psycopg2.errors.InsufficientPrivilege: permission denied for relation users
muesli-muesli-1       | 
muesli-muesli-1       | 
muesli-muesli-1       | The above exception was the direct cause of the following exception:
muesli-muesli-1       | 
muesli-muesli-1       | Traceback (most recent call last):
muesli-muesli-1       |   File "/usr/local/bin/alembic", line 8, in <module>
muesli-muesli-1       |     sys.exit(main())
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/config.py", line 588, in main
muesli-muesli-1       |     CommandLine(prog=prog).main(argv=argv)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/config.py", line 582, in main
muesli-muesli-1       |     self.run_cmd(cfg, options)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/config.py", line 559, in run_cmd
muesli-muesli-1       |     fn(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/command.py", line 320, in upgrade
muesli-muesli-1       |     script.run_env()
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/script/base.py", line 563, in run_env
muesli-muesli-1       |     util.load_python_file(self.dir, "env.py")
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/util/pyfiles.py", line 92, in load_python_file
muesli-muesli-1       |     module = load_module_py(module_id, path)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/util/pyfiles.py", line 108, in load_module_py
muesli-muesli-1       |     spec.loader.exec_module(module)  # type: ignore
muesli-muesli-1       |   File "<frozen importlib._bootstrap_external>", line 790, in exec_module
muesli-muesli-1       |   File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
muesli-muesli-1       |   File "alembic/env.py", line 81, in <module>
muesli-muesli-1       |     run_migrations_online()
muesli-muesli-1       |   File "alembic/env.py", line 74, in run_migrations_online
muesli-muesli-1       |     context.run_migrations()
muesli-muesli-1       |   File "<string>", line 8, in run_migrations
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/runtime/environment.py", line 851, in run_migrations
muesli-muesli-1       |     self.get_context().run_migrations(**kw)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/runtime/migration.py", line 620, in run_migrations
muesli-muesli-1       |     step.migration_fn(**kw)
muesli-muesli-1       |   File "/opt/muesli4/alembic/versions/5205d0ef9d62_add_table_for_allocations.py", line 26, in upgrade
muesli-muesli-1       |     op.create_table(
muesli-muesli-1       |   File "<string>", line 8, in create_table
muesli-muesli-1       |   File "<string>", line 3, in create_table
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/operations/ops.py", line 1254, in create_table
muesli-muesli-1       |     return operations.invoke(op)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/operations/base.py", line 392, in invoke
muesli-muesli-1       |     return fn(self, operation)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/operations/toimpl.py", line 114, in create_table
muesli-muesli-1       |     operations.impl.create_table(table)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/ddl/impl.py", line 356, in create_table
muesli-muesli-1       |     self._exec(schema.CreateTable(table))
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/alembic/ddl/impl.py", line 197, in _exec
muesli-muesli-1       |     return conn.execute(construct, multiparams)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1289, in execute
muesli-muesli-1       |     return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
muesli-muesli-1       |     return connection._execute_ddl(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1381, in _execute_ddl
muesli-muesli-1       |     ret = self._execute_context(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context
muesli-muesli-1       |     self._handle_dbapi_exception(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception
muesli-muesli-1       |     util.raise_(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/util/compat.py", line 207, in raise_
muesli-muesli-1       |     raise exception
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
muesli-muesli-1       |     self.dialect.do_execute(
muesli-muesli-1       |   File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute
muesli-muesli-1       |     cursor.execute(statement, parameters)
muesli-muesli-1       | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for relation users
muesli-muesli-1       | 
muesli-muesli-1       | [SQL: 
muesli-muesli-1       | CREATE TABLE allocation_time_preferences (
muesli-muesli-1       | 	allocation INTEGER NOT NULL, 
muesli-muesli-1       | 	student INTEGER NOT NULL, 
muesli-muesli-1       | 	time VARCHAR(7) NOT NULL, 
muesli-muesli-1       | 	penalty INTEGER NOT NULL, 
muesli-muesli-1       | 	PRIMARY KEY (allocation, student, time), 
muesli-muesli-1       | 	FOREIGN KEY(allocation) REFERENCES allocations (id) ON DELETE CASCADE, 
muesli-muesli-1       | 	FOREIGN KEY(student) REFERENCES users (id) ON DELETE CASCADE
muesli-muesli-1       | )
muesli-muesli-1       | 
muesli-muesli-1       | ]
muesli-muesli-1       | (Background on this error at: https://sqlalche.me/e/14/f405)
muesli-muesli-1       | IP-address: 172.23.0.5
muesli-muesli-1       | [uWSGI] getting INI configuration from development.ini
muesli-muesli-1       | *** Starting uWSGI 2.0.19.1-debian (64bit) on [Fri Mar 25 08:47:47 2022] ***
muesli-muesli-1       | compiled with version: 10.2.1 20210110 on 11 June 2021 09:08:33
muesli-muesli-1       | os: Linux-5.17.0-arch1-1 #1 SMP PREEMPT Tue, 22 Mar 2022 23:36:09 +0000
muesli-muesli-1       | nodename: b7b14688d287
muesli-muesli-1       | machine: x86_64
muesli-muesli-1       | clock source: unix
muesli-muesli-1       | pcre jit disabled
muesli-muesli-1       | detected number of CPU cores: 4
muesli-muesli-1       | current working directory: /opt/muesli4
muesli-muesli-1       | writing pidfile to /opt/muesli4.pid
muesli-muesli-1       | detected binary path: /usr/bin/uwsgi-core
muesli-muesli-1       | setgid() to 1000
muesli-muesli-1       | setuid() to 1000
muesli-muesli-1       | chdir() to /opt/muesli4
muesli-muesli-1       | your memory page size is 4096 bytes
muesli-muesli-1       | detected max file descriptor number: 1048576
muesli-muesli-1       | lock engine: pthread robust mutexes
muesli-muesli-1       | thunder lock: disabled (you can enable it with --thunder-lock)
muesli-muesli-1       | uwsgi socket 0 bound to TCP address :8080 fd 3
muesli-muesli-1       | Python version: 3.9.2 (default, Feb 28 2021, 17:03:44)  [GCC 10.2.1 20210110]
muesli-muesli-1       | *** Python threads support is disabled. You can enable it with --enable-threads ***
muesli-muesli-1       | Python main interpreter initialized at 0x559b65db9580
muesli-muesli-1       | your server socket listen backlog is limited to 100 connections
muesli-muesli-1       | your mercy for graceful operations on workers is 60 seconds
muesli-muesli-1       | mapped 145872 bytes (142 KB) for 1 cores
muesli-muesli-1       | *** Operational MODE: single process ***
muesli-muesli-1       | Loading paste environment: config:/opt/muesli4/development.ini
muesli-muesli-1       | WSGI app 0 (mountpoint='') ready in 2 seconds on interpreter 0x559b65db9580 pid: 25 (default app)
muesli-muesli-1       | *** uWSGI is running in multiple interpreter mode ***
muesli-muesli-1       | spawned uWSGI master process (pid: 25)
muesli-muesli-1       | spawned uWSGI worker 1 (pid: 29, cores: 1)
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/deployment"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/docker"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/api_tools"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/alembic"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/alembic/versions"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/tests"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/tests/api"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/tests/api/v1"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/static"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/static/css"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/static/js"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/yarn"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/lecture"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/user"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/tutorial"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/Fragments"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/Fragments/Format"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/Fragments/HTML"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/grading"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/templates/exam"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/pyramid_jwt"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/api"
muesli-muesli-1       | [uwsgi-fsmon] registered monitor for "/opt/muesli4/muesli/web/api/v1"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@christian-heusel