Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052132ModulesFrench Fiscalpublic2023-04-17 15:252023-05-02 18:47
Reportersofidossant 
Assigned Tofrancisco_ofarril 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0052132: Query generates locks on node A of the database server.
DescriptionThe query generates several locks, we should improve the max that it has.
Attached image of the analysis
Steps To ReproduceAll the tables of the query are only found in this query, so we know that it is generated in this module.
We do not have the steps, but this is the one that generates the lock in apache of node A of the Norauto database.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0051089 closed  Slowness on some queries of the module 
Attached Files? queryNorauto.sql (1,047) 2023-04-17 15:25
https://issues.openbravo.com/file_download.php?file_id=18378&type=bug
png Captura de pantalla -2023-04-17 09-24-02.png (122,753) 2023-04-17 15:25
https://issues.openbravo.com/file_download.php?file_id=18379&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2023-04-17 15:25sofidossantNew Issue
2023-04-17 15:25sofidossantAssigned To => Triage Omni OMS
2023-04-17 15:25sofidossantFile Added: queryNorauto.sql
2023-04-17 15:25sofidossantFile Added: Captura de pantalla -2023-04-17 09-24-02.png
2023-04-21 18:56francisco_ofarrilAssigned ToTriage Omni OMS => francisco_ofarril
2023-04-21 18:56francisco_ofarrilStatusnew => scheduled
2023-05-02 11:57aferrazReview Assigned To => aferraz
2023-05-02 11:57aferrazStatusscheduled => closed
2023-05-02 11:57aferrazResolutionopen => fixed
2023-05-02 13:50sofidossantStatusclosed => new
2023-05-02 13:50sofidossantNote Added: 0149131
2023-05-02 18:46aferrazStatusnew => closed
2023-05-02 18:46aferrazRelationship addedduplicate of 0051089
2023-05-02 18:47aferrazNote Added: 0149157

Notes
(0149131)
sofidossant   
2023-05-02 13:50   
What is the solution?
(0149157)
aferraz   
2023-05-02 18:47   
This problem is fixed in 0051089.