Error: [op-sqlite] SQL execution error: powersync_replace_schema table "ps_data__" already exists

[andrewhertog]

I'm getting the following error from powersync whenever I try to read or write from a local SQLite database

Error: [op-sqlite] SQL execution error: powersync_replace_schema table "ps_data__" already exists

I'm using React-Native with op-sqlite and drizzle orm and trying to sync with a Supabase database. I haven't been able to get a session to connect with powersync yet, as I keep getting the above message.

I've tested with some of your example code which seemed to work, but when I try to integrate it into the project I'm working on I'm getting the above, and I don't see any documentation on the error.

[rkistner]

Could you post your client-side schema definition please? There is likely an issue somewhere in the schema definition.

[andrewhertog]

Here is our powersync Schema and here is our client sqlite schema

[rkistner]

You need to pass an object to new Schema({}), not an array. I'm not sure why this is not picked up by validations though - that could be a bug

[andrewhertog]

Thanks. This worked