View Issue Details

IDProjectCategoryView StatusLast Update
0003834SymmetricDSBugpublic2020-01-02 14:42
Reportergilles.riand Assigned Toelong  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.9.14 
Target Version3.11.3Fixed in Version3.11.3 
Summary0003834: Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word
DescriptionI 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)
Tagsdialect: interbase, install

Relationships

related to 0004157 closedpmarzullo SymmetricDS Pro Impossible to see the webconsole (version pro) with Interbase 

Activities

elong

2019-04-26 22:16

developer   ~0001451

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.

nrichardson

2019-12-13 20:55

developer   ~0001669

Also found this "type" issue exists in the MonitorService.java where it appends 'and type = ...' to the where clause.

Related Changesets

SymmetricDS: 3.11 acf2e462

2019-12-16 14:09:54

admin

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

Issue History

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