On Friday 18 February 2011, you wrote: > Olivier, > > Sorry, I know no simple way to reproduce those issues I have been observing > in production (basically fill of confirmed orders with not enough stock and > no order point rule), this typically happen during the go live of > ecommerces connectors if you don't deal with it. > Also, I can tell you that this is not only the MRP queries that lock down > the server. For instance, during the slow picking or impossible invoice > cancel bugs I reported, it was impossible either to connect to the server. > Looks like as long as we have some long Python loop also talking to > Postgres, it's like it has a priority over all other connections. May be > something to do with Python GIL (Giant Interpreter Lock), not sure.
So, a few points to consider: - are you totally unable to login() during these problems? What is the load of the system at that time? (we want to see if it's PG locks or python GIL) - does the system recover by itself, or needs some intervention (restart of server eg.) - do the ecommerce connectors, by any means, touch the res.users table? - please, try to run the query Odo gave you, while the lockups are happening. - can you count the threads of the openerp-server process? -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/713216 Title: Cannot login while MRP scheduler is running Status in OpenERP Server: Incomplete Bug description: When using the Manufacturing scheduler in a medium sized environment the scheduler will lock down the server in a way where not a single user may connect to the server. The login window shows up but when you type your password and click login it goes to a white screen and nothing happens, because the manufacturing scheduler is preventing the server from letting anyone log in. If you were already logged in then you can use the program. Quite frustrating. Sure the manufacturing scheduler is supposed to run at night, but that is still a bug. _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
