From: | Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> |
---|---|
To: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
Cc: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>, "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: SSL SYSCALL error: Undefined error: 0 |
Date: | 2019-09-30 07:03:27 |
Message-ID: | 614829050.1255760.1569827007072@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 <khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
Hi,
On Sun, Sep 29, 2019 at 8:54 AM Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> 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 <murtuza(dot)zabuawala(at)enterprisedb(dot)com> 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, <nagaraj(dot)sf(at)yahoo(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2019-09-30 08:16:02 | Re: Query tool problem in PGAdmin 4.13 |
Previous Message | Khushboo Vashi | 2019-09-30 03:36:35 | Re: SSL SYSCALL error: Undefined error: 0 |