Redash Digital Ocean : Error running query: failed communicating with server

Hi guys,
I’m new to redash
I’ve been setting up redash on my digital ocean from its marketplace. I’m using postgresql as the database on another server (droplets). The database right now got millions of row data.

It’s up and running now. however, my query keep getting Error like below,

" Error running query: **failed communicating with server. Please check your Internet connection and try again.**"

First, I checked my network tabs, the result shows up there but it did not show in the redash and just showed the error message. I tried a simple count query and it runs well. The query that keeps showing me this error is something like this

SELECT s.name,
       EXTRACT(MONTH
               FROM t.transaction_at) AS month,
       EXTRACT(DAY
               FROM t.transaction_at) AS day,
       SUM(t.total_sell_price),
       SUM(t.total_buy_price)
FROM transactions_2 t
INNER JOIN stores s ON s.id = t.store_id
WHERE t.transaction_at >= '2021-09-01'
  AND t.transaction_at < '2021-10-01'
GROUP BY s.id,
         EXTRACT(MONTH
                 FROM t.transaction_at),
         EXTRACT(DAY
                 FROM t.transaction_at)
ORDER BY s.id,
         month,
         day

The result of these query maybe around 1000ish rows, i tried to minimize the rows with more where with result only 30 rows still didn’t work. The only approach that can work is when i limit the query to 10. but i don’t think that solve the core problem of my issue.

I already docker logs the redash server but there are no error occured that can be found. I searched around i couldn’t found the correct terms to fix this error. I hope anybody can help me with this at least where to start or where to look at.

Thank you

Thanks for your detailed request for help. We’ll get to the bottom of this. What size is your droplet? How much RAM does it use? Did you upgrade to Redash V10?

If you want to get more detailed logs you can set:

REDASH_LOG_LEVEL: "DEBUG"

in your environment.

Thanks for the reply, jesse

My size of droplets is 2 CPU, 4 GB RAM, 80GB Disk Storage

I’ll try to upgrade to redash v10 first and check the log then
i’ll update my found again here after

Thanks again

1 Like

i just upgraded to redash v10
and my query totally works fine

thanks a bunch man

1 Like