Error: FOREIGN KEY constraint failed

[dreamid27]

Hi Electric Developer, I encountered an error when the product table and the product_images table have a relationship.

OS : Mac
Browser: Chrome
Electric Version: 0.10.0

Error: FOREIGN KEY constraint failed

the table structure

I'm trying to query in my localhost, it's not problem and fetch as expected. and also the data is not filled on supabase.

SELECT p.id,
        p.name,
        p.price,
        pi.id as product_image_id,
        pi.product_image as product_image
    FROM 
        product p
    LEFT JOIN 
        product_images pi ON p.id = pi.product_id;

if you need the migration syntax

CREATE TABLE IF NOT EXISTS product_images (
    id UUID PRIMARY KEY,
    product_id UUID NOT NULL,
    product_image TEXT,
    FOREIGN KEY (product_id) REFERENCES product(id)
);

ALTER TABLE product_images ENABLE ELECTRIC;

[linear]

VAX-1877 Error: FOREIGN KEY constraint failed

[alco]

Hey @dreamid27. Could you share your sync code where you define the shape to be synced from the Electric server?

[dreamid27]

also the data is not filled

sure, this

[msfstef]

@dreamid27 from your sync code it seems like you are only syncing the product table and not the product_image table, and are executing a join on a table that's not been synced.

Try to change the sync line to:

const shape = await db.product.sync({
  include: {
    product_image: true
  }
})

this will sync the product table as well as any entries in the product_image table that have an FK relationship to any of the synced rows in the product table. Now your query should be able to execute since all the relevant data is present on the device.

Let us know if this resolves the issue!