Bigquery wrapper fails and hangs every query

[pasviegas]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Bigquery wrapper fails when trying to query a foreign table inside a view and blocks every single operation after that.

[2024-11-25 20:02:17] [57014] ERROR: canceling statement due to statement timeout
[2024-11-25 20:02:17] Where: while inserting index tuple (0,54) in relation "wrappers_fdw_stats"
[2024-11-25 20:02:17] SQL statement "insert into extensions.wrappers_fdw_stats as s (fdw_name, create_times) values($1, $2)
[2024-11-25 20:02:17] on conflict(fdw_name)
[2024-11-25 20:02:17] do update set
[2024-11-25 20:02:17] create_times = coalesce(s.create_times, 0) + excluded.create_times,
[2024-11-25 20:02:17] updated_at = timezone('utc'::text, now())"

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Create a foreign table
2. Create a view with a WITH query that references the foreign table
3. Execute a simple select on the view

Expected behavior

Select returns

System information

• OS: macOS
• Browser (if applies) chrome

[burmecia]

Thanks for reporting this issue. Can you provide more details about this issue, such like Wrappers version, Postgres version, SQL used and etc.? I've tried to reproduce it but cannot see the error.

[bnjmnt4n]

I've seen the same error as well. What I'm doing is multiple cronjobs via pg_cron which read from (different) BigQuery FDWs, but write to the same table. Although I've tried to space these cronjobs apart, there might be some overlap of execution timing. I suspect this is where the error occurs, due to locking or some other behavior? Note that there isn't always a timeout, but the above query could take some time to run (it has shot up to the top of our slowest executed queries via the Supabase dashboard).

For the time being, I'm going to try to add even more time between these cronjobs to avoid this issue.

Supabase Postgres version: 15.8.1.079

[burmecia]

Thanks @bnjmnt4n, the Wrappers version is 0.4.6 in Supabase Postgres v15.8.1.079, can you try it with a newer version Supabase Postgres such like 15.8.1.116?