View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006488SymmetricDSBugpublic2024-06-12 08:282024-06-17 17:00
Reporterctoabidmaqbool Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.7 
Target Version3.15.8Fixed in Version3.15.8 
Summary0006488: org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR
DescriptionExecuting create-sym-tables on hsqldb database is causing error e.g. org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR

I have find-out where the error is exists, basacially VARCHAR column is missing size attribute;

See attached screen-shot;

```
D:\java_tech\symmetric-server-3.15.7-sample>bin\symadmin --engine corp-000 create-sym-tables
Log output will be written to D:\java_tech\symmetric-server-3.15.7-sample/logs/symmetric.log
[] - AbstractCommandLauncher - Command: {create-sym-tables}
[] - AbstractCommandLauncher - Option: name=engine, value={corp-000}
[] - ENGINE - dataFileCache open start
[] - ENGINE - dataFileCache open end
[] - ENGINE - dataFileCache commit start
[] - ENGINE - dataFileCache commit end
[] - ENGINE - Database closed
[] - ENGINE - dataFileCache open start
[] - ENGINE - dataFileCache open end
[] - ENGINE - dataFileCache commit start
[] - ENGINE - dataFileCache commit end
[] - ENGINE - Database closed
[] - SymmetricUtils -
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2024 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
[corp-000] - ClientSymmetricEngine - Initializing connection to database
[corp-000] - ENGINE - dataFileCache open start
[corp-000] - ENGINE - dataFileCache open end
[corp-000] - ENGINE - dataFileCache commit start
[corp-000] - ENGINE - dataFileCache commit end
[corp-000] - ENGINE - Database closed
[corp-000] - ENGINE - dataFileCache open start
[corp-000] - ENGINE - dataFileCache open end
[corp-000] - JdbcDatabasePlatformFactory - Detected database 'HSQL Database Engine', version '2', protocol 'hsqldb'
[corp-000] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.hsqldb2.HsqlDb2DatabasePlatform
[corp-000] - HsqlDb2SymmetricDialect - The DbDialect being used is org.jumpmind.symmetric.db.hsqldb2.HsqlDb2SymmetricDialect
[corp-000] - ExtensionService - Found 0 extension points from the database that will be registered
[corp-000] - StagingManager - The staging directory was initialized at the following location: D:\java_tech\symmetric-server-3.15.7-sample\tmp\corp-000
[corp-000] - ExtensionService - Found 0 extension points from the database that will be registered
[corp-000] - ClientExtensionService - Found 7 extension points from spring that will be registered
[corp-000] - AbstractSymmetricEngine - Initializing SymmetricDS database
[corp-000] - AbstractSymmetricEngine - Checking tables and objects
[corp-000] - HsqlDb2SymmetricDialect - Checking if SymmetricDS tables need created or altered
[corp-000] - TriggerRouterService - SyncTriggers: fix multiple active trigger histories took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: get triggers for current node took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: sync triggers started took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: get active trigger histories took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: update or create ddl triggers took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: sync triggers ended took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: tables for trigger took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: drop trigger took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: trigger inactivated took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: does trigger exist took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: inactivate trigger hist took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: update or create database trigger took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: trigger to table supporting info took 0 ms
[corp-000] - TriggerRouterService - SyncTriggers: table does not exist took 0 ms
[corp-000] - HsqlDb2SymmetricDialect - There are SymmetricDS tables that needed altered
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_CF_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_CF_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_FTR_2_FTRG"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_FTR_2_FTRG"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_FTR_2_RTR"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_FTR_2_RTR"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_GPLTLNK_2_GPLT"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_GPLTLNK_2_GPLT"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_LNK_2_GRP_SRC"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_LNK_2_GRP_SRC"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_LNK_2_GRP_TGT"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_LNK_2_GRP_TGT"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_RT_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_RT_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TT_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TT_2_GRP_LNK"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TRG_2_CHNL"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TRG_2_CHNL"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TRG_2_RLD_CHNL"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TRG_2_RLD_CHNL"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TR_2_RTR"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TR_2_RTR"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TR_2_TRG"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TR_2_TRG"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TRGPLT_2_GPLT"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TRGPLT_2_GPLT"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP INDEX "SYM_FK_TRGPLT_2_TR"
[corp-000] - LogSqlResultsListener - DDL failed: DROP INDEX "SYM_FK_TRGPLT_2_TR"
[corp-000] - LogSqlResultsListener - Executing DDL: DROP TABLE "PUBLIC"."PUBLIC"."SYM_NODE_" IF EXISTS
[corp-000] - LogSqlResultsListener - Executing DDL: CREATE TABLE "PUBLIC"."PUBLIC"."SYM_NODE_"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "CONFIG_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "DATABASE_NAME" VARCHAR(50),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "BATCH_LAST_SUCCESSFUL" TIMESTAMP(3),
    "DATA_ROWS_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "DATA_ROWS_LOADED_COUNT" INTEGER DEFAULT 0,
    "OLDEST_LOAD_TIME" TIMESTAMP(3),
    "MOST_RECENT_ACTIVE_TABLE" VARCHAR,
    "PURGE_OUTGOING_LAST_RUN_MS" BIGINT DEFAULT 0,
    "PURGE_OUTGOING_LAST_FINISH" TIMESTAMP(3),
    "PURGE_OUTGOING_AVERAGE_MS" BIGINT,
    "ROUTING_LAST_RUN_MS" BIGINT,
    "ROUTING_LAST_FINISH" TIMESTAMP(3),
    "ROUTING_AVERAGE_RUN_MS" BIGINT DEFAULT 0,
    "SYM_DATA_SIZE" BIGINT,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    "DEPLOYMENT_SUB_TYPE" VARCHAR(50)
)
[corp-000] - LogSqlResultsListener - DDL failed: CREATE TABLE "PUBLIC"."PUBLIC"."SYM_NODE_"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "CONFIG_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "DATABASE_NAME" VARCHAR(50),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "BATCH_LAST_SUCCESSFUL" TIMESTAMP(3),
    "DATA_ROWS_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "DATA_ROWS_LOADED_COUNT" INTEGER DEFAULT 0,
    "OLDEST_LOAD_TIME" TIMESTAMP(3),
    "MOST_RECENT_ACTIVE_TABLE" VARCHAR,
    "PURGE_OUTGOING_LAST_RUN_MS" BIGINT DEFAULT 0,
    "PURGE_OUTGOING_LAST_FINISH" TIMESTAMP(3),
    "PURGE_OUTGOING_AVERAGE_MS" BIGINT,
    "ROUTING_LAST_RUN_MS" BIGINT,
    "ROUTING_LAST_FINISH" TIMESTAMP(3),
    "ROUTING_AVERAGE_RUN_MS" BIGINT DEFAULT 0,
    "SYM_DATA_SIZE" BIGINT,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    "DEPLOYMENT_SUB_TYPE" VARCHAR(50)
)
[corp-000] - JdbcSqlTemplate - length must be specified in type definition: VARCHAR. Failed to execute: CREATE TABLE "PUBLIC"."PUBLIC"."SYM_NODE_"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "CONFIG_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "DATABASE_NAME" VARCHAR(50),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "BATCH_LAST_SUCCESSFUL" TIMESTAMP(3),
    "DATA_ROWS_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "DATA_ROWS_LOADED_COUNT" INTEGER DEFAULT 0,
    "OLDEST_LOAD_TIME" TIMESTAMP(3),
    "MOST_RECENT_ACTIVE_TABLE" VARCHAR,
    "PURGE_OUTGOING_LAST_RUN_MS" BIGINT DEFAULT 0,
    "PURGE_OUTGOING_LAST_FINISH" TIMESTAMP(3),
    "PURGE_OUTGOING_AVERAGE_MS" BIGINT,
    "ROUTING_LAST_RUN_MS" BIGINT,
    "ROUTING_LAST_FINISH" TIMESTAMP(3),
    "ROUTING_AVERAGE_RUN_MS" BIGINT DEFAULT 0,
    "SYM_DATA_SIZE" BIGINT,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    "DEPLOYMENT_SUB_TYPE" VARCHAR(50)
)
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.ParserDQL.readTypeDefinition(Unknown Source)
        at org.hsqldb.ParserTable.readColumnDefinitionOrNull(Unknown Source)
        at org.hsqldb.ParserTable.readTableContentsSource(Unknown Source)
        at org.hsqldb.ParserTable.compileCreateTableBody(Unknown Source)
        at org.hsqldb.ParserTable.compileCreateTable(Unknown Source)
        at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
        at org.hsqldb.ParserCommand.compilePart(Unknown Source)
        at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
        at org.hsqldb.Session.executeDirectStatement(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
 [wrapped] java.sql.SQLSyntaxErrorException: length must be specified in type definition: VARCHAR
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
        at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
        at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
        at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:430)
        at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:412)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:502)
 [wrapped] org.jumpmind.db.sql.SqlException: length must be specified in type definition: VARCHAR
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308)
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:504)
        at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:412)
        at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:113)
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:574)
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:182)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:447)
        at org.jumpmind.symmetric.SymmetricAdmin.createSymTables(SymmetricAdmin.java:860)
        at org.jumpmind.symmetric.SymmetricAdmin.executeWithOptions(SymmetricAdmin.java:395)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:157)
        at org.jumpmind.symmetric.SymmetricAdmin.main(SymmetricAdmin.java:171)
-------------------------------------------------------------------------------
[] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=000 version=3.15.7 database=HSQL Database Engine
[] - ENGINE - dataFileCache commit start
[] - ENGINE - dataFileCache commit end
[] - ENGINE - Database closed
```
Tagsdialect: hsqldb

Activities

ctoabidmaqbool

2024-06-12 08:31

reporter   ~0002462

where the issue exists: symmetric-core/src/main/resources/symmetric-schema.xml
image.png (224,521 bytes)   
image.png (224,521 bytes)   

Related Changesets

SymmetricDS: 3.15 6ab4dcb4

2024-06-12 17:13:48

pmarzullo

Details Diff 		0006488: org.hsqldb.HsqlException: length must be specified in type
definition: VARCHAR		 Affected Issues
0006488
mod - symmetric-core/src/main/resources/symmetric-schema.xml Diff File

SymmetricDS: 3.15 1bd2048f

2024-06-17 16:31:40

pmarzullo

Details Diff 		0006488: org.hsqldb.HsqlException: length must be specified in type
definition: VARCHAR		 Affected Issues
0006488
mod - symmetric-client/src/test/java/org/jumpmind/symmetric/DbExportImportTest.java Diff File

Issue History

Date Modified Username Field Change
2024-06-12 08:28 ctoabidmaqbool New Issue
2024-06-12 08:28 ctoabidmaqbool Tag Attached: dialect: hsqldb
2024-06-12 08:31 ctoabidmaqbool Note Added: 0002462
2024-06-12 08:31 ctoabidmaqbool File Added: image.png
2024-06-12 17:12 pmarzullo Assigned To => pmarzullo
2024-06-12 17:12 pmarzullo Status new => assigned
2024-06-12 17:13 pmarzullo Target Version => 3.15.8
2024-06-12 17:14 pmarzullo Status assigned => resolved
2024-06-12 17:14 pmarzullo Resolution open => fixed
2024-06-12 17:14 pmarzullo Fixed in Version => 3.15.8
2024-06-12 18:00 pmarzullo Changeset attached => SymmetricDS 3.15 6ab4dcb4
2024-06-17 17:00 pmarzullo Changeset attached => SymmetricDS 3.15 1bd2048f
2024-08-16 17:45 admin Status resolved => closed