Re: SSL SYSCALL error: Undefined error: 0

Nagaraj Raj <[email protected]> Mon, 30 Sep 2019 07:03:27 +0000 (UTC)
Newsgroups gmane.comp.db.postgresql.pgadmin
Message-ID <[email protected]> 
 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