View Issue Details

IDProjectCategoryView StatusLast Update
0004466SymmetricDS ProBugpublic2020-07-23 09:00
Reportermatej.vehar@easy.biAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.12.1 
Target Version3.12.3Fixed in Version3.12.3 
Summary0004466: Permission test during installation fails on MySQL Clusters
DescriptionManaged MySQL cluster has primary keys enforced (for replication purposes). Therefore installation step where DB user's permissions are checked it fails with error:

2020-07-06 10:26:07,934 INFO [gui] [JdbcDatabasePlatformFactory] [qtp844112759-12] Detected database 'MySQL', version '8', protocol 'mysql'
2020-07-06 10:26:07,935 INFO [gui] [JdbcDatabasePlatformFactory] [qtp844112759-12] The IDatabasePlatform being used is org.jumpmind.db.platform.mysql.MySqlDatabasePlatform
2020-07-06 10:26:07,955 WARN [gui] [JdbcSqlTemplate] [qtp844112759-12] Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.. Failed to execute: CREATE TABLE `SYM_PERMISSION_TEST`(
    `TEST_ID` INTEGER,
    `TEST_VALUE` INTEGER
)
Steps To ReproduceInstall PRO version with Digital Ocean managed MySQL 8 database
Additional InformationTest SQL for CREATE TABLE is missing primary key. Probably is also good to check if other tables have primary keys to work in managed MySQL clusters.
Tagsinstall

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 9c63642f

2020-07-23 08:57:01

admin

Details Diff
0004466: Permission test during installation fails on MySQL Clusters
0004466
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2020-07-06 06:35 matej.vehar@easy.bi New Issue
2020-07-06 06:35 matej.vehar@easy.bi Tag Attached: install
2020-07-23 08:57 elong Assigned To => elong
2020-07-23 08:57 elong Status new => assigned
2020-07-23 08:57 elong Status assigned => resolved
2020-07-23 08:57 elong Resolution open => fixed
2020-07-23 08:57 elong Fixed in Version => 3.12.3
2020-07-23 08:57 elong Target Version => 3.12.3
2020-07-23 09:00 admin Changeset attached => SymmetricDS 3.12 9c63642f