Project

General

Profile

Actions

Bug #18004

closed

Fact data length might exceed database column limit

Added by Timo Goebel over 7 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Facts
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Fact importing fails when trying to import facts with large data:

Fact etc_services_fact could not be imported because of Mysql2::Error: Data too long for column 'value' at row 1: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('LONG-DATA', 789, 11085, '2017-01-10 02:39:07', '2017-01-10 02:39:07')

The column 'value' is of type TEXT, to fix this it could be increased to MEDIUMTEXT or even LONGTEXT.

Actions #1

Updated by The Foreman Bot over 6 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Timo Goebel
  • Pull request https://github.com/theforeman/foreman/pull/4923 added
Actions #2

Updated by Tomer Brisker over 6 years ago

  • translation missing: en.field_release set to 296
Actions #3

Updated by Timo Goebel over 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF