Bug #18004
Fact data length might exceed database column limit
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
History
#1
Updated by The Foreman Bot about 3 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 about 3 years ago
- Legacy Backlogs Release (now unused) set to 296
#3
Updated by Timo Goebel about 3 years ago
- % Done changed from 0 to 100
- Status changed from Ready For Testing to Closed
Applied in changeset c22f5db1c3d37130a2e7dad8a746779a62b8e3df.
fixes #18004 - increase fact value size