Facing issue related to database migration

[spidy2356]

I use supabase postgresql db string url, and it gives me this error
22/05/2025 10:33 PM FATAL failed to migrate database {"err": "ERROR: relation "goose_db_version" does not exist (SQLSTATE 42P01); ERROR: prepared statement "stmtcache_e5a75f08040fc616676da422178c6282978cd815e2cccfc2" already exists (SQLSTATE 42P05)", "errCauses": [{"error": "ERROR: relation "goose_db_version" does not exist (SQLSTATE 42P01)"}, {"error": "ERROR: prepared statement "stmtcache_e5a75f08040fc616676da422178c6282978cd815e2cccfc2" already exists (SQLSTATE 42P05)"}]}

At first everything works smoothly, but then it start me error, I delete other projects and clear database still this error comes

Plz help me if possible. Thank u

[iwconfig]

I delete other projects

Other Supabase projects has no effect on this project unless you're out of free tier stuff or something, but that would still be an unrelated issue.

and clear database

Did you perhaps delete the goose_db_version table? What steps did you take to migrate your db?

[spidy2356]

Yes, I deleted goose_db_version table, otherwise it also give me some other error... 1st everything works smoothly then suddenly it gives me error and I didn't migrate but chat gpt says database migration isn't complete that's why this error comes

1st this error shows
22/05/2025 10:21 PM FATAL failed to migrate database {"err": "ERROR: prepared statement "stmtcache_5c4655db4e0e87baba5b09e8e124f5a20a3f2d39bfce2543" already exists (SQLSTATE 42P05); ERROR: relation "goose_db_version" already exists (SQLSTATE 42P07)", "errCauses": [{"error": "ERROR: prepared statement "stmtcache_5c4655db4e0e87baba5b09e8e124f5a20a3f2d39bfce2543" already exists (SQLSTATE 42P05)"}, {"error": "ERROR: relation "goose_db_version" already exists (SQLSTATE 42P07)"}]}
Then I try to clear everything and then the previously posted error comes

[iwconfig]

goose_db_version is for database migrations, i.e. for managing schema changes.

Start over and do not remove anything from the fresh db (supabase). Migrate your old db (i.e. export from old -> import to new) according to the supabase documentation.

When that is done and you encounter any other problem, you go from there. Do not remove any tables.

[spidy2356]

I just want to know how to clear everything and start fresh

At first it goes smoothly but my own private channel/group not shown in list, so I restart teldrive and refresh web page and error started

[spidy2356]

ok, now I make a new project and use new db string, now this error comes, can u explain me why and what is it for and how to solve it

[47.103ms] [rows:0] call teldrive.update_size();
23/05/2025 07:11 PM     ERROR   [DB] github.com/tgdrive/teldrive/pkg/cron/cron.go:80 ERROR: prepared statement "stmtcache_56b279c4355f19704724de9249d7aacef5b2b64ce389c184" does not exist (SQLSTATE 26000)
[385.375ms] [rows:-] SELECT JSONB_AGG(jsonb_build_object('id', f.id, 'parts', f.parts)) as files,f.channel_id,f.user_id,s.session FROM teldrive.files as f LEFT JOIN teldrive.users as u ON u.user_id = f.user_id LEFT JOIN (
        SELECT user_id, session
        FROM teldrive.sessions
        WHERE created_at = (
            SELECT MAX(created_at)
            FROM teldrive.sessions s2
            WHERE s2.user_id = sessions.user_id
        )
    ) as s ON u.user_id = s.user_id WHERE f.type = 'file' AND f.status = 'pending_deletion' GROUP BY "f"."channel_id","f"."user_id","s"."session"
23/05/2025 07:11 PM     ERROR   [DB] github.com/tgdrive/teldrive/pkg/cron/cron.go:141 ERROR: prepared statement "stmtcache_fb01ad66db9b4e9ca45fbb14aff76479fe2c6fe56dd50d7f" does not exist (SQLSTATE 26000)
[432.714ms] [rows:-] SELECT JSONB_AGG(up.part_id) as parts,up.channel_id,up.user_id,s.session FROM teldrive.uploads as up LEFT JOIN teldrive.users as u ON u.user_id = up.user_id LEFT JOIN (
        SELECT user_id, session
        FROM teldrive.sessions
        WHERE created_at = (
            SELECT MAX(created_at)
            FROM teldrive.sessions s2
            WHERE s2.user_id = sessions.user_id
        )
    ) as s ON u.user_id = s.user_id WHERE up.created_at < '2025-05-16 13:41:06.525' GROUP BY "up"."channel_id","up"."user_id","s"."session"

[iwconfig]

It's in the documentation. prepare-stmt need to be set to false.

https://teldrive-docs.pages.dev/docs/getting-started/usage#configuration-for-supabase-database

[spidy2356]

oh thanks, it helps. due to this after few times I got the error (the 1st one..now fixed)

btw by mistake during login, I tap on "it wasn't me" on telegram and now even after login on teldrive web UI, I return bach to login page again. can I fix it?

and can I use multiple allowed-user under "JWT"???

[iwconfig]

i don't know sorry. it's possible your ip is banned temporarily, or maybe permanent (unlikely), so either wait a while, use another ip or create a new client application (app-id, app-hash).

can I use multiple allowed-user under "JWT"???

https://teldrive-docs.pages.dev/docs/cli/run#jwt-authentication