sqlalchemy + sqlite + multiprocessing gives DetachedInstance error - sometimes -
i have problem using sqlalchemy , multiprocessing sqlite. using default nullpool. create session in main process , pass multiple workers , entities passed workers through same queue.
sporadically hit detached instance error inside workers,. workers , master share same session instance.i have tried several times reproduce, issue not reproducible @ will. suggestions on how attack issue helpful
why don't use scoped session? http://docs.sqlalchemy.org/en/improve_toc/orm/contextual.html seems incapsulates creating of new session instance in each new thread (or process understand). check if helps you.
Comments
Post a Comment