· 6 years ago · Feb 21, 2020, 08:00 AM
1muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 ./load_sample_data.sh
2
3/usr/local/lib/python3.7/site-packages/grequests.py:21: MonkeyPatchWarning: Patching more than once will result in the union of all True parameters being patched
4 curious_george.patch_all(thread=False, select=False)
5jsonpickle is not installed. The to_json_pickle and from_json_pickle functions will not work.If you dont need those functions, there is nothing to do.
6GET http://es:9200/ [status:200 request:0.147s]
7GET http://es:9200/image/_search [status:404 request:0.173s]
8Operations to perform:
9 Apply all migrations: admin, api, auth, contenttypes, django_cron, oauth2_provider, sessions
10Running migrations:
11 Applying contenttypes.0001_initial... OK
12 Applying auth.0001_initial... OK
13 Applying admin.0001_initial... OK
14 Applying admin.0002_logentry_remove_auto_add... OK
15 Applying admin.0003_logentry_add_action_flag_choices... OK
16 Applying api.0001_initial... OK
17 Applying api.0002_auto_20180723_1737... OK
18 Applying api.0003_image_view_count... OK
19 Applying api.0004_shortenedlink... OK
20 Applying api.0005_auto_20180803_1905... OK
21 Applying api.0006_image_watermarked... OK
22 Applying api.0007_auto_20180803_1909... OK
23 Applying api.0008_imagelist_slug... OK
24 Applying api.0009_auto_20180831_1425... OK
25 Applying api.0010_auto_20180831_1815... OK
26 Applying api.0011_auto_20181117_0029... OK
27 Applying api.0012_auto_20190102_2012... OK
28 Applying api.0013_contentprovider... OK
29 Applying api.0014_auto_20190122_1853... OK
30 Applying api.0015_contentprovider_notes... OK
31 Applying api.0016_auto_20190122_1908... OK
32 Applying api.0017_remove_contentprovider_updated_on... OK
33 Applying api.0018_auto_20190122_1917... OK
34 Applying api.0019_auto_20190307_1830... OK
35 Applying api.0020_auto_20190918_1954... OK
36 Applying api.0021_deletedimages... OK
37 Applying contenttypes.0002_remove_content_type_name... OK
38 Applying auth.0002_alter_permission_name_max_length... OK
39 Applying auth.0003_alter_user_email_max_length... OK
40 Applying auth.0004_alter_user_username_opts... OK
41 Applying auth.0005_alter_user_last_login_null... OK
42 Applying auth.0006_require_contenttypes_0002... OK
43 Applying auth.0007_alter_validators_add_error_messages... OK
44 Applying auth.0008_alter_user_username_max_length... OK
45 Applying auth.0009_alter_user_last_name_max_length... OK
46 Applying auth.0010_alter_group_name_max_length... OK
47 Applying auth.0011_update_proxy_permissions... OK
48 Applying django_cron.0001_initial... OK
49 Applying django_cron.0002_remove_max_length_from_CronJobLog_message... OK
50 Applying oauth2_provider.0001_initial... OK
51 Applying oauth2_provider.0002_08_updates... OK
52 Applying oauth2_provider.0003_auto_20160316_1503... OK
53 Applying oauth2_provider.0004_auto_20160525_1623... OK
54 Applying oauth2_provider.0005_auto_20170514_1141... OK
55 Applying oauth2_provider.0006_auto_20171214_2232... OK
56 Applying sessions.0001_initial... OK
572020-02-21 07:39:52.846 WAT [37686] FATAL: role "deploy" does not exist
582020-02-21 07:39:52.853 WAT [37688] FATAL: role "deploy" does not exist
59createdb: error: could not connect to database template1: FATAL: role "deploy" does not exist
60Traceback (most recent call last):
61 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
62 return fn()
63 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
64 return _ConnectionFairy._checkout(self)
65 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
66 fairy = _ConnectionRecord.checkout(pool)
67 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
68 rec = pool._do_get()
69 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
70 return self._create_connection()
71 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
72 return _ConnectionRecord(self)
73 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
74 self.__connect(first_connect_check=True)
75 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
76 connection = pool._invoke_creator(self)
77 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
78 return dialect.connect(*cargs, **cparams)
79 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
80 return self.dbapi.connect(*cargs, **cparams)
81 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
82 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
83psycopg2.OperationalError: FATAL: database "analytics" does not exist
84
85
86The above exception was the direct cause of the following exception:
87
88Traceback (most recent call last):
89 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/bin/alembic", line 8, in <module>
90 sys.exit(main())
91 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 540, in main
92 CommandLine(prog=prog).main(argv=argv)
93 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 534, in main
94 self.run_cmd(cfg, options)
95 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 514, in run_cmd
96 **dict((k, getattr(options, k, None)) for k in kwarg)
97 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/command.py", line 276, in upgrade
98 script.run_env()
99 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/script/base.py", line 475, in run_env
100 util.load_python_file(self.dir, "env.py")
101 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
102 module = load_module_py(module_id, path)
103 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/compat.py", line 177, in load_module_py
104 spec.loader.exec_module(module)
105 File "<frozen importlib._bootstrap_external>", line 728, in exec_module
106 File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
107 File "migrations/env.py", line 77, in <module>
108 run_migrations_online()
109 File "migrations/env.py", line 65, in run_migrations_online
110 with connectable.connect() as connection:
111 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2196, in connect
112 return self._connection_cls(self, **kwargs)
113 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
114 else engine.raw_connection()
115 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2296, in raw_connection
116 self.pool.unique_connection, _connection
117 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2269, in _wrap_pool_connect
118 e, dialect, self
119 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
120 util.raise_from_cause(sqlalchemy_exception, exc_info)
121 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
122 reraise(type(exception), exception, tb=exc_tb, cause=cause)
123 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
124 raise value.with_traceback(tb)
125 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
126 return fn()
127 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
128 return _ConnectionFairy._checkout(self)
129 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
130 fairy = _ConnectionRecord.checkout(pool)
131 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
132 rec = pool._do_get()
133 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
134 return self._create_connection()
135 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
136 return _ConnectionRecord(self)
137 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
138 self.__connect(first_connect_check=True)
139 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
140 connection = pool._invoke_creator(self)
141 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
142 return dialect.connect(*cargs, **cparams)
143 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
144 return self.dbapi.connect(*cargs, **cparams)
145 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
146 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
147sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: database "analytics" does not exist
148
149(Background on this error at: http://sqlalche.me/e/e3q8)
1502020-02-21 07:39:59.412 WAT [37693] FATAL: role "deploy" does not exist
151pg_dump: error: connection to database "openledger" failed: FATAL: role "deploy" does not exist
1522020-02-21 07:39:59.439 WAT [37695] FATAL: role "deploy" does not exist
153psql: error: could not connect to server: FATAL: role "deploy" does not exist
154INSERT 0 2
155ERROR: relation "image" does not exist
156{"message": "Successfully scheduled task", "task_id": "4560b557-b5ac-4767-974f-855005421aaf", "status_check": "http://localhost:8001/task/4560b557-b5ac-4767-974f-855005421aaf"}{"message": "Successfully scheduled task", "task_id": "3390296d-a546-43f4-bee5-c85b946afe7f", "status_check": "http://localhost:8001/task/3390296d-a546-43f4-bee5-c85b946afe7f"}% muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 2020-02-21 07:43:09.294 WAT [37838] FATAL: role "root" does not exist
1572020-02-21 07:43:26.698 WAT [37843] FATAL: role "deploy" does not exist
158postgres -V postgres -V
159
160 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 postgres -V
161
162postgres (PostgreSQL) 12.2
163 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 clear ✔ 1028 07:45:04
164psql postgres
165 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 psql postgres
166psql (12.2)
167Type "help" for help.
168
169postgres=# \du
170 List of roles
171 Role name | Attributes | Member of
172-------------+------------------------------------------------------------+-----------
173 muarachmann | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
174
175postgres=# CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann'
176postgres-# \du
177 List of roles
178 Role name | Attributes | Member of
179-------------+------------------------------------------------------------+-----------
180 muarachmann | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
181
182postgres-# CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann';
1832020-02-21 07:47:18.110 WAT [38184] ERROR: syntax error at or near "CREATE" at character 51
1842020-02-21 07:47:18.110 WAT [38184] STATEMENT: CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann'
185 CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann';
186ERROR: syntax error at or near "CREATE"
187LINE 2: CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann';
188 ^
189postgres=# CREATE ROLE deploy WITH LOGIN PASSWORD 'rachmann';
190CREATE ROLE
191postgres=# \du
192 List of roles
193 Role name | Attributes | Member of
194-------------+------------------------------------------------------------+-----------
195 deploy | | {}
196 muarachmann | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
197
198postgres=# ALTER ROLE deploy CREARDB;
1992020-02-21 07:48:15.785 WAT [38184] ERROR: unrecognized role option "creardb" at character 19
2002020-02-21 07:48:15.785 WAT [38184] STATEMENT: ALTER ROLE deploy CREARDB;
201ERROR: unrecognized role option "creardb"
202LINE 1: ALTER ROLE deploy CREARDB;
203 ^
204postgres=# ALTER ROLE deploy CREATDB;
2052020-02-21 07:48:20.160 WAT [38184] ERROR: unrecognized role option "creatdb" at character 19
2062020-02-21 07:48:20.160 WAT [38184] STATEMENT: ALTER ROLE deploy CREATDB;
207ERROR: unrecognized role option "creatdb"
208LINE 1: ALTER ROLE deploy CREATDB;
209 ^
210postgres=# ALTER ROLE deploy CREATEDB;
211ALTER ROLE
212postgres=# \du
213 List of roles
214 Role name | Attributes | Member of
215-------------+------------------------------------------------------------+-----------
216 deploy | Create DB | {}
217 muarachmann | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
218
219postgres=# ALTER ROLE deploy CREATEROLE;
220ALTER ROLE
221postgres=# exit
222 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 clear ✔ 1030 07:48:42
223 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 ./load_sample_data.sh
224/usr/local/lib/python3.7/site-packages/grequests.py:21: MonkeyPatchWarning: Patching more than once will result in the union of all True parameters being patched
225 curious_george.patch_all(thread=False, select=False)
226jsonpickle is not installed. The to_json_pickle and from_json_pickle functions will not work.If you dont need those functions, there is nothing to do.
227GET http://es:9200/ [status:200 request:0.028s]
228GET http://es:9200/image/_search [status:404 request:0.016s]
229Operations to perform:
230 Apply all migrations: admin, api, auth, contenttypes, django_cron, oauth2_provider, sessions
231Running migrations:
232 No migrations to apply.
233Traceback (most recent call last):
234 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
235 return self.cursor.execute(sql, params)
236psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "auth_user_username_key"
237DETAIL: Key (username)=(continuous_integration) already exists.
238
239
240The above exception was the direct cause of the following exception:
241
242Traceback (most recent call last):
243 File "manage.py", line 17, in <module>
244 execute_from_command_line(sys.argv)
245 File "/usr/local/lib/python3.7/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
246 utility.execute()
247 File "/usr/local/lib/python3.7/site-packages/django/core/management/__init__.py", line 375, in execute
248 self.fetch_command(subcommand).run_from_argv(self.argv)
249 File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 323, in run_from_argv
250 self.execute(*args, **cmd_options)
251 File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 364, in execute
252 output = self.handle(*args, **options)
253 File "/usr/local/lib/python3.7/site-packages/django/core/management/commands/shell.py", line 86, in handle
254 exec(options['command'])
255 File "<string>", line 2, in <module>
256 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/models.py", line 151, in create_user
257 return self._create_user(username, email, password, **extra_fields)
258 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/models.py", line 145, in _create_user
259 user.save(using=self._db)
260 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/base_user.py", line 66, in save
261 super().save(*args, **kwargs)
262 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 741, in save
263 force_update=force_update, update_fields=update_fields)
264 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 779, in save_base
265 force_update, using, update_fields,
266 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 870, in _save_table
267 result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
268 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 908, in _do_insert
269 using=using, raw=raw)
270 File "/usr/local/lib/python3.7/site-packages/django/db/models/manager.py", line 82, in manager_method
271 return getattr(self.get_queryset(), name)(*args, **kwargs)
272 File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py", line 1186, in _insert
273 return query.get_compiler(using=using).execute_sql(return_id)
274 File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1368, in execute_sql
275 cursor.execute(sql, params)
276 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 99, in execute
277 return super().execute(sql, params)
278 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 67, in execute
279 return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
280 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
281 return executor(sql, params, many, context)
282 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
283 return self.cursor.execute(sql, params)
284 File "/usr/local/lib/python3.7/site-packages/django/db/utils.py", line 89, in __exit__
285 raise dj_exc_value.with_traceback(traceback) from exc_value
286 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
287 return self.cursor.execute(sql, params)
288django.db.utils.IntegrityError: duplicate key value violates unique constraint "auth_user_username_key"
289DETAIL: Key (username)=(continuous_integration) already exists.
290
291Traceback (most recent call last):
292 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
293 return fn()
294 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
295 return _ConnectionFairy._checkout(self)
296 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
297 fairy = _ConnectionRecord.checkout(pool)
298 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
299 rec = pool._do_get()
300 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
301 return self._create_connection()
302 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
303 return _ConnectionRecord(self)
304 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
305 self.__connect(first_connect_check=True)
306 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
307 connection = pool._invoke_creator(self)
308 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
309 return dialect.connect(*cargs, **cparams)
310 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
311 return self.dbapi.connect(*cargs, **cparams)
312 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
313 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
314psycopg2.OperationalError: FATAL: database "analytics" does not exist
315
316
317The above exception was the direct cause of the following exception:
318
319Traceback (most recent call last):
320 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/bin/alembic", line 8, in <module>
321 sys.exit(main())
322 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 540, in main
323 CommandLine(prog=prog).main(argv=argv)
324 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 534, in main
325 self.run_cmd(cfg, options)
326 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 514, in run_cmd
327 **dict((k, getattr(options, k, None)) for k in kwarg)
328 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/command.py", line 276, in upgrade
329 script.run_env()
330 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/script/base.py", line 475, in run_env
331 util.load_python_file(self.dir, "env.py")
332 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
333 module = load_module_py(module_id, path)
334 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/compat.py", line 177, in load_module_py
335 spec.loader.exec_module(module)
336 File "<frozen importlib._bootstrap_external>", line 728, in exec_module
337 File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
338 File "migrations/env.py", line 77, in <module>
339 run_migrations_online()
340 File "migrations/env.py", line 65, in run_migrations_online
341 with connectable.connect() as connection:
342 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2196, in connect
343 return self._connection_cls(self, **kwargs)
344 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
345 else engine.raw_connection()
346 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2296, in raw_connection
347 self.pool.unique_connection, _connection
348 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2269, in _wrap_pool_connect
349 e, dialect, self
350 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
351 util.raise_from_cause(sqlalchemy_exception, exc_info)
352 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
353 reraise(type(exception), exception, tb=exc_tb, cause=cause)
354 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
355 raise value.with_traceback(tb)
356 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
357 return fn()
358 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
359 return _ConnectionFairy._checkout(self)
360 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
361 fairy = _ConnectionRecord.checkout(pool)
362 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
363 rec = pool._do_get()
364 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
365 return self._create_connection()
366 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
367 return _ConnectionRecord(self)
368 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
369 self.__connect(first_connect_check=True)
370 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
371 connection = pool._invoke_creator(self)
372 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
373 return dialect.connect(*cargs, **cparams)
374 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
375 return self.dbapi.connect(*cargs, **cparams)
376 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
377 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
378sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: database "analytics" does not exist
379
380(Background on this error at: http://sqlalche.me/e/e3q8)
3812020-02-21 07:48:55.654 WAT [38466] FATAL: database "openledger" does not exist
382pg_dump: error: connection to database "openledger" failed: FATAL: database "openledger" does not exist
3832020-02-21 07:48:55.696 WAT [38468] FATAL: database "openledger" does not exist
384psql: error: could not connect to server: FATAL: database "openledger" does not exist
385ERROR: relation "content_provider" already exists
386ERROR: relation "image" does not exist
387{"message": "Successfully scheduled task", "task_id": "be814b54-bc97-421d-875b-0fcf373530b0", "status_check": "http://localhost:8001/task/be814b54-bc97-421d-875b-0fcf373530b0"}{"message": "Failed to schedule task due to an internal server error. Check scheduler logs."}% muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 code . ✔ 1032 07:48:56
388
389 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 ✔ 1033 07:49:43
390 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 2020-02-21 07:49:55.613 WAT [38830] FATAL: database "deploy" does not exist
3912020-02-21 07:50:01.645 WAT [38840] FATAL: database "deploy" does not exist
392
393 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 psql postgres
394psql (12.2)
395Type "help" for help.
396
397postgres=# CREATE DATABASE deploy;
398CREATE DATABASE
399postgres=# \du
400 List of roles
401 Role name | Attributes | Member of
402-------------+------------------------------------------------------------+-----------
403 deploy | Create role, Create DB | {}
404 muarachmann | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
405
406postgres=# \db
407 List of tablespaces
408 Name | Owner | Location
409------------+-------------+----------
410 pg_default | muarachmann |
411 pg_global | muarachmann |
412(2 rows)
413
414postgres=# exit
415 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 clear ✔ 1034 07:51:27
416 muarachmann@Muas-MacBook-Pro ~/Documents/open_source/creative_commons/cccatalog-api master 1.1.0 ./load_sample_data.sh
417/usr/local/lib/python3.7/site-packages/grequests.py:21: MonkeyPatchWarning: Patching more than once will result in the union of all True parameters being patched
418 curious_george.patch_all(thread=False, select=False)
419jsonpickle is not installed. The to_json_pickle and from_json_pickle functions will not work.If you dont need those functions, there is nothing to do.
420GET http://es:9200/ [status:200 request:0.023s]
421GET http://es:9200/image/_search [status:404 request:0.011s]
422Operations to perform:
423 Apply all migrations: admin, api, auth, contenttypes, django_cron, oauth2_provider, sessions
424Running migrations:
425 No migrations to apply.
426Traceback (most recent call last):
427 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
428 return self.cursor.execute(sql, params)
429psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "auth_user_username_key"
430DETAIL: Key (username)=(continuous_integration) already exists.
431
432
433The above exception was the direct cause of the following exception:
434
435Traceback (most recent call last):
436 File "manage.py", line 17, in <module>
437 execute_from_command_line(sys.argv)
438 File "/usr/local/lib/python3.7/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
439 utility.execute()
440 File "/usr/local/lib/python3.7/site-packages/django/core/management/__init__.py", line 375, in execute
441 self.fetch_command(subcommand).run_from_argv(self.argv)
442 File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 323, in run_from_argv
443 self.execute(*args, **cmd_options)
444 File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 364, in execute
445 output = self.handle(*args, **options)
446 File "/usr/local/lib/python3.7/site-packages/django/core/management/commands/shell.py", line 86, in handle
447 exec(options['command'])
448 File "<string>", line 2, in <module>
449 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/models.py", line 151, in create_user
450 return self._create_user(username, email, password, **extra_fields)
451 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/models.py", line 145, in _create_user
452 user.save(using=self._db)
453 File "/usr/local/lib/python3.7/site-packages/django/contrib/auth/base_user.py", line 66, in save
454 super().save(*args, **kwargs)
455 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 741, in save
456 force_update=force_update, update_fields=update_fields)
457 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 779, in save_base
458 force_update, using, update_fields,
459 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 870, in _save_table
460 result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
461 File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 908, in _do_insert
462 using=using, raw=raw)
463 File "/usr/local/lib/python3.7/site-packages/django/db/models/manager.py", line 82, in manager_method
464 return getattr(self.get_queryset(), name)(*args, **kwargs)
465 File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py", line 1186, in _insert
466 return query.get_compiler(using=using).execute_sql(return_id)
467 File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1368, in execute_sql
468 cursor.execute(sql, params)
469 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 99, in execute
470 return super().execute(sql, params)
471 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 67, in execute
472 return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
473 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
474 return executor(sql, params, many, context)
475 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
476 return self.cursor.execute(sql, params)
477 File "/usr/local/lib/python3.7/site-packages/django/db/utils.py", line 89, in __exit__
478 raise dj_exc_value.with_traceback(traceback) from exc_value
479 File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
480 return self.cursor.execute(sql, params)
481django.db.utils.IntegrityError: duplicate key value violates unique constraint "auth_user_username_key"
482DETAIL: Key (username)=(continuous_integration) already exists.
483
4842020-02-21 07:51:37.740 WAT [39176] ERROR: database "analytics" already exists
4852020-02-21 07:51:37.740 WAT [39176] STATEMENT: CREATE DATABASE analytics;
486createdb: error: database creation failed: ERROR: database "analytics" already exists
487Traceback (most recent call last):
488 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
489 return fn()
490 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
491 return _ConnectionFairy._checkout(self)
492 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
493 fairy = _ConnectionRecord.checkout(pool)
494 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
495 rec = pool._do_get()
496 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
497 return self._create_connection()
498 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
499 return _ConnectionRecord(self)
500 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
501 self.__connect(first_connect_check=True)
502 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
503 connection = pool._invoke_creator(self)
504 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
505 return dialect.connect(*cargs, **cparams)
506 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
507 return self.dbapi.connect(*cargs, **cparams)
508 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
509 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
510psycopg2.OperationalError: FATAL: database "analytics" does not exist
511
512
513The above exception was the direct cause of the following exception:
514
515Traceback (most recent call last):
516 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/bin/alembic", line 8, in <module>
517 sys.exit(main())
518 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 540, in main
519 CommandLine(prog=prog).main(argv=argv)
520 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 534, in main
521 self.run_cmd(cfg, options)
522 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/config.py", line 514, in run_cmd
523 **dict((k, getattr(options, k, None)) for k in kwarg)
524 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/command.py", line 276, in upgrade
525 script.run_env()
526 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/script/base.py", line 475, in run_env
527 util.load_python_file(self.dir, "env.py")
528 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
529 module = load_module_py(module_id, path)
530 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/alembic/util/compat.py", line 177, in load_module_py
531 spec.loader.exec_module(module)
532 File "<frozen importlib._bootstrap_external>", line 728, in exec_module
533 File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
534 File "migrations/env.py", line 77, in <module>
535 run_migrations_online()
536 File "migrations/env.py", line 65, in run_migrations_online
537 with connectable.connect() as connection:
538 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2196, in connect
539 return self._connection_cls(self, **kwargs)
540 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
541 else engine.raw_connection()
542 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2296, in raw_connection
543 self.pool.unique_connection, _connection
544 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2269, in _wrap_pool_connect
545 e, dialect, self
546 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
547 util.raise_from_cause(sqlalchemy_exception, exc_info)
548 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
549 reraise(type(exception), exception, tb=exc_tb, cause=cause)
550 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
551 raise value.with_traceback(tb)
552 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2265, in _wrap_pool_connect
553 return fn()
554 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
555 return _ConnectionFairy._checkout(self)
556 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
557 fairy = _ConnectionRecord.checkout(pool)
558 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
559 rec = pool._do_get()
560 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
561 return self._create_connection()
562 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
563 return _ConnectionRecord(self)
564 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
565 self.__connect(first_connect_check=True)
566 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
567 connection = pool._invoke_creator(self)
568 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
569 return dialect.connect(*cargs, **cparams)
570 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 453, in connect
571 return self.dbapi.connect(*cargs, **cparams)
572 File "/root/.local/share/virtualenvs/analytics-JemxtBuX/lib/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
573 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
574sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: database "analytics" does not exist
575
576(Background on this error at: http://sqlalche.me/e/e3q8)
5772020-02-21 07:51:39.210 WAT [39182] FATAL: database "openledger" does not exist
578pg_dump: error: connection to database "openledger" failed: FATAL: database "openledger" does not exist
5792020-02-21 07:51:39.270 WAT [39184] FATAL: database "openledger" does not exist
580psql: error: could not connect to server: FATAL: database "openledger" does not exist
581ERROR: relation "content_provider" already exists
582ERROR: relation "image" does not exist
583{"message": "Successfully scheduled task", "task_id": "df86c6d2-245f-4108-acf8-78e1b783e912", "status_check": "http://localhost:8001/task/df86c6d2-245f-4108-acf8-78e1b783e912"}{"message": "Successfully scheduled task", "task_id": "3f43ac34-f3e7-4806-9e4a-e572a9051768", "status_check": "http://localhost:8001/task/3f43ac34-f3e7-4806-9e4a-e572a9051768"}% muarachmann@Muas-MacB