Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0054980Openbravo ERPA. Platformpublic2024-03-18 12:372025-03-27 12:04
egoitz 
Triage Platform Base 
urgentmajorhave not tried
closedduplicate 
5
 
 
Gold
Core
No
0054980: Audit Trail infrestrucuture is creating temporary tables that could end on getting the limit of elements created in postgresql
Every time a table, index, or Postgresql element is created the value
of the OID field is updated and incremented in one.

SELECT proname, oid, proconfig FROM pg_proc order by oid desc;

Having audit trail enabled for many tables affects the number of elements created because many temporary tables are created and deleted.
N/a
No tags attached.
related to defect 0054768 closed AugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
related to feature request 0038629 closed alostale do not use ad_session_status to disable PG triggers 
Issue History
2024-03-18 12:37egoitzNew Issue
2024-03-18 12:37egoitzAssigned To => Triage Platform Base
2024-03-18 12:37egoitzOBNetwork customer => Gold
2024-03-18 12:37egoitzModules => Core
2024-03-18 12:37egoitzTriggers an Emergency Pack => No
2024-03-18 12:38egoitzRelationship addedrelated to 0054768
2024-03-18 17:36AugustoMauchTypedefect => design defect
2024-03-19 08:56alostaleRelationship addedrelated to 0038629
2025-03-27 12:04hgbotNote Added: 0177416
2025-03-27 12:04hgbotStatusnew => closed
2025-03-27 12:04hgbotResolutionopen => duplicate

Notes
(0177416)
hgbot   
2025-03-27 12:04   
Issue exported to Jira: https://openbravo.atlassian.net/browse/RM-24148 [^]