[ensembl-dev] DBD::mysql::st execute failed: Out of resources (Luc Merenda)

Steve Moss gawbul at gmail.com
Sat Jul 2 12:16:30 BST 2011


Hi Luc,

I've come across this issue myself before and its to do with
limitations on the number of open files you can have. See this link -
http://chrisjohnson.blogsite.org/mysql-error-23-on-linux/

A search on Google for "MySQL Out of resources when opening file"
should give other examples too :-)

Cheers,

Steve
Sent from my iPad

On 2 Jul 2011, at 12:00, "dev-request at ensembl.org"
<dev-request at ensembl.org> wrote:

> Send Dev mailing list submissions to
>    dev at ensembl.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>    http://lists.ensembl.org/mailman/listinfo/dev
> or, via email, send a message with subject or body 'help' to
>    dev-request at ensembl.org
>
> You can reach the person managing the list at
>    dev-owner at ensembl.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Dev digest..."
>
>
> Today's Topics:
>
>   1. DBD::mysql::st execute failed: Out of resources (Luc Merenda)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 1 Jul 2011 15:27:54 +0200
> From: Luc Merenda <merenda.luc at gmail.com>
> Subject: [ensembl-dev] DBD::mysql::st execute failed: Out of resources
> To: "dev at ensembl.org list" <dev at ensembl.org>
> Message-ID: <BANLkTimohd+nwGoW12Azzo9YAJX2iAUowg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi guys,
>
> I have developed a script to map contigs to ensembl protein trees
> using a per script that uses the ensembl per API. The problem is that
> after a certain amount of hours running, the script crashes with the
> following error message:
>
>
> DBD::mysql::st execute failed: Out of resources when opening file
> '/ens-mysql5/data_5306/tmp/#sql_1683_0.MYD' (Errcode: 24) at
> /home/luc/local/ensemblapi/ensembl-compara/modules/Bio/EnsEMBL/Compara/DBSQL/NestedSetAdaptor.pm
> line 573, <FILE> line 1226.
> DBD::mysql::st execute failed: Out of resources when opening file
> '/ens-mysql5/data_5306/tmp/#sql_1683_0.MYD' (Errcode: 24) at
> /home/luc/local/ensemblapi/ensembl-compara/modules/Bio/EnsEMBL/Compara/DBSQL/NestedSetAdaptor.pm
> line 573, <FILE> line 1226.
>
>
> Is this error caused by limitations to the number of automatic
> requests a specific ip address can make? Should I set a delay between
> consecutive requests?
> Thank you very much in advance.
> Luc
>
>
>
> ------------------------------
>
> _______________________________________________
> Dev mailing list
> Dev at ensembl.org
> http://lists.ensembl.org/mailman/listinfo/dev
>
>
> End of Dev Digest, Vol 13, Issue 2
> **********************************




More information about the Dev mailing list