Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036165Openbravo ERPA. Platformpublic2017-06-01 14:442017-06-08 17:12
alostale 
alostale 
normalminorhave not tried
closedfixed 
5
 
3.0PR17Q3 
caristu
Core
No
0036165: useless log for non matching DB messages
In PostgreSQL whenever a message is tried to be parsed to try to identify DB messages and it does not match a DB message, an INFO line is logged. This parser is many times invoked without warranty the message is coming from DB, and whenever it is not this line appears.

Checking production logs, we can see this happens very often flooding the log with useless messages.
Check actual customer logs for this kind of messages. In some customers ~1% of log lines are for it.

org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: ....
No tags attached.
blocks design defect 0036162 acknowledged Triage Platform Base clean up openbravo.log 
Issue History
2017-06-01 14:44alostaleNew Issue
2017-06-01 14:44alostaleAssigned To => platform
2017-06-01 14:44alostaleModules => Core
2017-06-01 14:44alostaleTriggers an Emergency Pack => No
2017-06-01 14:45alostaleReview Assigned To => caristu
2017-06-01 14:46alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15264#r15264
2017-06-01 14:46alostaleRelationship addedblocks 0036162
2017-06-01 14:46alostaleAssigned Toplatform => alostale
2017-06-01 17:12hgbotCheckin
2017-06-01 17:12hgbotNote Added: 0097083
2017-06-01 17:12hgbotStatusnew => resolved
2017-06-01 17:12hgbotResolutionopen => fixed
2017-06-01 17:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/af64a035d451271305f0bbf60e5dd319e9e208d9 [^]
2017-06-02 18:10caristuNote Added: 0097112
2017-06-02 18:10caristuStatusresolved => closed
2017-06-02 18:10caristuFixed in Version => 3.0PR17Q3
2017-06-08 17:12hudsonbotCheckin
2017-06-08 17:12hudsonbotNote Added: 0097233

Notes
(0097083)
hgbot   
2017-06-01 17:12   
Repository: erp/devel/pi
Changeset: af64a035d451271305f0bbf60e5dd319e9e208d9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Jun 01 14:55:14 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/af64a035d451271305f0bbf60e5dd319e9e208d9 [^]

fixed bug 36165: useless log for non matching DB messages

  - downgraded level from info to debug
  - don't concatenate log String if it's not logged

---
M src/org/openbravo/erpCommon/utility/ErrorTextParserPOSTGRE.java
---
(0097112)
caristu   
2017-06-02 18:10   
Code reviewed
(0097233)
hudsonbot   
2017-06-08 17:12   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/fda0f16ab470 [^]
Maturity status: Test