Question: Trinotate Sqlite db error
0
gravatar for manukumar.fgb13-15
3.2 years ago by
manukumar.fgb13-150 wrote:

Hi all,

Am using trinotate to annotate a transcriptome, everything went fine till I started uploading my data into sqlite database. Am pretty new to trinotate and the field of transcriptome annotation. I am facing an error when I try uploading my data into sqlite which I am not able to understand. The error displayed is as follows

 

CMD: /nobackup/users/r01mkg15/softwares/Trinotate-2.0.2/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map trinity.panto.fasta.gene_trans_map --transcript_fasta trinity.panto.fasta --transdecoder_pep transdecoder.pep --bulk_load

-parsing gene/trans map file.... done.

DBD::SQLite::db do failed: disk I/O error at /nobackup/users/r01mkg15/softwares/Trinotate-2.0.2/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 91.

Function not implemented at /nobackup/users/r01mkg15/softwares/Trinotate-2.0.2/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 91.

Error, cmd: /nobackup/users/r01mkg15/softwares/Trinotate-2.0.2/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map trinity.panto.fasta.gene_trans_map --transcript_fasta trinity.panto.fasta --transdecoder_pep transdecoder.pep --bulk_load died with ret 9728 at /users/r01mkg15/sharedscratch/softwares/Trinotate-2.0.2/Trinotate line 112.  

 

This seems to be persistent even after I reinstalled the sqlite module in perl and i have download the new the new database of trinotate.sqlite database. nothing seems to work. please guide me with this. Am working on a HPC cluster without root user access. 

 

Thanks in advance, looking forward for uaa helps and suggestions.

  

assembly software error • 1.9k views
ADD COMMENTlink written 3.2 years ago by manukumar.fgb13-150

Which version of SQLite are you using? Maybe it is old you need a newer one - just a guess.

ADD REPLYlink written 3.2 years ago by h.mon24k

sqlite3 is the version in our cluster at the moment

ADD REPLYlink written 3.2 years ago by manukumar.fgb13-150

Try:

sqlite3 -version

If it is old, try installing a newer one on your area and prepend it to the PATH. Anyway, Trinity / Trinotate has a mailing list where the developers are very active and helpful, it would be a good idea to ask there if my suggestion doesn't help.

ADD REPLYlink written 3.2 years ago by h.mon24k

I reinstalled the sqlite db all over again and found that the same problem persists. I feel its something to do with our HPC cluster, there might be some issues with the rights and permissions for the user to access the database. I will work with that issue and get in touch.

Thank you very much for the suggestions 

ADD REPLYlink written 3.2 years ago by manukumar.fgb13-150

I meet same problem.Have you fixed it yet?

ADD REPLYlink written 6 months ago by harrypotterandsbt10
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: 763 users visited in the last hour