Announcement

Collapse
No announcement yet.

SQL Error Log after migration

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Error Log after migration

    Hi All,

    I've a problem with my centreon central after migrate my sql form Centos 6 to Centos 7.
    I've do a mysqldump and all is ok, but if I create a new host in web dashboard I see there is a LOG file about sql-error.log

    2018-10-23 13:28|0|0|DB Error: unknown error QUERY : INSERT INTO host_service_relation VALUES ('', NULL, '2514', NULL, '11332')
    2018-10-23 13:29|0|0|DB Error: unknown error QUERY : INSERT INTO service (service_template_model_stm_id, command_command_id, timeperiod_tp_id, command_command_id2, timeperiod_tp_id2, service_description, service_alias, service_is_volatile, service_max_check_attempts, service_normal_check_interval, service_retry_check_interval, service_active_checks_enabled, service_passive_checks_enabled, service_obsess_over_service, service_check_freshness, service_freshness_threshold, service_event_handler_enabled, service_low_flap_threshold, service_high_flap_threshold, service_flap_detection_enabled, service_retain_status_information, service_retain_nonstatus_information, service_notification_interval, service_notification_options, service_notifications_enabled, contact_additive_inheritance, cg_additive_inheritance, service_use_only_contacts_from_host, service_stalking_options, service_first_notification_delay, service_recovery_notification_delay,service_commen t, geo_coords, command_command_id_arg, command_command_id_arg2, service_register, service_activate, service_acknowledgement_timeout) VALUES ( '3394', NULL, NULL, NULL, NULL, 'Ping', NULL, '2', NULL, NULL, NULL, '2', '2', '2', '2', NULL, '2', NULL, NULL, '2', '2', '2', NULL, NULL, '2', 0, 0, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1',NULL)

    2018-10-18 12:36:30 - MySQL error: MySQL server has gone away (caller: centreon:cript::centcore:/usr/share/perl5/vendor_perl/centreon/script/centcore.pm:796)
    Query: SELECT * FROM options WHERE `key` IN ('enable_perfdata_sync', 'enable_logs_sync', 'centcore_cmd_timeout', 'enable_broker_stats')

    2018-10-18 12:36:30 - MySQL error : cannot connect to database centreon: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (caller: centreon::common::db:/usr/share/perl5/vendor_perl/centreon/common/db.pm:266)
    2018-10-18 12:36:30 - MySQL error : cannot connect to database centreon: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (caller: centreon::common::db:/usr/share/perl5/vendor_perl/centreon/common/db.pm:266)
    2018-10-18 12:36:30 - Error when getting server properties
    2018-10-18 12:36:30 - 2470 Receiving order to stop...
    2018-10-18 12:36:30 - Centcore stop...
    2018-10-18 12:37:08 - Enable Debug in Centcore
    2018-10-18 14:11:08 - MySQL error: MySQL server has gone away (caller: centreon:cript::centcore:/usr/share/perl5/vendor_perl/centreon/script/centcore.pm:796)
    Query: SELECT * FROM options WHERE `key` IN ('enable_perfdata_sync', 'enable_logs_sync', 'centcore_cmd_timeout', 'enable_broker_stats')

    2018-10-18 14:11:08 - MySQL error : cannot connect to database centreon: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (caller: centreon::common::db:/usr/share/perl5/vendor_perl/centreon/common/db.pm:266)
    2018-10-18 14:11:08 - MySQL error : cannot connect to database centreon: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (caller: centreon::common::db:/usr/share/perl5/vendor_perl/centreon/common/db.pm:266)
    2018-10-18 14:11:08 - Error when getting server properties

    I'm on last version of centreon-web 2.8.26, and centreon-broker 1.8.1, MariaDB 10-3 (innodb_strict_mode= OFF)

    Anyone can suggest me a solution?
Working...
X