Hi Daniel,

thank you for your response. Unfortunately, resetting the auto increment value is not an option for us since other backend systems are using and referencing that data. 
We try to avoid maintaining our own fork of kamailio and therefore I have opened a pull request here https://github.com/kamailio/kamailio/pull/3407

cheers

Julius



On 27 Mar 2023, at 14:37, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

kamailio is not using the id column internally, you can changed as you
wish if no external/custom tools you have depend on its type.

I think only a few modules use the id columns from their related table
(iirc, msilo and lcr), for the rest the id column is purely for
facilitating external management of those records.

Then, I guess, another option would be to reset the auto increment value.

Cheers,
Daniel

On 27.03.23 13:52, Julius Flohr wrote:
Hi,

we've been using kamailio successfully for many years now and we've noticed that the id field in the location database of our installation (userloc module) will overflow in the foreseeable future. Currently it is setup as a INT(10).
Are there any reasons not to change it to BIGINT and upstream that change?

Cheers

Julius
_______________________________________________
Kamailio (SER) - Development Mailing List
To unsubscribe send an email to sr-dev-leave@lists.kamailio.org

--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - June 5-7, 2023 - www.kamailioworld.com
Kamailio Advanced Training - Online - March 27-30, 2023 - www.asipto.com