Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026961Openbravo ERP09. Financial managementpublic2014-06-27 14:122014-09-04 17:31
Reportermaite 
Assigned Torafaroda 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q4Fixed in Version 
Merge Request Status
Review Assigned ToAtulOpenbravo
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026961: Extreme slowness when running "GL Posting by DB table" for FIN_Finacc_Transaction table
DescriptionExtreme slowness when running "GL Posting by DB table" for FIN_Finacc_Transaction table
Steps To Reproduce1. Run "GL Posting by DB table" process for FIN_Finacc_Transaction table in an environment with huge amount of unposted transactions
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-27 14:12maiteNew Issue
2014-06-27 14:12maiteAssigned To => dmiguelez
2014-06-27 14:12maiteModules => Core
2014-06-27 14:12maiteTriggers an Emergency Pack => No
2014-06-27 14:13maiteAssigned Todmiguelez => jonalegriaesarte
2014-06-27 14:13maiteIssue Monitored: networkb
2014-06-27 14:16egoitzNote Added: 0068409
2014-06-30 13:42jonalegriaesarteResolution time => 1406412000
2014-06-30 13:42jonalegriaesarteTarget VersionPR14Q3 => PR14Q4
2014-07-21 16:43jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-09-01 10:01rafarodaStatusnew => scheduled
2014-09-01 10:01rafarodaAssigned Topramakrishnan => rafaroda
2014-09-01 10:01rafarodafix_in_branch => pi
2014-09-03 17:34hgbotCheckin
2014-09-03 17:34hgbotNote Added: 0069948
2014-09-03 17:34hgbotStatusscheduled => resolved
2014-09-03 17:34hgbotResolutionopen => fixed
2014-09-03 17:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612 [^]
2014-09-04 14:20AtulOpenbravoReview Assigned To => AtulOpenbravo
2014-09-04 14:20AtulOpenbravoNote Added: 0069965
2014-09-04 14:20AtulOpenbravoStatusresolved => closed
2014-09-04 17:31hudsonbotCheckin
2014-09-04 17:31hudsonbotNote Added: 0069969

Notes
(0068409)
egoitz   
2014-06-27 14:16   
The problem is reproducible when there are thousends of rows on the
fin_finacc_transaction table, and when many of them are posted.

That is solved with the following index:

CREATE INDEX fin_finacc_transaction_posted
  ON fin_finacc_transaction
  USING btree
  (posted COLLATE pg_catalog."default");

 analyze fin_finacc_transaction;
(0069948)
hgbot   
2014-09-03 17:34   
Repository: erp/devel/pi
Changeset: 26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Wed Sep 03 10:06:34 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612 [^]

Fixes issue 26961 Added index to POSTED column of FIN_FINACC_TRANSACTION table

---
M src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml
---
(0069965)
AtulOpenbravo   
2014-09-04 14:20   
Verified.
(0069969)
hudsonbot   
2014-09-04 17:31   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6b8123291049 [^]
Maturity status: Test