# Start rasa x failed due to sqlalchemy.exc.OperationalError

**URL:** <https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637>\
**Category:** \[Deprecated\] Rasa X Community Edition\
**Created:** [October 21, 2021, 7:20am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637 "2021-10-21T07:20:27Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 21, 2021, 7:20am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/1 "2021-10-21T07:20:27Z")

</div>

I made a python virtualenv using python3.6. Then I installed rasa and rasa x: pip install rasa pip install rasa-x --extra-index-url [Simple Index](https://pypi.rasa.com/simple)

environment: X64 linux centos7.9 Python 3.6.13

I run rasa init to initiate a new project and trained it. When I started rasa x in this project folder, I got a strange problem:

(rasax) [root@localhost rasaxtest]# rasa x Starting Rasa X in local mode… 0m Traceback (most recent call last): File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1800, in \_execute\_context cursor, statement, parameters, context File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/default.py”, line 717, in do\_execute cursor.execute(statement, parameters) sqlite3.OperationalError: near “WHERE”: syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasa/cli/x.py”, line 502, in run\_locally domain\_path=domain\_path, File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/local.py”, line 234, in main sql\_migrations.run\_migrations(session) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/sql\_migrations.py”, line 25, in run\_migrations \_run\_schema\_migrations(session) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/sql\_migrations.py”, line 41, in \_run\_schema\_migrations \_run\_alembic\_migration(alembic\_config) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/sql\_migrations.py”, line 65, in \_run\_alembic\_migration command.upgrade(alembic\_config, target\_revision) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/command.py”, line 298, in upgrade script.run\_env() File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/script/base.py”, line 489, in run\_env util.load\_python\_file(self.dir, “env.py”) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/util/pyfiles.py”, line 98, in load\_python\_file module = load\_module\_py(module\_id, path) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/util/compat.py”, line 184, in load\_module\_py spec.loader.exec\_module(module) File “”, line 678, in exec\_module File “”, line 219, in \_call\_with\_frames\_removed File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/database/schema\_migrations/alembic/env.py”, line 96, in run\_migrations\_online() File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/database/schema\_migrations/alembic/env.py”, line 86, in run\_migrations\_online context.run\_migrations() File “”, line 8, in run\_migrations File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/runtime/environment.py”, line 846, in run\_migrations self.get\_context().run\_migrations(\*\*kw) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/runtime/migration.py”, line 522, in run\_migrations step.migration\_fn(\*\*kw) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/rasax/community/database/schema\_migrations/alembic/versions/migration\_2021\_06\_09\_make\_workspace\_id\_index\_partial\_30ec36905354.py”, line 39, in upgrade sqlite\_where=sa.text(index\_text), File “/root/py36/lib/python3.6/contextlib.py”, line 88, in **exit** next(self.gen) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/operations/base.py”, line 353, in batch\_alter\_table impl.flush() File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/operations/batch.py”, line 82, in flush fn(\*arg, \*\*kw) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/ddl/impl.py”, line 283, in create\_index self.\_exec(schema.CreateIndex(index)) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/alembic/ddl/impl.py”, line 141, in \_exec return conn.execute(construct, \*multiparams, \*\*params) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1286, in execute return meth(self, multiparams, params, \_EMPTY\_EXECUTION\_OPTS) File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py”, line 78, in \_execute\_on\_connection self, multiparams, params, execution\_options File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1384, in \_execute\_ddl compiled, File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1843, in _execute\_context e, statement, parameters, cursor, context File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 2024, in handle\_dbapi\_exception sqlalchemy\_exception, with\_traceback=exc\_info[2], from=e File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/util/compat.py”, line 207, in raise_ raise exception File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/base.py”, line 1800, in \_execute\_context cursor, statement, parameters, context File “/root/.virtualenvs/rasax/lib/python3.6/site-packages/sqlalchemy/engine/default.py”, line 717, in do\_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near “WHERE”: syntax error [SQL: CREATE INDEX msg\_log\_workspace\_id\_idx ON message\_log (workspace\_id) WHERE workspace\_id is not NULL] (Background on this error at: [Error Messages — SQLAlchemy 1.4 Documentation](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/](http://forum.rasa.com/). ^CGoodbye Goodbye Exception ignored in: \<Finalize object, dead\> Traceback (most recent call last): File “/root/py36/lib/python3.6/multiprocessing/util.py”, line 186, in **call** File “/root/py36/lib/python3.6/multiprocessing/heap.py”, line 208, in free TypeError: ‘NoneType’ object is not callable Exception ignored in: \<Finalize object, dead\> Traceback (most recent call last): File “/root/py36/lib/python3.6/multiprocessing/util.py”, line 186, in **call** File “/root/py36/lib/python3.6/multiprocessing/heap.py”, line 208, in free TypeError: ‘NoneType’ object is not callable Exception ignored in: \<Finalize object, dead\> Traceback (most recent call last): File “/root/py36/lib/python3.6/multiprocessing/util.py”, line 186, in **call** File “/root/py36/lib/python3.6/multiprocessing/heap.py”, line 208, in free TypeError: ‘NoneType’ object is not callable Exception ignored in: \<Finalize object, dead\> Traceback (most recent call last): File “/root/py36/lib/python3.6/multiprocessing/util.py”, line 186, in **call** File “/root/py36/lib/python3.6/multiprocessing/heap.py”, line 208, in free TypeError: ‘NoneType’ object is not callable

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [October 21, 2021, 10:23am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/2 "2021-10-21T10:23:16Z")

</div>

@atptour Welcome to the forum 💐

Can you share the rasa --version for us while activating the Conda based environment?

OR

Please follow these steps for the installation of ROS and Rasa X 🙂

**Note:** You can ignore few steps, if you already performed it!

Please install Anaconda from [Anaconda | Individual Edition](https://www.anaconda.com/products/individual) , then create the conda environment using the following command

1. conda create -n rasa3 python=3.8
2. conda activate rasa 3

**PS:** If you using Linux, check the environment for the same.

**Note:** I’d recommend to create a fresh environment if not you can proceed with next steps:

**For Rasa Open Source:**

```auto
`pip install rasa==2.8.1`
`pip install rasa-sdk==2.8.1'

```

check version `rasa --version` its install or not

**For Installing basic project:**

`rasa init`

then if you need

**For Rasa-X Installation**

`pip install rasa-x==0.39.3 --extra-index-url https://pypi.rasa.com/simple`

check rasa version `rasa --version` its install or not

You will see some error : ImportError: cannot import name ‘RowProxy’ from ‘sqlalchemy.engine’ Install

`pip install SQLAlchemy==1.3.22` should fix it

If sanic related error: `pip install sanic-jwt==1.6.0`

delete .db (events and rasa ) if is showing alembic issue.

If you have any error in-between please share with us.

**Note:** You will see the Event Loop Close error in the terminal, you can ignore that, its an persistent issue with Rasa X and team is working on it.

I hope this will solve your issue. Good Luck!

---

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 22, 2021, 9:00am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/3 "2021-10-22T09:00:16Z")

</div>

I tried rasa --version. The result is below. However I also tried reinstallation in Anaconda under your suggestion, it took too long time and has not finished yet. I will reply you after I finish.

(rasax) [root@localhost .cache]# rasa --version Rasa Version : 2.8.6 Minimum Compatible Version: 2.8.0 Rasa SDK Version : 2.8.2 Rasa X Version : None Python Version : 3.6.13 Operating System : Linux-3.10.0-1160.42.2.el7.x86\_64-x86\_64-with-centos-7.9.2009-Core Python Path : /root/.virtualenvs/rasax/bin/python

---

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 23, 2021, 6:59am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/4 "2021-10-23T06:59:18Z")

</div>

I follow your steps for installation of ROS and Rasa X, and I still failed to start Rasa X:

It was installed in conda with python3.8:

(rasa3) [root@localhost responseselectorbot]# rasa --version Rasa Version : 2.8.1 Minimum Compatible Version: 2.8.0 Rasa SDK Version : 2.8.1 Rasa X Version : 0.39.3 Python Version : 3.8.12 Operating System : Linux-3.10.0-1160.42.2.el7.x86\_64-x86\_64-with-glibc2.17 Python Path : /root/anaconda3/envs/rasa3/bin/python

The error of rasa x startup:

(rasa3) [root@localhost test]# rasa x Starting Rasa X in local mode… 0m Traceback (most recent call last): File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasa/cli/x.py”, line 496, in run\_locally local.main( File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/local.py”, line 234, in main sql\_migrations.run\_migrations(session) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/sql\_migrations.py”, line 25, in run\_migrations \_run\_schema\_migrations(session) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/sql\_migrations.py”, line 41, in \_run\_schema\_migrations \_run\_alembic\_migration(alembic\_config) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/sql\_migrations.py”, line 65, in \_run\_alembic\_migration command.upgrade(alembic\_config, target\_revision) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/command.py”, line 298, in upgrade script.run\_env() File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/base.py”, line 489, in run\_env util.load\_python\_file(self.dir, “env.py”) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/util/pyfiles.py”, line 98, in load\_python\_file module = load\_module\_py(module\_id, path) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/util/compat.py”, line 184, in load\_module\_py spec.loader.exec\_module(module) File “”, line 843, in exec\_module File “”, line 219, in \_call\_with\_frames\_removed File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/database/schema\_migrations/alembic/env.py”, line 96, in run\_migrations\_online() File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/database/schema\_migrations/alembic/env.py”, line 86, in run\_migrations\_online context.run\_migrations() File “”, line 8, in run\_migrations File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/runtime/environment.py”, line 846, in run\_migrations self.get\_context().run\_migrations(\*\*kw) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/runtime/migration.py”, line 511, in run\_migrations for step in self.\_migrations\_fn(heads, self): File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/command.py”, line 287, in upgrade return script.\_upgrade\_revs(revision, rev) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/base.py”, line 364, in \_upgrade\_revs revs = list(revs) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/revision.py”, line 777, in \_iterate\_revisions uppers = util.dedupe\_tuple(self.get\_revisions(upper)) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/revision.py”, line 321, in get\_revisions resolved\_id, branch\_label = self._resolve\_revision\_number(id_) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/revision.py”, line 501, in \_resolve\_revision\_number self.\_revision\_map File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/util/langhelpers.py”, line 230, in **get** obj. **dict** [self. **name**] = result = self.fget(obj) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/revision.py”, line 123, in \_revision\_map for revision in self.\_generator(): File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/base.py”, line 112, in \_load\_revisions script = Script._from\_filename(self, vers, file_) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/script/base.py”, line 906, in _from\_filename module = util.load\_python\_file(dir_, filename) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/util/pyfiles.py”, line 98, in load\_python\_file module = load\_module\_py(module\_id, path) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/alembic/util/compat.py”, line 184, in load\_module\_py spec.loader.exec\_module(module) File “”, line 843, in exec\_module File “”, line 219, in \_call\_with\_frames\_removed File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/database/schema\_migrations/alembic/versions/migration\_2019\_06\_03\_initial\_migration\_2a216ed121dd.py”, line 14, in import rasax.community.database.schema\_migrations.alembic.utils as migration\_utils File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/database/schema\_migrations/alembic/utils.py”, line 12, in from sqlalchemy.engine import reflection, RowProxy, Connection ImportError: cannot import name ‘RowProxy’ from ‘sqlalchemy.engine’ (/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/sqlalchemy/engine/ **init**.py)

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/](http://forum.rasa.com/).

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [October 23, 2021, 9:16am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/5 "2021-10-23T09:16:56Z")

</div>

> [@nik202](#):
>
> pip install SQLAlchemy==1.3.22

@atptour I hope you have seen and read my complete post, this error mention there.

For ‘RowProxy’ error:

Install

`pip install SQLAlchemy==1.3.22`

Do mention me with @ and nik202

---

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 23, 2021, 1:47pm UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/6 "2021-10-23T13:47:49Z")

</div>

Thanks! After installing sqlalchemy==1.3.22 I started rasa x and got the following loop event:

Is it the error you metioned in Note?

[2021-10-23 09:38:33 -0400] [5536] [ERROR] Exception occurred while handling uri: ‘[http://localhost:5002/api/projects/default/models/tags/production?token=b1c19770ea89768fd18055ea74bcb388](http://localhost:5002/api/projects/default/models/tags/production?token=b1c19770ea89768fd18055ea74bcb388)’ Traceback (most recent call last): File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/sanic/app.py”, line 908, in handle\_request response = await self.\_run\_request\_middleware( File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/spf/framework.py”, line 646, in \_run\_request\_middleware\_19\_12 response = await response File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/database/utils.py”, line 368, in set\_session user = await decorators.user\_from\_request(request) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/api/decorators.py”, line 90, in user\_from\_request return await \_get\_user\_from\_request(request.app, request) File “/root/anaconda3/envs/rasa3/lib/python3.8/site-packages/rasax/community/api/decorators.py”, line 73, in \_get\_user\_from\_request payload = await instance.auth.extract\_payload(request, verify=False) AttributeError: ‘Sanic’ object has no attribute ‘auth’

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [October 23, 2021, 4:14pm UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/7 "2021-10-23T16:14:49Z")

</div>

@atptour please install

`pip install sanic-jwt==1.6.0`

---

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 26, 2021, 2:07am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/8 "2021-10-26T02:07:01Z")

</div>

Thanks! It does work now. But I still have another quesiton: you mentioned that I need to install rasa and rasa-x with special version: 2.8.1 and so on. Could I install and use rasa and rasa-x with the latest version? Will the newest rasa-x version work well? Or if I could fix few problems will the newest rasa-x work?

I have tried this action, it took too long time to install all the packages and the whole installation procedure was always blocked by mutiple versions selection of pip. I have not finished the full installation yet up to now:

INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. If you want to abort this run, you can press Ctrl + C to do so. To improve how pip performs, tell us what happened here: [https://pip.pypa.io/surveys/backtracking](https://pip.pypa.io/surveys/backtracking) INFO: pip is looking at multiple versions of sniffio to determine which version is compatible with other requirements. This could take a while.

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [October 26, 2021, 9:47am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/9 "2021-10-26T09:47:10Z")

</div>

@atptour Great, can I request too please close this thread with the solution for other readers and for your reference. If your installation taking a longer time,and If you are not able to install you can downgrade the pip version to 20.2.2 (conda install pip==20.2.2)

---

<div class="post-metadata">

**Author:** ![atptour](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@atptour](https://forum.rasa.com/u/atptour)\
**Post date:** [October 26, 2021, 11:03am UTC](https://forum.rasa.com/t/start-rasa-x-failed-due-to-sqlalchemy-exc-operationalerror/48637/10 "2021-10-26T11:03:16Z")

</div>

OK. Shall I close it or you? I have never operate closing topic in this forum. I have not found out the close button.