View Revisions: Issue #3953

Summary 0003953: Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver)
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
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