Hi all, I seem to be getting an identical error, also when using both the notebook and portal aspects. I’ve tried some of the recommended tests, including the provided notebook (with column names changed), but still get the “table does not exist errno: 1146” message. I’ve had this problem both with my original table and one with a character datatype column removed, and the table is ~2500 entries all within 2 degrees of the DP1 field centers. Please let me know if there are other things to try, or if this should be a new topic instead. Thanks!
Hi @mnmartinez, the first thing to do is to fully log out and restart your RSP session, as your account might have been affected by the same issue as discussed and resolved in this post.
If it is still not working, please provide just the first few rows of the table and the ADQL code you are using so we can try to help.
Indeed, the problem has been found on the Qserv side. The temporary database where your tables (required by your queries) are preloaded into got into a broken state. I have fixed the issue. Please, try your query. Sorry for the troubles!
Hi @MelissaGraham and @gapon, thank you for the help! I have tried the query again and it appears to be working in both the portal and notebooks. However, the version of the table with a character column seems to still be failing. This doesn’t affect my work at all and I can reinsert that column again later, but I’ve gone ahead and attached the first 5 rows of the table with the bad column in case it’s helpful. Thanks again!
table_example.fits (78.8 KB)
Hi @mnmartinez , wonderful, glad to hear you’re unblocked. There is currently an issue with string character columns in table uploads and a fix is in progress. In the meantime just taking that column out of the table being uploaded is one workaround, like you’ve found. Assuming the character column is some kind of object name or identifier, mapping it on to an integer identifier and including that integer column in the uploaded table will work too.
I’m going to mark @gapon’s reply as the solution for this thread but as always, please don’t hesitate to open a new topic at any time.