icingaweb2-module-director icon indicating copy to clipboard operation
icingaweb2-module-director copied to clipboard

Kickstart Wizard Storing icinga_command_argument[] failed: SQLSTATE[23000]: Integrity constraint violation

Open mark8x57 opened this issue 5 years ago • 1 comments

Expected Behavior

see the local command definitions as external commands in the director

Current Behavior

Error message appears on run import: Storing icinga_command_argument[] failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '57--d' for key 'unique_idx', query was: INSERT INTO icinga_command_argument (command_id, argument_name, argument_value, argument_format, key_string, description, skip_key, set_if, sort_order, repeat_key, set_if_format, required) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {array ( 'id' => NULL, 'command_id' => '57', 'argument_name' => '-d', 'argument_value' => '$ftp_delay$', 'argument_format' => 'string', 'key_string' => NULL, 'description' => 'Seconds to wait between sending string and polling for response.', 'skip_key' => NULL, 'set_if' => NULL, 'sort_order' => NULL, 'repeat_key' => NULL, 'set_if_format' => NULL, 'required' => NULL, )} (DbObject.php:853)

Value "57--d" counts up on each import attempt

Possible Solution

¯\(ツ)

Steps to Reproduce (for bugs)

run the director kickstart wizard import

Your Environment

  • Director version (System - About): origin/master
  • Icinga Web 2 version and modules (System - About): 2.7.3
  • Icinga 2 version (icinga2 --version): r2.11.3-1
  • Operating System and version: Ubuntu 18.04.4 LTS
  • Webserver, PHP versions: apache 2.4.29-1ubuntu4.12 / php 7.2+60ubuntu1

mark8x57 avatar Mar 16 '20 13:03 mark8x57

I see the same issue on FreeBSD, version: r2.13.4-1. But with a slightly different error:

Storing icinga_command_argument[] failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'argument_name' cannot be null

Any progress on this or ideas?

Subito avatar Sep 15 '22 15:09 Subito