Projects tigase _server server-core Issues #1138
Schema files are not sorted correctly during loading (#1138)
Closed
wojciech.kapcia@tigase.net opened 4 years ago
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:130] [CONFIG  ] [                  main ] DBSchemaLoader.loadSchemaFromSQLFiles(): Loading schema server, version: 8.1.0-SNAPSHOT-b5563/bc87a48c from files, current: 0.0.0
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:144] [INFO    ] [                  main ] DBSchemaLoader.loadSchemaFromSQLFiles(): Schema files to load: [mysql-issue #8.0.0.sql, mysql-issue #8.1.0.sql, mysql-issue #7.1.0.sql]
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:145] [INFO    ] [                  main ] DBSchemaLoader.loadSchemaFile()  : Loading schema from file(s): mysql-issue #8.0.0.sql, URI: jdbc:mysql://localhost:3306/…
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:151] [FINE    ] [                  main ] DBSchemaLoader.logAvailableDrivers(): DriverManager (available drivers): org.apache.derby.jdbc.AutoloadedDriver[10.12] ,net.sourceforge.jtds.jdbc.Driver[1.3] ,com.mysql.jdbc.Driver[5.1] ,com.mysql.fabric.jdbc.FabricMySQLDriver[5.1] ,org.postgresql.Driver[9.4]
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:151] [FINER   ] [                  main ] DBSchemaLoader.loadSQLQueries()  : Loading queries, resource: database/mysql-issue #8.0.0.sql
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:152] [FINER   ] [                  main ] DBSchemaLoader.loadSQLQueries()  : Loading queries, resource: database/mysql-issue #8.0.0-schema.sql
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:154] [FINER   ] [                  main ] DBSchemaLoader.loadSQLQueries()  : Loading queries, resource: database/mysql-issue #8.0.0-sp.sql
2020-04-15 21:24:20,063 P24249 [INFO]   [2020-04-15 21:24:18:160] [FINER   ] [                  main ] DBSchemaLoader.loadSQLQueries()  : Loading queries, resource: database/mysql-issue #8.0.0-props.sql
2020-04-15 21:24:20,064 P24249 [INFO]   [2020-04-15 21:24:18:160] [FINEST  ] [                  main ] DBSchemaLoader.lambda$loadSchemaFile$20(): Executing query: alter table tig_pairs modify `pval` mediumtext character set utf8mb4 collate utf8mb4_unicode_ci
2020-04-15 21:24:20,064 P24249 [INFO]   [2020-04-15 21:24:18:163] [SEVERE  ] [                  main ] DBSchemaLoader.lambda$loadSchemaFile$20(): Failed to execute query: alter table tig_pairs modify `pval` mediumtext character set utf8mb4 collate utf8mb4_unicode_ci
2020-04-15 21:24:20,064 P24249 [INFO]   [2020-04-15 21:24:18:166] [SEVERE  ] [                  main ] DBSchemaLoader.withConnectionGeneric():
2020-04-15 21:24:20,064 P24249 [INFO]
2020-04-15 21:24:20,064 P24249 [INFO]
2020-04-15 21:24:20,064 P24249 [INFO]   =====
2020-04-15 21:24:20,064 P24249 [INFO]   Failure: Table 'tigasedb.tig_pairs' doesn't exist
2020-04-15 21:24:20,064 P24249 [INFO]   =====

It should start with 7.1.0

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Version
tigase-server-8.1.0
Spent time
1h 15m
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#1138
Please wait...
Page is in error, reload to recover