Auto sequence issues

[guenhter]

Hi,

first thanks for this awesome migration. The user experience is great. I love it and used it already for many migrations.

One issue we experienced is, e.g. with prompts: when prompts are migrated, adding a new prompt seems not to be possible because the auto-generated id counter is still sitting at 0, while the IDs are already taken. So when a new prompt should be inserted, it increased the ID from 0 to 1 as ID (primary key) but 1 is already taken -> error.

We are fixing this by just setting the sequence it to the max_id + 1, but that should be available in the migration, shouldn't it?

regards

[asbevz]

Hello, guys! It's issue too important for me. @taylorwilsdon can you give answer?

[taylorwilsdon]

This tool moves records, but open webui is what bootstraps the DB and sets things like key increments. I personally have not been able to reproduce. Are you also having the same issue with migrated prompts @alexbevz? Can you confirm that you followed the steps in the readme exactly in order and started open webui with the Postgres database attached before you attempted to use this tool?

[asbevz]

This tool moves records, but open webui is what bootstraps the DB and sets things like key increments. I personally have not been able to reproduce. Are you also having the same issue with migrated prompts @alexbevz? Can you confirm that you followed the steps in the readme exactly in order and started open webui with the Postgres database attached before you attempted to use this tool?

@taylorwilsdon I have successfully migrated the data using your utility, but unfortunately I have not had time to test the migration yet. When I've tested it, I'll let you know the results right away. Thanks for your deal))

[guenhter]

A little prototype:

1. create two tables foo and bar with two column
2. each table has its own sequence on the id colunn
3. insert 3 records to foo (only with name provided)
4. insert 3 records to bar (provide id and name)

CREATE SEQUENCE foo_id_seq;
CREATE TABLE foo (id INTEGER PRIMARY KEY DEFAULT nextval('foo_id_seq'), name TEXT); 

CREATE SEQUENCE bar_id_seq; 
CREATE TABLE bar (id INTEGER PRIMARY KEY DEFAULT nextval('bar_id_seq'), name TEXT);

INSERT INTO foo (name) VALUES ('Alice'), ('Bob'), ('Charlie');
INSERT INTO bar (id, name) VALUES (10, 'David'), (20, 'Eve'), (30, 'Frank');

SELECT 'foo_id_seq' as sequence, last_value FROM foo_id_seq UNION ALL SELECT 'bar_id_seq' as sequence, last_value FROM bar_id_seq;

result

  sequence  | last_value 
------------+------------
 foo_id_seq |          3
 bar_id_seq |          1

that means that the sequence is not increased if the ID is provided for inserting.

I guess this also happens here.