View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000778 | SymmetricDS | Bug | public | 2012-08-19 17:05 | 2014-02-03 01:52 |
Reporter | chenson | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.0.10 | ||||
Target Version | 3.1.2 | Fixed in Version | 3.1.2 | ||
Summary | 0000778: If database user doesn't have permission to drop trigger, extra trigger_hist rows get created and the old are not deactivated | ||||
Description | If database user doesn't have permission to drop trigger, extra trigger_hist rows get created and the old are not deactivated. 16 15:29:54,965 INFO [source1] [ConfigurationChangedDataRouter] [source1-job-17] About to syncTriggers because new configuration came through the data router 2012-08-16 15:29:55,751 WARN [gui] [PostgreSqlSymmetricDialect] [qtp986448521-34] Tried to remove trigger using: drop trigger SYM_ON_I_FOR_TR_MSTRDT_SPR_PLNT on masterdata.super_plant and failed because: ERROR: must be owner of relation super_plant 2012-08-16 15:29:55,860 INFO [gui] [PostgreSqlSymmetricDialect] [qtp986448521-34] Creating SYM_ON_I_FOR_TR_MSTRDT_SPR_PLNT trigger for masterdata.super_plant 2012-08-16 15:29:55,878 ERROR [gui] [PostgreSqlSymmetricDialect] [qtp986448521-34] Failed to create post trigger: create trigger SYM_ON_I_FOR_TR_MSTRDT_SPR_PLNT after insert on "masterdata"."super_plant" for each row execute procedure "masterdata".fSYM_ON_I_FOR_TR_MSTRDT_SPR_PLNT(); 2012-08-16 15:29:55,884 ERROR [gui] [TriggerRouterService] [qtp986448521-34] Failed to create triggers for masterdata.super_plant org.jumpmind.db.sql.SqlException: ERROR: trigger "sym_on_i_for_tr_mstrdt_spr_plnt" for relation "super_plant" already exists at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:260) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:251) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:278) at org.jumpmind.db.sql.JdbcSqlTransaction.execute(JdbcSqlTransaction.java:208) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:279) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:1131) | ||||
Tags | No tags attached. | ||||
SymmetricDS: master c0c0790e 2012-08-19 14:24:40 Details Diff |
0000778: If database user doesn't have permission to drop trigger, extra trigger_hist rows get created and the old are not deactivated |
Affected Issues 0000778 |
|
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-08-19 17:05 | chenson | New Issue | |
2012-08-19 17:06 | chenson | Product Version | => 3.0.10 |
2012-08-19 17:06 | chenson | Target Version | => 3.1.2 |
2012-08-19 18:24 | chenson | Status | new => resolved |
2012-08-19 18:24 | chenson | Fixed in Version | => 3.1.2 |
2012-08-19 18:24 | chenson | Resolution | open => fixed |
2012-08-19 18:24 | chenson | Assigned To | => chenson |
2012-08-22 19:49 | chenson | Status | resolved => closed |
2014-02-03 01:52 | Changeset attached | => SymmetricDS trunk r6204 | |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master c0c0790e |