View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005260 | SymmetricDS | Bug | public | 2022-04-07 18:16 | 2022-04-11 21:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.13.4 | Fixed in Version | 3.13.4 | ||
| Summary | 0005260: Sybase ASE with 2k page file fails to create SYM tables (600 is the maximum allowable size of an index.) | ||||
| Description | Sybase ASE with a 2k page size for indexes will fail to startup because some runtime tables have columns that are too wide to create indexes. We should detect the page size and reduce the size of the columns as necessary. 2022-04-07 16:06:33,924 WARN [MIDB-001] [JdbcSqlTemplate] [background-refresher-1] 600 is the maximum allowable size of an index. Composite index specified is 693 bytes. . Failed to execute: CREATE TABLE sym_file_snapshot( trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, relative_dir VARCHAR(255) NOT NULL, file_name VARCHAR(260) NOT NULL, channel_id VARCHAR(128) DEFAULT 'filesync' NOT NULL, reload_channel_id VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, last_event_type CHAR(1) NOT NULL, crc32_checksum NUMERIC(18,0) NULL, file_size NUMERIC(18,0) NULL, file_modified_time NUMERIC(18,0) NULL, last_update_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, create_time DATETIME NOT NULL, PRIMARY KEY (trigger_id, router_id, relative_dir, file_name) ) | ||||
| Tags | dialect: sybase | ||||
|
SymmetricDS: 3.13 fd62fdfd 2022-04-07 20:38:34 Details Diff |
0005260: Sybase ASE with 2k page file fails to create SYM tables |
Affected Issues 0005260 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseSymmetricDialect.java | Diff File | ||
|
SymmetricDS: 3.14 e7ec16c2 2022-04-07 20:38:34 Details Diff |
0005260: Sybase ASE with 2k page file fails to create SYM tables |
Affected Issues 0005260 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseSymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-04-07 18:16 | elong | New Issue | |
| 2022-04-07 18:16 | elong | Status | new => assigned |
| 2022-04-07 18:16 | elong | Assigned To | => elong |
| 2022-04-07 18:16 | elong | Tag Attached: dialect: sybase | |
| 2022-04-07 20:39 | elong | Status | assigned => resolved |
| 2022-04-07 20:39 | elong | Resolution | open => fixed |
| 2022-04-07 20:39 | elong | Fixed in Version | => 3.13.4 |
| 2022-04-07 21:00 | admin | Changeset attached | => SymmetricDS 3.13 fd62fdfd |
| 2022-04-11 19:28 | admin | Status | resolved => closed |
| 2022-04-11 21:00 | admin | Changeset attached | => SymmetricDS 3.14 e7ec16c2 |