search

uwescience / sqlshare-pythonclient

The Python client for the SQLShare REST API
3 stars 1 forks source link

size quote errors #12

Closed adamgreenhall closed 11 years ago

adamgreenhall commented 11 years ago

I've been trying to upload a dataset with the python client, but have been getting several errors. Most recently:

Error uploading data in the chunk...: code: 500 : 
{"Contact name":"sqlshare@uw.edu",
"Help Page":"https:\/\/rest.sqlshare.escience.washington.edu\/REST.svc\/help",
"Message from SQLShare":"The database 'sqlshare' has reached its size quota.    Partition or delete data, drop indexes, or consult the documentation for possible resolutions
...

Previously I was also getting errors which I think were related to table size limits, but couldn't find much reference for the hard table size limit.

What are the limits on tables in sqlshare? Is the service expected to be up for the foreseeable future?

dhalperi commented 11 years ago

Hi Adam,

It's not a problem with your tables, it's a problem with the database itself:

This is something we're working on. Unfortunately we're literally at the limit of database space we can buy from Microsoft SQLAzure, and so we're flirting with the boundary on a daily basis. We're trying to get a better solution in place.

That said, are you seeing these problems today? We put a fix in place last night that we thought would put off the issues for a few weeks at least while we work on a better solution.

Dan

adamgreenhall commented 11 years ago

Thanks Dan - tried again yesterday and it worked just fine.