View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004998SymmetricDSBugpublic2021-05-19 22:592021-05-28 20:40
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004998: Firebird error while dropping trigger, token unknown
DescriptionWhen making a change to an existing sym_trigger, it gets an error about "token unknown". The SQL has a period in front of the trigger name even though schema is blank and Firebird does not support schemas. In sym_trigger_hist, the source_schema_name is blank instead of null.

[server] - TriggerRouterService - Error while dropping trigger SYM_ON_D_FOR_MYTST_SRVR for table MYTEST org.jumpmind.db.sql.SqlException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 14; . [SQLState:42000, ISC error code:335544634]
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:313)
    at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:63)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:398)
    at org.jumpmind.db.sql.JdbcSqlTransaction.execute(JdbcSqlTransaction.java:300)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.removeTrigger(AbstractSymmetricDialect.java:323)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.removeTrigger(AbstractSymmetricDialect.java:303)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.dropTrigger(TriggerRouterService.java:1487)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.dropTriggers(TriggerRouterService.java:1453)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTrigger(TriggerRouterService.java:1727)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTrigger(TriggerRouterService.java:1690)
    at com.jumpmind.symmetric.console.impl.aQ$2.doWork(TableTriggerForm.java:540)
    at com.jumpmind.symmetric.console.impl.V$2.onBackgroundDataRefresh(InProgressDialog.java:108)
    at com.jumpmind.symmetric.console.ui.b.a(BackgroundRefresherService.java:99)
    at com.jumpmind.symmetric.console.ui.b$3.run(BackgroundRefresherService.java:142)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 14; . [SQLState:42000, ISC error code:335544634]
    at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:534)
    at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:140)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:204)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readSingleResponse(AbstractWireOperations.java:171)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readResponse(AbstractWireOperations.java:155)
    at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readGenericResponse(AbstractWireOperations.java:257)
    at org.firebirdsql.gds.ng.wire.AbstractFbWireDatabase.readGenericResponse(AbstractFbWireDatabase.java:201)
    at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:89)
    at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:881)
    at org.firebirdsql.jdbc.FBStatement.internalExecute(FBStatement.java:868)
    at org.firebirdsql.jdbc.FBStatement.executeImpl(FBStatement.java:496)
    at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:482)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:307)
    at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:300)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:396)
    ... 18 more
Tagsdialect: firebird, sync-trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 b04e267e

2021-05-19 23:18:22

admin

Details Diff 		0004998: Firebird error while dropping trigger, token unknown Affected Issues
0004998
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2021-05-19 22:59 elong New Issue
2021-05-19 22:59 elong Status new => assigned
2021-05-19 22:59 elong Assigned To => elong
2021-05-19 22:59 elong Tag Attached: dialect: firebird
2021-05-19 22:59 elong Tag Attached: sync-trigger
2021-05-19 23:24 elong Status assigned => resolved
2021-05-19 23:24 elong Resolution open => fixed
2021-05-19 23:24 elong Fixed in Version => 3.12.10
2021-05-20 00:00 admin Changeset attached => SymmetricDS 3.12 b04e267e
2021-05-28 20:40 admin Status resolved => closed