Question: DBD::mysql::st execute failed: The table 'InplgOrthoInplg
0
gravatar for wocana
9 months ago by
wocana10
wocana10 wrote:

When i run this on orthomcl (running 39 proteomes):

/home/intirules/Desktop/Tesis/orthomclSoftware-v2.0.9/bin/orthomclPairs /home/intirules/Desktop/Tesis/orthomclSoftware-v2.0.9/doc/OrthoMCLEngine/Main/orthomcl.config.template ../orthomcl_pairs.log cleanup=yes

I get this error

DBD::mysql::st execute failed: The table 'InplgOrthoInplg' is full at /home/intirules/Desktop/Tesis/orthomclSoftware-v2.0.9/bin/orthomclPairs line 709, <F> line 14.

I already tried:

root@Biointi:/etc/mysql/mysql.conf.d# i**nnodb_data_file_path=ibdata1:16M:autoextend**
ADD COMMENTlink modified 9 months ago by RamRS20k • written 9 months ago by wocana10
1

is this the first run of that cmdline or is it a re-run?

OrthoMCL will run into trouble if you did not clean the DBs properly (or dropped them completely) in between runs

ADD REPLYlink written 9 months ago by lieven.sterck4.1k

Please use the formatting bar (especially the code option) to present your post better. I've done it for you this time.
code_formatting

ADD REPLYlink written 9 months ago by RamRS20k

Check all the suggestions from ERROR 1114 (HY000): The table is full.

Also try something like innodb_data_file_path=ibdata1:1G:autoextend, instead of just 16M.

ADD REPLYlink written 9 months ago by h.mon24k

did you also check if you have disk space left on your mysql server? You will get the same error when it can't write the tables to disk anymore (regardless of the table size)

ADD REPLYlink written 9 months ago by lieven.sterck4.1k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 2554 users visited in the last hour