DBD::mysql::st execute failed: The table 'InplgOrthoInplg
0
0
Entering edit mode
5.9 years ago
wocana ▴ 20

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# innodb_data_file_path=ibdata1:16M:autoextend
orthomcl ortho ubuntu mysql • 2.9k views
ADD COMMENT
1
Entering edit mode

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 REPLY
0
Entering edit mode

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 REPLY
0
Entering edit mode

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 REPLY
0
Entering edit mode

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 REPLY

Login before adding your answer.

Traffic: 2740 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6