Project:
| View Revisions: Issue #53735 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0053735: Sharelocks in M_STORAGE_DETAIL caused by UPDATE_M_STORAGE_DETAIL function with big amount of records | ||
| Revision | 2023-10-23 10:01 by malsasua | ||
| Steps To Reproduce | We 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 |
||
| Revision | 2023-10-20 14:19 by malsasua | ||
| Steps To Reproduce | We need to have a environment with 1.5K 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 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |