View Revisions: Issue #3953
| Summary | 0003953: Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver) | ||
|---|---|---|---|
| Revision | 2019-05-10 19:20 by enwony | ||
| Description | It looks like lower-case table name used for searching while upper-case name created initally. Part of logfile from second restart, all tables already exists in database: 2019-05-11 05:06:37,739 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added ... 2019-05-11 05:06:38,176 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2019-05-11 05:06:38,192 WARN [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL failed: CREATE TABLE "SYM_CHANNEL"( ... I found message on sourceforge that may rely to this (first message mention same situation, but it refer to older versions) https://sourceforge.net/p/symmetricds/discussion/739236/thread/02bddf3b/ PS: reproduced even if I specify encoding in server.properties |
||
| Revision | 2019-05-17 17:20 by elong | ||
| Description | It looks like lower-case table name used for searching while upper-case name created initally. Part of logfile from second restart, all tables already exists in database: 2019-05-11 05:06:37,739 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added ... 2019-05-11 05:06:38,176 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2019-05-11 05:06:38,192 WARN [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL failed: CREATE TABLE "SYM_CHANNEL"( ... I found message on sourceforge that may rely to this (first message mention same situation, but it refer to older versions) https://sourceforge.net/p/symmetricds/discussion/739236/thread/02bddf3b/ PS: reproduced even if I specify encoding in server.properties |
||
| Revision | 2019-05-10 19:20 by enwony | ||
| Steps To Reproduce | 1. Installed JRE1.8.0.211 2. Installed firebird 2.5.8.27089 3. Installed Symmetrics DS 3.10.2 4. Tuned conf/log4j.xml for extended logging 5. Tuned one engine file (attached). 6. Created empty local DB in firebird. 7. Started symmetricds server, wait 1 min to populate database with Sym_* tables. 8. Restart symmetricds server, got error in log (unsuccessful metadata update; Table SYM_CHANNEL already exists) and no longer in-sync Expected: symmetricsds server continue work after restart. |
||
| Revision | 2019-05-17 17:20 by elong | ||
| Steps To Reproduce | 1. Installed JRE1.8.0.211 2. Installed firebird 2.5.8.27089 3. Installed Symmetrics DS 3.10.2 4. Tuned conf/log4j.xml for extended logging 5. Tuned one engine file (attached). 6. Created empty local DB in firebird. 7. Started symmetricds server, wait 1 min to populate database with Sym_* tables. 8. Restart symmetricds server, got error in log (unsuccessful metadata update; Table SYM_CHANNEL already exists) and no longer in-sync Expected: symmetricsds server continue work after restart. |
||