Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009140
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2009-05-22 11:472009-08-20 00:00
ReporterroklenardicView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision40c4d1285238
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionUbuntu 9.04Database version8.3.7Ant version1.7.1
Product Version2.50MP1SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009140: Delete Client never finishes

DescriptionDelete Client does not finish after 30 minutes despite the new client being empty (not trying to delete big bazaar). Weird behaviour considering a 2.5Ghz dualcore computer with 4Gb or RAM.

I was using the 2.50MP1 virtual machine with virtual box
Steps To Reproduce1) create a new client using Initial Client Setup
2) do the Delete Client
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0016606)
rafaroda (viewer)
2009-05-25 10:07

 Hi Rok,

I was able to delete a newly created Client in 2 minutes.

Could you please try to reproduce this issue again?

Thanks.
(0016656)
roklenardic (viewer)
2009-05-26 12:56

 OK, it finished but in the VM it needs around 20minutes, weird.
(0016757)
psarobe (viewer)
2009-05-29 11:14

 I face the same issue in VMware
(0017756)
roklenardic (viewer)
2009-07-02 11:58

 Just tested MP2 virtual machine, and again, on a brand new 2.5Ghz, 3Gb RAM computer it takes almost 45minutes to delete a practically empty client just created using the initial client setup.

this was scheduled for a fix in mp1, nothing has happened though?
(0018687)
shuehner (administrator)
2009-07-29 13:16

 I could reproduce the issue with the 2.50MP2 virtualbox appliance. Setup in virtualbox 1G mem for the vm not other special setup.

Testcase:
1.) Initial Client setup (w.o. accounting)
2.) Delete client (runtime was about 30-45min)
(0018688)
roklenardic (viewer)
2009-07-29 13:23

 I suspect the VM uses so much memory with this process that it starts swapping and becomes exponentially slow.

This does not happen on a properly configured local machine where a delete client operation takes 2-5mins.
(0018689)
shuehner (administrator)
2009-07-29 14:31

 Note: Testing reveals zero swap usage on host and inside the vm, nearly zero i/o.

I suppose your local machine testcase is not an exact replica meaning it will likely not contain the BigBazaar client. Could you confirm.

Main reason for the slowness is usage of an NOT IN (list) clause which is not optimized by postgres and together with BigBazaar which ships 70k lines in several tables makes it really slow. Checking postgres logfile reveals that >=90% time is spent in only a few sql statements using this idiom.

A possible solution is known for this but involves splitting the pl into different coedepath for oracle/postgres :(
(0018692)
hgbot (developer)
2009-07-29 16:55

 Repository: erp/devel/pi
Changeset: f677d6c966a21a66c0ae0e8646710cef3eb4de28
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jul 29 16:55:40 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f677d6c966a21a66c0ae0e8646710cef3eb4de28 [^]

Fixed 9140: Speed up delete client on postgres

---
M src-db/database/model/postscript-PostgreSql.sql
---
(0018698)
hgbot (developer)
2009-07-29 18:22

 Repository: erp/devel/pi
Changeset: 40c4d1285238b88e6557a346cab8662060375464
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jul 29 18:19:07 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/40c4d1285238b88e6557a346cab8662060375464 [^]

Issue 9140: Fix stupid qouting error in last commit

---
M src-db/database/model/postscript-PostgreSql.sql
---
(0019048)
sureshbabu (viewer)
2009-08-19 11:15

 Tested working fine can able to delete within 3 to 4 minutes in virtual box)

- Issue History
Date Modified Username Field Change
2009-05-22 11:47 roklenardic New Issue
2009-05-22 11:47 roklenardic Assigned To => rafaroda
2009-05-22 11:47 roklenardic OBNetwork customer => No
2009-05-25 10:07 rafaroda Note Added: 0016606
2009-05-25 10:07 rafaroda Status new => feedback
2009-05-26 12:56 roklenardic Note Added: 0016656
2009-05-29 11:14 psarobe Status feedback => scheduled
2009-05-29 11:14 psarobe Note Added: 0016757
2009-05-29 11:14 psarobe Assigned To rafaroda => shuehner
2009-05-29 11:14 psarobe fix_in_branch => pi
2009-05-29 11:15 psarobe Priority normal => high
2009-05-29 11:15 psarobe fix_in_branch pi =>
2009-07-02 11:58 roklenardic Note Added: 0017756
2009-07-29 13:16 shuehner Note Added: 0018687
2009-07-29 13:23 roklenardic Note Added: 0018688
2009-07-29 14:31 shuehner Note Added: 0018689
2009-07-29 16:55 hgbot Checkin
2009-07-29 16:55 hgbot Note Added: 0018692
2009-07-29 16:55 hgbot Status scheduled => resolved
2009-07-29 16:55 hgbot Resolution open => fixed
2009-07-29 16:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f677d6c966a21a66c0ae0e8646710cef3eb4de28 [^]
2009-07-29 18:22 hgbot Checkin
2009-07-29 18:22 hgbot Note Added: 0018698
2009-07-29 18:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f677d6c966a21a66c0ae0e8646710cef3eb4de28 [^] => http://code.openbravo.com/erp/devel/pi/rev/40c4d1285238b88e6557a346cab8662060375464 [^]
2009-08-19 11:15 sureshbabu Status resolved => closed
2009-08-19 11:15 sureshbabu Note Added: 0019048
2009-08-19 11:15 sureshbabu Fixed in Version => pi
2009-08-20 00:00 anonymous sf_bug_id 0 => 2840618

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker