Skip to content
This repository has been archived by the owner on Dec 13, 2022. It is now read-only.

UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new values #10727

Open
2 of 5 tasks
legolass73 opened this issue Feb 15, 2022 · 1 comment
Open
2 of 5 tasks

UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new values #10727

legolass73 opened this issue Feb 15, 2022 · 1 comment
Labels
status/new New tickets

Comments

@legolass73
Copy link

legolass73 commented Feb 15, 2022 •
edited
Loading

BUG REPORT INFORMATION

Prerequisites

The opened issue, must be code related. GitHub is not meant for support. Feel free to check the CONTRIBUTING section for more details.

Versions

For the RPM based systems

[root@SJM-CENTREON installs]# rpm -qa | grep centreon | egrep -v "(plugin|pack)" | sort
centreon-21.10.3-5.el8.noarch
centreon-auto-discovery-server-21.10.1-1.el8.noarch
centreon-base-config-centreon-engine-21.10.3-5.el8.noarch
centreon-broker-21.10.0-6.el8.x86_64
centreon-broker-cbd-21.10.0-6.el8.x86_64
centreon-broker-cbmod-21.10.0-6.el8.x86_64
centreon-broker-core-21.10.0-6.el8.x86_64
centreon-broker-storage-21.10.0-6.el8.x86_64
centreon-clib-21.10.0-6.el8.x86_64
centreon-common-21.10.3-5.el8.noarch
centreon-connector-21.10.0-6.el8.x86_64
centreon-connector-perl-21.10.0-6.el8.x86_64
centreon-connector-ssh-21.10.0-6.el8.x86_64
centreon-database-21.10.3-5.el8.noarch
centreon-engine-21.10.0-6.el8.x86_64
centreon-engine-daemon-21.10.0-6.el8.x86_64
centreon-engine-extcommands-21.10.0-6.el8.x86_64
centreon-gorgone-21.10.1-1.el8.noarch
centreon-gorgone-centreon-config-21.10.1-1.el8.noarch
centreon-license-manager-21.10.0-1.el8.noarch
centreon-license-manager-common-21.10.0-1.el8.noarch
centreon-nrpe3-daemon-4.0.2-1.el8.x86_64
centreon-perl-libs-21.10.3-5.el8.noarch
centreon-poller-centreon-engine-21.10.3-5.el8.noarch
centreon-pp-manager-21.10.0-2.el8.noarch
centreon-release-21.10-5.el8.noarch
centreon-trap-21.10.3-5.el8.noarch
centreon-web-21.10.3-5.el8.noarch
centreon-widget-engine-status-21.10.0-2.el8.noarch
centreon-widget-global-health-21.10.1-1.el8.noarch
centreon-widget-graph-monitoring-21.10.0-2.el8.noarch
centreon-widget-grid-map-21.10.0-2.el8.noarch
centreon-widget-hostgroup-monitoring-21.10.0-2.el8.noarch
centreon-widget-host-monitoring-21.10.0-2.el8.noarch
centreon-widget-httploader-21.10.0-2.el8.noarch
centreon-widget-live-top10-cpu-usage-21.10.0-2.el8.noarch
centreon-widget-live-top10-memory-usage-21.10.0-2.el8.noarch
centreon-widget-servicegroup-monitoring-21.10.0-2.el8.noarch
centreon-widget-service-monitoring-21.10.1-1.el8.noarch
centreon-widget-tactical-overview-21.10.0-2.el8.noarch


[root@SJM-CENTREON installs]# systemctl status mariadb            
● mariadb.service - MariaDB 10.6.7 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─centreon.conf, migrated-from-my.cnf-settings.conf
   Active: active (running) since Tue 2022-02-15 18:50:32 CET; 40min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 63723 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 18 (limit: 102192)
   Memory: 345.5M
   CGroup: /system.slice/mariadb.service
           └─63723 /usr/sbin/mariadbd

Operating System

OracleLinux 8

Browser used

  • Google Chrome
  • Vivaldi (ChrimiumBase)
  • Firefox
  • Internet Explorer IE11
  • Safari

Version: 5.1.2567.4

***Additional environment details (AWS, VirtualBox, physical, etc.): ****

  • VmWare Virtual Machine*

Description

<html>
<body>
<!--StartFragment-->

4 Installation
--
Currently upgrading... please do not interrupt this process.StepStatus19.10.19 to 20.04.0-beta.1UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new valuesYou seem to be having trouble with your upgrade.Please check the "upgrade.log" and the "sql-error.log" located in "/var/log/centreon" for more detailsYou may refer to the line in the specified file in order to correct the issue.The SQL files are located in "/usr/share/centreon/www/install/sql/"But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed. | Currently upgrading... please do not interrupt this process.StepStatus19.10.19 to 20.04.0-beta.1UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new valuesYou seem to be having trouble with your upgrade.Please check the "upgrade.log" and the "sql-error.log" located in "/var/log/centreon" for more detailsYou may refer to the line in the specified file in order to correct the issue.The SQL files are located in "/usr/share/centreon/www/install/sql/"But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed. | 19.10.19 to 20.04.0-beta.1 | UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new values
Currently upgrading... please do not interrupt this process.StepStatus19.10.19 to 20.04.0-beta.1UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new valuesYou seem to be having trouble with your upgrade.Please check the "upgrade.log" and the "sql-error.log" located in "/var/log/centreon" for more detailsYou may refer to the line in the specified file in order to correct the issue.The SQL files are located in "/usr/share/centreon/www/install/sql/"But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed. | 19.10.19 to 20.04.0-beta.1 | UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new values


19.10.19 to 20.04.0-beta.1 | UPGRADE - 20.04.0-beta.1 : Unable to replace engine's broker modules configuration from xml to json format - While trying to insert in 'cb_type_field_relation' table new values

<!--EndFragment-->
</body>
</html>

Steps to Reproduce

Migrate Step from centreon 2.8

  1. I logged in Centreon
  2. I reached the Custom View
  3. And so on...

Describe the received result

Describe the expected result

Logs

PHP error logs

For version using PHP 7.2 or 7.3 on centOs 8 or PHP 8

[root@SJM-CENTREON installs]# tail -f /var/log/php-fpm/centreon-error.log
[15-Feb-2022 19:19:43 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[15-Feb-2022 19:19:43 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[15-Feb-2022 19:19:44 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[15-Feb-2022 19:19:44 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[15-Feb-2022 19:19:44 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[15-Feb-2022 19:19:44 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[15-Feb-2022 19:21:53 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[15-Feb-2022 19:21:53 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 49
[15-Feb-2022 19:21:53 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
[15-Feb-2022 19:21:53 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68

centreon-engine logs (if needed)

[root@SJM-CENTREON installs]# tail -f /var/log/centreon-engine/centengine.log
[1644949471] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_load': No such file or directory
[1644949508] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_procs': No such file or directory
[1644949546] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_users': No such file or directory
[1644949583] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_disk': No such file or directory
[1644949621] [1273] Error: Host check command execution failed: could not create process '/usr/sbin/check_ping': No such file or directory
[1644949621] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_ping': No such file or directory
[1644949658] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_http': No such file or directory
[1644949696] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_ssh': No such file or directory
[1644949733] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_swap': No such file or directory
[1644949771] [1273] Error: Service check command execution failed: could not create process '/usr/sbin/check_load': No such file or directory

centreon-broker logs (if needed)

[root@SJM-CENTREON installs]# tail -f /var/log/centreon-broker/central-broker-master.log
tail: cannot open '/var/log/centreon-broker/central-broker-master.log' for reading: No such file or directory
tail: no files remaining

centreon gorgone logs for Centreon >= 20.4 (if needed)

[root@SJM-CENTREON installs]# tail -f /var/log/centreon-gorgone/gorgoned.log
2022-02-10 08:38:24 - INFO - [core] Public key file '/var/lib/centreon-gorgone/.keys/rsakey.pub.pem' loaded
2022-02-10 08:38:24 - INFO - [core] Gorgoned started
2022-02-10 08:38:24 - INFO - [core] PID 57538
2022-02-10 08:38:24 - INFO - [core] Server accepting clients
2022-02-14 20:12:01 - INFO - [core] Initialize server keys
2022-02-14 20:12:01 - INFO - [core] Private key file '/var/lib/centreon-gorgone/.keys/rsakey.priv.pem' loaded
2022-02-14 20:12:01 - INFO - [core] Public key file '/var/lib/centreon-gorgone/.keys/rsakey.pub.pem' loaded
2022-02-14 20:12:01 - INFO - [core] Gorgoned started
2022-02-14 20:12:01 - INFO - [core] PID 903
2022-02-14 20:12:01 - INFO - [core] Server accepting clients

Additional relevant information (e.g. frequency, ...)
@legolass73 legolass73 added the status/new New tickets label Feb 15, 2022
@TelehouseVN
Copy link

Did you fix it?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
status/new New tickets
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@legolass73 @TelehouseVN