Hi,
I amd installing mistral from stable/2023.1 branch according to this page https://docs.openstack.org/mistral/latest/admin/install/install-ubuntu.html#installation
i had errors while using 'tox' command.
python is 3.10.6
pip is 22.0.2
environment is ubuntu 22.04.6 LTS
below is part of the logs.
mistral.tests.unit.api.v2.test_event_trigger.TestEventTriggerController.test_put
--------------------------------------------------------------------------------
Captured traceback:
~~~~~~~~~~~~~~~~~~~
Traceback (most recent call last):
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: event_triggers_v2
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/mistral/mistral/tests/unit/base.py", line 291, in _clean_db
db_api.delete_event_triggers()
File "/root/mistral/mistral/db/v2/api.py", line 708, in delete_event_triggers
return IMPL.delete_event_triggers(**kwargs)
File "/root/mistral/mistral/db/sqlalchemy/base.py", line 132, in _within_session
result = func(*args, **kw)
File "/root/mistral/mistral/db/v2/sqlalchemy/api.py", line 2072, in delete_event_triggers
return _delete_all(models.EventTrigger, **kwargs)
File "/root/mistral/mistral/db/v2/sqlalchemy/api.py", line 262, in _delete_all
query.delete(synchronize_session=False)
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3213, in delete
result = self.session.execute(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1712, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection
return connection._execute_clauseelement(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
ret = self._execute_context(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
self._handle_dbapi_exception(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception
util.raise_(newraise, with_traceback=exc_info[2], from_=e)
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/root/mistral/.tox/py3/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: event_triggers_v2
[SQL: DELETE FROM event_triggers_v2 WHERE event_triggers_v2.project_id = ? OR event_triggers_v2.scope = ?]
[parameters: ('99-88-33', 'public')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
======
Totals
======
Ran: 192 tests in 3.3616 sec.
- Passed: 53
- Skipped: 2
- Expected Fail: 0
- Unexpected Success: 0
- Failed: 137
Sum of execute time for each test: 5.8977 sec.
==============
Worker Balance
==============
- Worker 0 (97 tests) => 0:00:02.737008
- Worker 1 (95 tests) => 0:00:03.361629
Test id Runtime (s)
------------------------------------------------------------------------------------------------------------------------ -----------
mistral.tests.unit.api.v2.test_execution_report.TestExecutionReportController.test_estimated_time_no_previous_executions 1.265
mistral.tests.unit.api.v2.test_execution_report.TestExecutionReportController.test_estimated_time 1.188
mistral.tests.unit.api.test_resource_base.TestRestResource.test_from_db_model_workflow_with_input 0.336
mistral.tests.unit.api.v2.test_action_executions.TestActionExecutionsController.test_basic_get 0.198
mistral.tests.unit.actions.test_adhoc_action_provider.AdHocActionProviderTest.test_adhoc_actions 0.152
mistral.tests.unit.api.test_resource_base.TestRestResource.test_from_db_model_workflow_resource 0.125
mistral.tests.unit.api.test_resource_base.TestRestResource.test_from_db_model_workflow_resource_no_params 0.114
mistral.tests.unit.api.test_cors_middleware.TestCORSMiddleware.test_invalid_cors_get_request 0.075
mistral.tests.unit.actions.test_std_mistral_http_action.MistralHTTPActionTest.test_http_action_error_result 0.067
mistral.tests.unit.actions.test_action_service.LegacyActionProviderTest.test_get_system_action_provider 0.059
ERROR: InvocationError for command /root/mistral/.tox/py3/bin/stestr run --slowest (exited with code 1)
/root/mistral/.tox/pep8/lib/python3.10/site-packages/nose/config.py:142: DeprecationWarning: invalid escape sequence '\.'
"""nose configuration.
/root/mistral/.tox/pep8/lib/python3.10/site-packages/nose/importer.py:12: DeprecationWarning: the imp module is deprecated in favour of importlib and slated for removal in Python 3.12; see the module's documentation for alternative uses
from imp import find_module, load_module, acquire_lock, release_lock
/root/mistral/.tox/pep8/lib/python3.10/site-packages/nose/inspector.py:111: DeprecationWarning: invalid escape sequence '\ '
"""Find lines in home that are inspectable.
/root/mistral/.tox/pep8/lib/python3.10/site-packages/setuptools/command/easy_install.py:158: EasyInstallDeprecationWarning: easy_install command is deprecated. Use build and pip and other standards-based tools.
warnings.warn(
/root/mistral/.tox/pep8/lib/python3.10/site-packages/setuptools/command/install.py:34: SetuptoolsDeprecationWarning: setup.py install is deprecated. Use build and pip and other standards-based tools.
warnings.warn(
pep8 develop-inst-noop: /root/mistral
pep8 installed: /root/mistral/.tox/pep8/lib/python3.10/site-packages/pip/_internal/locations/_distutils.py:9: DeprecationWarning: The distutils package is deprecated and slated for removal in Python 3.12. Use setuptools or check PEP 632 for potential alternatives, from distutils.cmd import Command as DistutilsCommand,/usr/lib/python3.10/distutils/command/install.py:13: DeprecationWarning: The distutils.sysconfig module is deprecated, use sysconfig instead, from distutils.sysconfig import get_config_vars, is_virtual_environment,alembic==1.9.4,amqp==5.1.1,attrs==23.1.0,autopage==0.5.1,bcrypt==4.0.1,beautifulsoup4==4.12.2,cachetools==5.3.0,certifi==2023.5.7,cffi==1.15.1,charset-normalizer==3.1.0,cliff==4.3.0,cmd2==2.4.3,coverage==7.2.3,croniter==1.3.14,cryptography==40.0.2,debtcollector==2.5.0,decorator==5.1.1,defusedxml==0.7.1,dnspython==2.3.0,doc8==0.11.2,docutils==0.17.1,dogpile.cache==1.1.8,entrypoints==0.3,eventlet==0.33.3,extras==1.0.0,fasteners==0.18,fixtures==4.0.1,flake8==3.7.9,future==0.18.3,futurist==2.4.1,greenlet==2.0.2,hacking==3.0.1,idna==3.4,importlib-metadata==6.0.1,iso8601==1.1.0,Jinja2==3.1.2,jsonschema==4.17.3,kazoo==2.9.0,keystoneauth1==5.2.0,keystonemiddleware==10.3.0,kombu==5.2.4,linecache2==1.0.0,logutils==0.3.5,Mako==1.2.4,MarkupSafe==2.1.2,mccabe==0.6.1,-e git+https://opendev.org/openstack/mistral@bbe6b2ff66b41038eaa6896eb3cc87dce3ae7e87#egg=mistral,mistral-lib==2.8.0,msgpack==1.0.5,netaddr==0.8.0,netifaces==0.11.0,networkx==3.1,nose==1.3.7,os-service-types==1.7.0,oslo.cache==3.4.0,oslo.concurrency==5.1.1,oslo.config==9.1.1,oslo.context==5.1.1,oslo.db==12.3.1,oslo.i18n==6.0.0,oslo.log==5.2.0,oslo.messaging==14.3.1,oslo.metrics==0.6.0,oslo.middleware==5.1.1,oslo.policy==4.2.0,oslo.serialization==5.1.1,oslo.service==3.1.1,oslo.utils==6.1.0,oslotest==4.5.0,osprofiler==3.4.3,packaging==23.1,paramiko==3.1.0,Paste==3.5.2,PasteDeploy==3.0.1,pbr==5.11.1,pecan==1.4.2,ply==3.11,prettytable==3.7.0,prometheus-client==0.16.0,py-mini-racer==0.6.0,pycadf==3.1.1,pycodestyle==2.5.0,pycparser==2.21,pyflakes==2.1.1,Pygments==2.15.1,pyinotify==0.9.6,PyJWT==2.6.0,PyNaCl==1.5.0,pyparsing==3.0.9,pyperclip==1.8.2,pyrsistent==0.19.3,python-dateutil==2.8.2,python-keystoneclient==5.1.0,python-subunit==1.4.2,pytz==2023.3,PyYAML==6.0,repoze.lru==0.7,requests==2.28.2,requests-mock==1.10.0,restructuredtext-lint==1.4.0,rfc3986==2.0.0,Routes==2.5.1,simplegeneric==0.8.1,six==1.16.0,soupsieve==2.4.1,SQLAlchemy==1.4.41,sqlalchemy-migrate==0.13.0,sqlparse==0.4.4,statsd==4.0.1,stestr==4.0.1,stevedore==5.1.0,tempest==35.0.0,Tempita==0.5.2,tenacity==6.3.1,testresources==2.0.1,testscenarios==0.5.0,testtools==2.6.0,tooz==4.1.0,traceback2==1.4.0,unittest2==1.1.0,urllib3==1.26.15,vine==5.0.0,voluptuous==0.13.1,waitress==2.1.2,wcwidth==0.2.6,WebOb==1.8.7,WebTest==3.0.0,wrapt==1.15.0,WSME==0.11.0,yappi==1.4.0,yaql==2.0.0,zake==0.2.2,zipp==3.15.0
pep8 run-test-pre: PYTHONHASHSEED='430288132'
pep8 run-test: commands[0] | doc8 doc/source
Scanning...
Validating...
========
Total files scanned = 49
Total files ignored = 0
Total accumulated errors = 0
Detailed error counts:
- doc8.checks.CheckCarriageReturn = 0
- doc8.checks.CheckIndentationNoTab = 0
- doc8.checks.CheckMaxLineLength = 0
- doc8.checks.CheckNewlineEndOfFile = 0
- doc8.checks.CheckTrailingWhitespace = 0
- doc8.checks.CheckValidity = 0
pep8 run-test: commands[1] | flake8 . /root/mistral/tools/sync_db.py
____________________________________________________ summary _____________________________________________________
ERROR: py3: commands failed
pep8: commands succeeded
Thanks!
