openerp-india team mailing list archive

[Kyle Waid <1077985@xxxxxxxxxxxxxxxxxx>]

Thank you for the response, however I strongly disagree. This is a major
issue with the software. If I close my browser, it should immediately
kill the query executing. If I have a reverse proxy and timeout occurs,
it should immediately kill the query.


Image a user trying to do a full export from the product catalog and you have thousands of records. They get frustrated because the ORM is slow, which it is, they close the browser. Open a new one and try again. Each time they try the software will open a new cursor and try and execute the massive operation. If only granted simple export capability, I could easily crash any OpenERP system.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1077985

Title:
  Connection not released after browser close

Status in OpenERP Server:
  Opinion

Bug description:
  In the web client, I go to the product normal form. By default it
  loads 80 records. Takes only a few seconds. I can change the filter to
  show unlimited. This generation takes significantly longer because the
  application tries to compute the stock for each product. The more
  stock moves you have the longer it takes. Sometimes this operation can
  take more than 1 minute. During this load time, if I decide to close
  my browser the query will continue to execute server side. It only
  stops when it is completed. I could perform this operation with
  several browser windows until the system is deadlocked and out of
  shared memory. This is a major design flaw.

  
  If I close my browser, it should immediately terminate the connection executing server side. Any type of long running operation will compound to this problem. Especially if the user becomes impatient, closes the window and opens a new window for a second attempt.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1077985/+subscriptions