[stork-users] Assigned addresses query puts incorrect value into a smallint

[Darren Ankney]

Hi Frederick,

This may be a known issue:
https://gitlab.isc.org/isc-projects/stork/-/issues/2425 though the
error message doesn't match exactly.

Looks like the team intends to work on that one in the upcoming 2.5.0
development branch.  Reading the comments there, there seem to be
several issues.  Perhaps you might like to add your own experience.

There was also another issue that was closed after replication became
impossible: https://gitlab.isc.org/isc-projects/stork/-/issues/2014

Thank you,
Darren Ankney

On Thu, Apr 23, 2026 at 3:56 AM Frederick Bloggingtons
<frederickbloggingtons at gmail.com> wrote:
>
> Hello,
>
> Stork 2.4.0
> Kea 3.1.7
>
> Getting the following issue in the database logs, every 1 minute.
>
> 2026-04-23 07:46:21 UTC:10.254.1.203(30515):stork_prod_app at db_stork_prod:[31520]:STATEMENT: UPDATE "address_pool" SET "stats" = '{"assigned-addresses":"18446744073709551608","cumulative-assigned-addresses":"0","declined-addresses":"0","reclaimed-declined-addresses":"0","reclaimed-leases":"8","total-addresses":"16"}', "stats_collected_at" = '2026-04-23 07:46:21.595787488+00:00:00', "utilization" = '1152921504606846976000' WHERE "address_pool"."id" = 613
> 2026-04-23 07:46:21 UTC:10.254.1.203(30515):stork_prod_app at db_stork_prod:[31520]:ERROR: value "1152921504606846976000" is out of range for type smallint at character 309
>
> I had thought this problem was resolved in a previous build - is there a fix?
>
> Regards
> --
> Stork-users mailing list
> Stork-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/stork-users