[ensembl-dev] Error returned when using GRCh37's BioMart MartService

Bruno Grande bgrande at sfu.ca
Tue Jun 2 19:53:48 BST 2015


Hello,

I'm attempting to download data using GRCh37's BioMart MartService REST API
(using XML Query). I've successfully used this exact approach 2-3 months
ago. However, my recent attempts return errors.

Yesterday, BioMart was down. Now that it's back up, I'm getting the
following error:

Query ERROR: caught BioMart::Exception::Database: Could not connect to
mysql database ensembl_mart_80: DBI
connect('database=ensembl_mart_80;host=ensdb-5-g-03;port=5637','ensro',...)
failed: Can't connect to MySQL server on 'ensdb-5-g-03' (111) at
/ensemblweb/grch37/wwwmart/www_80/biomart-perl/lib/BioMart/Configuration/DBLocation.pm
line 98.

You may see this error for yourself by visiting this URL
<http://grch37.ensembl.org/biomart/martservice/?query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%3C%21DOCTYPE+Query%3E%0A%3CQuery++virtualSchemaName+%3D+%22default%22+formatter+%3D+%22TSV%22+header+%3D+%220%22+uniqueRows+%3D+%221%22%0A++++++++count+%3D+%22%22+datasetConfigVersion+%3D+%220.6%22+%3E%0A++++%3CDataset+name+%3D+%22hsapiens_gene_ensembl%22+interface+%3D+%22default%22+%3E%0A++++++++%3CAttribute+name+%3D+%22ensembl_gene_id%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22hgnc_symbol%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22gene_biotype%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22external_gene_name%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22chromosome_name%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22start_position%22+%2F%3E%0A++++++++%3CAttribute+name+%3D+%22end_position%22+%2F%3E%0A++++%3C%2FDataset%3E%0A%3C%2FQuery%3E%0A>
(my
GET request with the XML query). Note that this only happens when I use the
GRCh37 API (http://grch37.ensembl.org/biomart/martservice/), but it works
with the latest API (http://www.ensembl.org/biomart/martservice/).

Any ideas as to why the GRCh37 API is returning an error? Do you think it
has something to do with BioMart being down yesterday?

Thanks,
Bruno
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20150602/a49b1801/attachment.html>


More information about the Dev mailing list