← Back to team overview

dhis2-devs team mailing list archive

[Bug 1490174] [NEW] Deleting Data Elements in UI very slow / hanging

 

Public bug reported:

I have observed this behaviour multiple times now (2.18 and 2.19:

When deleting data elements from the data element list, the process is
unreasonably slow (2-8 minutes) on a relatively slow connection (in this
case I'm using a basic 1mbits connection in Norway running into a Cape
Town server) AND in most cases the "progress bar message" DELETING.....
is never replaced by the "Object deleted" message.

When deleting similar data elements from a local instance, it takes
around 15 seconds. This is also relatively slow, in particular since the
most demanding lookup into the datavalue table only takes around 1
second running as a separate pgSQL query - which leads me to suspect
that there is some inefficient code (nested query or similar) in the
delete DE sequence.

With a slow connection, it seems like the DE delete sequence takes so
long that some kind of time-out takes place.

In some cases, refreshing the browser page will show that the deleted DE
is gone - in other cases the browser (cache) still shows the DE is
there, whereas  checking the server instance via pgremote shows the DE
has indeed been deleted. If the refresh button is hit too early - let us
say within 1-2 minutes - there's no change in the database.

Note that I have only observed this low performance / tendency to "hang"
when deleting Data Elements - all other deletions seems to be quick.

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1490174

Title:
  Deleting Data Elements in UI very slow / hanging

Status in DHIS:
  New

Bug description:
  I have observed this behaviour multiple times now (2.18 and 2.19:

  When deleting data elements from the data element list, the process is
  unreasonably slow (2-8 minutes) on a relatively slow connection (in
  this case I'm using a basic 1mbits connection in Norway running into a
  Cape Town server) AND in most cases the "progress bar message"
  DELETING..... is never replaced by the "Object deleted" message.

  When deleting similar data elements from a local instance, it takes
  around 15 seconds. This is also relatively slow, in particular since
  the most demanding lookup into the datavalue table only takes around 1
  second running as a separate pgSQL query - which leads me to suspect
  that there is some inefficient code (nested query or similar) in the
  delete DE sequence.

  With a slow connection, it seems like the DE delete sequence takes so
  long that some kind of time-out takes place.

  In some cases, refreshing the browser page will show that the deleted
  DE is gone - in other cases the browser (cache) still shows the DE is
  there, whereas  checking the server instance via pgremote shows the DE
  has indeed been deleted. If the refresh button is hit too early - let
  us say within 1-2 minutes - there's no change in the database.

  Note that I have only observed this low performance / tendency to
  "hang" when deleting Data Elements - all other deletions seems to be
  quick.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1490174/+subscriptions


Follow ups