This is a test version of Biostars. For the public version, visit https://www.biostars.org.
orthomcl error: DBD::mysql::st execute failed: The table 'SimilarSequences' is full at ***

When I use orthomclLoadBlast, I got an error message.

DBD::mysql::st execute failed: The table 'SimilarSequences' is full at /tool/orthomcl/orthomclSoftware-v2.0.9/bin/orthomclLoadBlast line 39, <F> line 14.

My "similarSequences.txt" file is about 2.5G and the command is orthomclLoadBlast orthomcl.config.template similarSequences.txt

I have tried to change myisam_max_sort_file_size = 20G, but the error still exists.

Anyone can give me suggestions? Thanks

orthomcl cluster
• 5,618 views • link
updated by Ram Ram • written by yangyongzhi2008 • yangyongzhi2008

1 answer

One possible answer: https://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full

• 0 views • link
updated by Ram Ram • written by yangyongzhi2008 • yangyongzhi2008

Log in to answer this question.

More posts like this
  • Orthomcl Pairs
    written by Harshini • Harshini
    ./bin/orthomclPairs orthomclfinal.config pairs.log cleanup=yes DBD::mysql::st execute failed: Table 'orthomcl.interTaxonMatch' doesn't exist at ./bin/orthomclPairs line 709, <F> line 15. Unsure as to why this error came …
  • OrthoMCL problem when connecting with mysql
    written by Seq225 Seq225
    Hi, I am trying to use OrthoMCL. Having problem at the step 8. I am getting this message over and over again. *DBD::mysql::st execute failed: …
  • DBD::mysql::st execute failed: The table 'InplgOrthoInplg
    written by wocana • wocana
    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 …
  • Error running OrthoMCL
    written by johane92 • johane92
    Hi all, I'm developing a pipeline for using OrthoMCL and I can't get around an error that occurs when running OrthoMCLPairs: DBD::mysql::st execute failed: Table …
  • Orthomclinstallschema: DBD::mysql::st execute failed:....
    written by tito3000 • tito3000
    Hi everyone! orthomclInstallSchema gives me this error: DBD::mysql::st execute failed: Table 'SimilarSequences' already exists at /usr/local/bin/orthomclSoftware/bin/orthomclInstallSchema line 184, <F> line 14. Can you Help me, …
  • Tutorial: Easy way to run easily orthoMCL (Copy & paste)
    written by Esaie Esaie
    After spent a lot of time to run the 13 step of orthoMCL I reached running it successfully. The difficulty for me it's not orthoMCL …
  • Problem when installing orthomcl in step 4: orthomclInstallSchema
    written by zengxi.hada zengxi.hada
    I was installing the software orthomcl according to the user guide in http://www.orthomcl.org/common/downloads/software/v2.0/UserGuide.txt. When I processed to "Step 4: orthomclInstallSchema", I encountered problems. ``` $ …
  • Orthomclloadblast-----Orthomcl Problems
    written by wang.qiang.prc • wang.qiang.prc
    <p>When I use the subprogram--orthomclLoadBlast,I found a problem. I use all kinds of solutions online(mainly we should change local-infile = 1).However , it still does …
  • Orthomcl Incompatibility With Mysql5.5.20
    written by GR GR
    <p>Hello Everyone,</p> <p>Has anyone experienced a problem while running orthomcl with latest version of mysql? When I run the orthomclLoadParser, I got the following errors:</p> …
  • Orthomclpairs Doesnt Work
    written by User 4041 • User 4041
    Hello everyone, I have done the orthomclLoadBlast step before the orthomclPairs successfully and obtained a SimilarSequences table in the orthomcl database that I created. The …