Comment 6 for bug 713216

Revision history for this message
Raphaƫl Valyi - http://www.akretion.com (rvalyi) wrote : Re: [Bug 713216] Re: MRP Locks down server

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.

On Fri, Feb 18, 2011 at 3:13 PM, Olivier Dony (OpenERP) <
<email address hidden>> wrote:

> Kyle, one way to analyze this further would be if you could run the
> following query directly in a psql client at the time the problem
> occurs, and give us the output. This will display all running queries
> and the locks they hold:
>
> -- Diagnose locks
> select
> pg_stat_activity.datname,
> pg_class.relname,
> pg_locks.transactionid,
> pg_locks.virtualxid,
> pg_locks.virtualtransaction,
> pg_locks.mode,
> pg_locks.granted,
> pg_stat_activity.usename,
> pg_stat_activity.current_query,
> pg_stat_activity.query_start,
> pg_stat_activity.procpid
> from pg_stat_activity,
> pg_locks left outer join pg_class
> on (pg_locks.relation = pg_class.oid)
> where pg_locks.pid=pg_stat_activity.procpid
> and procpid != pg_backend_pid()
> order by procpid, query_start;
>
>
> You can attach the output as a text file or put it on http://pastebin.com/or similar, in order to avoid issues with comment wrapping.
>
> Thanks!
>
> ** Summary changed:
>
> - MRP Locks down server
> + Cannot login while MRP scheduler is running
>
> --
> You received this bug notification because you are subscribed to OpenERP
> Server.
> 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.
>