0

One pressing problem is that when I try to access my tables or visualizations on the CartoDB web app, I get this error page. My account is 'safedev'


Something that may or may not be relevant, but was not true before now:

When I try to q=SELECT CDB_UserTable()&api_key=[my-api-key] with the SQL api (via POST, but not via GET), I get:


503 Service Unavailable

Error 503 Service Unavailable

Service Unavailable

Guru Meditation:

XID: 175897971 (EDIT: Will not match this number exactly - Jake)


Varnish cache server


However, if I do not supply my api_key (ie. q=SELECT CDB_UserTables()), I get normal results.

Also I can still get data from my tables via the SQL API, with or without api_key. For example, q=SELECT * FROM "table"&api_key=[my-api-key] returns what I expect.

1

Update: Found the 503 issue.

You have at least one table whose name has a dot inside, and this triggered a probelm due to wrong escaping in one place of our cartodb-postgresql extension code.

I'm preparing a fix for the issue (link to issue), but reloading the postgresql extension takes a bit of time (plus it needs to travel all users databases), so initially expect to have it fixed by tuesday midday GMT+1 time.

Sorry for the inconveniences.

Question: How did you create a table with a dot on its name, using the SQL API?


About the Varnish error performing a POST, I've filled an internal ticket (as that is likely a problem of cartodb.com).


Update 2:

After checking locally I couldn't reproduce, so checked your database and the problen was a table named table_with"quote IIRC.

While quotes at table names are alowed at Postgres, we surely don't allow them and this change has a bigger impact than just a bugfix, so I've filled another ticket (https://github.com/CartoDB/cartodb/issues/1428) but is not a priority, and for the time being you shouldn't create tables with quotes on them.

I've performed an ALTER TABLE on the offending one removing the quote so your dashboard should work again.

  • Unfortunately, I can't tell you with absolute certainty how we might have created a table with a dot in its name. However, I can give you a couple likely scenarios: 1. We created a table over the SQL API with the name as you see it, and then (in a separate query) called SELECT CDB_Cartodbfy('table_name') 2. We created an empty table in the CartoDB tables dashboard and renamed it to the name you saw. I might be able to tell better if I knew the name of the offending table. – Jake Molnar Dec 5 '14 at 19:43
  • I don't mean to make a fuss, but it's Friday now and my tables dashboard is still inaccessible.. – Jake Molnar Dec 12 '14 at 18:13
  • Sorry, I'll take a look again on monday. StackExchange notified me of this comment 20 min ago, no yesterday :( In any case, it is possible that despite my fixes CartoDB Editor is still not ready for table names containing dots. We don't allow then from the editor nor imports, we're working to fully add support from SQL API created tables but "full freedom" introduces problems like your case. If you're in a hurry I could just rename the table with a dot. – Kartones Dec 13 '14 at 19:30
  • Problem fixed, you had a nasty table_with"quote table breaking everything. Sadly we don't support those. For more details check the updated Answer. Sorry for the problems caused – Kartones Dec 15 '14 at 10:28
  • Thanks @Kartones, I'll make sure that we don't allow any more quotes to find their way into table names – Jake Molnar Jan 6 '15 at 17:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.