int-initial-pgsql - Build # 1623 - Unstable:
Check console output at https://ci.openbravo.com/job/int-initial-pgsql/1623/ to
view the results.
Committers since last success:
Changes for Build #1623
Alvaro Ferraz <[email protected]> null
Related to issue 33629: Code review improvements
Group by bp.id and bp.name instead of by bp to avoid errors in Oracle.
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java
Asier Lostalé <[email protected]> null
fixed bug 33629: slow order/invoice grid population in Add Payment
Description
In evironments with big volumes it was slow because it performed a Seq Scan
on FIN_Payment_ScheduleDetail table.
It has been fixed for the cases when BP is preset by:
- Removing left joins to get BP from order/invoice to retrieve it directly
from FIN_Payment_ScheduleDetail
- Adding an index on FIN_Payment_ScheduleDetail.BP so that previous query
does not require of a Seq Scan
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java
src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml
Gorka Ion Damián <[email protected]> null
Fixes issue 33909. Add null check on closeSession
On some very specific scenarios it is possible to execute 2 commitAndClose or
rollbacks on the same SessionHandler instance. As both methods calls the
setSession(null) and closeSession() methods a NPE is thrown on the second
execution.
src/org/openbravo/dal/core/SessionHandler.java
Last 20 lines of the console output:
[...truncated 7060 lines...]
executing script 'Check openbravo log'
[int-initial-pgsql] $ /bin/bash /tmp/build_step_template2911734941823467430.sh
ENABLE
DEBUG: Check openbravo log called with parameters: ENABLED=ENABLE
Errors in openbravo log (artifact: int-initial-pgsql.log):
b3e0edee 2016-09-07 13:36:51,726 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.erpCommon.ad_forms.AcctServerData - SQL error in query:
select 1 as id from dual where exists ( select 1 from ( SELECT
a.DateAcct as dateacct FROM C_Invoice a WHERE a.ad_client_id
= ? AND a.ad_org_id in ('DA85A88AB431414CBDE748D89A32AFB2', '0')
AND a.posted = 'N' AND a.processed = 'Y' AND (a.processing =
'N' OR a.processing IS NULL) AND EXISTS ( SELECT 1
FROM c_period p WHERE a.DateAcct >= p.StartDate AND
a.DateAcct < p.EndDate + 1 AND EXISTS ( SELECT 1
FROM c_periodcontrol pc WHERE pc.c_period_id = p.c_period_id
AND ad_org_getperiodcontrolallow(a.ad_org_id) = pc.ad_org_id
AND pc.docbasetype = ? AND pc.periodstatus = 'O' )
)) b where 1=1 )Exception:org.postgresql.util.PSQLException:
An I/O error occurred while sending to the backend.
b3e0edee 2016-09-07 13:36:51,748 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.database.ConnectionProviderImpl - Error on releaseConnection
b3e0edee 2016-09-07 13:36:51,805 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.service.db.DalBaseProcess - The process
org.openbravo.erpCommon.ad_process.AcctServerProcess has thrown an exception.
Recording test results
Archiving artifacts
Checking \] ERROR|\] WARN
/srv/ci/workspace/int-initial-pgsql/SANDBOX/openbravo.log:
b3e0edee 2016-09-07 13:36:51,726 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.erpCommon.ad_forms.AcctServerData - SQL error in query:
select 1 as id from dual where exists ( select 1 from ( SELECT
a.DateAcct as dateacct FROM C_Invoice a WHERE a.ad_client_id
= ? AND a.ad_org_id in ('DA85A88AB431414CBDE748D89A32AFB2', '0')
AND a.posted = 'N' AND a.processed = 'Y' AND (a.processing =
'N' OR a.processing IS NULL) AND EXISTS ( SELECT 1
FROM c_period p WHERE a.DateAcct >= p.StartDate AND
a.DateAcct < p.EndDate + 1 AND EXISTS ( SELECT 1
FROM c_periodcontrol pc WHERE pc.c_period_id = p.c_period_id
AND ad_org_getperiodcontrolallow(a.ad_org_id) = pc.ad_org_id
AND pc.docbasetype = ? AND pc.periodstatus = 'O' )
)) b where 1=1 )Exception:org.postgresql.util.PSQLException:
An I/O error occurred while sending to the backend.
b3e0edee 2016-09-07 13:36:51,748 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.database.ConnectionProviderImpl - Error on releaseConnection
b3e0edee 2016-09-07 13:36:51,805 [DefaultQuartzScheduler_Worker-1] ERROR
org.openbravo.service.db.DalBaseProcess - The process
org.openbravo.erpCommon.ad_process.AcctServerProcess has thrown an exception.
Build step 'Jenkins Text Finder' changed build result to UNSTABLE
Email was triggered for: Unstable (Test Failures)
Sending email for trigger: Unstable (Test Failures)
------------------------------------------------------------------------------
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
