· 5 years ago · Feb 24, 2020, 04:46 PM
1avsaliy@MSK-6N0NWF2:~$ sudo apt update
2[sudo] password for avsaliy:
3Hit:1 http://security.ubuntu.com/ubuntu bionic-security InRelease
4Hit:2 http://archive.ubuntu.com/ubuntu bionic InRelease
5Hit:3 http://archive.ubuntu.com/ubuntu bionic-updates InRelease
6Hit:4 http://archive.ubuntu.com/ubuntu bionic-backports InRelease
7Reading package lists... Done
8Building dependency tree
9Reading state information... Done
10132 packages can be upgraded. Run 'apt list --upgradable' to see them.
11avsaliy@MSK-6N0NWF2:~$ sudo apt install postgresql postgresql-contrib
12Reading package lists... Done
13Building dependency tree
14Reading state information... Done
15postgresql is already the newest version (10+190ubuntu0.1).
16postgresql-contrib is already the newest version (10+190ubuntu0.1).
17The following package was automatically installed and is no longer required:
18 libfreetype6
19Use 'sudo apt autoremove' to remove it.
200 upgraded, 0 newly installed, 0 to remove and 132 not upgraded.
21avsaliy@MSK-6N0NWF2:~$ sudo service postgresql start
22 * Starting PostgreSQL 10 database server [ OK ]
23avsaliy@MSK-6N0NWF2:~$ service postgresql status
2410/main (port 5433): online
25avsaliy@MSK-6N0NWF2:~$ sudo su postgres
26postgres@MSK-6N0NWF2:/home/avsaliy$ createdb zen --encoding='utf-8'
27createdb: database creation failed: ERROR: database "zen" already exists
28postgres@MSK-6N0NWF2:/home/avsaliy$ psql
29psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
30Type "help" for help.
31
32postgres=# \c zen
33You are now connected to database "zen" as user "postgres".
34zen=# CREATE USER my_user WITH ENCRYPTED PASSWORD 'my_user_password';
35ERROR: role "my_user" already exists
36zen=# \q
37postgres@MSK-6N0NWF2:/home/avsaliy$ pg_restore -d zen /mnt/c/Users/avsaliy/Downloads/zen.dump
38pg_restore: [archiver (db)] Error while PROCESSING TOC:
39pg_restore: [archiver (db)] Error from TOC entry 197; 1259 40990 TABLE log_raw postgres
40pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw" already exists
41 Command was: CREATE TABLE public.log_raw (
42 event_id integer NOT NULL,
43 age_segment character varying(128),
44 event character varying(128),
45 item_id bigint,
46 item_topic character varying(128),
47 item_type character varying(128),
48 source_id bigint,
49 source_topic character varying(128),
50 source_type character varying(128),
51 ts bigint,
52 user_id bigint
53);
54
55
56
57pg_restore: [archiver (db)] Error from TOC entry 196; 1259 40988 SEQUENCE log_raw_event_id_seq postgres
58pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw_event_id_seq" already exists
59 Command was: CREATE SEQUENCE public.log_raw_event_id_seq
60 AS integer
61 START WITH 1
62 INCREMENT BY 1
63 NO MINVALUE
64 NO MAXVALUE
65 CACHE 1;
66
67
68
69pg_restore: [archiver (db)] Error from TOC entry 2876; 0 40990 TABLE DATA log_raw postgres
70pg_restore: [archiver (db)] COPY failed for table "log_raw": ERROR: duplicate key value violates unique constraint "log_raw_pkey"
71DETAIL: Key (event_id)=(2931262) already exists.
72CONTEXT: COPY log_raw, line 1
73pg_restore: [archiver (db)] Error from TOC entry 2753; 2606 40998 CONSTRAINT log_raw log_raw_pkey postgres
74pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "log_raw" are not allowed
75 Command was: ALTER TABLE ONLY public.log_raw
76 ADD CONSTRAINT log_raw_pkey PRIMARY KEY (event_id);
77
78
79
80WARNING: errors ignored on restore: 4
81postgres@MSK-6N0NWF2:/home/avsaliy$ psql
82psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
83Type "help" for help.
84
85postgres=# \c zen
86You are now connected to database "zen" as user "postgres".
87zen=# \dt
88 List of relations
89 Schema | Name | Type | Owner
90--------+-----------------+-------+----------
91 public | dash_engagement | table | postgres
92 public | dash_visits | table | postgres
93 public | log_raw | table | postgres
94(3 rows)
95
96zen=# select count(*) from log_raw;
97 count
98--------
99 322391
100(1 row)
101
102zen=# select * from dash_engagement;
103 record_id | dt | item_topic | event | age_segment | unique_users
104-----------+----+------------+-------+-------------+--------------
105(0 rows)
106
107zen=# select * from dash_visits;
108 record_id | item_topic | source_topic | age_segment | dt | visits
109-----------+------------+--------------+-------------+----+--------
110(0 rows)
111
112zen=# GRANT ALL PRIVILEGES ON TABLE dash_visits TO my_user;
113GRANT
114zen=# GRANT USAGE, SELECT ON SEQUENCE dash_visits_record_id_seq TO my_user;
115GRANT
116zen=# GRANT ALL PRIVILEGES ON TABLE dash_engagement TO my_user;
117GRANT
118zen=# GRANT USAGE, SELECT ON SEQUENCE dash_engagement_record_id_seq TO my_user;
119GRANT
120zen=# \q
121postgres@MSK-6N0NWF2:/home/avsaliy$ exit
122exit
123avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24' --end_dt='2019-09-25'
124Traceback (most recent call last):
125 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
126 return fn()
127 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
128 return _ConnectionFairy._checkout(self)
129 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
130 fairy = _ConnectionRecord.checkout(pool)
131 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
132 rec = pool._do_get()
133 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
134 self._dec_overflow()
135 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
136 compat.reraise(exc_type, exc_value, exc_tb)
137 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
138 raise value
139 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
140 return self._create_connection()
141 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
142 return _ConnectionRecord(self)
143 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
144 self.__connect(first_connect_check=True)
145 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
146 connection = pool._invoke_creator(self)
147 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
148 return dialect.connect(*cargs, **cparams)
149 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
150 return self.dbapi.connect(*cargs, **cparams)
151 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
152 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
153psycopg2.OperationalError
154
155The above exception was the direct cause of the following exception:
156
157Traceback (most recent call last):
158 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 49, in <module>
159 log_raw = pd.io.sql.read_sql(query, con = engine, index_col = 'event_id')
160 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 438, in read_sql
161 chunksize=chunksize,
162 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1218, in read_query
163 result = self.execute(*args)
164 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1087, in execute
165 return self.connectable.execute(*args, **kwargs)
166 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2181, in execute
167 connection = self._contextual_connect(close_with_result=True)
168 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
169 self._wrap_pool_connect(self.pool.connect, None),
170 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2280, in _wrap_pool_connect
171 e, dialect, self
172 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
173 util.raise_from_cause(sqlalchemy_exception, exc_info)
174 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
175 reraise(type(exception), exception, tb=exc_tb, cause=cause)
176 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
177 raise value.with_traceback(tb)
178 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
179 return fn()
180 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
181 return _ConnectionFairy._checkout(self)
182 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
183 fairy = _ConnectionRecord.checkout(pool)
184 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
185 rec = pool._do_get()
186 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
187 self._dec_overflow()
188 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
189 compat.reraise(exc_type, exc_value, exc_tb)
190 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
191 raise value
192 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
193 return self._create_connection()
194 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
195 return _ConnectionRecord(self)
196 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
197 self.__connect(first_connect_check=True)
198 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
199 connection = pool._invoke_creator(self)
200 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
201 return dialect.connect(*cargs, **cparams)
202 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
203 return self.dbapi.connect(*cargs, **cparams)
204 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
205 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
206sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)
207(Background on this error at: http://sqlalche.me/e/e3q8)
208avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24' --end_dt='2019-09-25'
209Traceback (most recent call last):
210 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 55, in <module>
211 dash_visits = log_raw.groupby(['dt','item_topic', 'source_topic', 'age_segment']).agg({'visits': 'count'})
212 File "/usr/local/lib/python3.6/dist-packages/pandas/core/groupby/generic.py", line 940, in aggregate
213 result, how = self._aggregate(func, *args, **kwargs)
214 File "/usr/local/lib/python3.6/dist-packages/pandas/core/base.py", line 366, in _aggregate
215 raise SpecificationError("nested renamer is not supported")
216pandas.core.base.SpecificationError: nested renamer is not supported
217avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24' --end_dt='2019-09-25'
218success
219success
220avsaliy@MSK-6N0NWF2:~$ sudo pip3 install dash==1.6.1
221[sudo] password for avsaliy:
222The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
223The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
224Requirement already satisfied: dash==1.6.1 in /usr/local/lib/python3.6/dist-packages
225Requirement already satisfied: Flask>=1.0.2 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
226Requirement already satisfied: dash-core-components==1.5.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
227Requirement already satisfied: dash-html-components==1.0.2 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
228Requirement already satisfied: dash-table==4.5.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
229Requirement already satisfied: dash_renderer==1.2.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
230Requirement already satisfied: flask-compress in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
231Requirement already satisfied: future in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
232Requirement already satisfied: plotly in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
233Requirement already satisfied: click>=5.1 in /usr/lib/python3/dist-packages (from Flask>=1.0.2->dash==1.6.1)
234Requirement already satisfied: Jinja2>=2.10.1 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)Requirement already satisfied: itsdangerous>=0.24 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)
235Requirement already satisfied: Werkzeug>=0.15 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)Requirement already satisfied: retrying>=1.3.3 in /usr/local/lib/python3.6/dist-packages (from plotly->dash==1.6.1)
236Requirement already satisfied: six in /usr/lib/python3/dist-packages (from plotly->dash==1.6.1)
237Requirement already satisfied: MarkupSafe>=0.23 in /usr/lib/python3/dist-packages (from Jinja2>=2.10.1->Flask>=1.0.2->dash==1.6.1)
238avsaliy@MSK-6N0NWF2:~$ sudo apt install python3-pip
239Reading package lists... Done
240Building dependency tree
241Reading state information... Done
242python3-pip is already the newest version (9.0.1-2.3~ubuntu1.18.04.1).
243The following package was automatically installed and is no longer required:
244 libfreetype6
245Use 'sudo apt autoremove' to remove it.
2460 upgraded, 0 newly installed, 0 to remove and 132 not upgraded.
247avsaliy@MSK-6N0NWF2:~$ sudo pip3 install dash==1.6.1
248The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
249The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
250Requirement already satisfied: dash==1.6.1 in /usr/local/lib/python3.6/dist-packages
251Requirement already satisfied: Flask>=1.0.2 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
252Requirement already satisfied: dash-core-components==1.5.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
253Requirement already satisfied: dash-html-components==1.0.2 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
254Requirement already satisfied: dash-table==4.5.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
255Requirement already satisfied: dash_renderer==1.2.1 in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
256Requirement already satisfied: flask-compress in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
257Requirement already satisfied: future in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
258Requirement already satisfied: plotly in /usr/local/lib/python3.6/dist-packages (from dash==1.6.1)
259Requirement already satisfied: Werkzeug>=0.15 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)
260Requirement already satisfied: click>=5.1 in /usr/lib/python3/dist-packages (from Flask>=1.0.2->dash==1.6.1)
261Requirement already satisfied: Jinja2>=2.10.1 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)
262Requirement already satisfied: itsdangerous>=0.24 in /usr/local/lib/python3.6/dist-packages (from Flask>=1.0.2->dash==1.6.1)
263Requirement already satisfied: six in /usr/lib/python3/dist-packages (from plotly->dash==1.6.1)
264Requirement already satisfied: retrying>=1.3.3 in /usr/local/lib/python3.6/dist-packages (from plotly->dash==1.6.1)
265Requirement already satisfied: MarkupSafe>=0.23 in /usr/lib/python3/dist-packages (from Jinja2>=2.10.1->Flask>=1.0.2->dash==1.6.1)
266avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_dashboard.py --start_dt='2019-09-24' --end_dt='2019-09-25'
267Running on http://0.0.0.0:8050/
268Debugger PIN: 068-656-539
269 * Serving Flask app "zen_dashboard" (lazy loading)
270 * Environment: production
271 WARNING: This is a development server. Do not use it in a production deployment.
272 Use a production WSGI server instead.
273 * Debug mode: on
274Running on http://0.0.0.0:8050/
275Debugger PIN: 556-317-367
276Traceback (most recent call last):
277 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
278 return fn()
279 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
280 return _ConnectionFairy._checkout(self)
281 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
282 fairy = _ConnectionRecord.checkout(pool)
283 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
284 rec = pool._do_get()
285 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
286 self._dec_overflow()
287 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
288 compat.reraise(exc_type, exc_value, exc_tb)
289 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
290 raise value
291 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
292 return self._create_connection()
293 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
294 return _ConnectionRecord(self)
295 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
296 self.__connect(first_connect_check=True)
297 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
298 connection = pool._invoke_creator(self)
299 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
300 return dialect.connect(*cargs, **cparams)
301 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
302 return self.dbapi.connect(*cargs, **cparams)
303 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
304 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
305psycopg2.OperationalError
306
307The above exception was the direct cause of the following exception:
308
309Traceback (most recent call last):
310 File "/mnt/c/Users/avsaliy/Documents/zen_dashboard.py", line 35, in <module>
311 dash_visits = pd.io.sql.read_sql(query1, con = engine)
312 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 438, in read_sql
313 chunksize=chunksize,
314 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1218, in read_query
315 result = self.execute(*args)
316 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1087, in execute
317 return self.connectable.execute(*args, **kwargs)
318 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2181, in execute
319 connection = self._contextual_connect(close_with_result=True)
320 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
321 self._wrap_pool_connect(self.pool.connect, None),
322 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2280, in _wrap_pool_connect
323 e, dialect, self
324 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
325 util.raise_from_cause(sqlalchemy_exception, exc_info)
326 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
327 reraise(type(exception), exception, tb=exc_tb, cause=cause)
328 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
329 raise value.with_traceback(tb)
330 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
331 return fn()
332 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
333 return _ConnectionFairy._checkout(self)
334 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
335 fairy = _ConnectionRecord.checkout(pool)
336 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
337 rec = pool._do_get()
338 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
339 self._dec_overflow()
340 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
341 compat.reraise(exc_type, exc_value, exc_tb)
342 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
343 raise value
344 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
345 return self._create_connection()
346 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
347 return _ConnectionRecord(self)
348 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
349 self.__connect(first_connect_check=True)
350 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
351 connection = pool._invoke_creator(self)
352 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
353 return dialect.connect(*cargs, **cparams)
354 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
355 return self.dbapi.connect(*cargs, **cparams)
356 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
357 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
358sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)
359(Background on this error at: http://sqlalche.me/e/e3q8)
360avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_dashboard.py --start_dt='2019-09-24' --end_dt='2019-09-25'
361Traceback (most recent call last):
362 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
363 return fn()
364 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
365 return _ConnectionFairy._checkout(self)
366 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
367 fairy = _ConnectionRecord.checkout(pool)
368 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
369 rec = pool._do_get()
370 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
371 self._dec_overflow()
372 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
373 compat.reraise(exc_type, exc_value, exc_tb)
374 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
375 raise value
376 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
377 return self._create_connection()
378 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
379 return _ConnectionRecord(self)
380 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
381 self.__connect(first_connect_check=True)
382 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
383 connection = pool._invoke_creator(self)
384 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
385 return dialect.connect(*cargs, **cparams)
386 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
387 return self.dbapi.connect(*cargs, **cparams)
388 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
389 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
390psycopg2.OperationalError
391
392The above exception was the direct cause of the following exception:
393
394Traceback (most recent call last):
395 File "/mnt/c/Users/avsaliy/Documents/zen_dashboard.py", line 35, in <module>
396 dash_visits = pd.io.sql.read_sql(query1, con = engine)
397 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 438, in read_sql
398 chunksize=chunksize,
399 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1218, in read_query
400 result = self.execute(*args)
401 File "/usr/local/lib/python3.6/dist-packages/pandas/io/sql.py", line 1087, in execute
402 return self.connectable.execute(*args, **kwargs)
403 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2181, in execute
404 connection = self._contextual_connect(close_with_result=True)
405 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
406 self._wrap_pool_connect(self.pool.connect, None),
407 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2280, in _wrap_pool_connect
408 e, dialect, self
409 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
410 util.raise_from_cause(sqlalchemy_exception, exc_info)
411 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
412 reraise(type(exception), exception, tb=exc_tb, cause=cause)
413 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
414 raise value.with_traceback(tb)
415 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
416 return fn()
417 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 363, in connect
418 return _ConnectionFairy._checkout(self)
419 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 773, in _checkout
420 fairy = _ConnectionRecord.checkout(pool)
421 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout
422 rec = pool._do_get()
423 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
424 self._dec_overflow()
425 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
426 compat.reraise(exc_type, exc_value, exc_tb)
427 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
428 raise value
429 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
430 return self._create_connection()
431 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
432 return _ConnectionRecord(self)
433 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__
434 self.__connect(first_connect_check=True)
435 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/pool/base.py", line 652, in __connect
436 connection = pool._invoke_creator(self)
437 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
438 return dialect.connect(*cargs, **cparams)
439 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 489, in connect
440 return self.dbapi.connect(*cargs, **cparams)
441 File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
442 conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
443sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)
444(Background on this error at: http://sqlalche.me/e/e3q8)
445avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_dashboard.py --start_dt='2019-09-24' --end_dt='2019-09-25'
446Running on http://0.0.0.0:8050/
447Debugger PIN: 739-517-103
448 * Serving Flask app "zen_dashboard" (lazy loading)
449 * Environment: production
450 WARNING: This is a development server. Do not use it in a production deployment.
451 Use a production WSGI server instead.
452 * Debug mode: on
453Running on http://0.0.0.0:8050/
454Debugger PIN: 810-414-543
455Running on http://0.0.0.0:8051/
456Debugger PIN: 976-163-130
457
458
459Running on http://0.0.0.0:8051/
460Debugger PIN: 532-900-522
461
462Running on http://0.0.0.0:8050/
463Debugger PIN: 375-963-107
464375-963-107
465Running on http://0.0.0.0:8050/
466Debugger PIN: 246-886-525