int-basic-oracle - Build # 1799 - Failure:
Check console output at https://ci.openbravo.com/job/int-basic-oracle/1799/ to
view the results.
Committers since last success:
Changes for Build #1799
Víctor Martínez Romanos <[email protected]> null
Related to issue 35205: new normal index
C_CONVERSION_RATE_DOCUMENT.C_INVOICE_ID
Added this new normal indexes because it has been detected to avoid seq. scan
in several flows.
More info at
https://docs.google.com/spreadsheets/d/1m5GZaaoEkYvyGdyxddtxxb3SeAhvtavfdq53iumOT7s
src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml
Víctor Martínez Romanos <[email protected]> null
Fixed issue 35205: Partial indexes functional stuff
The only performance drawback in transforming a normal index to a partial index
is in the queries with a where clause filtering by a indexed column when this
column is null.
In this case, and only when the ratio of null values is very low, the query
will probably execute a seq. scan over the table instead of using the index,
thus killing the performance.
To detect this scenario, we have "greped" the PI code for "is*null" string
(case insensitve), and filtered the places where the candidate indexes appear.
Then, we have individually analize each of the queries to detect whether we
could safely transform the index to partial index based on the previous
explanation.
The result can be found in
https://docs.google.com/spreadsheets/d/1m5GZaaoEkYvyGdyxddtxxb3SeAhvtavfdq53iumOT7s
Functional Analysis tab.
Values with Candidate = Y are the ones to be transformed to partial indexes,
Candidate = N means to keep the normal index, and TBCN is to create a normal
index because it would help in performance.
When there is no query that uses this index inside an "IS NULL" condition, we
have automatically set it to partial index as there shouldn't be any risk
For the rest of the candidates there are individual explanations which can be
found as a note (in the Candidate column and/or in the places where this index
might be used).
For future references, this is the command used to grep the PI code:
grep -n --color=always -riI "is[[:space:]]*null" --exclude \*.js
--exclude-dir src-wad --exclude-dir build /home/openbravo/HG/erp/devel/pi |
grep -vi case | more
modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_TRL.xml
src-db/database/model/tables/AD_USER.xml
src-db/database/model/tables/A_AMORTIZATIONLINE.xml
src-db/database/model/tables/A_ASSET.xml
src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml
src-db/database/model/tables/C_BPARTNER.xml
src-db/database/model/tables/C_CITY.xml
src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml
src-db/database/model/tables/C_INVOICE.xml
src-db/database/model/tables/C_INVOICELINE.xml
src-db/database/model/tables/C_INVOICETAX_CASHVAT.xml
src-db/database/model/tables/C_ORDER.xml
src-db/database/model/tables/C_ORDERLINE.xml
src-db/database/model/tables/C_POC_DOCTYPE_TEMPLATE.xml
src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
src-db/database/model/tables/C_TAXREGISTER.xml
src-db/database/model/tables/C_TAXREGISTERLINE.xml
src-db/database/model/tables/C_TAXREGISTER_TYPE_LINES.xml
src-db/database/model/tables/C_TAX_ZONE.xml
src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml
src-db/database/model/tables/FIN_ORIG_PAYMENT_SCHEDULE.xml
src-db/database/model/tables/FIN_ORIG_PAYM_SCHEDDETAIL.xml
src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml
src-db/database/model/tables/GL_JOURNAL.xml
src-db/database/model/tables/MA_MAINTENANCE.xml
src-db/database/model/tables/MA_MEASURE_GROUP.xml
src-db/database/model/tables/MA_PROCESS.xml
src-db/database/model/tables/MA_WEINCIDENCE.xml
src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml
src-db/database/model/tables/M_COSTADJUSTMENTLINE.xml
src-db/database/model/tables/M_COSTING.xml
src-db/database/model/tables/M_INOUT.xml
src-db/database/model/tables/M_INOUTLINE.xml
src-db/database/model/tables/M_LANDEDCOST.xml
src-db/database/model/tables/M_LC_COST.xml
src-db/database/model/tables/M_LC_MATCHED.xml
src-db/database/model/tables/M_LC_RECEIPT.xml
src-db/database/model/tables/M_LC_RECEIPTLINE_AMT.xml
src-db/database/model/tables/M_LOCATOR.xml
src-db/database/model/tables/M_MATCHPO.xml
src-db/database/model/tables/M_PRODUCT.xml
src-db/database/model/tables/M_RAPPEL_BPARTNER.xml
src-db/database/model/tables/M_RAPPEL_INVOICE.xml
src-db/database/model/tables/M_RAPPEL_PRODUCT.xml
src-db/database/model/tables/M_RAPPEL_PRODUCTCATEGORY.xml
src-db/database/model/tables/M_RAPPEL_SCALE.xml
src-db/database/model/tables/M_RESERVATION.xml
src-db/database/model/tables/M_RESERVATION_STOCK.xml
src-db/database/model/tables/M_STOCK_AUX.xml
src-db/database/model/tables/M_STOCK_VALUATION.xml
src-db/database/model/tables/M_TRANSACTION.xml
src-db/database/model/tables/M_TRANSACTION_COST.xml
src-db/database/model/tables/M_WAREHOUSE_SHIPPER.xml
src-db/database/model/tables/S_TIMEEXPENSELINE.xml
Last 20 lines of the console output:
[...truncated 19483 lines...]
[junit] Feb 24, 2017 11:47:23 AM
org.openqa.selenium.remote.ProtocolHandshake createSession
[junit] INFO: Attempting bi-dialect session, assuming Postel's Law holds
true on the remote end
[junit] Feb 24, 2017 11:47:30 AM
org.openqa.selenium.remote.ProtocolHandshake createSession
[junit] INFO: Detected dialect: OSS
[junit] Feb 24, 2017 11:47:30 AM org.openqa.selenium.remote.Augmenter
extractRemoteWebDriver
[junit] WARNING: Augmenter should be applied to the instances of
@Augmentable classes or previously augmented instances only
[junit]
BUILD FAILED
/srv/ci/workspace/int-basic-oracle/SANDBOX/automation/pi/build.xml:338: The
following error occurred while executing this line:
/srv/ci/workspace/int-basic-oracle/SANDBOX/automation/pi/build.xml:77: Test
com.openbravo.test.integration.erp.testsuites.smoke.SmokeModulesSuite failed
Total time: 76 minutes 46 seconds
Build step 'Execute managed script' marked build as failure
Recording test results
Archiving artifacts
Checking \] ERROR|\] WARN
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
