Project

General

Profile

Actions

Bug #26765

closed

adjust metrics column in reports table to mediumtext

Added by Dominic Schlegel almost 5 years ago. Updated over 4 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

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".

Actions #1

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

Also available in: Atom PDF