Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0041075 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] StoreServer | minor | have not tried | 2019-06-12 10:05 | 2019-06-12 23:01 | |||
Reporter | AugustoMauch | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | c2ff03c953d2 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | mtaal | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0041075: Missing entry in excludeFilter results in update.database error | |||||||
Description | Functions used by SymmetricDS triggers start with the faa_sym_ prefix. SymmetricDS database components must be included in the excludeFilter.xml [1] file, because they must be ignored by dbsourcemanager, due to them being managed outside the import/export Openbravo flow. They way the excludeFilter is defined now, when a table with symmetricds triggers is removed, the update.database command fails with the following erorr message: [java] 28402 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_u() does not exist [java] 28411 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- ----------------------------------------------------------------------- [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_U [java] -- ----------------------------------------------------------------------- [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_U() [java] 28420 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_i() does not exist [java] 28429 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END [java] -- ----------------------------------------------------------------------- [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_I [java] -- ----------------------------------------------------------------------- [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_I() [java] 28439 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_d() does not exist [java] 28448 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END [java] -- ----------------------------------------------------------------------- [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_D [java] -- ----------------------------------------------------------------------- [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_D() [1] https://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/file/c618902eb69b/src-db/database/model/excludeFilter.xml [^] | |||||||
Steps To Reproduce | In a multiserver environment: - Modify the XML model to remove a table that is configured to be synchronized - Execute update.database. An error similiar to the one shown in the description will be shown in the log | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0112598) hgbot (developer) 2019-06-12 10:13 |
Repository: erp/pmods/org.openbravo.replication.symmetricds Changeset: c2ff03c953d25747e753b4490ecc5656075d2e53 Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Wed Jun 12 10:13:05 2019 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/c2ff03c953d25747e753b4490ecc5656075d2e53 [^] Fixes issue 41075: Adds proper exclude filter for SymmetricDS trigger functions The previous exclude filter for trigger functions has not been removed, to decrease the risk of regressions. --- M src-db/database/model/excludeFilter.xml --- |
(0112761) mtaal (manager) 2019-06-12 23:01 |
reviewed |
Issue History | |||
Date Modified | Username | Field | Change |
2019-06-12 10:05 | AugustoMauch | New Issue | |
2019-06-12 10:05 | AugustoMauch | Assigned To | => AugustoMauch |
2019-06-12 10:05 | AugustoMauch | Triggers an Emergency Pack | => No |
2019-06-12 10:13 | hgbot | Checkin | |
2019-06-12 10:13 | hgbot | Note Added: 0112598 | |
2019-06-12 10:13 | hgbot | Status | new => resolved |
2019-06-12 10:13 | hgbot | Resolution | open => fixed |
2019-06-12 10:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/c2ff03c953d25747e753b4490ecc5656075d2e53 [^] |
2019-06-12 20:26 | mtaal | Review Assigned To | => mtaal |
2019-06-12 23:01 | mtaal | Note Added: 0112761 | |
2019-06-12 23:01 | mtaal | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |