Projects tigase _server tigase-pubsub Issues #77
Improve compatibility with MySQL8 (#77)
Closed
wojciech.kapcia@tigase.net opened 6 years ago

ERROR

 Loading schema: Tigase PubSub Component, version: 4.0.0-SNAPSHOT-b678/0aadd9ad (database version: none)

Schema files to load: [mysql-issue #3.1.0.sql, mysql-issue #3.2.0.sql, mysql-issue #4.0.0.sql]
Loading schema from file(s): mysql-issue #3.1.0.sql, URI: jdbc:mysql://localhost/tigasedbinst800my8?user=root&password=root&useSSL=false&useLegacyDatetimeCode=false
 completed OK
Loading schema from file(s): mysql-issue #3.2.0.sql, URI: jdbc:mysql://localhost/tigasedbinst800my8?user=root&password=root&useSSL=false&useLegacyDatetimeCode=false
 completed OK
Loading schema from file(s): mysql-issue #4.0.0.sql, URI: jdbc:mysql://localhost/tigasedbinst800my8?user=root&password=root&useSSL=false&useLegacyDatetimeCode=false
Failed to execute query: call TigExecuteIf( ( SELECT count(*) FROM information_schema.statistics s1 INNER JOIN information_schema.statistics s2 ON s1.table_schema = s2.table_schema AND s1.table_name = s2.table_name AND s1.index_name = s2.index_name JOIN (SELECT @@GLOBAL.innodb_large_prefix AS val) x WHERE s1.table_schema = database() AND s1.table_name = 'tig_pubsub_items' AND s1.column_name = 'node_id' AND s2.column_name = 'id' AND ((s2.sub_part = 255 AND x.val = 0) OR (s2.sub_part <> 255 AND x.val = 1)) ), "drop index `node_id` on tig_pubsub_items" )



=====
Failure: Unknown system variable 'innodb_large_prefix'
=====

Andrzej Wójcik (Tigase) commented 6 years ago

I've fixed the issues with database schema on MySQL 8.0 and made a few checks to make sure it works on MySQL 5.7, MySQL 8.0, MariaDB 10.2 and MariaDB 10.3. In each case, schema was applied properly on the database without any issues.

I do not have any "working" database which has schema on MySQL pre-5.7 to verify that upgrade works, so this was not tested.

issue 1 of 1
Type
Task
Priority
Normal
Assignee
RedmineID
8682
Spent time
5h 30m
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-pubsub#77
Please wait...
Page is in error, reload to recover