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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0053735
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2023-10-20 12:262024-01-29 12:40
ReporterngarciaView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket77148
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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
(0156225)
ludmila_ursu (viewer)
2023-10-24 11:09

 JIRA created: https://openbravo.atlassian.net/browse/RM-9047 [^]
(0157337)
mtaal (viewer)
2023-11-20 11:42

 Hello,
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
(0158889)
mtaal (viewer)
2024-01-05 11:30

 Update from Victor on 22nd December:
Asked to involve the partner and in parallel to send us the pgbadger to have more info to analyze.
(0159860)
vmromanos (viewer)
2024-01-29 12:40

 After applying the workaround to reduce the M_Storage_Detail size, the issue is not reproducible anymore.

- 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 OBNetwork customer => OBPS
2023-10-20 12:26 ngarcia Modules => Core
2023-10-20 12:26 ngarcia Support ticket => 77148
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
2024-01-05 11:30 mtaal Note Added: 0158889
2024-01-29 12:38 vmromanos Status feedback => scheduled
2024-01-29 12:38 vmromanos Assigned To mtaal => vmromanos
2024-01-29 12:40 vmromanos Review Assigned To => vmromanos
2024-01-29 12:40 vmromanos Note Added: 0159860
2024-01-29 12:40 vmromanos Status scheduled => closed
2024-01-29 12:40 vmromanos Resolution open => unable to reproduce

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker