mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
59685cd623
Historical data from an older Icinga 2 installation contained NULL
values for the name column in some rows of the icinga_commenthistory and
icinga_downtimehistory tables.
Normally this field contains something like
${name1}!${name2}!${unique_value} where the $unique_value is based on a
timestamp for older entries and a UUID for newer ones. For a concrete
example, this could be "host.example.com!ping6!123…".
Unfortunately, using an empty string for these NULL values will cause an
error later because the new primary key will be calculated based on it.
Therefore, a new deterministic name is generated based on the primary
keys and the known name1 and name2 values.
Closes #766.
|
||
|---|---|---|
| .. | ||
| comment_query.sql | ||
| downtime_query.sql | ||
| event_time_cache_schema.sql | ||
| flapping_query.sql | ||
| ido_migration_progress_schema.sql | ||
| notification_query.sql | ||
| previous_hard_state_cache_schema.sql | ||
| state_query.sql | ||