Re: SSL SYSCALL error: Undefined error: 0

Поиск
Список
Период
Сортировка
От Nagaraj Raj
Тема Re: SSL SYSCALL error: Undefined error: 0
Дата
Msg-id 614829050.1255760.1569827007072@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: SSL SYSCALL error: Undefined error: 0  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список 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.vashi@enterprisedb.com> wrote:


Hi,

On Sun, Sep 29, 2019 at 8:54 AM Nagaraj Raj <nagaraj.sf@yahoo.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.zabuawala@enterprisedb.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.sf@yahoo.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
 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Khushboo Vashi
Дата:
Сообщение: Re: SSL SYSCALL error: Undefined error: 0
Следующее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Query tool problem in PGAdmin 4.13