[HDDS-4443] Recon: Using Mysql database throws exception and fails startup

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Component/s: Ozone Recon
• Labels: pull-request-available
• Target Version/s: 1.1.0
• Assignee: Vivek Ratnavel Subramanian
• Reporter: Vivek Ratnavel Subramanian
• Created: 10/Nov/20 03:19
• Updated: 12/Nov/20 21:38
• Resolved: 12/Nov/20 21:38

Description

Recon uses Derby as its SQL database by default. Switching it to Mariadb/Mysql throws an exception `Specified key was too long; max key length is 767 bytes`

Fix this issue by reducing the primary key length from VARCHAR(768) to VARCHAR(766) in ReconTaskSchemaDefinition.java. Also change the autocommit config to default to true since data is not persisted in MySql tables even after insert queries are executed with autocommit flag set to false by default.

Issue Links

• is depended upon by: HDDS-4457 Recon: Add unit test to cover Mariadb/Mysql database
• links to: GitHub Pull Request #1570