ERROR: 500 Server Error: Internal Server Error

[maktk23]

Hi, get this error when do the "st2 execution list" and the console history page is not showing older records

st2 execution list
ERROR: 500 Server Error: Internal Server Error
MESSAGE: Internal Server Error for url: http://127.0.0.1:9101/v1/executions/?include_attributes=id%2Caction.ref%2Ccontext.user%2Cstatus%2Cstart_timestamp%2Cend_timestamp&limit=50&sort_desc=True&parent=null

*this is the stackstorm version
st2 3.1.0, on Python 2.7.5
MongoDB server version: 4.4.9

==========================================================================

st2 --debug execution list
2021-12-02 20:06:11,220 DEBUG - Using cached token from file "/root/.st2/token-xxx@xxx"

-------- begin 140588570833872 request ----------

curl -X GET -H 'Connection: keep-alive' -H 'Accept-Encoding: gzip, deflate' -H 'Accept: /' -H 'User-Agent: python-requests/2.22.0' -H 'X-Auth-Token: 74007e9a09134923a6ff859d32104262' 'http://127.0.0.1:9101/v1/executions/?include_attributes=id%2Caction.ref%2Ccontext.user%2Cstatus%2Cstart_timestamp%2Cend_timestamp&limit=50&sort_desc=True&parent=null'

-------- begin 140588570833872 response ----------

{
"faultstring": "Internal Server Error"
}

-------- end 140588570833872 response ------------

ERROR: 500 Server Error: Internal Server Error
MESSAGE: Internal Server Error for url: http://127.0.0.1:9101/v1/executions/?include_attributes=id%2Caction.ref%2Ccontext.user%2Cstatus%2Cstart_timestamp%2Cend_timestamp&limit=50&sort_desc=True&parent=null

CLI settings:

Config file path: /root/.st2/config
Client settings:

ST2_BASE_URL: http://127.0.0.1
ST2_AUTH_URL: http://127.0.0.1:9100
ST2_API_URL: http://127.0.0.1:9101/v1
ST2_STREAM_URL: http://127.0.0.1:9102/v1
ST2_AUTH_TOKEN: 74007e9a09134923a6ff859d32104262

Proxy settings:

HTTP_PROXY:
HTTPS_PROXY:

Traceback (most recent call last):
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/shell.py", line 407, in run
func(args)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/commands/action.py", line 1147, in run_and_print
result, count = self.run(args, **kwargs)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/commands/resource.py", line 47, in decorate
return func(*args, **kwargs)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/commands/action.py", line 1143, in run
return self.manager.query_with_count(limit=args.last, **kwargs)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/models/core.py", line 41, in decorate
return func(*args, **kwargs)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/models/core.py", line 285, in query_with_count
instances, response = self._query_details(**kwargs)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/models/core.py", line 273, in _query_details
self.handle_error(response)
File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2client/models/core.py", line 167, in handle_error
response.raise_for_status()
File "/opt/stackstorm/st2/lib/python2.7/site-packages/requests/models.py", line 940, in raise_for_status
raise HTTPError(http_error_msg, response=self)
HTTPError: 500 Server Error: Internal Server Error
MESSAGE: Internal Server Error for url: http://127.0.0.1:9101/v1/executions/?include_attributes=id%2Caction.ref%2Ccontext.user%2Cstatus%2Cstart_timestamp%2Cend_timestamp&limit=50&sort_desc=True&parent=null

[arm4b]

Hi @maktk23,
thanks for the report.

st2 3.1.0, on Python 2.7.5 was released in July 2019 and I don't think we support that version anymore.
I'd recommend trying the latest st2 v3.6.0.

If that's not possible, try to check if all the st2 services are running and up, also look deeper in the st2 logs for misconfiguration, and backend logs like MongoDB and RabbitMQ if they're working properly.