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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006836
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalalways2009-01-09 22:072009-02-24 20:00
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityimmediateResolutionfixedFixed in Version2.50beta
StatusclosedFix in branchpiFixed in SCM revision13532
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentoo 2.6.24Database versionXEAnt version1.7
Product Version2.35MP4SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006836: Having a huge amount of records on fact_Acct (>125.000) blocks the database on deleting process.

DescriptionIf you have for than 125.000 fact_acct records and you try to delete all of them together (supouse all the periods are opened), the database gets blocked with Oracle looks.
Steps To ReproduceRegister more than 125.000 records on fact_acct (20.000 invoices, 20.000 settlements, 20.000 bankstatements, etc.).
Disable background process.
Try to erase the accounting information with the existing process Finantial management->Accounting->Transactions->Erase Accounting
Proposed Solution1-Database fine tunning.
2-Delete all the information in blocks instead of all at once.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0006846 closedshuehner Having a huge amount of records on fact_Acct (>125.000) blocks the database on deleting process. 
depends on backport 0007756 closedshuehner Having a huge amount of records on fact_Acct (>125.000) blocks the database on deleting process. 

-  Notes
(0012101)
networkb (developer)
2009-01-12 09:43

It is critical, because getting the database locked stops the production environment.
(0012106)
rafaroda (developer)
2009-01-12 13:15

This issue only reproduces in 2.3x versions.
(0012107)
rafaroda (developer)
2009-01-12 13:17

No change required in trunk.
(0013919)
shuehner (administrator)
2009-02-23 12:51

Reopen, as we want to commit the change to be done for 2.3x also for trunk and 2.40
(0013946)
svnbot (reporter)
2009-02-23 15:31

Repository: openbravo
Revision: 13532
Author: huehner
Date: 2009-02-23 15:30:56 +0100 (Mon, 23 Feb 2009)

Fixed 6836
Keep transaction size of the accounting reset process small by doing period commits.

---
U trunk/src-db/database/model/functions/FACT_ACCT_RESET.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13532&sc=1 [^]

- Issue History
Date Modified Username Field Change
2009-01-09 22:07 galderromo New Issue
2009-01-09 22:07 galderromo Assigned To => rafaroda
2009-01-09 22:07 galderromo sf_bug_id 0 => 2496478
2009-01-10 19:45 shuehner Issue Monitored: shuehner
2009-01-12 09:38 networkb Assigned To rafaroda => networkb
2009-01-12 09:38 networkb Priority normal => immediate
2009-01-12 09:43 networkb Note Added: 0012101
2009-01-12 09:49 networkb Reporter galderromo => networkb
2009-01-12 09:49 networkb Assigned To networkb => rafaroda
2009-01-12 13:02 iperdomo Status new => scheduled
2009-01-12 13:02 iperdomo Assigned To rafaroda => shuehner
2009-01-12 13:02 iperdomo fix_in_branch => trunk
2009-01-12 13:02 iperdomo fix_in_branch trunk => 2.3x
2009-01-12 13:15 rafaroda Note Added: 0012106
2009-01-12 13:15 rafaroda fix_in_branch 2.3x =>
2009-01-12 13:16 rafaroda Status scheduled => feedback
2009-01-12 13:16 rafaroda Status feedback => new
2009-01-12 13:16 rafaroda Status new => scheduled
2009-01-12 13:16 rafaroda fix_in_branch => trunk
2009-01-12 13:17 rafaroda Regression testing => No
2009-01-12 13:17 rafaroda Status scheduled => closed
2009-01-12 13:17 rafaroda Note Added: 0012107
2009-01-12 13:17 rafaroda Resolution open => out of date
2009-02-23 12:51 shuehner Status closed => new
2009-02-23 12:51 shuehner Resolution out of date => open
2009-02-23 12:51 shuehner Note Added: 0013919
2009-02-23 12:52 shuehner Status new => scheduled
2009-02-23 15:31 svnbot Checkin
2009-02-23 15:31 svnbot Note Added: 0013946
2009-02-23 15:31 svnbot Status scheduled => resolved
2009-02-23 15:31 svnbot Resolution open => fixed
2009-02-23 15:31 svnbot svn_revision => 13532
2009-02-24 20:00 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker