# Pastebin snyJrWLs Elizabeths-MacBook-Pro:metabrainz.org Elizabeth$ docker-compose -f docker/docker-compose.dev.yml up docker_db_1 is up-to-date docker_mail_1 is up-to-date docker_redis_1 is up-to-date docker_web_1 is up-to-date Attaching to docker_db_1, docker_mail_1, docker_redis_1, docker_web_1 db_1 | The files belonging to this database system will be owned by user "postgres". db_1 | This user must also own the server process. db_1 | db_1 | The database cluster will be initialized with locale "en_US.utf8". mail_1 | + sed -ri ' db_1 | The default database encoding has accordingly been set to "UTF8". mail_1 | s/^#?(dc_local_interfaces)=.*/\1='\''0.0.0.0 ; ::0'\''/; db_1 | The default text search configuration will be set to "english". mail_1 | s/^#?(dc_other_hostnames)=.*/\1='\'''\''/; db_1 | mail_1 | s/^#?(dc_relay_nets)=.*/\1='\''172.18.0.3\/16'\''/; db_1 | Data page checksums are disabled. mail_1 | s/^#?(dc_eximconfig_configtype)=.*/\1='\''internet'\''/; web_1 | * Running on http://0.0.0.0:80/ (Press CTRL+C to quit) db_1 | mail_1 | ' /etc/exim4/update-exim4.conf.conf web_1 | * Restarting with stat db_1 | fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... ok mail_1 | + update-exim4.conf -v web_1 | * Debugger is active! db_1 | creating subdirectories ... ok web_1 | * Debugger PIN: 248-308-384 mail_1 | using non-split configuration scheme from /etc/exim4/exim4.conf.template db_1 | selecting default max_connections ... 100 web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET / HTTP/1.1" 500 - mail_1 | 274 LOG: MAIN db_1 | selecting default shared_buffers ... 128MB web_1 | Traceback (most recent call last): mail_1 | 274 exim 4.84_2 daemon started: pid=274, no queue runs, listening for SMTP on port 25 (IPv6 and IPv4) db_1 | selecting dynamic shared memory implementation ... posix web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 2000, in __call__ mail_1 | + sed -ri ' web_1 | return self.wsgi_app(environ, start_response) mail_1 | s/^#?(dc_local_interfaces)=.*/\1='\''0.0.0.0 ; ::0'\''/; db_1 | creating configuration files ... ok web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1991, in wsgi_app db_1 | creating template1 database in /var/lib/postgresql/data/pgdata/base/1 ... ok mail_1 | s/^#?(dc_other_hostnames)=.*/\1='\'''\''/; web_1 | response = self.make_response(self.handle_exception(e)) db_1 | initializing pg_authid ... ok mail_1 | s/^#?(dc_relay_nets)=.*/\1='\''172.18.0.2\/16'\''/; web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1567, in handle_exception db_1 | initializing dependencies ... ok mail_1 | s/^#?(dc_eximconfig_configtype)=.*/\1='\''internet'\''/; web_1 | reraise(exc_type, exc_value, tb) db_1 | creating system views ... ok mail_1 | ' /etc/exim4/update-exim4.conf.conf web_1 | File "/usr/local/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise db_1 | loading system objects' descriptions ... ok mail_1 | + update-exim4.conf -v web_1 | raise value db_1 | creating collations ... ok mail_1 | using non-split configuration scheme from /etc/exim4/exim4.conf.template web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app db_1 | creating conversions ... ok mail_1 | 273 LOG: MAIN db_1 | creating dictionaries ... ok web_1 | response = self.full_dispatch_request() mail_1 | 273 exim 4.84_2 daemon started: pid=273, no queue runs, listening for SMTP on port 25 (IPv6 and IPv4) db_1 | setting privileges on built-in objects ... ok web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request mail_1 | + sed -ri ' db_1 | creating information schema ... ok web_1 | rv = self.handle_user_exception(e) mail_1 | s/^#?(dc_local_interfaces)=.*/\1='\''0.0.0.0 ; ::0'\''/; db_1 | loading PL/pgSQL server-side language ... ok web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception mail_1 | s/^#?(dc_other_hostnames)=.*/\1='\'''\''/; db_1 | vacuuming database template1 ... ok web_1 | reraise(exc_type, exc_value, tb) mail_1 | s/^#?(dc_relay_nets)=.*/\1='\''172.18.0.2\/16'\''/; db_1 | copying template1 to template0 ... ok web_1 | File "/usr/local/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise mail_1 | s/^#?(dc_eximconfig_configtype)=.*/\1='\''internet'\''/; db_1 | copying template1 to postgres ... ok web_1 | raise value db_1 | syncing data to disk ... ok mail_1 | ' /etc/exim4/update-exim4.conf.conf web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request db_1 | mail_1 | + update-exim4.conf -v web_1 | rv = self.dispatch_request() db_1 | Success. You can now start the database server using: mail_1 | using non-split configuration scheme from /etc/exim4/exim4.conf.template web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request db_1 | mail_1 | 274 LOG: MAIN web_1 | return self.view_functions[rule.endpoint](**req.view_args) db_1 | pg_ctl -D /var/lib/postgresql/data/pgdata -l logfile start mail_1 | 274 exim 4.84_2 daemon started: pid=274, no queue runs, listening for SMTP on port 25 (IPv6 and IPv4) web_1 | File "/code/metabrainz/views.py", line 11, in home db_1 | web_1 | good_users=User.get_featured(limit=4, with_logos=True), db_1 | web_1 | File "/code/metabrainz/model/user.py", line 167, in get_featured db_1 | WARNING: enabling "trust" authentication for local connections web_1 | return query.order_by(func.random()).limit(limit).all() db_1 | You can change this by editing pg_hba.conf or using the option -A, or web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2588, in all db_1 | --auth-local and --auth-host, the next time you run initdb. web_1 | return list(self) db_1 | waiting for server to start....LOG: database system was shut down at 2017-05-09 10:42:11 UTC web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__ db_1 | LOG: MultiXact member wraparound protections are now enabled web_1 | return self._execute_and_instances(context) db_1 | LOG: autovacuum launcher started web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances db_1 | LOG: database system is ready to accept connections web_1 | result = conn.execute(querycontext.statement, self._params) db_1 | done web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 914, in execute web_1 | return meth(self, multiparams, params) web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection web_1 | return connection._execute_clauseelement(self, multiparams, params) db_1 | server started web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement db_1 | CREATE DATABASE web_1 | compiled_sql, distilled_params db_1 | web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context db_1 | CREATE ROLE db_1 | db_1 | db_1 | /docker-entrypoint.sh: running /docker-entrypoint-initdb.d/create_extensions.sql web_1 | context) db_1 | CREATE EXTENSION web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception db_1 | web_1 | exc_info db_1 | web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause db_1 | LOG: received fast shutdown request web_1 | reraise(type(exception), exception, tb=exc_tb, cause=exc_value) db_1 | waiting for server to shut down...LOG: aborting any active transactions redis_1 | _._ web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 182, in reraise db_1 | LOG: autovacuum launcher shutting down redis_1 | _.-``__ ''-._ web_1 | raise value.with_traceback(tb) db_1 | LOG: shutting down redis_1 | _.-`` `. `_. ''-._ Redis 3.2.1 (00000000/0) 64 bit web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context db_1 | .LOG: database system is shut down redis_1 | .-`` .-```. ```\/ _.,_ ''-._ web_1 | context) db_1 | done redis_1 | ( ' , .-` | `, ) Running in standalone mode web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute db_1 | server stopped redis_1 | |`-._`-...-` __...-.``-._|'` _.-'| Port: 6379 web_1 | cursor.execute(statement, parameters) db_1 | redis_1 | | `-._ `._ / _.-' | PID: 1 web_1 | sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "user" does not exist db_1 | PostgreSQL init process complete; ready for start up. redis_1 | `-._ `-._ `-./ _.-' _.-' web_1 | LINE 2: FROM "user" db_1 | redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| web_1 | ^ db_1 | LOG: database system was shut down at 2017-05-09 10:42:19 UTC redis_1 | | `-._`-._ _.-'_.-' | http://redis.io web_1 | [SQL: 'SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured \nFROM "user" \nWHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() \n LIMIT %(param_1)s'] [parameters: {'param_1': 4}] db_1 | LOG: MultiXact member wraparound protections are now enabled redis_1 | `-._ `-._`-.__.-'_.-' _.-' web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 - db_1 | LOG: autovacuum launcher started redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | LOG: database system is ready to accept connections redis_1 | | `-._`-._ _.-'_.-' | web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 200 - db_1 | ERROR: relation "user" does not exist at character 981 redis_1 | `-._ `-._`-.__.-'_.-' _.-' web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=jquery.js HTTP/1.1" 200 - db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | `-._ `-.__.-' _.-' web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 200 - db_1 | FROM "user" redis_1 | `-._ _.-' web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 - db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | `-.__.-' web_1 | 172.18.0.1 - - [09/May/2017 12:11:58] "GET /?__debugger__=yes&cmd=resource&f=ubuntu.ttf HTTP/1.1" 200 - db_1 | LIMIT 4 redis_1 | web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET / HTTP/1.1" 500 - db_1 | ERROR: relation "user" does not exist at character 981 redis_1 | 1:M 08 May 21:11:44.429 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | 1:M 08 May 21:11:44.470 # Server started, Redis version 3.2.1 web_1 | Traceback (most recent call last): db_1 | FROM "user" redis_1 | 1:M 08 May 21:11:44.471 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 2000, in __call__ db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | 1:M 08 May 21:11:44.471 * The server is now ready to accept connections on port 6379 web_1 | return self.wsgi_app(environ, start_response) db_1 | LIMIT 4 redis_1 | _._ web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1991, in wsgi_app db_1 | ERROR: relation "user" does not exist at character 981 redis_1 | _.-``__ ''-._ web_1 | response = self.make_response(self.handle_exception(e)) db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | _.-`` `. `_. ''-._ Redis 3.2.1 (00000000/0) 64 bit web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1567, in handle_exception db_1 | FROM "user" redis_1 | .-`` .-```. ```\/ _.,_ ''-._ web_1 | reraise(exc_type, exc_value, tb) redis_1 | ( ' , .-` | `, ) Running in standalone mode db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | File "/usr/local/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise redis_1 | |`-._`-...-` __...-.``-._|'` _.-'| Port: 6379 db_1 | LIMIT 4 web_1 | raise value redis_1 | | `-._ `._ / _.-' | PID: 1 db_1 | ERROR: relation "user" does not exist at character 981 web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app redis_1 | `-._ `-._ `-./ _.-' _.-' db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured web_1 | response = self.full_dispatch_request() redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | FROM "user" web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request redis_1 | | `-._`-._ _.-'_.-' | http://redis.io db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | rv = self.handle_user_exception(e) redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | LIMIT 4 web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | ERROR: relation "user" does not exist at character 981 web_1 | reraise(exc_type, exc_value, tb) redis_1 | | `-._`-._ _.-'_.-' | db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured web_1 | File "/usr/local/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | FROM "user" web_1 | raise value redis_1 | `-._ `-.__.-' _.-' db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request redis_1 | `-._ _.-' db_1 | LIMIT 4 web_1 | rv = self.dispatch_request() redis_1 | `-.__.-' db_1 | ERROR: relation "user" does not exist at character 981 db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured web_1 | File "/usr/local/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request redis_1 | db_1 | FROM "user" web_1 | return self.view_functions[rule.endpoint](**req.view_args) redis_1 | 1:M 09 May 10:41:35.410 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | File "/code/metabrainz/views.py", line 11, in home redis_1 | 1:M 09 May 10:41:35.563 # Server started, Redis version 3.2.1 db_1 | LIMIT 4 db_1 | ERROR: relation "user" does not exist at character 981 web_1 | good_users=User.get_featured(limit=4, with_logos=True), redis_1 | 1:M 09 May 10:41:35.563 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured web_1 | File "/code/metabrainz/model/user.py", line 167, in get_featured redis_1 | 1:M 09 May 10:41:35.564 * The server is now ready to accept connections on port 6379 db_1 | FROM "user" web_1 | return query.order_by(func.random()).limit(limit).all() redis_1 | 1:signal-handler (1494328596) Received SIGTERM scheduling shutdown... db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2588, in all redis_1 | 1:M 09 May 11:16:36.991 # User requested shutdown... db_1 | LIMIT 4 web_1 | return list(self) redis_1 | 1:M 09 May 11:16:36.992 # Redis is now ready to exit, bye bye... db_1 | ERROR: relation "user" does not exist at character 981 web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__ redis_1 | _._ db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured web_1 | return self._execute_and_instances(context) redis_1 | _.-``__ ''-._ db_1 | FROM "user" redis_1 | _.-`` `. `_. ''-._ Redis 3.2.1 (00000000/0) 64 bit web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances redis_1 | .-`` .-```. ```\/ _.,_ ''-._ db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() web_1 | result = conn.execute(querycontext.statement, self._params) redis_1 | ( ' , .-` | `, ) Running in standalone mode db_1 | LIMIT 4 web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 914, in execute redis_1 | |`-._`-...-` __...-.``-._|'` _.-'| Port: 6379 db_1 | LOG: received smart shutdown request web_1 | return meth(self, multiparams, params) redis_1 | | `-._ `._ / _.-' | PID: 1 db_1 | LOG: autovacuum launcher shutting down web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection redis_1 | `-._ `-._ `-./ _.-' _.-' db_1 | LOG: database system was interrupted; last known up at 2017-05-09 10:42:20 UTC web_1 | return connection._execute_clauseelement(self, multiparams, params) redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | LOG: database system was not properly shut down; automatic recovery in progress web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement redis_1 | | `-._`-._ _.-'_.-' | http://redis.io db_1 | LOG: invalid record length at 0/1721198 web_1 | compiled_sql, distilled_params redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | LOG: redo is not required web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | LOG: MultiXact member wraparound protections are now enabled web_1 | context) redis_1 | | `-._`-._ _.-'_.-' | db_1 | LOG: database system is ready to accept connections web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | LOG: autovacuum launcher started web_1 | exc_info redis_1 | `-._ `-.__.-' _.-' db_1 | ERROR: relation "user" does not exist at character 981 web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause redis_1 | `-._ _.-' db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | `-.__.-' web_1 | reraise(type(exception), exception, tb=exc_tb, cause=exc_value) db_1 | FROM "user" redis_1 | web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 182, in reraise db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | 1:M 09 May 11:18:33.087 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. web_1 | raise value.with_traceback(tb) db_1 | LIMIT 4 web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context redis_1 | 1:M 09 May 11:18:33.140 # Server started, Redis version 3.2.1 db_1 | ERROR: relation "user" does not exist at character 981 web_1 | context) redis_1 | 1:M 09 May 11:18:33.140 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. web_1 | File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | 1:M 09 May 11:18:33.140 * The server is now ready to accept connections on port 6379 web_1 | cursor.execute(statement, parameters) db_1 | FROM "user" redis_1 | 1:signal-handler (1494329601) Received SIGTERM scheduling shutdown... web_1 | sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "user" does not exist db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | 1:M 09 May 11:33:21.731 # User requested shutdown... web_1 | LINE 2: FROM "user" db_1 | LIMIT 4 redis_1 | 1:M 09 May 11:33:21.731 # Redis is now ready to exit, bye bye... web_1 | ^ db_1 | LOG: received smart shutdown request redis_1 | _._ web_1 | [SQL: 'SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured \nFROM "user" \nWHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() \n LIMIT %(param_1)s'] [parameters: {'param_1': 4}] db_1 | LOG: autovacuum launcher shutting down redis_1 | _.-``__ ''-._ web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET /?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 200 - db_1 | LOG: database system was interrupted; last known up at 2017-05-09 11:18:45 UTC redis_1 | _.-`` `. `_. ''-._ Redis 3.2.1 (00000000/0) 64 bit web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET /?__debugger__=yes&cmd=resource&f=jquery.js HTTP/1.1" 200 - db_1 | LOG: database system was not properly shut down; automatic recovery in progress redis_1 | .-`` .-```. ```\/ _.,_ ''-._ web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET /?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 200 - redis_1 | ( ' , .-` | `, ) Running in standalone mode web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 - db_1 | LOG: invalid record length at 0/1721208 redis_1 | |`-._`-...-` __...-.``-._|'` _.-'| Port: 6379 web_1 | 172.18.0.1 - - [09/May/2017 12:21:16] "GET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 - db_1 | LOG: redo is not required redis_1 | | `-._ `._ / _.-' | PID: 1 db_1 | LOG: MultiXact member wraparound protections are now enabled redis_1 | `-._ `-._ `-./ _.-' _.-' db_1 | LOG: database system is ready to accept connections redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | LOG: autovacuum launcher started redis_1 | | `-._`-._ _.-'_.-' | http://redis.io db_1 | ERROR: relation "user" does not exist at character 981 redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | |`-._`-._ `-.__.-' _.-'_.-'| db_1 | FROM "user" redis_1 | | `-._`-._ _.-'_.-' | db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | `-._ `-._`-.__.-'_.-' _.-' db_1 | LIMIT 4 redis_1 | `-._ `-.__.-' _.-' db_1 | ERROR: relation "user" does not exist at character 981 redis_1 | `-._ _.-' db_1 | STATEMENT: SELECT "user".id AS user_id, "user".is_commercial AS user_is_commercial, "user".musicbrainz_id AS user_musicbrainz_id, "user".created AS user_created, "user".state AS user_state, "user".contact_name AS user_contact_name, "user".contact_email AS user_contact_email, "user".data_usage_desc AS user_data_usage_desc, "user".org_name AS user_org_name, "user".logo_filename AS user_logo_filename, "user".org_logo_url AS user_org_logo_url, "user".website_url AS user_website_url, "user".api_url AS user_api_url, "user".org_desc AS user_org_desc, "user".address_street AS user_address_street, "user".address_city AS user_address_city, "user".address_state AS user_address_state, "user".address_postcode AS user_address_postcode, "user".address_country AS user_address_country, "user".tier_id AS user_tier_id, "user".amount_pledged AS user_amount_pledged, "user".good_standing AS user_good_standing, "user".in_deadbeat_club AS user_in_deadbeat_club, "user".featured AS user_featured redis_1 | `-.__.-' db_1 | FROM "user" redis_1 | db_1 | WHERE "user".featured = true AND "user".in_deadbeat_club = false AND "user".org_logo_url IS NOT NULL ORDER BY random() redis_1 | 1:M 09 May 12:11:01.101 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. db_1 | LIMIT 4 redis_1 | 1:M 09 May 12:11:01.102 # Server started, Redis version 3.2.1 redis_1 | 1:M 09 May 12:11:01.102 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. redis_1 | 1:M 09 May 12:11:01.103 * The server is now ready to accept connections on port 6379