I find this error when trying to run Rasa x

sfclarisse · December 7, 2021, 8:48pm

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)

nik202 · December 7, 2021, 9:54pm

@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 ?

sfclarisse · December 7, 2021, 10:00pm

screenshot1

I installed using pip install rasa-x --extra-index-url https://pypi.rasa.com/simple´

nik202 · December 7, 2021, 10:02pm

@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 · December 7, 2021, 10:07pm

I am simply trying to run “Rasa x”, and I find these errors.

nik202 · December 7, 2021, 10:08pm

@sfclarisse try delete .db files from the project folder and run ?

sfclarisse · December 7, 2021, 10:21pm

I did this, the same error happened. Do you think I should downgrade the Rasa X or the error isn’t about this?

nik202 · December 7, 2021, 10:24pm

@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 · December 9, 2021, 5:16pm

I tried both versions, I keep seeing the same error.

nik202 · December 9, 2021, 5:30pm

@sfclarisse according to this error, you should delete the .db files events and rasa and again run rasa x.

Abbott · December 14, 2021, 12:44pm

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.

MyAccountAccess

sfclarisse · December 14, 2021, 1:35pm

How do I know which versions are supported to install in the virtual environment?

sfclarisse · December 14, 2021, 7:39pm

could you tell me what happened? what can i do to solve?

nik202 · December 14, 2021, 7:56pm

@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 ?

sfclarisse · December 15, 2021, 6:50pm

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?

nik202 · December 15, 2021, 6:52pm

@sfclarisse means when you type rasa x are you able to see rasa x GUI is opening in default web browser.

sfclarisse · December 15, 2021, 6:52pm

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/.```

nik202 · December 15, 2021, 6:59pm

@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

Topic		Replies	Views
Rasa x not working [Deprecated] Rasa X Community Edition	4	1779	September 14, 2021
Getting SQLAlchemy error while running rasa x command [Deprecated] Rasa X Community Edition	8	2042	April 13, 2022
Error Occurred while launching rasa x [Deprecated] Rasa X Community Edition	12	1851	January 13, 2022
Error with rasa x command [Deprecated] Rasa X Community Edition	9	4143	March 23, 2022
SQLite error when starting Rasa X in local mode [Deprecated] Rasa X Community Edition	2	1129	December 4, 2019

I find this error when trying to run Rasa x

Related topics