Hi,
I'm using macOS and just downloaded latest version and installed it has
automatically replaced the existing version to newer one.I have enclosed
pgAmin logs below,
2019-09-27 14:53:08,002: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:09,921: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 2577152):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:09,927: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 8217990):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:09,927: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:11,915: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 2627509):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:11,915: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:13,377: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 2275203):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:13,377: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:16,330: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 4813706):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:16,333: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 8806366):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:16,333: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:18,134: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 2691871):
Error Message:SSL SYSCALL error: Undefined error: 0
2019-09-27 14:53:18,134: ERROR flask.app: string indices must be integers
Traceback (most recent call last):
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1813, in full_dispatch_request
rv = self.dispatch_request()
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask/app.py", line
1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/venv/lib/python3.7/site-packages/flask_login/utils.py",
line 261, in decorated_view
return func(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 251, in wrap
return f(*args, **kwargs)
File "/Volumes/pgAdmin 4/pgAdmin
4.app/Contents/Resources/web/pgadmin/dashboard/__init__.py", line 371, in
dashboard_stats
for chart_row in res['rows']:
TypeError: string indices must be integers
2019-09-27 14:53:19,152: ERROR flask.app: Failed to execute query
(execute_dict) for the server #2- DB:ohl (Query-id: 8844676):
Error Message:SSL SYSCALL error: Undefined error: 0
Thanks,
On Sunday, September 29, 2019, 08:36:46 PM PDT, Khushboo Vashi
<[email protected]> wrote:
Hi,
On Sun, Sep 29, 2019 at 8:54 AM Nagaraj Raj <[email protected]> wrote:
Yes, I have checked in server logs too but do not see any issue. I'm getting
this error in pgAdmin only, when I do refresh any objects in admin tool. On
Saturday, September 28, 2019, 02:20:38 AM PDT, Murtuza Zabuawala
<[email protected]> wrote:
This error mostly occurred in python/psycopg2 when postgres runs out of memory
while performing complex query.
Did you checked DB server side logs?
On Sat, 28 Sep 2019, 03:21 Nagaraj Raj, <[email protected]> wrote:
Hello,
I have upgraded pgAdmin to latest version 4.13. Some times it's behaving
abnormally and throwing below error,
Please provide the OS details and how you upgraded the pgAdmin 4.This issue is
of psycopg2, so we need the pgadmin logs to further work on it.Enable the
pgadmin logging (Ref: https://www.pgadmin.org/faq/#8) and provide the logs.
Thanks,Khushboo
Error retrieving details for the node
SSL SYSCALL error: Undefined error: 0
Thanks,Naga
