Deletion of v6 reservation over API by address causes all v6 reservations to disappear

name: Deletion of v6 reservation over API by address causes all v6 reservations to disappear
about: Kea 2.4.1

Describe the bug I am using the API to add and remove reservations for v4 and v6.
I find that removing a v4 reservation by IP address works as expected, but removing a v6 reservation results in all reservations being deleted.

To Reproduce Steps to reproduce the behavior:

1. Create two v6 reservations in the database
2. send a 'reservation-del' to the dhcp6 process via the API to remove one address
3. run a 'reservation-get-all' and receive the message "text": "0 IPv6 host(s) found."
4. Perform the same sequence with v4 and it succeeds
5. Check the postgres database contents and see that the v6 reservations table is empty

Note that if I do a deletion specifying the flex-id or DUID of a reservation, only that single reservation is removed.

Expected behavior I am expecting that a single IPv6 reservation is deleted.

Environment:

• Kea version: 2.4.1
• OS: Ubuntu 22.04.4 LTS
• Installed from kea packages on cloudsmith
• Flex-id, HA, host commands and lease commands are in use.

Additional Information

reservation-get-all result over api:

[
    {
        "arguments": {
            "hosts": [
                {
                    "client-classes": [],
                    "flex-id": "67622D6C6F6E39382D7273773030313A78652D302F302F33",
                    "hostname": "123123.vorboss.lab",
                    "ip-addresses": [
                        "2a00:e340:1102::3"
                    ],
                    "option-data": [],
                    "prefixes": [
                        "2a00:e340:1103:300::/56"
                    ],
                    "subnet-id": 1
                },
                {
                    "client-classes": [],
                    "flex-id": "67622D6C6F6E39382D7273773030313A78652D302F302F34",
                    "hostname": "123124.vorboss.lab",
                    "ip-addresses": [
                        "2a00:e340:1102::4"
                    ],
                    "option-data": [],
                    "prefixes": [
                        "2a00:e340:1103:400::/56"
                    ],
                    "subnet-id": 1
                }
            ]
        },
        "result": 0,
        "text": "2 IPv6 host(s) found."
    }
]

Deletion sent:

{
    "command": "reservation-del",
    "service": ["dhcp6"],
    "arguments": {
        "subnet-id": 1,
        "ip-address": "2a00:e340:1102::4"
    }
}

Debug from kea-ctrl-agent:

INFO  COMMAND_RECEIVED Received command 'reservation-del'
DEBUG HOOKS_CALLOUTS_BEGIN begin all callouts for hook $reservation_del
INFO  HOST_CMDS_RESERV_DEL reservation-del command called (parameters: { "ip-address": "2a00:e340:1102::4", "subnet-id": 1 })
INFO  HOST_CMDS_RESERV_DEL_SUCCESS reservation-del command success (parameters: { "ip-address": "2a00:e340:1102::4", "subnet-id": 1 })
DEBUG HOOKS_CALLOUT_CALLED hooks library with index 2 has called a callout on hook $reservation_del that has address 0x7ff2f67cecb0 (callout duration: 3.743 ms)
DEBUG HOOKS_CALLOUTS_COMPLETE completed callouts for hook $reservation_del (total callouts duration: 3.743 ms)

Subsequent reservation-get-all:

[
    {
        "arguments": {
            "hosts": []
        },
        "result": 3,
        "text": "0 IPv6 host(s) found."
    }
]

Contacting you My work email is andrew.mulheirn@vorboss.com