Announcement

Collapse

New forum rules

The forum get new posts rules.

A new user will be moderate for new post. After five valid posts, the user will be to have right to post without moderation.

If you have some issue to post or to connect, contact us.
See more
See less

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