Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2023-10-20 12:262023-11-20 13:03
ReporterngarciaView Statuspublic 
Assigned Tomtaal 
PriorityurgentResolutionopenFixed in Version
StatusfeedbackFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0053735: Sharelocks in M_STORAGE_DETAIL caused by UPDATE_M_STORAGE_DETAIL function with big amount of records

DescriptionSharelocks in M_STORAGE_DETAIL caused by UPDATE_M_STORAGE_DETAIL function with big amount of records
Steps To ReproduceWe need to have a environment with 1.5M records in M_STORAGE_DETAIL table
We need to have a high number of AWO tasks pending to be confirmed that call the M_MOVEMENTLINE_TRG

1) Start confirming the tasks (20/25 per minute)
2) Check sharelocks can be observed in Postgres log
3) The openbravo.log shows that Data Import Entries related to OBAWO_Task increase their duration
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
ludmila_ursu (developer)
2023-10-24 11:09

JIRA created: [^]
mtaal (manager)
2023-11-20 11:42

Thank the customer/partner for the extensive analysis. For now it seems normal behavior. For now we would advice the customer/partner to check with the cloud team to analyze the database and check if the database settings/config can be improved on system level.

grt. Martin

- Issue History
Date Modified Username Field Change
2023-10-20 12:26 ngarcia New Issue
2023-10-20 12:26 ngarcia Assigned To => Triage Omni WMS
2023-10-20 12:26 ngarcia Modules => Core
2023-10-20 12:26 ngarcia Triggers an Emergency Pack => No
2023-10-23 10:01 malsasua Steps to Reproduce Updated View Revisions
2023-10-24 09:18 mtaal Assigned To Triage Omni WMS => ludmila_ursu
2023-10-24 11:09 ludmila_ursu Note Added: 0156225
2023-11-20 11:42 mtaal Note Added: 0157337
2023-11-20 11:42 mtaal Status new => feedback
2023-11-20 13:03 mtaal Assigned To ludmila_ursu => mtaal

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker