Skip to content

Import blocked #179

@Virsacer

Description

@Virsacer

Expected Behavior

Import everything

Current Behavior

13:24:13: Task hostSensors failed: Storing host_sensor[] failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'health_state' at row 1, query was: INSERT INTO host_sensor (name, host_uuid, health_state, current_reading, unit_modifier, base_units, rate_units, sensor_type, vcenter_uuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) {array (
  'name' => 'System Board 1 Exhaust Temp',
  'host_uuid' => 'xxxxxx',
  'health_state' => 'Green',
  'current_reading' => 2800,
  'unit_modifier' => -2,
  'base_units' => 'degrees C',
  'rate_units' => 'none',
  'sensor_type' => 'temperature',
  'vcenter_uuid' => 'xxxxxx',
)}
13:24:14: Task eventStream failed: There is already an active transaction
13:24:16: Task eventStream failed: There is already an active transaction
13:24:18: Task eventStream failed: There is already an active transaction
13:24:20: Task eventStream failed: There is already an active transaction
13:24:22: Task eventStream failed: There is already an active transaction
13:25:39: Task storagePods failed: There is already an active transaction
13:25:39: Task quickStats failed: There is already an active transaction
13:27:09: Task storagePods failed: There is already an active transaction
13:27:09: Task quickStats failed: There is already an active transaction
13:28:39: Task storagePods failed: There is already an active transaction
13:28:39: Task quickStats failed: There is already an active transaction
13:29:09: Task vmDatastoreUsage failed: There is already an active transaction
13:29:09: Task vmDiskUsage failed: There is already an active transaction
13:30:09: Task storagePods failed: There is already an active transaction
13:30:09: Task quickStats failed: There is already an active transaction
13:31:39: Task storagePods failed: There is already an active transaction
13:31:39: Task quickStats failed: There is already an active transaction

Possible Solution

Convert 'health_state' to lower case.

Steps to Reproduce (for bugs)

New Database
Add vCenter

Your Environment

  • VMware vCenter®/ESXi™-Version: 7.0.0
  • Version/GIT-Hash of this module: 917b4cd
  • Icinga Web 2 version: 2.8.1
  • Operating System and version: Oracle Linux 7
  • Webserver, PHP versions: Apache, PHP 7.3.11

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions