· 7 years ago · Mar 17, 2018, 04:52 PM
1Starting docker_critiquebrainz_redis_1 ...
2Starting docker_db_test_1 ... done
3Starting docker_musicbrainz_db_1 ... done
4Starting docker_musicbrainz_db_1 ...
5Initializing the database...
6Creating tables... Traceback (most recent call last):
7 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
8 context)
9 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
10 cursor.execute(statement, parameters)
11psycopg2.ProgrammingError: relation "license" already exists
12
13
14The above exception was the direct cause of the following exception:
15
16Traceback (most recent call last):
17 File "manage.py", line 177, in <module>
18 cli()
19 File "/usr/local/lib/python3.6/site-packages/click/core.py", line 722, in __call__
20 return self.main(*args, **kwargs)
21 File "/usr/local/lib/python3.6/site-packages/click/core.py", line 697, in main
22 rv = self.invoke(ctx)
23 File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
24 return _process_result(sub_ctx.command.invoke(sub_ctx))
25 File "/usr/local/lib/python3.6/site-packages/click/core.py", line 895, in invoke
26 return ctx.invoke(self.callback, **ctx.params)
27 File "/usr/local/lib/python3.6/site-packages/click/core.py", line 535, in invoke
28 return callback(*args, **kwargs)
29 File "manage.py", line 114, in init_db
30 data_utils.create_all()
31 File "/code/critiquebrainz/data/utils.py", line 16, in create_all
32 db.run_sql_script(os.path.join(ADMIN_SQL_DIR, 'create_tables.sql'))
33 File "/code/critiquebrainz/db/__init__.py", line 26, in run_sql_script
34 connection.execute(sql.read())
35 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 939, in execute
36 return self._execute_text(object, multiparams, params)
37 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1097, in _execute_text
38 statement, parameters
39 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
40 context)
41 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
42 exc_info
43 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
44 reraise(type(exception), exception, tb=exc_tb, cause=cause)
45 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
46 raise value.with_traceback(tb)
47 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
48 context)
49 File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
50 cursor.execute(statement, parameters)
51sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "license" already exists
52 [SQL: 'BEGIN;\n\nCREATE TABLE license (\n id VARCHAR NOT NULL,\n full_name VARCHAR NOT NULL,\n info_url VARCHAR\n);\n\nCREATE TABLE moderation_log (\n id SERIAL NOT NULL,\n admin_id UUID NOT NULL,\n user_id UUID,\n review_id UUID,\n action action_types NOT NULL,\n "timestamp" TIMESTAMP NOT NULL,\n reason VARCHAR NOT NULL\n);\n\nCREATE TABLE oauth_client (\n client_id VARCHAR NOT NULL,\n client_secret VARCHAR NOT NULL,\n redirect_uri TEXT NOT NULL,\n user_id UUID,\n name VARCHAR NOT NULL,\n "desc" VARCHAR NOT NULL,\n website VARCHAR NOT NULL\n);\n\nCREATE TABLE oauth_grant (\n id SERIAL NOT NULL,\n client_id VARCHAR NOT NULL,\n code VARCHAR NOT NULL,\n expires TIMESTAMP NOT NULL,\n redirect_uri TEXT NOT NULL,\n scopes TEXT,\n user_id UUID NOT NULL\n);\n\nCREATE TABLE oauth_token (\n id SERIAL NOT NULL,\n client_id VARCHAR NOT NULL,\n access_token VARCHAR NOT NULL,\n refresh_token VARCHAR NOT NULL,\n expires TIMESTAMP NOT NULL,\n scopes TEXT,\n user_id UUID NOT NULL\n);\nALTER TABLE oauth_token ADD CONSTRAINT oauth_token_access_token_key UNIQUE (access_token);\nALTER TABLE oauth_token ADD CONSTRAINT oauth_token_refresh_token_key UNIQUE (refresh_token);\n\nCREATE TABLE review (\n id UUID NOT NULL DEFAULT uuid_generate_v4(),\n entity_id UUID NOT NULL,\n entity_type entity_types NOT NULL,\n user_id UUID NOT NULL,\n edits INTEGER NOT NULL,\n is_draft BOOLEAN NOT NULL,\n is_hidden BOOLEAN NOT NULL,\n license_id VARCHAR NOT NULL,\n language VARCHAR(3) NOT NULL,\n source VARCHAR,\n source_url VARCHAR\n);\nALTER TABLE review ADD CONSTRAINT review_entity_id_user_id_key UNIQUE (entity_id, user_id);\n\nCREATE TABLE revision (\n id SERIAL NOT NULL,\n review_id UUID,\n "timestamp" TIMESTAMP NOT NULL,\n text VARCHAR, \n rating SMALLINT CHECK (rating >= 0 AND rating <= 100)\n);\nALTER TABLE revision ADD CONSTRAINT revision_text_rating_both_not_null_together\n CHECK (rating is NOT NULL OR text is NOT NULL);\n\nCREATE TABLE avg_rating (\n entity_id UUID NOT NULL,\n entity_type entity_types NOT NULL,\n rating SMALLINT NOT NULL CHECK (rating >= 0 AND rating <= 100),\n count INTEGER NOT NULL\n);\n\nCREATE TABLE spam_report (\n user_id UUID NOT NULL,\n reason VARCHAR,\n revision_id INTEGER NOT NULL,\n reported_at TIMESTAMP NOT NULL,\n is_archived BOOLEAN NOT NULL\n);\n\nCREATE TABLE "user" (\n id UUID NOT NULL DEFAULT uuid_generate_v4(),\n display_name VARCHAR NOT NULL,\n email VARCHAR,\n created TIMESTAMP NOT NULL,\n musicbrainz_id VARCHAR,\n show_gravatar BOOLEAN NOT NULL DEFAULT False,\n is_blocked BOOLEAN NOT NULL DEFAULT False\n);\nALTER TABLE "user" ADD CONSTRAINT user_musicbrainz_id_key UNIQUE (musicbrainz_id);\n\nCREATE TABLE vote (\n user_id UUID NOT NULL,\n revision_id INTEGER NOT NULL,\n vote BOOLEAN NOT NULL,\n rated_at TIMESTAMP NOT NULL\n);\n\nCOMMIT;\n']