Autoincrementing primary Key

Hi, i am using the newest portable version of HeidiSQL (11.3) with a mariaDB, also relatively new (10.6). When a table holds no rows, i cannot set an Auto increment value. Everytime i save it it reverts to an empty field. Furthermore if i create rows, it lets me set and autoincrementing value, but always changes it by itself. creating a new row causes the primary key to be auto incremented by 3. Viewing the auto increment option also show the nex value instead of the amount the value should be incremented by.

Viewing the auto increment option also show the nex value instead of the amount the value should be incremented by.

That's always the case, so very normal.

Can you post your CREATE TABLE code here?

yes i can, when i click the little green plus this code gets executed: INSERT INTO DBNAME.ProdukteG; the table ProdukteG has default values for all fields besides the primary key which is set to auto_increment. All defalut values are working as expected.

If it helps i can create an example table with just 2 coloums

I meant the code from the CREATE code tab:

ok sure.

i attach 3 images, the create code for an empty table, the data i then put in with the primary key automatically generated and the create code after inserting data.

I was just trying to reproduce that, but on MariaDB 10.3 and 10.5 I had no problems with setting a primary key/auto-increment value in an empty table.

Please update to the latest build and try again. (Help > Check for updates)

newest "official" release seems to be 11.3, which is my version. The updater offers me a nightly version as an update. Should i try that one?

i will also test if it makes a difference that the mariadb i connect to is inside a galera cluster. (3 node cluster)

WOW i connected to my 2 node cluster and now autoincrement always increments by 2! So somehow the cluster size affects the autoincrementing value. Is that expected/by-design or unwanted? BTW if you want to reproduce that i can make you a user account on my clusters, the are globally reachable.

The updater offers me a nightly version as an update. Should i try that one?

Yes.

I did install the nightly version. The behaviour didnt change. The autoincrement is still beeing incremented by the number of nodes in the cluster.

I suspect your cluster nodes have a non-1 setting for auto_increment_increment variable?

Here's an explanation why that's a good idea.

I will ask the DBA about that, but it looks really promising

i queried for the auto increment settings and that seems to be the case. Awesome, thanks for your help.