View Issue Details

IDProjectCategoryView StatusLast Update
0003832SymmetricDSBugpublic2021-06-19 21:06
Reportergilles.riand Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.9.14 
Summary0003832: SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size
DescriptionImpossible to Install SymDS 3.9.15 with interbase XE Patch5


2018-12-17 16:14:29,280 WARN [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL failed: CREATE TABLE "SYM_TRIGGER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "SOURCE_CATALOG_NAME" VARCHAR(255),
    "SOURCE_SCHEMA_NAME" VARCHAR(255),
    "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL,
    "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL,
    "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255),
    "NAME_FOR_INSERT_TRIGGER" VARCHAR(255),
    "NAME_FOR_DELETE_TRIGGER" VARCHAR(255),
    "SYNC_ON_UPDATE_CONDITION" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL,
    "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL,
    "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-12-17 16:14:29,280 WARN [SymmetricDS] [JdbcSqlTemplate] [qtp1156304131-17] [interclient][interbase]no current record for fetch operation
[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: CREATE TABLE "SYM_TRIGGER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "SOURCE_CATALOG_NAME" VARCHAR(255),
    "SOURCE_SCHEMA_NAME" VARCHAR(255),
    "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL,
    "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL,
    "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255),
    "NAME_FOR_INSERT_TRIGGER" VARCHAR(255),
    "NAME_FOR_DELETE_TRIGGER" VARCHAR(255),
    "SYNC_ON_UPDATE_CONDITION" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL,
    "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL,
    "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-12-17 16:14:29,282 ERROR [SymmetricDS] [AppUI] [qtp1156304131-17] Invocation of method uploadFinished in com.jumpmind.symmetric.console.impl.dq$5 failed. StackTraceKey.init [MethodException:468589223]
com.vaadin.event.ListenerMethod$MethodException: Invocation of method uploadFinished in com.jumpmind.symmetric.console.impl.dq$5 failed.
    at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:531)
    at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211)
    at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174)
    at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033)
    at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:815)
    at com.vaadin.ui.Upload$2.streamingFailed(Upload.java:1107)
    at com.vaadin.server.communication.FileUploadHandler.streamToReceiver(FileUploadHandler.java:628)
    at com.vaadin.server.communication.FileUploadHandler.handleFileUploadValidationAndData(FileUploadHandler.java:460)
    at com.vaadin.server.communication.FileUploadHandler.doHandleSimpleMultipartFileUpload(FileUploadHandler.java:413)
    at com.vaadin.server.communication.FileUploadHandler.handleRequest(FileUploadHandler.java:290)
    at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1568)
    at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:381)
    at com.jumpmind.symmetric.console.ui.AppServlet.service(AppServlet.java:42)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:841)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
    at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:206)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
    at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.Server.handle(Server.java:561)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
    at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.jumpmind.db.sql.SqlException: [interclient][interbase]no current record for fetch operation
[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    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:411)
    at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:542)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
    at com.jumpmind.symmetric.console.impl.dq$5.uploadFinished(NodeSetupWizard.java:147)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
    ... 47 more
Caused by: java.sql.SQLException: [interclient][interbase]no current record for fetch operation
[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown Source)
    at interbase.interclient.Statement.execute(Unknown Source)
    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:426)
    at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:411)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
    ... 57 more
2018-12-17 16:15:17,094 INFO [not available] [SecurityService] [background-refresher-1] Generated secret key using AES/GCM/PKCS5Padding 256
2018-12-17 16:15:17,230 INFO [not available] [SecurityService] [background-refresher-1] Initialized with AES 256-bit
2018-12-17 16:15:17,238 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] Initializing connection to database
2018-12-17 16:15:17,339 INFO [lame-easy_test_3_9_15] [SecurityService] [background-refresher-1] Initialized with AES 256-bit
2018-12-17 16:15:17,350 INFO [lame-easy_test_3_9_15] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'InterBase', version '10', protocol 'interbase'
2018-12-17 16:15:17,350 INFO [lame-easy_test_3_9_15] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform
2018-12-17 16:15:17,484 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect
2018-12-17 16:15:17,602 INFO [lame-easy_test_3_9_15] [ExtensionService] [background-refresher-1] Found 0 extension points from the database that will be registered
2018-12-17 16:15:17,603 INFO [lame-easy_test_3_9_15] [StagingManager] [background-refresher-1] The staging directory was initialized at the following location: tmp\lame-easy_test_3_9_15
2018-12-17 16:15:17,603 INFO [lame-easy_test_3_9_15] [EnhancedStagingManager] [background-refresher-1] Compressed staging is enabled
2018-12-17 16:15:17,767 INFO [lame-easy_test_3_9_15] [ExtensionService] [background-refresher-1] Found 0 extension points from the database that will be registered
2018-12-17 16:15:17,767 INFO [lame-easy_test_3_9_15] [ClientExtensionService] [background-refresher-1] Found 14 extension points from spring that will be registered
2018-12-17 16:15:17,777 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] Initializing SymmetricDS database
2018-12-17 16:15:17,777 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] Checking if SymmetricDS tables need created or altered
2018-12-17 16:15:22,531 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] There are SymmetricDS tables that needed altered
2018-12-17 16:15:22,546 WARN [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] DDL failed: CREATE TABLE "SYM_TRIGGER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "SOURCE_CATALOG_NAME" VARCHAR(255),
    "SOURCE_SCHEMA_NAME" VARCHAR(255),
    "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL,
    "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL,
    "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255),
    "NAME_FOR_INSERT_TRIGGER" VARCHAR(255),
    "NAME_FOR_DELETE_TRIGGER" VARCHAR(255),
    "SYNC_ON_UPDATE_CONDITION" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL,
    "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL,
    "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-12-17 16:15:22,547 WARN [lame-easy_test_3_9_15] [JdbcSqlTemplate] [background-refresher-1] [interclient][interbase]no current record for fetch operation
[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: CREATE TABLE "SYM_TRIGGER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "SOURCE_CATALOG_NAME" VARCHAR(255),
    "SOURCE_SCHEMA_NAME" VARCHAR(255),
    "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL,
    "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL,
    "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL,
    "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255),
    "NAME_FOR_INSERT_TRIGGER" VARCHAR(255),
    "NAME_FOR_DELETE_TRIGGER" VARCHAR(255),
    "SYNC_ON_UPDATE_CONDITION" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL,
    "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL,
    "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL,
    "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-12-17 16:15:22,547 ERROR [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:2946958765]
org.jumpmind.db.sql.SqlException: [interclient][interbase]no current record for fetch operation
[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    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:411)
    at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:542)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
    at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
    at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:429)
    at com.jumpmind.symmetric.console.impl.de.t(AbstractWizardScreen.java:149)
Steps To ReproduceJust install with interbase XE
Tagsdialect: interbase, install

Relationships

duplicate of 0003362 closedpmarzullo SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size 

Activities

gilles.riand

2018-12-17 15:22

reporter  

symmetric.log (69,602 bytes)
wrapper.log (4,150 bytes)
install.log (24,839 bytes)

gilles.riand

2018-12-18 09:01

reporter   ~0001367

I'm using jre1.8.0_131

gilles.riand

2018-12-18 09:03

reporter   ~0001368

The Interclient.jar is on the folder C:\Embarcadero\InterBase\SDK\lib\
For me 2012-06-13 (so 13 june 2012) it's the Last version of Interbase XE patch5

Issue History

Date Modified Username Field Change
2018-12-17 15:22 gilles.riand New Issue
2018-12-17 15:22 gilles.riand File Added: symmetric.log
2018-12-17 15:22 gilles.riand File Added: Install_V3.9.15_20181217160816_6520178787065992358.log
2018-12-17 15:22 gilles.riand File Added: wrapper.log
2018-12-17 15:22 gilles.riand File Added: install.log
2018-12-18 09:01 gilles.riand Note Added: 0001367
2018-12-18 09:03 gilles.riand Note Added: 0001368
2019-04-26 22:10 elong Relationship added duplicate of 0003362
2019-04-26 22:10 elong Summary Interbase XE => SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size
2019-04-26 22:10 elong Description Updated View Revisions
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