[ensembl-dev] DBD::mysql::st execute failed: Out of resources

[Luc Merenda]

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