Actions
Bug #26765
closedadjust metrics column in reports table to mediumtext
Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Description
We tried uploading a Salt Highstate Report and the corresponding Foreman task which processed the upload was actually failing with below error:
Mysql2::Error: Data too long for column 'metrics' at row 1: INSERT INTO `reports` (`host_id`, `reported_at`, `created_at`, `updated_at`, `status`, `metrics`)
We have quite a huge output and therefore it is not unrealistic to have more data in the metric column than a normal MySQL "text" field. We therefore changed the DB Schema manually to "mediumtext" and the upload of the highstate report seems to work now.
Please adjust the corresponding column to "mediumtext".
Updated by Tomer Brisker over 4 years ago
- Status changed from New to Rejected
Support for MySQL is being dropped in Foreman 2.0. Please migrate to PostgreSQL - see https://theforeman.org/2019/09/dropping-support-for-mysql.html for more details.
Actions