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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0052132
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] French Fiscalmajoralways2023-04-17 15:252023-05-02 18:47
ReportersofidossantView Statuspublic 
Assigned Tofrancisco_ofarril 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket62151
OBNetwork customerGold
Regression introduced in release
Summary

0052132: 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.
TagsNo tags attached.
Attached Files? file icon queryNorauto.sql [^] (1,047 bytes) 2023-04-17 15:25
png file icon Captura de pantalla -2023-04-17 09-24-02.png [^] (122,753 bytes) 2023-04-17 15:25

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0051089 closed Slowness on some queries of the module 

-  Notes
(0149131)
sofidossant (viewer)
2023-05-02 13:50

 What is the solution?
(0149157)
aferraz (viewer)
2023-05-02 18:47

 This problem is fixed in 0051089.

- Issue History
Date Modified Username Field Change
2023-04-17 15:25 sofidossant New Issue
2023-04-17 15:25 sofidossant Assigned To => Triage Omni OMS
2023-04-17 15:25 sofidossant File Added: queryNorauto.sql
2023-04-17 15:25 sofidossant Support ticket => 62151
2023-04-17 15:25 sofidossant OBNetwork customer => Gold
2023-04-17 15:25 sofidossant File Added: Captura de pantalla -2023-04-17 09-24-02.png
2023-04-21 18:56 francisco_ofarril Assigned To Triage Omni OMS => francisco_ofarril
2023-04-21 18:56 francisco_ofarril Status new => scheduled
2023-05-02 11:57 aferraz Review Assigned To => aferraz
2023-05-02 11:57 aferraz Status scheduled => closed
2023-05-02 11:57 aferraz Resolution open => fixed
2023-05-02 13:50 sofidossant Status closed => new
2023-05-02 13:50 sofidossant Note Added: 0149131
2023-05-02 18:46 aferraz Status new => closed
2023-05-02 18:46 aferraz Relationship added duplicate of 0051089
2023-05-02 18:47 aferraz Note Added: 0149157

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker