[dev.icinga.com #12533] ido pgsql migration from 2.4.0 to 2.5.0 : wrong size for config_hash

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/12533

Created by Ether on 2016-08-24 17:03:32 +00:00

Assignee: gbeutner
Status: Resolved (closed on 2016-08-25 05:40:03 +00:00)
Target Version: 2.5.3
Last Update: 2016-08-25 06:06:29 +00:00 (in Redmine)

Icinga Version: 2.5.0
Backport?: Not yet backported
Include in Changelog: 1

---

Hi,

I upgraded from 2.4.0 to 2.5.0 in /usr/share/icinga2-ido-pgsql/schema/upgrade, then I had this error below in logs. I created a patch fil to solve the issue (at the end) /usr/share/icinga2-ido-pgsql/schema/upgrade/2.5.0.patch.sql.

Note : I'm running a CentOS Linux release 7.2.1511 (Core) 3.10.0-327.28.2.el7.x86_64 (up to date)

**

ERROR

[2016-08-24 18:21:40 +0200] critical/IdoPgsqlConnection: Error "ERREUR: valeur trop longue pour le type character varying(64)
" when executing query "UPDATE icinga_contacts SET alias = E'Icinga 2 Admin', can_submit_commands = E'1', config_hash = E'b37a1e4ab536c4b2edd34a008de91b017de22c04f6ef181eb72fdc5e1a887f1e8b380e7fd6471a26e19e435e16b4af753a547ca9e59adc5c88f741c593fe8fbc', config_type = E'1', contact_object_id = 68, email_address = E'icinga@localhost', host_notifications_enabled = E'1', instance_id = 1, notify_host_down = E'1', notify_host_downtime = E'1', notify_host_flapping = E'1', notify_host_recovery = E'1', notify_service_critical = E'1', notify_service_downtime = E'1', notify_service_flapping = E'1', notify_service_recovery = E'1', notify_service_unknown = E'1', notify_service_warning = E'1', pager_address = E'', service_notifications_enabled = E'1' WHERE contact_object_id = 68"
Context:
(0) Reconnecting to PostgreSQL IDO database 'ido-pgsql'

PATCH FILE

ALTER TABLE icinga_commands ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_contactgroups ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_contacts ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_hostgroups ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_hosts ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_servicegroups ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_services ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_timeperiods ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_endpoints ALTER COLUMN config_hash TYPE varchar(128);
ALTER TABLE icinga_zones ALTER COLUMN config_hash TYPE varchar(128);

Changesets

2016-08-25 05:37:41 +00:00 by gbeutner 225bb80

Fix incorrect hash size for User objects

fixes #12533

2016-08-25 06:04:12 +00:00 by gbeutner 3b04e04

Fix incorrect hash size for User objects

fixes #12533

---

Relations:

• duplicates #12533

[icinga-migration]

Updated by gbeutner on 2016-08-25 05:37:21 +00:00

• Status changed from New to Assigned
• Assigned to set to gbeutner
• Target Version set to 2.6.0

[icinga-migration]

Updated by gbeutner on 2016-08-25 05:40:03 +00:00

• Status changed from Assigned to Resolved
• Done % changed from 0 to 100

Applied in changeset 225bb80.

[icinga-migration]

Updated by gbeutner on 2016-08-25 06:06:29 +00:00

• Target Version changed from 2.6.0 to 2.5.3

[icinga-migration]

Updated by gbeutner on 2016-08-25 06:47:44 +00:00

• Duplicated set to 12542