Preparing the local database...
Traceback (most recent call last):
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\default.py", line 719, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table conversation_channel_statistic already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "c:\program files\python38\lib\site-packages\rasa\cli\x.py", line 496, in run_locally
local.main(
File "c:\program files\python38\lib\site-packages\rasax\community\local.py", line 196, in main
sql_migrations.run_migrations(session)
File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 35, in run_migrations
_run_schema_migrations(session)
File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 52, in _run_schema_migrations
_run_alembic_migration(alembic_config)
File "c:\program files\python38\lib\site-packages\rasax\community\sql_migrations.py", line 76, in _run_alembic_migration
command.upgrade(alembic_config, target_revision)
File "c:\program files\python38\lib\site-packages\alembic\command.py", line 298, in upgrade
script.run_env()
File "c:\program files\python38\lib\site-packages\alembic\script\base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "c:\program files\python38\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "c:\program files\python38\lib\site-packages\alembic\util\compat.py", line 184, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 783, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "c:\program files\python38\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
run_migrations_online()
File "c:\program files\python38\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 86, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "c:\program files\python38\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "c:\program files\python38\lib\site-packages\alembic\runtime\migration.py", line 522, in run_migrations
step.migration_fn(**kw)
File "c:\program files\python38\lib\site-packages\rasax\community\database\schema_migrations\alembic\versions\migration_2021_08_13_statistic_on_used_channel_names_017cb274256f.py", line 71, in upgrade
op.create_table(
File "<string>", line 8, in create_table
File "<string>", line 3, in create_table
File "c:\program files\python38\lib\site-packages\alembic\operations\ops.py", line 1252, in create_table
return operations.invoke(op)
File "c:\program files\python38\lib\site-packages\alembic\operations\base.py", line 373, in invoke
return fn(self, operation)
File "c:\program files\python38\lib\site-packages\alembic\operations\toimpl.py", line 101, in create_table
operations.impl.create_table(table)
File "c:\program files\python38\lib\site-packages\alembic\ddl\impl.py", line 259, in create_table
self._exec(schema.CreateTable(table))
File "c:\program files\python38\lib\site-packages\alembic\ddl\impl.py", line 141, in _exec
return conn.execute(construct, *multiparams, **params)
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1289, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "c:\program files\python38\lib\site-packages\sqlalchemy\sql\ddl.py", line 77, in _execute_on_connection
return connection._execute_ddl(
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1381, in _execute_ddl
ret = self._execute_context(
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1845, in _execute_context
self._handle_dbapi_exception(
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 2026, in _handle_dbapi_exception
util.raise_(
File "c:\program files\python38\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "c:\program files\python38\lib\site-packages\sqlalchemy\engine\default.py", line 719, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table conversation_channel_statistic already exists
[SQL:
CREATE TABLE conversation_channel_statistic (
project_id VARCHAR(255) NOT NULL,
channel VARCHAR(255) NOT NULL,
count INTEGER,
PRIMARY KEY (project_id, channel),
FOREIGN KEY(project_id) REFERENCES conversation_statistic (project_id)
)
]
(Background on this error at: https://sqlalche.me/e/14/e3q8)```
**Rasa Version : 2.8.15**
**Minimum Compatible Version: 2.8.9**
**Rasa SDK Version : 2.8.3**
**Rasa X Version : 1.0.0**
**Python Version : 3.8.3**
**Operating System : Windows-10-10.0.19041-SP0**
**Python Path : c:\program files\python38\python.exe**
**Pip Version: pip 20.1.1 from C:\Users\clari\Anaconda3\lib\site-packages\pip (python 3.8)**
Can someone help me? (Sorry in advance, I'm not good at English)
@sfclarisse can you please confirm how you installed rasa x in your local machine? and are you sure your rasa x version is the same as mention please even share rasa --version
?
I installed using
pip install rasa-x --extra-index-url https://pypi.rasa.com/simple
´
@sfclarisse really, Rasa X version is 1.0.0 I never seen this version Compatibility Matrix. I guess I am outdated now. Anyways, what is the issue you facing? and what command you running as you encountered the error, for me please share the screenshot from the command you entered.
@sfclarisse try delete .db files from the project folder and run ?
I did this, the same error happened. Do you think I should downgrade the Rasa X or the error isn’t about this?
@sfclarisse well, honestly I haven’t seen this version, I am amazed how you install this version Try at least 0.42.4, may be. I guess you have even install previously 0.39.3 also?
@sfclarisse according to this error, you should delete the .db files events and rasa and again run rasa x.
This error message is more likely a python library compatibility problem. Your multidict, gast, numpy packages are not the version that rasa needs. A solution for this is to use virtual environment and install the compatible version of multidict, gast, numpy packages in that virtual environment.
How do I know which versions are supported to install in the virtual environment?
@sfclarisse please share me again your rasa --version?
I am sure, you are using 0.39.3 ? If so, you are able to talk with bot while using rasa x GUI and on terminal you are only seeing this error, is that right or me just guessing ?
rasa x GUI? What does it mean? I can talk to the bot in the terminal, but isn’t that the ‘open source’ rasa feature?
@sfclarisse means when you type rasa x are you able to see rasa x GUI is opening in default web browser.
Starting Rasa X in local mode... 🚀
Traceback (most recent call last):
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 162, in _catch_revision_errors
yield
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 364, in _upgrade_revs
revs = list(revs)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 765, in _iterate_revisions
requested_lowers = self.get_revisions(lower)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in get_revisions return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in <listcomp>
return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in get_revisions for rev_id in resolved_id
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in <genexpr>
for rev_id in resolved_id
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 397, in _revision_for_ident
resolved_id,
alembic.script.revision.ResolutionError: No such revision or branch '652500998f3e'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasa\cli\x.py", line 500, in run_locally
domain_path=domain_path,
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\local.py", line 234, in main
sql_migrations.run_migrations(session)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 25, in run_migrations
_run_schema_migrations(session)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 41, in _run_schema_migrations
_run_alembic_migration(alembic_config)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\sql_migrations.py", line 65, in _run_alembic_migration
command.upgrade(alembic_config, target_revision)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\command.py", line 298, in upgrade
script.run_env()
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 184, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 96, in <module>
run_migrations_online()
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\rasax\community\database\schema_migrations\alembic\env.py", line 86, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\runtime\environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\runtime\migration.py", line 511, in run_migrations
for step in self._migrations_fn(heads, self):
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\command.py", line 287, in upgrade
return script._upgrade_revs(revision, rev)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 369, in _upgrade_revs
for script in reversed(list(revs))
File "c:\users\clari\anaconda3\envs\ambiente\lib\contextlib.py", line 130, in __exit__
self.gen.throw(type, value, traceback)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 194, in _catch_revision_errors
compat.raise_from_cause(util.CommandError(resolution))
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 308, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\util\compat.py", line 301, in reraise
raise value.with_traceback(tb)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 162, in _catch_revision_errors
yield
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\base.py", line 364, in _upgrade_revs
revs = list(revs)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 765, in _iterate_revisions
requested_lowers = self.get_revisions(lower)
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in get_revisions return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 319, in <listcomp>
return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in get_revisions for rev_id in resolved_id
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 324, in <genexpr>
for rev_id in resolved_id
File "c:\users\clari\anaconda3\envs\ambiente\lib\site-packages\alembic\script\revision.py", line 397, in _revision_for_ident
resolved_id,
alembic.util.exc.CommandError: Can't locate revision identified by '652500998f3e'
Sorry, something went wrong (see error above). Make sure to start Rasa X with valid data and valid domain and config files. Please, also check any warnings that popped up.
If you need help fixing the issue visit our forum: http://forum.rasa.com/.```
@sfclarisse ok can you delete the rasa .db files such as events and rasa from project folder and try run rasa x again?
@sfclarisse always mention me with @ nik202