Bareos Bug Tracker
Bareos Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000842bareos-core[All Projects] directorpublic2017-08-08 14:232017-11-28 12:38
Reporterhostedpower 
Assigned Tojoergs 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformLinuxOSDebianOS Version8
Product Version16.2.5 
Target VersionFixed in Version 
Summary0000842: Cannot create database anymore on MySQL 5.17 and higher
DescriptionScript to create database fails on certain tables, result is non working install.

Server version: 5.7.19

Steps To Reproduce/usr/lib/bareos/scripts/make_bareos_tables
Making mysql tables
ERROR 1071 (42000) at line 388: Specified key was too long; max key length is 255 bytes
ERROR 1071 (42000) at line 396: Specified key was too long; max key length is 255 bytes
Creation of Bareos MySQL tables succeeded.
Additional Informationhttps://bugs.mysql.com/bug.php?id=86725 [^]

5.7.17 or later

- "ADD KEY" to the TEXT columns with over key length, got a warning. (key length is auto resize)
- "ADD UNIQUE KEY" to the TEXT columns with over key length, got long key error.

5.7.16 or earlier

- "ADD KEY" to the TEXT columns with over key length, is succeeded. (key length is no resize)
- "ADD UNIQUE KEY" to the TEXT columns with over key length, is succeeded. (key length is no resize)
TagsNo tags attached.
bareos-master: impact
bareos-master: action
bareos-17.2: impact
bareos-17.2: action
bareos-16.2: impact
bareos-16.2: action
bareos-15.2: impact
bareos-15.2: action
bareos-14.2: impact
bareos-14.2: action
bareos-13.2: impact
bareos-13.2: action
bareos-12.4: impact
bareos-12.4: action
Attached Files

- Relationships
duplicate of 0000705resolvedjoergs create_bareos_database fails on MySQL 5.7 

-  Notes
(0002826)
joergs (administrator)
2017-11-28 12:38

Thank you for the information. This problem will be handled by ticket 0000705, as it already contains a patch.

- Issue History
Date Modified Username Field Change
2017-08-08 14:23 hostedpower New Issue
2017-11-28 12:35 joergs Relationship added duplicate of 0000705
2017-11-28 12:38 joergs Note Added: 0002826
2017-11-28 12:38 joergs Status new => closed
2017-11-28 12:38 joergs Assigned To => joergs
2017-11-28 12:38 joergs Resolution open => duplicate


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker