View Revisions: Issue #4914

Back to Issue
Summary 0004914: Unable to create SYM_FILE_SNAPSHOT table on Firebird 3x with UTF8 Charset and a small page size
Revision 2021-03-24 08:16 by adisman
Description If I use SQL Server Firebird version 3.08 with a page size of 16 kB and Charset UTF8 Symmetric DS will try to create a SYM_FILE_SNAPSHOT table after startup. This table attempts to create a primary key over these 4 columns.

ALTER TABLE SYM_FILE_SNAPSHOT ADD PRIMARY KEY (TRIGGER_ID, ROUTER_ID, RELATIVE_DIR, FILE_NAME);

    TRIGGER_ID VARCHAR (128) NOT NULL,
    ROUTER_ID VARCHAR (50) NOT NULL,
    RELATIVE_DIR VARCHAR (255) NOT NULL,
    FILE_NAME VARCHAR (128) NOT NULL,


Creating an index over these four columns with that length and UTF8 character set fails because such an index exceeds the maximum size.

On an ANSI character set database, this primary key can be created because it does not exceed the server's sql limit.
An error already occurs with the UTF8 character set.

Page size 16KB is currently the maximum SQL Server Firebird version 3.0X

In the engine * .properties file I have set:
db.connection.properties = encoding = utf8

Because I don't need file synchronization for this case, I tried to turn it off, but the symmetric server creates these tables the same way.
Revision 2025-04-09 19:34 by pbelov
Description If I use Firebird database version 3.08 with a page size of 16 kB and Charset UTF8 Symmetric DS will try to create a SYM_FILE_SNAPSHOT table after startup.
This table attempts to create a primary key over these 4 columns:

ALTER TABLE SYM_FILE_SNAPSHOT ADD PRIMARY KEY (TRIGGER_ID, ROUTER_ID, RELATIVE_DIR, FILE_NAME);
    TRIGGER_ID VARCHAR (128) NOT NULL,
    ROUTER_ID VARCHAR (50) NOT NULL,
    RELATIVE_DIR VARCHAR (255) NOT NULL,
    FILE_NAME VARCHAR (128) NOT NULL,


Creating an index over these four columns with that length and UTF8 character set fails because such an index exceeds the maximum size.

On an ANSI character set database, this primary key can be created because it does not exceed the Firebird limit.
An error already occurs with the UTF8 character set.

Page size 16KB is currently the maximum for the Firebird database version 3.0X

In the engine * .properties file I have set:
db.connection.properties = encoding = utf8

Because I don't need file synchronization for this case, I tried to turn it off, but the symmetric server creates these tables the same way.
Revision 2021-03-24 08:16 by adisman
Steps To Reproduce 1) Install SymmetricDS 12.7
2) Install SQL Firebird 3.08
3) Create a DB with charset UTF8
4) Attach Symmetric to this db with charset UTF8
Revision 2025-04-09 19:34 by pbelov
Steps To Reproduce 1) Install SymmetricDS 12.7
2) Install Firebird 3.08
3) Create a database/catalog with the UTF8 charset
4) Attach Symmetric to this database