c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

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.