Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
icinga-migration opened this issue Aug 24, 2016 · 4 comments

Comments

Projects
None yet
1 participant
@icinga-migration
Copy link
Member

commented Aug 24, 2016

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:

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Aug 25, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Aug 25, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Aug 25, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Aug 25, 2016

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

  • Duplicated set to 12542
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.