Re: v4.26, produces no output, errors in the log
After all my refreshes and re-installs it seems like Chrome browser issues
got on the way.
Apologies for the false alarm.
On Fri, Oct 9, 2020 at 1:56 AM Akshay Joshi
wrote:
> Hi Cherio
>
> Have you execute the query or explain options (explain, explain analyze)?
> These options are available on the toolbar, I have tested explain is
> working fine for me on v4.26.
> If possible please provide the SQL Query and Screenshots.
>
> On Thu, Oct 8, 2020 at 11:25 PM Cherio wrote:
>
>> After reinstalling 4.26, clearing everything again and restarting the
>> errors are gone, the data shows but the Explain tab is blank entirely.
>> Those sub-tabs underneath are missing so there is no explain data
>> whatsoever.
>>
>> The logs are clean.
>>
>> On Thu, Oct 8, 2020 at 1:29 PM Cherio wrote:
>>
>>> I just upgraded pgAdmin from 4.24 to 4.26 (python wheel install) and
>>> almost all result tabs are now blank.
>>> Neither Query nor Explain produce any result. I cleared all chrome cache
>>> (cookies, session/local storage), restarted the backend with no success.
>>>
>>> I rolled back to 4.24 and everything works as before.
>>>
>>> Version: 4.26
>>> Copyright (C) 2013 - 2020, The pgAdmin Development Team
>>> Python Version: 3.8.2 (default, Jul 16 2020, 14:00:26) [GCC 9.3.0]
>>> Flask Version: 1.0.2
>>> Application Mode: Desktop
>>> Current User: pgadm...@pgadmin.org
>>> OS: "20.04.1 LTS (Focal Fossa)"
>>>
>>> The log is a repetition of the same error (see below)
>>>
>>>
>>> ===
>>> 2020-10-08 12:25:39,125: ERROR flask.app: 400 Bad Request: The
>>> CSRF session token is missing.
>>> Traceback (most recent call last):
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 256, in protect
>>> validate_csrf(self._get_csrf_token())
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 94, in validate_csrf
>>> raise ValidationError('The CSRF session token is missing.')
>>> wtforms.validators.ValidationError: The CSRF session token is missing.
>>>
>>> During handling of the above exception, another exception occurred:
>>>
>>> Traceback (most recent call last):
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>>> 1811, in full_dispatch_request
>>> rv = self.preprocess_request()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>>> 2087, in preprocess_request
>>> rv = func()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 224, in csrf_protect
>>> self.protect()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 259, in protect
>>> self._error_response(e.args[0])
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 302, in _error_response
>>> raise CSRFError(reason)
>>> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
>>> missing.
>>> 2020-10-08 13:01:37,714: ERROR flask.app: 400 Bad Request: The
>>> CSRF session token is missing.
>>> Traceback (most recent call last):
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 256, in protect
>>> validate_csrf(self._get_csrf_token())
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 94, in validate_csrf
>>> raise ValidationError('The CSRF session token is missing.')
>>> wtforms.validators.ValidationError: The CSRF session token is missing.
>>>
>>> During handling of the above exception, another exception occurred:
>>>
>>> Traceback (most recent call last):
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>>> 1811, in full_dispatch_request
>>> rv = self.preprocess_request()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>>> 2087, in preprocess_request
>>> rv = func()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 224, in csrf_protect
>>> self.protect()
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 259, in protect
>>> self._error_response(e.args[0])
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 302, in _error_response
>>> raise CSRFError(reason)
>>> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
>>> missing.
>>> 2020-10-08 13:01:42,712: ERROR flask.app: 400 Bad Request: The
>>> CSRF session token is missing.
>>> Traceback (most recent call last):
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 256, in protect
>>> validate_csrf(self._get_csrf_token())
>>> File
>>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>>> line 94, in validate_csrf
>>>
Re: v4.26, produces no output, errors in the log
Hi Cherio
Have you execute the query or explain options (explain, explain analyze)?
These options are available on the toolbar, I have tested explain is
working fine for me on v4.26.
If possible please provide the SQL Query and Screenshots.
On Thu, Oct 8, 2020 at 11:25 PM Cherio wrote:
> After reinstalling 4.26, clearing everything again and restarting the
> errors are gone, the data shows but the Explain tab is blank entirely.
> Those sub-tabs underneath are missing so there is no explain data
> whatsoever.
>
> The logs are clean.
>
> On Thu, Oct 8, 2020 at 1:29 PM Cherio wrote:
>
>> I just upgraded pgAdmin from 4.24 to 4.26 (python wheel install) and
>> almost all result tabs are now blank.
>> Neither Query nor Explain produce any result. I cleared all chrome cache
>> (cookies, session/local storage), restarted the backend with no success.
>>
>> I rolled back to 4.24 and everything works as before.
>>
>> Version: 4.26
>> Copyright (C) 2013 - 2020, The pgAdmin Development Team
>> Python Version: 3.8.2 (default, Jul 16 2020, 14:00:26) [GCC 9.3.0]
>> Flask Version: 1.0.2
>> Application Mode: Desktop
>> Current User: pgadm...@pgadmin.org
>> OS: "20.04.1 LTS (Focal Fossa)"
>>
>> The log is a repetition of the same error (see below)
>>
>>
>> ===
>> 2020-10-08 12:25:39,125: ERROR flask.app: 400 Bad Request: The CSRF
>> session token is missing.
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 256, in protect
>> validate_csrf(self._get_csrf_token())
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 94, in validate_csrf
>> raise ValidationError('The CSRF session token is missing.')
>> wtforms.validators.ValidationError: The CSRF session token is missing.
>>
>> During handling of the above exception, another exception occurred:
>>
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>> 1811, in full_dispatch_request
>> rv = self.preprocess_request()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>> 2087, in preprocess_request
>> rv = func()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 224, in csrf_protect
>> self.protect()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 259, in protect
>> self._error_response(e.args[0])
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 302, in _error_response
>> raise CSRFError(reason)
>> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
>> missing.
>> 2020-10-08 13:01:37,714: ERROR flask.app: 400 Bad Request: The CSRF
>> session token is missing.
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 256, in protect
>> validate_csrf(self._get_csrf_token())
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 94, in validate_csrf
>> raise ValidationError('The CSRF session token is missing.')
>> wtforms.validators.ValidationError: The CSRF session token is missing.
>>
>> During handling of the above exception, another exception occurred:
>>
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>> 1811, in full_dispatch_request
>> rv = self.preprocess_request()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py", line
>> 2087, in preprocess_request
>> rv = func()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 224, in csrf_protect
>> self.protect()
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 259, in protect
>> self._error_response(e.args[0])
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 302, in _error_response
>> raise CSRFError(reason)
>> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
>> missing.
>> 2020-10-08 13:01:42,712: ERROR flask.app: 400 Bad Request: The CSRF
>> session token is missing.
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 256, in protect
>> validate_csrf(self._get_csrf_token())
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
>> line 94, in validate_csrf
>> raise ValidationError('The CSRF session token is missing.')
>> wtforms.validators.ValidationError: The CSRF session token is missing.
>>
>> During handling of the above exception, another exception occurred:
>>
>> Traceback (most recent call last):
>> File
>> "/home/user/opt/pgadmin4/lib/python3.8/
Re: v4.26, produces no output, errors in the log
After reinstalling 4.26, clearing everything again and restarting the
errors are gone, the data shows but the Explain tab is blank entirely.
Those sub-tabs underneath are missing so there is no explain data
whatsoever.
The logs are clean.
On Thu, Oct 8, 2020 at 1:29 PM Cherio wrote:
> I just upgraded pgAdmin from 4.24 to 4.26 (python wheel install) and
> almost all result tabs are now blank.
> Neither Query nor Explain produce any result. I cleared all chrome cache
> (cookies, session/local storage), restarted the backend with no success.
>
> I rolled back to 4.24 and everything works as before.
>
> Version: 4.26
> Copyright (C) 2013 - 2020, The pgAdmin Development Team
> Python Version: 3.8.2 (default, Jul 16 2020, 14:00:26) [GCC 9.3.0]
> Flask Version: 1.0.2
> Application Mode: Desktop
> Current User: pgadm...@pgadmin.org
> OS: "20.04.1 LTS (Focal Fossa)"
>
> The log is a repetition of the same error (see below)
>
>
> ===
> 2020-10-08 12:25:39,125: ERROR flask.app: 400 Bad Request: The CSRF
> session token is missing.
> Traceback (most recent call last):
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 256, in protect
> validate_csrf(self._get_csrf_token())
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 94, in validate_csrf
> raise ValidationError('The CSRF session token is missing.')
> wtforms.validators.ValidationError: The CSRF session token is missing.
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 1811, in full_dispatch_request
> rv = self.preprocess_request()
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 2087, in preprocess_request
> rv = func()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 224, in csrf_protect
> self.protect()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 259, in protect
> self._error_response(e.args[0])
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 302, in _error_response
> raise CSRFError(reason)
> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
> missing.
> 2020-10-08 13:01:37,714: ERROR flask.app: 400 Bad Request: The CSRF
> session token is missing.
> Traceback (most recent call last):
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 256, in protect
> validate_csrf(self._get_csrf_token())
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 94, in validate_csrf
> raise ValidationError('The CSRF session token is missing.')
> wtforms.validators.ValidationError: The CSRF session token is missing.
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 1811, in full_dispatch_request
> rv = self.preprocess_request()
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 2087, in preprocess_request
> rv = func()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 224, in csrf_protect
> self.protect()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 259, in protect
> self._error_response(e.args[0])
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 302, in _error_response
> raise CSRFError(reason)
> flask_wtf.csrf.CSRFError: 400 Bad Request: The CSRF session token is
> missing.
> 2020-10-08 13:01:42,712: ERROR flask.app: 400 Bad Request: The CSRF
> session token is missing.
> Traceback (most recent call last):
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 256, in protect
> validate_csrf(self._get_csrf_token())
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 94, in validate_csrf
> raise ValidationError('The CSRF session token is missing.')
> wtforms.validators.ValidationError: The CSRF session token is missing.
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 1811, in full_dispatch_request
> rv = self.preprocess_request()
> File "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask/app.py",
> line 2087, in preprocess_request
> rv = func()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-packages/flask_wtf/csrf.py",
> line 224, in csrf_protect
> self.protect()
> File
> "/home/user/opt/pgadmin4/lib/python3.8/site-package
