Can't access personal tables in myDB

Question

Hello!

I've been working quite a bit with some tables previously uploaded to myDB. Historically this has been working quite well. Today, however I noticed that I can no longer run queries with QueryClient that match against tables in myDB

(e.g. I get an error that looks like this:

dl.queryClient.queryClientError: Error: relation "mydb.snr10_matched225" does not exist

LINE 2:          FROM mydb."snr10_matched225" AS d, 

)

I've also checked the Data Explorer itself to see if these tables accidentally got deleted or something; they do seem to still be there. However, I can't query them from inside the Data Explorer either; I get the message One or more tables provided in the query were not found with any query involving these tables. Interestingly, querying against these tables worked successfully as recent as Aug 5; re-running queries that worked then no longer run. I also don't seem to be able to successfully re-upload identical copies of these tables to myDB. Is there a way to fix this?

Answer 1

Thanks for reaching out! We think we found the issue and fixed it (too many stale DB connections). Could you please give it a try again?

Comments

Hi! Looks like it works now. Thanks so much!!

---

Hi!

I am seeing the exact same as described above, where even things as simple as
'''
df=convert(qc.query(sql="select * from mydb://test"))
'''
fail, which, following: https://github.com/astro-datalab/notebooks-latest/blob/master/04_HowTos/CrossmatchTables/How_to_crossmatch_tables.ipynb has worked successfully in the past.

Thanks for the help in fixing this!

---

Hi all! I'm also seeing that this issue has returned. Looks like the same problem.