Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029646 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2015-04-21 10:09 | 2015-04-28 15:53 | |||
| Reporter | ioritzCia | View Status | public | |||||
| Assigned To | Triage Omni OMS | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q3 | |||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 6 | |||
| OS Version | Ubuntu 14.04 | Database version | 9.3 | Ant version | ||||
| Product Version | 3.0PR15Q1 | SCM revision | ||||||
| Review Assigned To | ioritzCia | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029646: Performance problem in add payment query | |||||||
| Description | There is a query that gets built in Add Paymen functionality that comes from the following hql to be injected: select @selectClause@ from FIN_Payment_ScheduleDetail as psd left outer join psd.orderPaymentSchedule as ops left outer join ops.order as ord @joinClauseOrder@ left outer join ord.businessPartner as ordbp left outer join ops.fINPaymentPriority as opriority left outer join ops.finPaymentmethod opsfp left outer join psd.invoicePaymentSchedule as ips left outer join ips.invoice as inv @joinClauseInvoice@ left outer join inv.businessPartner as invbp left outer join ips.fINPaymentPriority as ipriority left outer join ips.finPaymentmethod as ipsfp left outer join psd.organization as org left outer join org.organizationInformationList as oinfo left outer join psd.paymentDetails as pd left outer join pd.finPayment as fp @joinClause@ where @additional_filters@ and @whereClause@ group by @groupByClause@ @havingClause@ You can find attached a part of the postgres log with the resulting query its duration and parameters. In this case took more than 50 seconds. This is not the usual time for this query in the log, postgres is configured in this instance to log the queries that are slower than 5 sec. An there are 3503 appearances of that query that were slower than 5 sec since 03-02-2015 to 13-04-2015. The usual time the query takes when it appears in the log is from 6s to 10s, which is still slow, but there are times when it takes more. We have a cloned instance. | |||||||
| Steps To Reproduce | Execute the attached query in the database. | |||||||
| Tags | Performance | |||||||
| Attached Files |  AddPayment.log [^] (4,339 bytes) 2015-04-21 10:09 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-04-21 10:09 | ioritzCia | New Issue | |
| 2015-04-21 10:09 | ioritzCia | Assigned To | => Triage Finance |
| 2015-04-21 10:09 | ioritzCia | File Added: AddPayment.log | |
| 2015-04-21 10:09 | ioritzCia | Web browser | => Google Chrome |
| 2015-04-21 10:09 | ioritzCia | Modules | => Advanced Payables and Receivables Mngmt |
| 2015-04-21 10:09 | ioritzCia | Triggers an Emergency Pack | => No |
| 2015-04-21 10:09 | ioritzCia | Tag Attached: Performance | |
| 2015-04-21 10:11 | ioritzCia | Web browser | Google Chrome => Google Chrome |
| 2015-04-21 10:11 | ioritzCia | Description Updated | View Revisions |
| 2015-04-22 10:15 | jonalegriaesarte | Web browser | Google Chrome => Google Chrome |
| 2015-04-22 10:15 | jonalegriaesarte | Resolution time | => 1432072800 |
| 2015-04-22 10:15 | jonalegriaesarte | Target Version | => 3.0PR15Q3 |
| 2015-04-22 10:18 | jonalegriaesarte | Web browser | Google Chrome => Google Chrome |
| 2015-04-23 10:26 | ioritzCia | Relationship added | duplicate of 0028854 |
| 2015-04-23 10:27 | ioritzCia | Review Assigned To | => ioritzCia |
| 2015-04-23 10:27 | ioritzCia | Status | new => closed |
| 2015-04-23 10:27 | ioritzCia | Resolution | open => duplicate |
| 2015-04-28 15:53 | shuehner | Issue Monitored: shuehner | |
| 2015-04-28 15:53 | shuehner | Issue End Monitor: shuehner | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |