How to increase connection timeout using sqlalchemy with sqlite in python

Question

I am using sqlite (v2.6.0) as database backend and using sqlalchemy(v0.7.9) to operate it. Recently I got a error OperationalError: (OperationalError) database is locked

By searching stackoverflow a possible solution is to increase the timeout of a connection. Referece: OperationalError: database is locked

But I don't know how to did that in sqlalchemy (since connection are actually controlled by it) Can someone give me a direction?

fwiw, increasing the timeout is likely only going to make this error less frequent. it's better to implement retries. — andrew cooke
– andrew cooke, Commented Feb 25, 2013 at 13:52

Audrius Kažukauskas · Accepted Answer · 2013-02-25 12:04:21Z

31

SQLAlchemy's create_engine() takes an argument connect_args which is a dictionary that will be passed to connect() of the underlying DBAPI (see Custom DBAPI connect() arguments). sqlite3.connect() accepts timeout argument, so this should work:

create_engine('sqlite:///some.db', connect_args={'timeout': 15})

answered Feb 25, 2013 at 12:04

Audrius Kažukauskas

13.6k4 gold badges56 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Steve Saporta Over a year ago

In case anyone is trying to solve the same problem for PostgreSQL 9.3, the connect_args argument would be spelled differently: connect_args={'connect_timeout': 15}

Sanandrea Over a year ago

The actual argument name depends on the dialect and driver that is used to connect to the database. The @SteveSaporta comments relates most probably to the psycopg2 dbapi, while PostgreSQL has other possible drivers such as pg8000 which expects a timeout argument.

Collectives™ on Stack Overflow

How to increase connection timeout using sqlalchemy with sqlite in python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related