Recurrent ERR 502 + value discrependy

Technical Help
, ,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

I am using Baserow and n8n together already for a while.
It was fine for long.

But recently, I start to uncounter recurrent discrepancy in data transfer, mainly with numbers (example: a stock inventory pass from 5 in data source to 0 in Baserow table) : around 20% discrepancy.
And, since yesterday, all workflows (which include Baserow node) break due to a 502 error in baserow node.
All used workflow are inside a loop with 60-400 items.
I have tried to add a wait 20seconds node before the Baserow node which breaks, but then it’s another Baserow node which breaks.

I am using :

  • web Baserow
  • self hosted n8n (version 1.111.1)

Any idea what could be the cause of the 502 ?
Could it be because I have to many columns in the tables ?

2

Hi,

Are those number fields actual number fields or calculated fields by a formula or rollup field? Can you also clarify the issue? Is the entire automation running slow or do the number fields not update correctly?

The number of columns shouldn’t be a problem, but the number of Link to table and Lookup fields might cause problems. Each time you update a record, it needs to update all fields that depend on that record which might cause a 502 error because of a timeout

3

Well.

The 502 error happen very often when I run a “get all rows” but also when I “update a row”. On table with link/relation but also on table with no link/relation.

And the discrepancy happen mainly with number but not only.

Example of what i call discrepancy:

_ I add a number value : 195

_ But it add 500 to the cell instead.

(I also have the problem with some text field on table with not much column).

And I can try as many time as I want, the discrepancy is consistent : always the same wrong value on the same rows.

I have try every N8n structure possible to see if I can avoid the break and lowdown the number discrepancy:

  • create a loop node (with max items = 1/loop) + wait node (up to 30seconds) → it breaks every time after 30-40 items.
  • create succession of loops : loop 1 (max items = 20/loop) + loop 2 (max item = 1/loop) + wait 5sec between each item, wait 1min after the 20 items are passed → it breaks too.
  • back to 1 loop node (max 10-20 items per loop) : it does not break BUT I get 20% value discrepancy again !

Then when I dig further to try to understand what is wrong I realized :

  • in n8n: between input and output there is no discrepancy,
  • in Baserow: but in the table I don’t see same values as what is displayed in the node output.

I have tried to run the same exact workflow into Google sheet : no problem.

Any idea what could make it go wrong ?

4

Can you give it a try with the HTTP nodes that make a request directly to the API instead of using the Baserow nodes?

5

Hi @frederikdc ,

I have tried to replace n8n baserow node by direct http query in most of my workflow and I confirm that it seems to work fine.

So problem seems to be the baserow node then !

Thanks for your advice.