c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <713216@xxxxxxxxxxxxxxxxxx>]

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 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.