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

Steve Moss gawbul at gmail.com
Sat Jul 2 18:30:49 BST 2011


Hi Luc (again),

I remember now that the issue I had was with mysqlimport, giving me
the same error, with a script I wrote to automate local EnsEMBL MySQL
installation. Using the command 'perror 24' should give you 'OS error
code 24: Too many open files', which is a reflection of the default
setting of 1024 for the 'open-files-limit' MySQL variable. Adding a
line with 'open-files-limit=8192' (minus the quotations) or a higher
value to /etc/my.cnf should solve the issue! I think setting to 4096
actually worked for me :-)

Cheers,

Steve
Sent from my iPad

On 2 Jul 2011, at 12:21, Steve Moss <gawbul at gmail.com> wrote:

> Hi Luc,
>
> A search on Google for "mysql out of resources when opening file
> errcode 24" gave a better example here -
> http://stackoverflow.com/questions/502545/too-many-open-files-error-on-ubuntu-8-04
>
> 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