WSServerHandshakeError: 505, message='Invalid response status' with SQLAlchemy #2045

davidmuraya · 2025-04-25T15:28:35Z

davidmuraya
Apr 25, 2025

Hi,

I am new to Turso and I would like to use it in a project.

This code works OK. I can connect to the database, insert and fetch the records.

import libsql_experimental as libsql
import time

url = "libsql://xx-xx.aws-us-east-1.turso.io"
auth_token = "xxx"

conn = libsql.connect("db2.db", sync_url=url, auth_token=auth_token)

start = time.perf_counter()
conn.execute("INSERT INTO election(description) VALUES ('2007');")

conn.commit()

print(conn.execute("select * from election").fetchall())

However, when I try using sqlalchemy, I get the following error:

WSServerHandshakeError: 505, message='Invalid response status', url='wss://xx-xx.aws-us-east-1.turso.io'

During handling of the above exception, another exception occurred:

OperationalError                          Traceback (most recent call last)
OperationalError: 505, message='Invalid response status', url='wss://xx-xx.aws-us-east-1.turso.io'

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

OperationalError                          Traceback (most recent call last)
[/usr/local/lib/python3.11/dist-packages/libsql_client/dbapi2/hrana.py](https://localhost:8080/#) in _acquire_connection(self, url)
    292             exc = _conv_stmt_result(None, error).errors[0]
    293             assert exc is not None  # make mypy happy
--> 294             raise exc
    295 
    296     @run_in_executor

OperationalError: (sqlite3.OperationalError) 505, message='Invalid response status', url='wss://xx-xx.aws-us-east-1.turso.io'
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Here is my code:

from sqlalchemy import Integer, Text, create_engine, select
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, Session 


class Base(DeclarativeBase):
    pass


class Election(Base):
    __tablename__ = "election"

    # id: integer primary key, auto-increments by default
    id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)

    # description: text, must be unique
    description: Mapped[str] = mapped_column(Text, unique=True)

    def __repr__(self) -> str:
        return f"Election(id={self.id!r}, description={self.description!r})"

url = "libsql://xx-xx.aws-us-east-1.turso.io"
auth_token = "xx"


dbUrl = f"sqlite+{sql_url}/?authToken={auth_token}&secure=true"


engine = create_engine(dbUrl, connect_args={'check_same_thread': False}, echo=True)

# Use the session as a context manager
with Session(engine) as session:
    elections = session.scalars(select(Election)).all()
    print(elections)

What could be this issue?

Any help is appreciated.

sanchitrk · 2025-05-26T17:47:58Z

sanchitrk
May 26, 2025

I'm getting the same error

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

WSServerHandshakeError: 505, message='Invalid response status' with SQLAlchemy #2045

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

WSServerHandshakeError: 505, message='Invalid response status' with SQLAlchemy #2045

Uh oh!

davidmuraya Apr 25, 2025

Replies: 1 comment

Uh oh!

sanchitrk May 26, 2025

davidmuraya
Apr 25, 2025

sanchitrk
May 26, 2025