Project

General

Profile

Bug #18004

Fact data length might exceed database column limit

Added by Timo Goebel over 3 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Facts
Target version:
Difficulty:
Triaged:
Bugzilla link:
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.

Associated revisions

Revision c22f5db1 (diff)
Added by Timo Goebel over 2 years ago

fixes #18004 - increase fact value size

History

#1 Updated by The Foreman Bot over 2 years ago

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

#2 Updated by Tomer Brisker over 2 years ago

  • Legacy Backlogs Release (now unused) set to 296

#3 Updated by Timo Goebel over 2 years ago

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

Also available in: Atom PDF