Primary key value keep getting added when it is not supposed to

Version: (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Calc: threaded

I’m having this problem for a while on my DB, I dont know why this is happening and if it just happens on my DB, or if its a general problem.

When Im testing the DB, adding some records, anytime an error occurs, like, adding more text in a field than it supports, after I close the error, fix the amount of text, and then save the record, it jumps to the next primary key value, if the value was supposed to be 1, it jumps to 2, and if I continue to try to save it, the value keeps getting added.

Im using the primary key as an integer value with the automatic option of incrementation.

Has someone had this problem before? Is there a way to fix it?