Nethvoice clone fails when a module is moved two times

[Stell0]

When a nethvoice is moved two times, the second one fails

Steps to reproduce

• move a nethvoice from one node to another
• move it again

Expected behavior

module should be cloned

Actual behavior

• this step fails with the following error:

<7>podman exec mariadb mysql asterisk -u root -pvncrKp2j60ryZUuFns48XUI4YN8POzKq -e '
UPDATE `kvstore_Sipsettings`
SET `val` = CASE
    WHEN `key` = '"'"'bindport'"'"' THEN '"'"'20468'"'"'
    WHEN `key` = '"'"'tlsbindport'"'"' THEN '"'"'20469'"'"'
END
WHERE `key` IN ('"'"'bindport'"'"', '"'"'tlsbindport'"'"');
'
<7>podman exec mariadb mysql asterisk -u root -pvncrKp2j60ryZUuFns48XUI4YN8POzKq -e '
UPDATE `iaxsettings`
SET `data` = '"'"'20470'"'"',
    `seq` = 1,
    `type` = 0
WHERE `keyword` = '"'"'bindport'"'"';
'
ERROR 1062 (23000) at line 2: Duplicate entry 'bindport-1-0' for key 'PRIMARY'
Traceback (most recent call last):
  File "/home/nethvoice18/.config/actions/clone-module/22set_db_services_ports", line 66, in <module>

See also

https://mattermost.nethesis.it/nethesis/pl/irhfqrfa1pdy7n6t8ge5upn8yh
https://helpdesk.nethesis.it/a/tickets/191647

[Stell0]

This is caused because the first clone create an entry in iaxsettings with seq=1, but the default has seq=0. Everithing works because freepbx container init also set it at first launch, but the second time nethvoice is cloned, the query try to update the entry giving it a seq=1 and a key with seq=1 already exists.

[Stell0]

Test case:

• move nethvoice two time and check if event the second is succesful

[Amygos]

Testing release nethesis/ns8-nethvoice 1.4.5-testing.5