hit smallint limit on Prefix table

[andy-shady-org]

Hi,

Ive hit 'smallint' limit on ipam_prefix table when trying to import 43k+ prefixes.
Ive tried setting the _depth column to bigint, but that didnt fix it. I've also tried clearing the cache, and reimporting the dataset.
Neither fixed the issue.

The issue seems to happen when saving a prefix, not creating one.

Any help would be great.

[kkthxbye-code]

Could you provide a full stacktrace?

[andy-shady-org]

There is nothing in that output relating to this issue Im afraid.

[kkthxbye-code]

I'm not sure what the default logging config is when following the install tutorial, as I only use docker, but you can configure it by reading here: https://docs.netbox.dev/en/stable/configuration/system/#logging

Alternatively you can enable the DEBUG setting and trigger the issue again, and you should get debug output including a stacktrace.

[andy-shady-org]

Yes, I have debug turned on, Im rerunning the import on a fresh db, so Ill update this when its finished

[andy-shady-org]

I think Ive found the issue, there is a vlan id of 99999 in the dataset Im importing from Infoblox, its this insert that fails and creates the smallint issue.

Sorry for the inconvience :(

[jeremystretch]

No worries, glad you figured it out. Thanks for following up!