View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003834 | SymmetricDS | Bug | public | 2018-12-17 16:41 | 2020-01-02 14:42 |
| Reporter | gilles.riand | Assigned To | elong | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.14 | ||||
| Target Version | 3.11.3 | Fixed in Version | 3.11.3 | ||
| Summary | 0003834: Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word | ||||
| Description | I try to install on Interbase, I make my own SQL Script to fixed Issue 0003832 auto.config.database=false and DESCRIPTION ONLY 1024 CREATE TABLE SYM_TRIGGER ".." LAST_UPDATE_TIME TIMESTAMP NOT NULL, DESCRIPTION VARCHAR(1024) ); But now... or in th e gui !!! Where the Details of the SQL Queries ? 2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start 2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start 2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Mon Dec 17 17:33:38 CET 2018 2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Mon Dec 17 17:33:38 CET 2018 2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start 2018-12-17 17:33:32,654 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED: nodeId=easy_test_3_9_15 groupId=lame type=professional subType=null name=lame-easy_test_3_9_15 softwareVersion=3.9.15 databaseName=InterBase databaseVersion=10.0 driverName=InterClient driverVersion=10.0.9 for Java 1.6 with InterBase XE, 2009 and 2007 uptime=0 sec. 2018-12-17 17:33:36,629 ERROR [gui] [b] [qtp12134395-17] [interclient][interbase]Dynamic SQL Error [interclient][interbase]SQL error code = -104 [interclient][interbase]Token unknown - line 1, char 65 [interclient][interbase]type StackTraceKey.init [SqlException:4204806638] org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error [interclient][interbase]SQL error code = -104 [interclient][interbase]Token unknown - line 1, char 65 [interclient][interbase]type at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224) at com.jumpmind.symmetric.console.service.impl.ProConsoleService.createSystemMonitors(ProConsoleService.java:49) at com.jumpmind.symmetric.console.ui.b.initializeTabs(MainWindow.java:624) at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:531) at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:399) at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:342) at com.jumpmind.symmetric.console.ui.AppUI.init(AppUI.java:57) at com.vaadin.ui.UI.doInit(UI.java:745) at com.vaadin.server.communication.UIInitHandler.getBrowserDetailsUI(UIInitHandler.java:216) at com.vaadin.server.communication.UIInitHandler.synchronizedHandleRequest(UIInitHandler.java:74) at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41) at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1568) at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:381) | ||||
| Tags | dialect: interbase, install | ||||
|
|
From stack trace, it's running a prepared insert statement: insert into sym_monitor (monitor_id, node_group_id, external_id, type, expression, threshold, run_period, run_count, severity_level, enabled, last_update_time, last_update_by, create_time) values(?,?,?,?,?,?,?,?,?,?,?,?,?) It complains about unknown token around the "type" column. I'm guessing "type" is a reserved word. We'll need to call it "monitor_type" instead. |
|
|
Also found this "type" issue exists in the MonitorService.java where it appends 'and type = ...' to the where clause. |
|
SymmetricDS: 3.11 acf2e462 2019-12-16 14:09:54 Details Diff |
0003834: Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word |
Affected Issues 0003834 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/MonitorService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/MonitorServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-17 16:41 | gilles.riand | New Issue | |
| 2019-04-26 22:16 | elong | Note Added: 0001451 | |
| 2019-04-26 23:09 | elong | Summary | Log Details Error => Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word |
| 2019-04-29 14:25 | elong | Tag Attached: dialect: interbase | |
| 2019-04-29 14:25 | elong | Tag Attached: install | |
| 2019-04-29 14:25 | elong | Project | SymmetricDS Pro => SymmetricDS |
| 2019-05-18 13:06 | elong | Priority | normal => high |
| 2019-05-18 13:06 | elong | Status | new => acknowledged |
| 2019-12-13 20:55 | nrichardson | Note Added: 0001669 | |
| 2019-12-13 20:55 | nrichardson | Assigned To | => pmarzullo |
| 2019-12-13 20:55 | nrichardson | Status | acknowledged => assigned |
| 2019-12-16 12:56 | elong | Relationship added | related to 0004157 |
| 2019-12-16 19:10 | elong | Assigned To | pmarzullo => elong |
| 2019-12-16 19:10 | elong | Status | assigned => resolved |
| 2019-12-16 19:10 | elong | Resolution | open => fixed |
| 2019-12-16 19:10 | elong | Fixed in Version | => 3.11.3 |
| 2019-12-16 19:10 | elong | Target Version | => 3.11.3 |
| 2019-12-16 20:00 | admin | Changeset attached | => SymmetricDS 3.11 acf2e462 |
| 2020-01-02 14:42 | admin | Status | resolved => closed |