Kickstart Wizard Storing icinga_command_argument[] failed: SQLSTATE[23000]: Integrity constraint violation
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
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?