Trinotate / Trinotate.github.io

web documentation for Trinotate
47 stars 17 forks source link

error message DBD::SQLite::db prepare failed: no such table: RNAMMERdata #17

Open gdamasco opened 5 years ago

gdamasco commented 5 years ago

Dear Brian I am getting the following error message at the very last step of trinotate to write the annotation report. Would you mind helping me out?

I am running the exact codes you have avialable in github in a HPC.

CMD: /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl --sqlite Trinotate.sqlite -E 1e-5 --pfam_cutoff DNC DBD::SQLite::db prepare failed: no such table: RNAMMERdata at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 77. DBD::SQLite::db prepare failed: no such table: RNAMMERdata at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 77. at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 108. Sqlite_connect::do_sql_2D('DBI::db=HASH(0x198da48)', 'select Featurestart, Featureend, Featurescore, FeatureStrand,...', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Trinotate.pm line 424 Trinotate::get_RNAMMER_info('DBI::db=HASH(0x198da48)', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl line 539 main::get_RNAMMER_info('DBI::db=HASH(0x198da48)', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl line 139 Error, cmd: /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl --sqlite Trinotate.sqlite -E 1e-5 --pfam_cutoff DNC died with ret 512 at ./Trinotate line 126.

brianjohnhaas commented 5 years ago

This is peculiar. Try giving the full path to the Trinotate sqlite database in the command. This should help in case it's not finding it.

-via googleFi

On Wed, Apr 17, 2019, 1:35 AM gdamasco notifications@github.com wrote:

Dear Brian I am getting the following error message at the very last step of trinotate to write the annotation report. Would you mind helping me out?

I am running the exact codes you have avialable in github in a HPC.

CMD: /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl --sqlite Trinotate.sqlite -E 1e-5 --pfam_cutoff DNC DBD::SQLite::db prepare failed: no such table: RNAMMERdata at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 77. DBD::SQLite::db prepare failed: no such table: RNAMMERdata at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 77. at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Sqlite_connect.pm line 108. Sqlite_connect::do_sql_2D('DBI::db=HASH(0x198da48)', 'select Featurestart, Featureend, Featurescore, FeatureStrand,...', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/../PerlLib/Trinotate.pm line 424 Trinotate::get_RNAMMER_info('DBI::db=HASH(0x198da48)', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl line 539 main::get_RNAMMER_info('DBI::db=HASH(0x198da48)', 'TRINITY_DN11686_c0_g1_i1') called at /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl line 139 Error, cmd: /global/scratch/damasco/SRA/trinotate/trinotate3.1.1/util/Trinotate_report_writer.pl --sqlite Trinotate.sqlite -E 1e-5 --pfam_cutoff DNC died with ret 512 at ./Trinotate line 126.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Trinotate/Trinotate.github.io/issues/17, or mute the thread https://github.com/notifications/unsubscribe-auth/AHMVXyZG_9bLmEZhRserJ7KbSpeFdw8aks5vhrKrgaJpZM4c0Oq- .

gdamasco commented 5 years ago

Hi Brian

I installed trinotate locally and after giving the full path as you said, I am getting this error:

Can't locate DBI.pm in @INC (@INC contains: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/../../PerlLib /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/rnammer/1.2/cpan/lib/perl5/x86_64-linux-thread-multi /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/rnammer/1.2/cpan/lib/perl5 /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/transdecoder/5.0.2/PerlLib /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/DB_File/1.840/lib64/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 9. BEGIN failed--compilation aborted at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 9. Error, cmd: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map bos_Trinity.fasta.gene_trans_map --transcript_fasta /global/scratch/damasco/SRA/assembly/boswelia/trinity/Trinity.fasta --transdecoder_pep /global/scratch/damasco/SRA/annotation/Trinity.fasta.transdecoder_dir/longest_orfs.pep --bulk_load died with ret 512 at ./Trinotate line 126.

brianjohnhaas commented 5 years ago

there are a couple of perl modules that are needed. DBI DBD::SQLite

the way I typically install these modules is like so:

perl -MCPAN -e shell

install DBI

install DBD::SQLite

quit

On Thu, Apr 18, 2019 at 11:33 AM gdamasco notifications@github.com wrote:

Hi Brian

I installed trinotate locally and after giving the full path as you said, I am getting this error:

Can't locate DBI.pm in @inc https://github.com/inc (@inc https://github.com/inc contains: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/../../PerlLib /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/rnammer/1.2/cpan/lib/perl5/x86_64-linux-thread-multi /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/rnammer/1.2/cpan/lib/perl5 /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/transdecoder/5.0.2/PerlLib /clusterfs/vector/home/groups/software/sl-7.x86_64/modules/DB_File/1.840/lib64/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 9. BEGIN failed--compilation aborted at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 9. Error, cmd: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map bos_Trinity.fasta.gene_trans_map --transcript_fasta /global/scratch/damasco/SRA/assembly/boswelia/trinity/Trinity.fasta --transdecoder_pep /global/scratch/damasco/SRA/annotation/Trinity.fasta.transdecoder_dir/longest_orfs.pep --bulk_load died with ret 512 at ./Trinotate line 126.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Trinotate/Trinotate.github.io/issues/17#issuecomment-484563679, or mute the thread https://github.com/notifications/unsubscribe-auth/ABZRKX47LYWAUUVVVEY4NVLPRCIGJANCNFSM4HGQ5K7A .

--

Brian J. Haas The Broad Institute http://broadinstitute.org/~bhaas http://broad.mit.edu/~bhaas

gdamasco commented 5 years ago

Thank for your help Brian, but I am still struggling..

This is the error I am getting now

DBD::SQLite::db do failed: database is locked at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 93. Resource temporarily unavailable at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 93. Error, cmd: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map Trinity.fasta.gene_trans_map_bur --transcript_fasta /global/scratch/damasco/SRA/assembly/bursera/trinity/Trinity.fasta --transdecoder_pep /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/bursera_transdecoder/longest_orfs.pep --bulk_load died with ret 2816 at ./Trinotate line 126.

brianjohnhaas commented 5 years ago

Were you able to run the initial prep step to create the boilerplate sqlite database?

On Thu, Apr 18, 2019 at 4:44 PM gdamasco notifications@github.com wrote:

Thank for your help Brian, but I am still struggling..

This is the error I am getting now

DBD::SQLite::db do failed: database is locked at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 93. Resource temporarily unavailable at /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 93. Error, cmd: /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/util/trinotateSeqLoader/TrinotateSeqLoader.pl --sqlite Trinotate.sqlite --gene_trans_map Trinity.fasta.gene_trans_map_bur --transcript_fasta /global/scratch/damasco/SRA/assembly/bursera/trinity/Trinity.fasta --transdecoder_pep /global/scratch/damasco/SRA/trinotate_old/trinotate3.1.1/bursera_transdecoder/longest_orfs.pep --bulk_load died with ret 2816 at ./Trinotate line 126.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Trinotate/Trinotate.github.io/issues/17#issuecomment-484683402, or mute the thread https://github.com/notifications/unsubscribe-auth/ABZRKX6FYKN4VYGQATG7A63PRDMRNANCNFSM4HGQ5K7A .

--

Brian J. Haas The Broad Institute http://broadinstitute.org/~bhaas http://broad.mit.edu/~bhaas

gdamasco commented 5 years ago

Yes. I was

gdamasco commented 5 years ago

Hey, I reran the initial prep step to create the boilerplate sqlite and it seems to be working fine now. Thank you for your prompt help. :)

brianjohnhaas commented 5 years ago

wonderful! great to hear

On Thu, Apr 18, 2019 at 5:57 PM gdamasco notifications@github.com wrote:

Hey, I reran the initial prep step to create the boilerplate sqlite and it seems to be working fine now. Thank you for your prompt help. :)

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Trinotate/Trinotate.github.io/issues/17#issuecomment-484703299, or mute the thread https://github.com/notifications/unsubscribe-auth/ABZRKXYV3QHEJIBCJRS75ALPRDVDRANCNFSM4HGQ5K7A .

--

Brian J. Haas The Broad Institute http://broadinstitute.org/~bhaas http://broad.mit.edu/~bhaas