‹ Back to Astro Data Lab

504: Gateway Time-out on phat_v3.phot_mod query

0 votes
1 view

I have been trying to run the same query for phat_v3.phot_mod for over a day and I keep getting the error:

Error from AstroDataLab: <html> <head><title>504 Gateway Time-out</title></head> <body> <center><h1>504 Gateway Time-out</h1></center> <hr><center>nginx/1.27.3</center> </body> </html>

Error from TOPCAT: java.io.IOException: Non-VOTable service error response 504: Gateway Time-out - <html> <head><title>504 Gateway Time-out</title></head> <body> <center><h1>504 Gateway Time-out</h1></center> <hr><center>nginx/1.27.3</center> </body> </html>

However, every time I select the top 100 entries the query works great and I can download and work with the data! But, as soon as I try for the full catalog I get the 504: Gateway time out error after a few seconds of running the query.

I am trying to pull 51 columns from ~3 million sources from phat_v3.phot_mod. Am I just pulling too much data?

I also thought that this was a server issue and would be fixed in a bit, but this issue has stumped me for over 24 hours now. :( I also think its important to note that I am very new to AstroDataLab so this might be user-error.

by meredith_lefevre (120 points) | 1 view

1 Answer

0 votes
Hi Meredith,

large queries should be submitted in async mode... but the fact that you get the error in seconds and not minutes suggests that something else is afoot. Can you please post your query string and invocation call either here, or via email to datalab@noirlab.edu ? (if you prefer)
 

BTW, are you using TOPCAT and the error is from your TOPCAT maybe?

Thanks,

Robert
by robertdemo (10.3k points)
Hi Robert!

Thanks for helping me out! Heres my query I've been trying to run:

SELECT
    ra,
    dec,
    random_id,

    f275w_vega,
    f275w_crowd,
    f275w_sharp,
    f275w_round,
    f275w_snr,
    f275w_st_flag,
    f275w_err,
    f275w_gst_flag,

    f336w_vega,
    f336w_crowd,
    f336w_sharp,
    f336w_round,
    f336w_snr,
    f336w_st_flag,
    f336w_err,
    f336w_gst_flag,

    f475w_vega,
    f475w_crowd,
    f475w_sharp,
    f475w_round,
    f475w_snr,
    f475w_st_flag,
    f475w_err,
    f475w_gst_flag,

    f814w_vega,
    f814w_crowd,
    f814w_sharp,
    f814w_round,
    f814w_snr,
    f814w_st_flag,
    f814w_err,
    f814w_gst_flag,

    f110w_vega,
    f110w_crowd,
    f110w_sharp,
    f110w_round,
    f110w_snr,
    f110w_st_flag,
    f110w_err,
    f110w_gst_flag,

    f160w_vega,
    f160w_crowd,
    f160w_sharp,
    f160w_round,
    f160w_snr,
    f160w_st_flag,
    f160w_err,
    f160w_gst_flag

FROM phat_v3.phot_mod

WHERE f814w_vega < 22

(also I'm not sure what an invocation call is or where to find that sorry I'm still learning)

I was using TOPCAT to submit my queries, but when I got the error on there, I switched over here to see if it was a TOPCAT specific issue. I am using TOPCAT to look at the data, but the .csv file created on AstroDataLab was blank except for the error above, even when I loaded it onto another software. Please let me know if you need any more information from me to explain my situation! Thanks again for your help!
by meredith_lefevre (120 points)
Hi Meredith, I confirm that your query runs fine... for exactly 1 minute. It's something on our end, we are investigating. I'll ping back when we have an answer (could be tomorrow, unfortunately).
by robertdemo (10.3k points)
Glad to know it's not an issue for only me! Thank you so much for your help, and no worried on a delayed response!

- Meredith
ago by meredith_lefevre (120 points)

546 questions

559 answers

520 comments

725 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories