Unable to make any queries since LS10 outage

Question

Since the outage and recovery last week, I've not been able to make any queries with LS_DR_10 tractor or apflux. Each time I try to make a request, it ends up timing out after 5 minutes. I see that the systems appear to be online, so I am not sure if this issue is isolated to me?

Answer 1

Hi, are you still having this issue? We suspect your helpdesk question coincided with our switching between DB machines.

Comments

Yep, I'm stil having this issue with the query timing out.

> query= "SELECT a.rax, a.decx, a.flux, a.quality, b.ls_id, b.brick_primary, b.ra, b.dec, b.mag_r, b.mag_g, b.mag_i, b.mag_w1, b.mag_w2, b.mag_w3, b.mag_w4, b.fracflux_r\n"
query+="FROM mydb://rosobjs AS a, ls_dr10.tractor as b\n"
query+="WHERE q3c_join(a.rax, a.decx, b.ra, b.dec,"+str(search_rad/3600.0)+");"
> res = qc.query(sql=query,fmt='table')        

queryClientError: Error: QM: Query timeout at 300 sec

Using the similar queries which had previously worked do not appear to work anymore.