search

Icinga / icingaweb2-module-director

The Director aims to be your new favourite Icinga config deployment tool. Director is designed for those who want to automate their configuration deployment and those who want to grant their “point & click” users easy access to the configuration.
https://icinga.com/docs/director/latest
GNU General Public License v2.0
413 stars 203 forks source link

Error 187 when apply a pending schema migration #2765

Open bisontim opened 1 year ago

bisontim commented 1 year ago

Hi, I am trying to apply a pending schema migration, after my upgrade of icnga, icingaweb2, director (master), incubator.

I obtain: Migration 187 failed (SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "INSERT" LINE 3: INSERT INTO director_schema_migration ^) while running ALTER TABLE import_row_modifier ADD COLUMN filter_expression text DEFAULT NULL, INSERT INTO director_schema_migration (schema_version, migration_time) VALUES (187, NOW())

Could you suggest me how to solve it? Thanks a lot Mario

Icinga Web 2 Version 2.11.4 Git commit 11453bfa92a70a44efbf7f966f5e7f27e9300a28 PHP Version 7.4.3-4ubuntu2.18 Git commit date 2023-01-26

icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.7-1)

Loaded Libraries icinga/icinga-php-thirdparty 0.11.0 icinga/icinga-php-library 0.12.0 Loaded Modules businessprocess 2.4.0 director master fileshipper 1.2.0 graphite 1.1.0 incubator 0.20.0 monitoring 2.11.4

OS="Ubuntu" VERSION="20.04.6 LTS (Focal Fossa)"

Server version: Apache/2.4.41 (Ubuntu) Server built: 2023-03-08T17:32:54

PHP 7.4.3-4ubuntu2.18 (cli) (built: Feb 23 2023 12:43:23) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.3-4ubuntu2.18, Copyright (c), by Zend Technologies

bisontim commented 1 year ago

If I used last stable director 1.10.2 I have not the issue.