Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041075
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] StoreServerminorhave not tried2019-06-12 10:052019-06-12 23:01
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc2ff03c953d2
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041075: Missing entry in excludeFilter results in update.database error

DescriptionFunctions 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 ReproduceIn 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
TagsNo 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
Powered by Mantis Bugtracker