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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0051089
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] French Fiscalmajoralways2022-12-09 17:262023-11-07 15:51
ReporteregoitzView Statuspublic 
Assigned To 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0051089: Slowness on some queries of the module

DescriptionThe following query is slow on environment with huge volume of data
Steps To ReproduceSELECT obpos_appl0_.EM_Obcfr_Isblockchained AS col_0_0_, coalesce(obcfrticke1_.Seqno, 0) AS col_1_0_, obcfrticke1_.Hash AS col_2_0_, '***' AS col_3_0_, ( SELECT coalesce(max(obcfr_bloc2_.Seqno), 0) FROM OBCFR_BlockchainIssue obcfr_bloc2_ WHERE obcfr_bloc2_.Entity = 'OBCFR_Ticket' AND coalesce(obcfr_bloc2_.Obpos_Applications_ID, obcfr_bloc2_.AD_Client_ID) = 'C5CBA19E2F6D492FBAD24041E7BC8286') AS col_4_0_ FROM OBPOS_APPLICATIONS obpos_appl0_ LEFT OUTER JOIN OBCFR_Ticket obcfrticke1_ ON obpos_appl0_.Obpos_Applications_ID = obcfrticke1_.Obpos_Applications_ID WHERE obpos_appl0_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286' AND coalesce(obcfrticke1_.Seqno, 0) = coalesce(( SELECT max(obcfr_tick3_.Seqno) FROM OBCFR_Ticket obcfr_tick3_ WHERE obcfr_tick3_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286'), 0);
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0049792 closedegoitz Openbravo Localizations Some queries are slow, and read lot of information from disk on environment with millioins of transation. 
has duplicate defect 0052132 closedfrancisco_ofarril Modules Query generates locks on node A of the database server. 

-  Notes
(0144786)
hgbot (developer)
2022-12-16 15:33

 Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/merge_requests/29 [^]
(0144906)
hgbot (developer)
2022-12-21 16:35

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/5 [^]
(0144909)
hgbot (developer)
2022-12-21 18:00

 Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/merge_requests/29 [^]
(0144910)
hgbot (developer)
2022-12-21 18:00

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev [^]
Changeset: 0bbf4a121c2344a831756551ba34e9290b324a39
Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com>
Date: 21-12-2022 17:00:44
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/commit/0bbf4a121c2344a831756551ba34e9290b324a39 [^]

Fixes ISSUE-51089: Improve performance of the query to load terminalHtml terminal property in POS

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/certification/france/ui/UIComponentQuery.java
---
(0144911)
hgbot (developer)
2022-12-21 18:01

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france [^]
Changeset: 6a90ba360904e9e650c780d0fa1094ea9ce945e3
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 21-12-2022 17:01:28
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/commit/6a90ba360904e9e650c780d0fa1094ea9ce945e3 [^]

Fixes ISSUE-51089: Improve performance of the query to load terminalHtml terminal property in POS

---
M lib/runtime/org.openbravo.certification.france-1.0.jar
M src-db/database/sourcedata/AD_MODULE.xml
---
(0144912)
hgbot (developer)
2022-12-21 18:01

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/5 [^]
(0147491)
hgbot (developer)
2023-03-13 14:49

 Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev [^]
Changeset: babcb1c64497a2560005177e08163bad144404d9
Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com>
Date: 13-03-2023 13:49:05
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/commit/babcb1c64497a2560005177e08163bad144404d9 [^]

Related to ISSUE-51089: Improve performance of the query to load terminalHtml terminal property in POS - 19q3 backport

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/certification/france/ui/UIComponentQuery.java
---
(0147564)
hgbot (developer)
2023-03-15 15:07

 Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france [^]
Changeset: e99a864b8d65dabe4ecbc7746652b0cd95bcb5f0
Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com>
Date: 15-03-2023 14:07:06
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/commit/e99a864b8d65dabe4ecbc7746652b0cd95bcb5f0 [^]

Related to ISSUE-51089: Improve performance of the query to load terminalHtml terminal property in POS - 19q3 backport.

Obfuscate from https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/commit/babcb1c64497a2560005177e08163bad [^]

---
M lib/runtime/org.openbravo.certification.france-1.0.jar
M src-db/database/sourcedata/AD_MODULE.xml
---

- Issue History
Date Modified Username Field Change
2022-12-09 17:26 egoitz New Issue
2022-12-09 17:26 egoitz Assigned To => psanjuan
2022-12-12 08:56 psanjuan Assigned To psanjuan => aferraz
2022-12-12 11:40 aferraz Steps to Reproduce Updated View Revisions
2022-12-12 17:32 aferraz Assigned To aferraz => francisco_ofarril
2022-12-16 15:33 hgbot Note Added: 0144786
2022-12-21 16:35 hgbot Note Added: 0144906
2022-12-21 18:00 hgbot Note Added: 0144909
2022-12-21 18:00 hgbot Resolution open => fixed
2022-12-21 18:00 hgbot Status new => closed
2022-12-21 18:00 hgbot Note Added: 0144910
2022-12-21 18:01 hgbot Note Added: 0144911
2022-12-21 18:01 hgbot Note Added: 0144912
2022-12-22 14:23 francisco_ofarril Status closed => new
2022-12-22 14:23 francisco_ofarril Resolution fixed => open
2022-12-22 14:23 francisco_ofarril Status new => acknowledged
2022-12-22 14:24 francisco_ofarril Status acknowledged => scheduled
2022-12-22 14:24 francisco_ofarril Status scheduled => resolved
2022-12-22 14:24 francisco_ofarril Resolution open => fixed
2022-12-27 16:25 aferraz Status resolved => closed
2023-03-10 14:19 francisco_ofarril Status closed => new
2023-03-10 14:19 francisco_ofarril Resolution fixed => open
2023-03-10 14:19 francisco_ofarril Status new => scheduled
2023-03-13 12:05 aferraz Status scheduled => resolved
2023-03-13 12:05 aferraz Resolution open => fixed
2023-03-13 12:05 aferraz Status resolved => closed
2023-03-13 14:49 hgbot Note Added: 0147491
2023-03-15 15:07 hgbot Note Added: 0147564
2023-03-20 13:26 aferraz Relationship added has duplicate 0049792
2023-05-02 18:46 aferraz Relationship added has duplicate 0052132
2023-11-07 15:51 psanjuan Project Openbravo Localizations => Modules
2023-11-07 15:51 psanjuan Assigned To francisco_ofarril =>
2023-11-07 15:51 psanjuan Category Localization France => French Fiscal

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker