You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using sqlite3 pooled connections and executing an update SQL, the connection is never returned back to the pool after the update completes. When using select SQL statements, everything works properly.
Both select and update emit the close event, but only select emits the end event.
It looks like ConnectionPool releases the connection only when it gets the end event. Since end is never emitted with update statements, the connection is never returned to the pool.
The text was updated successfully, but these errors were encountered:
grncdr
changed the title
Pooled connections not released
SQLite3 pooled connections not released
Feb 12, 2020
When using sqlite3 pooled connections and executing an
update
SQL, the connection is never returned back to the pool after the update completes. When usingselect
SQL statements, everything works properly.Both
select
andupdate
emit theclose
event, but onlyselect
emits theend
event.It looks like
ConnectionPool
releases the connection only when it gets theend
event. Sinceend
is never emitted withupdate
statements, the connection is never returned to the pool.The text was updated successfully, but these errors were encountered: