Hi All, Could someone help me in understanding why I am getting this error. Have installed rasa x and after running rasa x command, I am getting below error.
This is error getting in terminal:
(venv) user@chatbot-poc:~$ rasa x
Preparing the local database...
Traceback (most recent call last):
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1803, in _execute_context
cursor, statement, parameters, context
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: True
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/user/venv/lib/python3.6/site-packages/rasa/cli/x.py", line 502, in run_locally
domain_path=domain_path,
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/local.py", line 196, in main
sql_migrations.run_migrations(session)
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 35, in run_migrations
_run_schema_migrations(session)
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 52, in _run_schema_migrations
_run_alembic_migration(alembic_config)
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/sql_migrations.py", line 76, in _run_alembic_migration
command.upgrade(alembic_config, target_revision)
File "/home/user/venv/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade
script.run_env()
File "/home/user/venv/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "/home/user/venv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "/home/user/venv/lib/python3.6/site-packages/alembic/util/compat.py", line 184, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/database/schema_migrations/alembic/env.py", line 96, in <module>
run_migrations_online()
File "/home/user/venv/lib/python3.6/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 "/home/user/venv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/user/venv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 522, in run_migrations
step.migration_fn(**kw)
File "/home/user/venv/lib/python3.6/site-packages/rasax/community/database/schema_migrations/alembic/versions/migration_2021_06_16_speedup_in_training_data_update_652500998f3e.py", line 42, in upgrade
sqlite_where=sa.text(index_text),
File "/usr/lib/python3.6/contextlib.py", line 88, in __exit__
next(self.gen)
File "/home/user/venv/lib/python3.6/site-packages/alembic/operations/base.py", line 353, in batch_alter_table
impl.flush()
File "/home/user/venv/lib/python3.6/site-packages/alembic/operations/batch.py", line 82, in flush
fn(*arg, **kw)
File "/home/user/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 283, in create_index
self._exec(schema.CreateIndex(index))
File "/home/user/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 141, in _exec
return conn.execute(construct, *multiparams, **params)
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1289, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 81, in _execute_on_connection
self, multiparams, params, execution_options
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1387, in _execute_ddl
compiled,
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
e, statement, parameters, cursor, context
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2027, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1803, in _execute_context
cursor, statement, parameters, context
File "/home/user/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: True
[SQL: CREATE INDEX message_log_in_training_data_idx ON message_log (in_training_data) WHERE in_training_data is True]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
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/.
Below are the rasa and OS details,
Rasa Version : 2.8.20
Rasa SDK : 2.8.3
Rasa X Version : 1.0.1
Python Version : 3.6.9
OS : Ubuntu 18.04