Odoo Help


Unable to use a closed cursor and Thread

meriem HAKKANI
on 11/21/16, 5:23 AM 722 views


I'm developing a module importing data into a thread,Following this line I have an exception :

Unable to use a closed cursor

self.env['product.product'].search([('default_code', '=', internalRef)])

but if i don't use thread I have no exception

thanks a lot

Please show us some more of the code, it looks like the problem is on another line? :)

on 11/21/16, 5:41 AM
meriem HAKKANI
On 11/21/16, 5:52 AM

Hi Axel Mendoza

thank you very much for you answer , i tried this 


new_cr = registry(self._cr.dbname).cursor()


self = self.with_env(self.env(cr=new_cr)).with_context(original_cr=self._cr)

Axel Mendoza
On 11/21/16, 12:12 PM

Hi Merien Hakkani

In Odoo database cursor are opened at the beginning of the request and closed after the request is processed so it means that if you are using a new thread the cursor could or couldn't remain open when you wanna use it, normally it wont be open, so you may need to create a new env for self.env  with a new cursor attached in order to make it always work

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/21/16, 5:23 AM
Seen: 722 times
Last updated: 11/21/16, 12:12 PM